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 consider 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 - 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
-
Need working internet, need a working mouse, need faster laptop, need a bigger classroom.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
Classroom size was really too small and packed. (Posted on 2/17/2020) - might recommend Review by Course Participant/Trainee
-
Environment can be made more conducive- more space, better facilities and furniture, more snacks and water provided, staff are helpful overall but will appreciate if they can be less pressurizing in urging me to pay up because I had issues in my skillsfuture - if they can try to listen to my problem and even go one step further to troubleshoot the problem for me it will be a much happier customer experience; I understand that a business is being run here but i find the customer experience is room for improvement. Although eventually another lady assisted and my issues got sorted out but somehow this has dampened my mood to a very satisfied overall training experience. (Posted on 1/22/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 1/22/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
-
Steps to activities to be included into the notes (Posted on 1/22/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
-
Longer duration or compressed content (Posted on 1/22/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
-
Will be good if participants must have some prior knowledge of basic scripting or coding (Posted on 1/22/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
-
Qlikview test certification and course and extend to 3 days. (Posted on 1/22/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 too cramp, wires all around are hazard (Posted on 1/22/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/22/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 1/22/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 1/22/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
-
Table too squeezy and no charger point for my laptop1. 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
Class size can be kept even smaller for more interactive with instructor as everyone is at different levels of understanding , light refreshments besides water can be provided or more regular breaks (Posted on 1/21/2020) - 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
-
More hands on or practical (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
-
Better laptop1. 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
Overall very good (Posted on 1/21/2020) - might recommend Review by Course Participant/Trainee
-
Start earlier e.g. 9am to 5pm1. 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
Better notes (step by step) (Posted on 1/21/2020)
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)
