You have no items in your shopping cart.
Course Details
Day 1 QlikView Data Analytics Fundamental
Topic 1. Overview of Business Intelligence and QlikView
- What is Business Intelligence
- What is QlikView?
- QlikView vs Traditional BI
- QlikView Demo
- QlikView Products
- Download and Install Qlikview Personal Edition
- Exploring Qlikview Interface
- Setting User Preference
Topic 2. Getting Started Wizard
- What is Getting Started Wizard
- Getting Started Wizard Steps
Topic 3. Data Visualization
- Chart Types in QlikView
- Quick Chart Wizard
Topic 4. Discovery and Analysis
- Sheet Objects and Filters in QlikView
- Pivot and Straight Tables
- Statistic Chart Wizard
- Actions
- Time Chart Wizard
Topic 5. Loading Data
- Loading data to QlikView
- Associate Data from Different Sources
- Concatenate Tables
- Table Viewer
Topic 6. Building Dashboard
- Create Document and Sheets
- Mini Project: Create a QlikView Dashboard
Day 2 QlikView Scripting
Topic 7. QlikView Scripting
- Script Editor
- Script Syntax
- Debugging
Topic 8. Data Transformations
- Transformation Wizard
- Fill Function
- Manipulate Column
- Rotating Data
Topic 9. Data Modelling
- Star Schema Data Model
- Synthetic Key Data Model
- Circular Reference Data Model
Topic 10. Expressions
- Aggregate Functions
- Chart Expressions
- Variable
- Class Functions
Topic 11. Set Analysis
- What is Set Analysis
- Set Analysis Syntax
- Point in Time Reporting
- Alternate States
Topic 12. Security
- Overview of QlikView Security
- Types of Security
- Document & Sheet Level Security
- Hidden Script
- Section Access
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 21-65 years old
Minimum Software/Hardware Requirement
Software:
You can download and install the following software:
Hardware: Windows and Mac Laptops
Job Roles
- Data Scientists
- Data Analysts
- Digital Marketers
Trainers
Gary How: Gary How has overall 10 years of IT experience with strong exposure in Business Intelligence and Analytics domains. He has been delivering Qlik Sense enterprise solutions and training to corporate users for the past 4 years since it first released in 2014. Further, through the course of his work, he has also implemented software trials on various Business Intelligence solutions including MS Power BI and Tableau. He holds a Bachelor's degree in Computing from NUS.
Gary Chan: Gary Chan is a ACTA certified trainer. Gary Chan is a Chartered Accountant (ACCA, UK) and a member of the Institute of Singapore Chartered Accountants (ISCA). He has a MBA in International Business from Henley University (UK) and a Master degree in Strategic Marketing (Ireland). He is an ACTA certified trainer.
Gary has more than 20 years in business and financial management responsibilities in multinationals and local SMEs and more than 10 years’ experience of teaching/training/consulting in financial, business management & development, sales and marketing and leadership.
Bell Ang Chai Huat: Bell Ang is a ACTA certified trainer. Bell Ang is a Certified Practicing Accountant, member of CPA Australia. Approved mentor of Singapore Accountancy Commission. She is an ACTA Certified trainer and Xero Certified Advisor.
With more than 40 years working experience, Bell has held positions both in the Accounting/Finance and IT consultancy positions in various industries.
As an IT consultant, Bell specialises in the financial systems for example, Oracle financial, Scala. She has successfully led and handled more than 20 projects with full implementation and conducted several in-house and clients' trainings.
Malcolm Soo: Malcolm Soo is a ACTA certified trainer. He is a chartered Accountant. Have more than 20 years Accounting/Tax Experience. Currently, a freelance accountant and trainer for the following: LCCI 1 & 2, Accounting for Non-Financial Professional and QuickBook.
Customer Reviews (46)
- might recommend Review by Course Participant/Trainee
-
. (Posted on 4/19/2022)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
Bigger and more professional training room. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - might recommend Review by Course Participant/Trainee
-
Classroom too stuffy (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
Environment very cramp and noisy. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
Facility can be improved. Laptop not working properly. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
Better pc (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - might recommend Review by Course Participant/Trainee
-
. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
Classroom and infrastructure can be improved. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - might recommend Review by Course Participant/Trainee
-
. (Posted on 2/18/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/17/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/17/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - might consider Review by Course Participant/Trainee
-
Venue and individual laptops (Posted on 2/17/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - might consider Review by Course Participant/Trainee
-
Environment not so conducive. (Posted on 2/17/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/17/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
You May Be Interested In These Courses
Multi AI Agents Orchestration with AutoGen and AutoGen Studio
$300.00 (GST-exclusive)
$327.00
(GST-inclusive)
WSQ - Business Innovation with Blockchain Technology
$350.00 (GST-exclusive)
$381.50
(GST-inclusive)
WSQ - Business Innovation with Artificial Intelligence
$350.00 (GST-exclusive)
$381.50
(GST-inclusive)
WSQ - Business Innovation with Internet-of-Things (IoT)
$350.00 (GST-exclusive)
$381.50
(GST-inclusive)
WSQ - NFT Opportunities for Digital Artists and Businesses
$350.00 (GST-exclusive)
$381.50
(GST-inclusive)
Master TikTok Marketing - Create Videos That Captivate Audiences
$600.00 (GST-exclusive)
$654.00
(GST-inclusive)
WSQ - Unlocking Business Potential with Strategic Negotiation Tactics
$750.00 (GST-exclusive)
$817.50
(GST-inclusive)
WSQ - TikTok Marketing: Turning Engagement into Leads
$800.00 (GST-exclusive)
$872.00
(GST-inclusive)
WSQ - Digital Transformation and Business Innovation with Generative AI (GenAI)
$800.00 (GST-exclusive)
$872.00
(GST-inclusive)
