QlikView Business Intelligence Training

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

Prerequisite

This course is for beginner. No prior knowledge on programming is required.:

Software Requirement

• With QlikView Personal Edition, Qlik offers a free version of QlikView for personal use. It is meant for individuals, students or small start-ups
• Download and install QlikView Personal Edition https://www.qlik.com/us/try-or-buy/download-qlikview

HRDF Funding

Please refer to this video https://youtu.be/Kzpd-V1F9Xs

1-     HRD Corp Grant Helper

How to submit grant applications for HRD Corp Claimable Courses

2-     Employers are required to apply for the grant at least one week before training commences.

Employers must submit their applications with supporting documents, including invoices/quotations, trainer profiles, training schedule and course content.

3-     First, Login to Employer’s e-TRIS account -https://etris.hrdcorp.gov.my

Second, Click Application

4-     Click Grant on the left side under Applications

5-     Click Apply Grant on the left side under Applications

6-     Click Apply

7-     Choose a Scheme Code and select HRD Corp Claimable Courses: Skim Bantuan Latihan Khas. Then, click Apply

8-     Scheme Code represents all types of training that suit the requirements provided by HRD Corp. Below are the list of schemes offered by HRD Corp:

9-     Select your Immediate Officer and click Next

10-  Select a Training Provider, then click Next

11-  Please select a training programme from the list, then key in all the required details and click Next

Select your desired training programme.

Give an explanation on why the participant is required to attend the training. E.g., related to their tasks/ career development, etc.

Explain the background and objective of this training.

Select a relevant focus area. For Employer-Specific Courses, select ‘Not Applicable’.

12-  If the training programme is a micro-credential programme, you are required to complete these 3 fields. Save and click Next

Insert MiCAS Application number

13-  Based on the nine (9) pillars listed below, HRD Corp Focus Area Courses are closely tied to support government initiatives towards nation building. As such, courses offered through the HRD Corp Focus Areas are designed to provide the workforce with skills required for current and future demands. Details of the focus areas are as follows:

14-  Please select a Course Title and Type of Training

15-  Select the correct type of training according to the actual type of training, or as mentioned in the training brochure:

16-  Please key in the Training Location and click Next

17-  Please select the Level of Certification and click Next

18-  Please follow the instructions and key in trainee details

19-  Click Add Batch, then click Save

20-  Click Add Trainee Details

21-  Please key in all the required details, then click Add

22-  Click Add if there are more participants. Once done, click Save

23-  Click Next

24-  Please key in the course fees and allowance details, then click Save

25-  Estimated cost includes the course fees/external trainer fees, allowances, and consumable training materials. Please comply with the HRD Corp Allowable Cost Matrix.

26-  Select Upfront Payment to Training Provider and key in the percentage from 0% to 30%. Then, click Save and Next

27-  Complete the declaration form and select a desired officer

28-  Add all the required documents, then click Add Attachment. Then, click Save and Submit Application

29-  Once the New Grant Application is successfully submitted, the Grant Officer will evaluate the application accordingly. The application may be queried if additional information is required.

The application status will be updated via the employer’s dashboard, email, and the e-TRiS inbox.

• Data Scientists
• Data Analysts
• Digital Marketers

Saranya Ravikumar: Saranya Ravikumar, has Masters of Engineering in Computer Science and Engineering who worked as an Assistant Professor in a reputed Engineering College at India. She is a Dell Emc certified Data Analyst. With a passion for teaching, she has more than 4 years of experience as an Assistant professor in Engineering Colleges. Also, she has more than 2 years of experience in leveraging the technical concepts through effective lectures in order to make the listeners gain the practical knowledge on the technical concepts of R, Python and Data Analytics using R. She has trained more than 100 students in R Technical skills which has an outcome of some students be placed in a leading MNC as Junior Analyst. She has received the best project supervisor award for guiding the students in Technovision’2018 at a reputed Engineering College. Moreover, she has worked on many Big Data Projects in the field of Plantation, Banking and Security including Multivariate Regression, Time series Forecasting and Classification.

Raj R: Raj R has more than 10 years, experience in architecting solutions in , Big Data , Data Analytics, Data Science , Artificial Intelligence , Machine Learning, IoT, and system integration.He has being coaching SQL, No-SQL, distributed applications (cloud /on-premise) , software methodologies, and integration tools.