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.
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
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.
Review
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
Write Your Own Review
- Recommended Courses




