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
SSG Training Grant
SSG TG is $15 per pax. Net fee after SSG TG is $309.82. Absentee Payroll is not eligible.
Steps to Apply Skills Future Claim
- The staff will send you an invoice with the fee breakdown.
- Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
- Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
- Upload your invoice and click ‘Submit’
Get Additional Course Fee Support Up to $500 under UTAP
The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).
For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)
Steps to Apply UTAP
- Log in to your U Portal account to submit your UTAP application upon completion of the course.
Note
- SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
- All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
- An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount will be paid to training provider first and claimed after end of class by learner.
Job Roles
- Data Scientists
- Data Analysts
- Digital Marketers
Trainers
Bimala Mishra has Overall 13 years of IT experience, with strong exposure in Database, Business Intelligence and Analytics domains. She has extensively worked on implementation of Enterprise Datawarehouse and BI solutions. She is a Certified Business Intelligence Professional from ICCP, USA (2013). Bimala’s varied career includes Data Analysis, Design and development of enterprise solution. She has done Masters in Computer application from one of the pioneer institutes of India and have worked on MNC such as Hewlett Packard. She is an expert on SQL backend Query, Excel, QlikView, Qlik Sense, C Programming, Java, Python to name a few. She enjoys working with both adults and youngsters. Currently she is an active volunteer of NLB S.T.A.R program, where she teaches Seniors about NLB mobile Apps and assists secondary students in her children school on their computer project assignments.
Sachin Godhania has Overall 12 years of IT experience, with strong exposure in Business Intelligence , Analytics and Database. He has extensively worked on implementation of BI solutions mainly use Qlik for various domains like Financial & Banking, Service, manufacturing etc. He is QlikView developer and Qlik Sense Architecture Certified. His expertise is not limited to dashboard development but proposing enterprise architecture and Business Analysis and training. He has done Bachelors in Information Technology application from Sardar Patel university in India. He is an expert on Qlik (QlikView, Qlik Sense, NPrinting) SQL backend Query, Excel, Python, Tableau to name a few. He enjoys working with both adults and youngsters. Currently am apart from my work , he pursuing Masters in Innovation from SMU, Singapore.
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.
Customer Reviews (46)
- might recommend Review by Course Participant/Trainee
-
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
-
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
-
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
-
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
-
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
-
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