Course Information

  • Sessions 2 days
  • Duration 15 hrs
  • Level Beginner
  • Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.

QlikView Business Analytics Training

Course Code: C738

What's This Course About

Step into the realm of cutting-edge Business Intelligence with our QlikView Business Intelligence Training course. QlikView, a leading BI tool, empowers businesses to transform raw data into actionable insights, and this training offers a holistic approach to mastering its vast capabilities.

Starting with the essentials of creating dynamic data visualizations, you'll progress to loading data effectively and building captivating interactive dashboards that offer real-time insights. Dive deeper into the heart of QlikView with intricate scripting, data modeling techniques, and learn to craft precise expressions to meet business requirements. Further enhance your BI skills with set analysis, ensuring data interpretation is both thorough and precise. Concluding with an understanding of QlikView's robust security protocols, you'll leave with the confidence and knowledge to utilize QlikView in driving data-led business decisions.

Funding and Grant Applications

No funding is available for this course.

Course Fee

$600.00 (GST-exclusive)
$654.00 (GST-inclusive)

Course Date

Course Time

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

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

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.

Review

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
. (Posted on 4/19/2022)
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
. (Posted on 2/18/2020)
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
. (Posted on 2/18/2020)
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
. (Posted on 2/18/2020)
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
. (Posted on 2/18/2020)

Items 1 to 5 of 46 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. ...
  7. 10

Write Your Own Review

You're reviewing: QlikView Business Analytics Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
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