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
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
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
-
More detailed notes (Posted on 1/21/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 1/21/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
-
Inform participants to download the software (Posted on 1/21/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 1/21/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
-
Extend the duration of the course (Posted on 8/21/2019)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 10/3/2018)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)
