Course Details
Day 1 Qlik Sense for Business Analysts
Topic 1 Get Started on Qlik Sense
- What is Qlik Sense
- Qlik Sense Demo
- Download Qlik Sense Desktop
- Qlik Sense Hub & Apps
- Create Your First App
- Create Sheets for Your App
Topic 2. Loading Data
- Loading Excel Data
- Create a Connection to Data Source
- Data Association
- Concatenate Tables
Topic 3. Data Visualization
- Chart Types in Qlik Sense
- Add Charts
- Create a Dashboard
Topic 4 Data Discovering
- Interacting with Visualizations
- Types of Selections
- Using Lasso Selection
- Bookmark Selections
- Create Visualizations with Insight Advisor
- Create visualizations with Chart Suggestion
- Alternate States
- Touch Gestures
Topic 5 Data Storytelling
- What is Data Storytelling
- Taking Snapshots
- Create a Simple Story
Day 2 Qlik Sense Scripting
Topic 6 Scripting
- Data Load Editor
- Load Data
- Variables and Control Statements
- Join and Concatenate Tables
Topic 7. Data Modelling
- Synthetic Key Data Model
- Synthetic Keys Removal Script
- Circular Reference Data Model
- Circular Reference Removal Script
Topic 8. Expressions
- Aggregate Functions
- Chart Expressions
- Dollar-Sign Expansion
- Class Functions
Topic 9. Set Analysis
- What is Set Analysis
- Create Set Expressions
- Set Modifier
Course Info
Prerequisite:
This course is for beginner. No prior knowledge on programming is required.:
Software Requirement
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.
Job Roles
- Data Scientists
- Data Analysts
- Digital Marketers
Trainers
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 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.
Customer Reviews (16)
- 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 - 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 - 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 - 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 - 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 - 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 - Thanks to Rups, He used our own data for dashboard design 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 - might consider 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 - 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 - 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 - might consider 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 - might consider 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 - might consider 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 - 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 - 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 - might consider 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