Course Details
Course Details
What You'll Learn
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
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
Job Roles
- Data Scientists
- Data Analysts
- Digital Marketers
Trainers
Trainers
is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies
Review
Customer Reviews (5)
- Good course materials Review by Course Participant/Trainee
-
Really enjoyed the training. The examples were relevant and the pace was just right. (Posted on 12/26/2025)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 - Highly recommended Review by Course Participant/Trainee
-
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 11/6/2025)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 - Great learning experience Review by Course Participant/Trainee
-
A very practical course. The trainer made a complex topic simple and enjoyable to learn. (Posted on 10/13/2025)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 - Learned a lot Review by Course Participant/Trainee
-
Great course materials and well-paced lessons. The exercises really helped me understand the topic. (Posted on 8/27/2025)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 - Hands-on and practical Review by Course Participant/Trainee
-
Great course materials and well-paced lessons. The exercises really helped me understand the topic. (Posted on 8/13/2025)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
- Recommended Courses