Qlik Sense MasterClass (Beginner, Intermediate, Advanced)

Today, we are all surrounded with full of data.

Data is everywhere but if we do not transform the data into useful insight, we are not able to make the correct decision on a certain matter.

Imagine if we are recently appointed to be a director of an organization, are we able to:

1. React based on the latest or historical information that is happening around us?

2. Reduce or automate the manual works that have been done in decades?

3. Draw insights from a stack of printed reports?

If you do not have the answer, join this class to know more about Qlik Sense which can help solve your problems.

Certificate of completion

Digital certificate - Included

Reed courses certificate of completion

Digital certificate - Included

• Beginner Content 1:08:53

  • 1: Introduction Preview 03:02
  • 2: What is BI? Preview 02:45
  • 3: Loading Data into Qlik Sense Preview 06:02
  • 4: Qlik Sense Workflow 04:43
  • 5: Creating Our First Dashboard Preview 06:57
  • 6: Introduction : Adding New Columns 01:15
  • 7: Adding New Columns into Table 07:05
  • 8: Introduction : Sorting 01:37
  • 9: Sorting in Table 05:08
  • 10: Introduction : Chart Interactions Preview 01:31
  • 11: Chart Interaction in Qlik Sense 06:11
  • 12: Table Linkage 07:14
  • 13: Creating Bookmarks 03:13
  • 14: Introduction : Variables in Qlik Sense Preview 01:25
  • 15: Creating Buttons 05:46
  • 16: Beginner : Conclusion 04:59

• Intermediate Content 1:47:31

  • 17: Intermediate : Introduction Preview 02:11
  • 18: Connecting Data via Web Connectors 05:44
  • 19: Qlik Sense Workflow : ETL > Dashboard 03:03
  • 20: ETL Layer : Extract 04:32
  • 21: ETL Layer : Transform 04:55
  • 22: ETL Layer : Load 07:51
  • 23: Application Layer : Dashboard 05:47
  • 24: Script Syntax : Concatenate and NoConcatenate 05:11
  • 25: Introduction : Join Clause Preview 01:36
  • 26: Left Join 05:15
  • 27: Right Join 05:17
  • 28: Introduction : Join Clause Preview 01:57
  • 29: Join 06:21
  • 30: Fiscal Calendar 09:28
  • 31: Introduction : Dashboard Design Preview 01:53
  • 32: Visualizations : Set Analysis 07:50
  • 33: Introduction : Color Codes Preview 01:56
  • 34: Visualizations : Color Code 05:17
  • 35: Master Item : Dimensions 06:17
  • 36: Master Items : Measure 03:55
  • 37: Master Items : Visualizations 02:57
  • 38: MTD and YTD buttons 08:18

• Advanced Content 1:28:16

  • 39: Load Script : Cross Table 04:38
  • 40: Load Script : Group by 06:51
  • 41: Load Script : Order By 05:32
  • 42: Load Script : YTD Fact Table 10:02
  • 43: Load Script : Master Calendar 12:27
  • 44: Load Script : Fiscal Calendar 04:46
  • 45: Load Script : Link Table 08:06
  • 46: Load Script : Star Schema 02:59
  • 47: Visualizations : 100% Chart Preview 06:26
  • 48: Visualizations : AGGR 06:57
  • 49: Visualizations : Rank 05:59
  • 50: Visualizations : Toggle 08:55
  • 51: Visualizations : Pagination 02:48
  • 52: Advanced : Conclusion 01:50

• Bonus Content 1:43:33

  • 53: Introduction - QTD 03:29
  • 54: Creating Inline Data - QTD 06:50
  • 55: Constructing Expression - QTD 05:56
  • 56: ApplyMap Function 08:45
  • 57: ApplyMap vs Join 06:44
  • 58: Apply Map - What we Can do with values Not Mapped? 04:02
  • 59: What happpen if we are joining Columns of Different Data Types? 05:46
  • 60: Dashboard Optimization - Text vs Num 10:25
  • 61: Introduction - Data Snapshots 04:07
  • 62: Pseudocode - Data Snapshots 04:07
  • 63: Logic Demo - Data Snapshots 19:11
  • 64: Introduction - Data Repatching 02:36
  • 65: Pseudocode - Data Repatching 04:04
  • 66: Demo - Data Repatching (Part 1) 11:07
  • 67: Demo - Data Repatching (Part 2) 06:24

In the Intermediate session, you will be exposed to the load script where we load our data into Qlik Sense.

And also did some of the basic transformations.

Once we have all the tables transformed and saved into QVD formats, we will load all the QVDs back into the load script.

And finally, we will load the data model into our final application, which is the dashboard layer.

Next, we will go into the Sheets to expose ourselves to visualization expressions, how to create buttons, and also the idea of having master dimension, master expressions, and master visualizations in the dashboard.

For the Advanced session, we will guide you on how to build our load scripts with Master Calendar and Fiscal Calendar, YTD tables, and so on.

Once the load script is completed, we will move on to the sheets to know how do we apply the flags created in the load script into the visualization expression.

A more simplified way to create MTD/YTD logic will be introduced at this session as well.

Functions such as Rank and AGGR are also introduced in the advanced session.

Together with all the knowledge that we learned so far, we will create a 100% chart which will be an interesting chart to showcase the distribution of the specific dimensions that we are interested in.

Thanks for enrolling and Happy Qliking!

This course is suitable for those who wants to venture into Business Intelligence Industry, IT fresh graduates, Data Analyst, and so on.

No requirements are required. All students are welcomed.

Business Analyst, BI Developer, BI Analyst, Data Analyst

Currently there are no Q&As for this course. Be the first to ask a question.