Qlik Sense For Beginner + Intermediate + Advanced(All in 1)

Qlik Sense For Beginner + Intermediate + Advanced(All in 1), available at $44.99, has an average rating of 4.1, with 113 lectures, based on 56 reviews, and has 343 subscribers.

You will learn about Qlik Sense Load Script Qlik Sense Set Analysis Qlik Sense Visualizations Qlik Sense Expression ETL This course is ideal for individuals who are Beginner in BI or IT Fresh Graduate or Beginner in Data Analytics It is particularly useful for Beginner in BI or IT Fresh Graduate or Beginner in Data Analytics.

Enroll now: Qlik Sense For Beginner + Intermediate + Advanced(All in 1)

Summary

Title: Qlik Sense For Beginner + Intermediate + Advanced(All in 1)

Price: $44.99

Average Rating: 4.1

Number of Lectures: 113

Number of Published Lectures: 103

Number of Curriculum Items: 113

Number of Published Curriculum Objects: 103

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

Qlik Sense Load Script
Qlik Sense Set Analysis
Qlik Sense Visualizations
Qlik Sense Expression
ETL

Who Should Attend

Beginner in BI
IT Fresh Graduate
Beginner in Data Analytics

Target Audiences

Beginner in BI
IT Fresh Graduate
Beginner in Data Analytics

Today, we are all surrounded with full of data.

Data can be in the form of structured data(eg: Tables, worksheets), or unstructured data (free text fields or comments from social media).

An example of Data Usage is in AI model.

Data are the core of an AI model, which utilizes data input for the model to train, test, and learn from the data.

The usage of Machine Learning has allowed computers to perform predictions and provides suggestions to humans based on the data input that has been fed into the machine.

An example of Machine Learning is the Web Search Engine, which tries to understand what is the content we are searching for based on the data input that has been entered into the Search Engine.

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 for 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.

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!

Course Curriculum

Chapter 1: Beginner Content

Lecture 1: Introduction

Lecture 2: Introduction: What is BI

Lecture 3: [Intro] Loading Data into Qlik Sense

Lecture 4: [Demo] Loading Data in Qlik Sense

Lecture 5: Thanks for Enrolling!

Lecture 6: [Intro] Qlik Sense Workflow

Lecture 7: [Intro] Creating Our First Dashboard

Lecture 8: [Demo] Creating Our First Dashboard

Lecture 9: [Intro] Adding new Columns

Lecture 10: [Trailer] Adding new Columns

Lecture 11: [Demo] Adding new Columns

Lecture 12: [Intro] Sorting

Lecture 13: [Trailer] Sorting

Lecture 14: [Demo] Sorting

Lecture 15: [Intro] Chart Interactions

Lecture 16: [Trailer] Chart Interactions

Lecture 17: [Demo] Chart Interactions

Lecture 18: [Intro] Table Associations

Lecture 19: [Demo] Table Associations

Lecture 20: [Intro] Creating Bookmarks

Lecture 21: [Demo] Creating Bookmarks

Lecture 22: [Intro] Creating Buttons

Lecture 23: [Demo] Creating Buttons

Lecture 24: Beginner : Conclusion

Lecture 25: Quiz

Lecture 26: Answer

Chapter 2: Intermediate Class

Lecture 1: Introduction

Lecture 2: [Intro] Connecting Data from Web Sources

Lecture 3: [Trailer] Connecting data via Web Sources

Lecture 4: [Demo] Connecting data using Web Connectors – Google Drive

Lecture 5: Qlik Sense Workflow

Lecture 6: [Intro] ETL Layer – Extract

Lecture 7: ETL Layer – Extract

Lecture 8: [Intro] ETL Layer – Transform

Lecture 9: [Trailer] ETL Layer – Transform

Lecture 10: [Demo] ETL Layer – Transform

Lecture 11: [Intro] ETL Layer – Model

Lecture 12: [Demo] ETL Layer – Model

Lecture 13: Application Layer – Dashboard

Lecture 14: [Intro] Concatenate Clause

Lecture 15: [Trailer] Concatenate Clause

Lecture 16: [Demo] Concatenate and Noconcatenate

Lecture 17: [Trailer] Join Clause

Lecture 18: [Intro] Left Joins

Lecture 19: [Demo] Left Joins

Lecture 20: [Intro] Right Joins

Lecture 21: [Demo] Right Joins

Lecture 22: [Intro] Outer Join

Lecture 23: [Trailer] Outer Join

Lecture 24: [Demo] Outer Join

Lecture 25: Fiscal Calendar

Lecture 26: [Intro] Dashboard Design

Lecture 27: [Intro] Set Analysis

Lecture 28: [Demo] Set Analysis

Lecture 29: [Intro] Color Code

Lecture 30: [Trailer] Color Code

Lecture 31: [Demo] Color Code

Lecture 32: [Intro] Master Items

Lecture 33: Master Items – Dimension

Lecture 34: Master Items – Measure

Lecture 35: Master Items – Visualization

Lecture 36: [Intro] MTD and YTD Buttons

Lecture 37: [Demo] MTD and YTD Buttons

Lecture 38: [Quiz] Questions

Lecture 39: [Quiz] Answer

Chapter 3: Advanced Class

Lecture 1: [Intro] Cross Table

Lecture 2: [Demo] Cross Table

Lecture 3: [Intro] Group By

Lecture 4: [Demo] Group By

Lecture 5: [Intro] Order By

Lecture 6: [Demo] Order By

Lecture 7: [Intro] YTD Fact Table

Lecture 8: [Demo] YTD Fact Table

Lecture 9: [Intro] Master Calendar

Lecture 10: [Demo] Master Calendar

Lecture 11: [Intro] Fiscal Calendar

Lecture 12: [Demo] Fiscal Calendar

Lecture 13: [Intro] Link Table

Lecture 14: [Demo] Link Table

Lecture 15: [Intro] Star Schema

Lecture 16: [Demo] Star Schema

Lecture 17: [Intro] 100% Chart

Lecture 18: [Demo] 100% Chart

Lecture 19: [Intro] Aggr

Lecture 20: [Demo] Aggr

Lecture 21: [Intro] Rank

Lecture 22: [Demo] Rank

Lecture 23: [Intro] Toggle

Lecture 24: [Demo] Toggle

Lecture 25: [Intro] Pagination

Lecture 26: [Demo] Pagination

Lecture 27: [Quiz] Question

Lecture 28: [Quiz] Answer

Lecture 29: [Ending] Congrats!

Chapter 4: Bonus Sharing

Lecture 1: Introduction – QTD

Lecture 2: Creating Inline Data – QTD

Instructors

Arthur Fong
BI Developer

Rating Distribution

1 stars: 2 votes
2 stars: 1 votes
3 stars: 11 votes
4 stars: 21 votes
5 stars: 21 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu