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.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Disclaimer

We are not affiliated with Olik. This course does not certify that you as QlikView Certified User. We use QlikView Personal Edition only for the training of this course .

Funding and Grant

HRD Corp Claimable Course for Employers Registered with HRD Corp

Course Code: M739

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