Tired of spending countless hours on Qlik Forums trying to get your bloody Set Expressions to work?
Are you struggling to use the script editor and script functions and wondering how to create a reliable data model using the script editor?
Want to gain the knowledge and understanding to create and manage QlikSense applications and deliver data-driven insights to your organization?
Are you tired of sifting through mountains of data to gain valuable insights?
Do you want to be able to write complex expressions and make data-driven decisions and impress your colleagues and clients?
This course is designed to provide you with the skills and knowledge necessary to become a QlikSense expert.
Unlock the full potential of your data and take your career to the next level with the
QlikSense Masterclass !
Who is this course for?
This course is designed for data analysts, business intelligence professionals, and anyone who wants to take their data analysis skills to the next level.
Whether you're new to QlikSense or have experience with other BI tools, you will gain the skills you need to succeed.
What will you learn?
You will gain the knowledge and understanding to create and manage QlikSense applications and deliver data-driven insights to your organization.
You will learn the core concepts of QlikSense, including creating data models, building visualizations, and creating apps.
You will also learn data integration techniques and advanced features such as dashboards and stories.
You will gain the skills to develop apps to get meaningful insights from your data.
By the end of this course, you will have a comprehensive understanding of QlikSense and will be able to develop and implement successful QlikSense applications.
You will have the confidence to take on any challenge that comes your way and will be able to use the advanced features of QlikSense to maximize your data-driven insights.
This course will give you the tools and knowledge necessary to become a QlikSense expert.
So let’s get started and take your QlikSense skills to the next level!
Don't miss out on this opportunity to set yourself apart in the industry.
Enroll in the QlikSense Masterclass course today and start turning your data into actionable insights that will drive your business and career forward.
Course Intro
Course Description
Master Qlik Sense app development by solving Real-Life Analytics Problems. Learn Visualisation, Data modeling, and scripting by doing
step by step!
Hours of professional Qlik Sense Video training, unique data sets designed to take you from the basics to advanced concepts.
Engaging exercises that are both fun, practical and also give you a taste for
Real-life scenarios, projects, and Analytics of the REAL WORLD.
Course Structure
Each module builds on the other and you go from being a complete beginner to an advanced user who can get their hands dirty in the script editor.
We build on concepts step by step and learn how to write complex Set expressions by breaking them down into small bits and building them up. Learning is easy when it's taught the right way. The more you learn the better you will get. However, you can stop at any time you will still have a strong set of skills to take with you.
Each module is based on practical real-life data sets, where you will need to apply Qlik Sense concepts in a practical way and learn the theory by doing.
Practice makes perfect! Let's go!
Module Overview
Intro
- Intro
- Set up
- Navigating the Qlik Environment
Building your first app📊
- Build your first app
- Use Qlik Associative engine
- Create Master Dimensions & Measures
- Build your first dashboard
- Create KPI, Filters,Bar charts.
- Create scatter plot, tree map and maps
Intro to the script📜
- Load data using the script editor
- Solve synthetic keys issues
- Learn how to join tables
- Conditional loads using Where, Like, match
- Go from 0 to hero in Set Expressions
- Build advanced dashboards with conditional colors
- Debug script issues
Amazon sales analytics📈
Become a pro in scripting
- Transform data using Mapping, mapsubstring
- Data segmentation usingIf, Interval match, group by
- Create Resident loads and Group By
- Create a Master Calendar
- Advanced Set Expressions
- Advanced calculations using Aggr function & First Sorted value
- Creating KPI's with elemental functions P() & E()
- Creating 80/20 Pareto analysis chart
Canonical Calendar🗓️
- When to use canonical calendar
- Building a canonical calendar
- Caveat to using canonical calendar
Interactive Dashboard analytics🪄
- Intro to variables
- Using variables to file paths
- Adding measures through variables
- Incorporate variables inside Set Expressions
- Variables inside variables
- Create an interactive dashboard using variables
- Create What- IF - Scenarios
- Side by Side comparison using Alternate States
Front end Magic: Start Up Analytics Dashboard✨
- Magic of buttons & how to use them
- Embed external links in dashboards
- Hide & Show charts based on needs
- Build a cool and interactive target startup selector dashboard
Ad Hoc reports📝
- Create Ad Hoc reports using dimension list
- Create Ad hoc reports using variables and drop down list
Data load through Excel files📁
- Automatically bulk load excel/csv files from a folder
- Bulk load data from multiple files by looping through files
- Loop through different sheets in an excel and load data
- Debug errors in bulk load
Data Cleaning🧹
- Data cleaning challenges
- How to clean data using Qlik functions
QlikSense Extras🔥
- How to use BookMarks
- Story telling using Qlik's inbuilt story Mode
- QVD viewers and how to use them
- Change Qlik Themes and default color pallete
- How to find the right color contrasts
Bonus Material♾️
Extra Bonus practice lessons
and MUCH MUCH more
After finishing the course, you will know...
- How to create a data model using the Qlik associative engine
- How to use different charts and build beautiful dashboards📊
- How to create master dimensions & measures 👑
- How to create KPI's, tree maps, Combo Charts &MORE📊
- How to start scripting and use the script editor to transform your data 📜
- How to Transform data using Joins, Mapping, Mapsubstring & other script functions 🐱💻
- How to load data on conditions using where, match, like functions 📜
- How to Classify & segment your data using IF, Interval match, Class functions🏷️
- How to debug bulk load errors 🐞
- Clean data using data cleaning functions🧹
+ Bonus tutorials:
- Ad Hoc reporting: Create user based input report.
- Data cleaning
- Total vs {1} vs All tool
- Year on Year growth % tutorial
- Dynamic value selection using buttons & sliders.
and accompanying scripts worth $35 for FREE.
And Much Much more! ♾️
- Solve synthetic keys & circular reference data issues
- {< How to write simple to advanced Set Expressions in an easy way >}
- Build KPI based effective dashboards💹
- How to use variables inside Set Expressions {< >}
- Build interactive dashboards using variables
- Use Elemental functions like P() & E () to make complex calculations 🧮
- Build effective dashboards using Master measures and dimensions
- How to use variables inside variables aka variception (variable inception , get it )😉
- Create What-IF analysis charts
- How to elevate your dashboards using dynamic coloring 🌈
- How to take your dashboard to the next level by making your dashboard dynamic 🧙♂️.
- How to create a master calendar📅
- How to create a canonical calendar & what to watch out for.📆
- How to do Pareto analysis or 80/20 analysis charts 📈
- How to create ABC analysis dimension using Sorted AGGR()
- How to build dashboards capable of side by side analysis using alternate states📈.
- How to use the magic of buttons to automatize your dashboard ✨
- Ad Hoc reporting : Creating user based ad hoc reports. 📋
- How to Loop through various sheets in an excel and load data automatically 🧾
Course Curriculum
- Section 2 Intro (2:10)
- Loading our first dataset using the qlik associative engine. (10:44)
- Checking our data and creating the data model (2:41)
- What are dimensions and measures. (3:45)
- Overview of the sheet (12:25)
- Building our first dashboard - Part 1 (10:02)
- Building our first dashboard - Part 2 (7:04)
- Creating Master Measures & Drill Down Dimensions (10:01)
- Creating KPI charts & filters (12:08)
- Pimping our scatter plot with more features (8:35)
- Creating a new sheet and building our dashboard with a new focus (9:25)
- Creating a Tree Map and more features (6:24)
- Creating a combo chart (9:03)
- Adding maps to our dashboard (14:45)
- Section 3 Intro (1:58)
- Intro to the script editor (12:11)
- Loading data using the script editor (8:33)
- What are synthetic keys? How to Solve them (6:38)
- What are circular references? How to Solve them? (7:49)
- Intro to Joins : How to Join tables (9:20)
- Conditional data load using Where,Like, Match (8:53)
- Intro to Set expressions Part 1 (10:15)
- Set expressions - Part 2 (12:46)
- Set Expressions Part 3: How to use variables in Set Expressions (7:29)
- Concatenating multiple tables (7:04)
- Putting it together in our KPI dashboard (14:51)
- Dashboard contd.. (5:11)
- Growth % & conditional coloring - Dashboard part 3 (6:30)
- Creating and customizing a Pivot Table (7:35)
- Extra chapter on set expression Identifiers. $ vs 1 vs 1-$ (6:32)
- Adding Load messages to your script editor for easy debug (7:11)
- How to create composite keys (5:13)
- Section 4 Intro (2:05)
- New section data load (10:58)
- Data model transformation using Mapping function (9:16)
- Inline load : How to enter manual data (3:12)
- Data transformation using MapSubstring function (5:02)
- Data segmentation using IF & Interval Match (13:36)
- Resident Loads & Group By (6:56)
- Data classification using Class & Match function (5:24)
- Creating a basic Master Calendar (14:48)
- Advanced Date Set expressions & calendar Flags (10:04)
- Year on Year comparison Chart (3:32)
- Adding Distribution charts to the Dashboard (5:30)
- Intro to the Aggregate function (5:42)
- Advanced calculations using AGGR, Rank & IF (11:18)
- Advanced calculations using Aggr & First Sorted Value (7:56)
- Intro to elemental functions Possible() & Exclude() (4:06)
- Using the exclude function E() in our dashboard (10:11)
- Using the Possible function P() in our dashboard (8:06)
- Putting it all together in the dashboard Part - 1 (10:53)
- Putting it all together in the dashboard- Part 2 (6:44)
- Basics of Running Total and Running Percentage (8:49)
- 80/20 Pareto Analysis chart (10:32)
- Pareto analysis or ABC analysis using Sorted AGGR function (15:32)
- Completing our dashboard (6:27)
- Completing our dashboard Part -2 . Fine tuning our ABC analysis chart (7:46)
- Spice up your tables by creating SparkLines (4:41)
- Section 5 intro (1:42)
- Intro to variables (6:49)
- Using variables to load file paths (5:21)
- Loading entire Measures using variables (4:10)
- How to incorporate variables inside Set Expressions (4:58)
- Simplifying Date functions using variables (6:14)
- Variables inside a variable aka Variable inception YTD inside Variables. (14:46)
- Variable input: Assign values to variables interactively in the dashboard (8:36)
- Dashboard completion & Assigning field selections to variables (9:12)
- How to create a What-IF Scenario analysis dashboard (10:55)
- How to create a side by side comparative analysis charts using Alternate States (9:57)
- Section 6 Intro (1:23)
- Loading start up data set (6:51)
- Magic of buttons. How to automatize your dashboard (6:59)
- Embed links to external websites directly in your dashboard (1:52)
- How to hide & Show charts based on needs (7:40)
- Building a cool, interactive target startup selector dashboard (15:08)
- Bonus lesson: Creating an interactive user input dashboard with dynamic buttons (11:29)
- Automatically Bulk load excel/ csv files from a folder (6:15)
- Bulk load data from multiple files by looping through files using a FOR Loop (8:34)
- Load data from different sheets by Looping through sheet names (6:51)
- Load data by Looping through incremental sheet numbers (4:56)
- Debugging errors in bulk loads to make sure all files are loaded (5:02)
Learn from some one who has taught thousands of students on YouTube.
The Thinkmetrics YouTube channel has gained more than 2.2k subscribers and more than 200,000 views.
Now you get a chance to learn from the popular teacher to jumpstart your Qlik journey.
What some of our YouTube subscribers say:
"Your way of explaining was so good & clear "
- Radha Ravi
" Superb Bro. The way of explaining is really amazing.
Need more videos like this, which will be useful for us.
Thanks❣"
- KARTIK SEMWAL
"Amazing explanation for a beginner like me , liked the way you explained. Keep the videos coming."
- Tushar Tyagi
"Thank you for making these videos. I recently got my 1st job and my training on qlik sense has started. I was able to do my first task with the help of your videos. so thanks again and keep making such videos for more and better understanding :)"
-Sehrish Humayoun
"Your explanation is truly amazing, you explained in an hour what I have been trying to learn for a month. Do you have a chance to give it to me for free? When I earn money, I promise I will buy it. I have never seen an educator who explains it as well as you. I believe I will achieve a lot with your lessons."
-Sameth
Experience Online Learning at its Best
Learn on the go. Anywhere. Anytime!!!
What you will get when you enroll today
📺 94 lessons
12 hours of on-demand video
🗂️ 15 downloadable resources, qvf files, scripts & datasets
🏆 Certificate of completion
📱 Access to Thinkmetrics community.
Learn together with fellow students. A community that helps one another to learn, ask questions and grow together
♾️ Full lifetime access
&
🆕 New lessons updated
🆕 Get 6 Bonus tutorials and accompanying scripts worth $30 for FREE.
Enroll today and also get the newly released
Want Qlik formulas at your finger tips so you just quickly copy and paste them and save countless hours?
Introducing
QlikSense front End Cheatsheet
Worth 10$
For Free !
Read more about it here:
The Qlik Sense cheatsheet
What students have to say
-Ruchi
-Cory
-Loryn
"I think it is an excellent video; you explain it really well, in a calm and clear way. I recently did a Qlik video from Udemy and it has no comparison with the incredible work you do. You are a great teacher!"
-gonzalofuste
"I don't write any comment at all for anyone .... but I want to echo everyone here, this guy is great and a good teacher and I wonder the same thing how come his views aren't where they should be.
I'm not an expert in qlike but I'm not a beginner either ......"
-Mohammed Hassan
"thank you for making these videos. I recently got my 1st job and my training on qlik sense has started. I was able to do my first task with the help of your videos. so thanks again and keep making such videos for more and better understanding :)"
-Sehrish Humayoun
"The explanation was very good. I am so glad that I have taken this course. I am practicing same as what you are doing in the class"
-Devireddy Manaswini
"I've been learning Qlik through Udemy course & YouTube videos and i must say,none of them compares to this one. The course is well structured and the instructor, Kaushal, teaches in a way that is easy to grasp the technicalities with Qlik. Highly recommend for anyone looking to master Qlik"
-Anson lobo
Best Ever explanation on the topics related to Qliksense on entire youtube. Hats off Thanks a lot
-Abhijeet Joshi
Course Intro
If you don't find yourself learning new topics & having the
'ah ha! so that's how to do that'
moment at least a dozen times and looking forward to logging in, eager to learn more or laugh at my stupid jokes(or face ,what ever works for you) then just email me and you'll get your money back.
Hundreds of students have loved the course and i'm so confident that you will learn so much that i'm willing to tell you something that i can never tell my girlfriend.
Your satisfaction is guaranteed.
If not, you have an unconditional 30 - Day Money Back Guarantee.
No questions asked!
Are there any course requirements or prerequisites?
- Sign up and get access to the Qlik Sense business trial account or any other Qlik Sense environment to practice
- Keen to learn new concepts and develop your skills further
- Basic understanding of data concepts
- Keen to learn new concepts and develop your skills further
Who is this course for?
- You should take this course if want to learn Qlik Sense completely from scratch
- You should take this course if you have some Qlik Sense knowledge, but want to get better
- You should take this course if you are good with Qlik Sense and want to take your skills to the next level and truly leverage the full potential of Qlik Sense
Frequently Asked Questions
Can i follow along as i watch the videos?
All course material contains resources,qvf files, and data files. So as long as you have access to the Qlik environment, you can follow along and practice step by step.
How can i get free access to Qlik?
You can get access to the Qlik environment by signing up to the Qlik business cloud account which gives you 30 days (+ 15 days extension) days free access to Qlik.
Do I get assistance if i get stuck?
Yes!! You will get support if you get stuck in the course and have questions regarding the course modules. But questions will be limited to the course modules.
General questions can be asked to the community on Discord to fellow students.
What if I don't like the course?
You are guaranteed a 30-day money-back policy. If for some reason you think that the course was not for you, please email us and you'll get your money back.
No questions asked!
About me
ThinkMetrics - aka - Kaush
Hey,
🙋🏻♂️ I'm Kaush, a Data Analyst and Data Visualization Developer working for a tech company. I live and work in Sweden.
I'm a data visualization developer & Data Analyst 👨💻 by day and an avid reader 🤓 who loves everything from fitness 🏋️ to productivity and life hacks by night.
I spend my time working, working out, building things for the internet, or blogging. I'm deeply interested in self-improvement and building a more meaningful and productive life. I have struggled to get to where I am and I enjoy helping people reach new heights.
I love teaching what I know and have been teaching on YouTube for a long time now. My students seem to love the way I teach and wanted me to create a course and so I did.
Check out my YouTube channel.
Say hi!
Enroll today and get
📺 14 hours of on-demand video & 99 lessons ($159)
+
🗂️ 15 downloadable resources
+
♾️ Full lifetime access
+
🆕 New lessons updated
+
📱 Life time Access to an exclusive Discord community to learn together ($99)
+
🏆 Certificate of completion
+
💸 30 Money back guarantee
+
🗂️ 6 Bonus tutorials and accompanying scripts worth $30 .($30)
+
📜 The newly released QlikSense Front End CheatSheet worth 10$
Worth 159+99+30+10 = $298
All for just $2̶8̶8̶
$89
Enroll now while the offer lasts!
Get the Masterclass now
✅ 14 hours of on-demand video & 99 lessons
✅ Downloadable resources & scripts
✅ Full lifetime access
✅ New lessons updated
✅ Life time Access to an exclusive Discord community
✅ Certificate of completion
✅ 30 Money back guarantee
✅ Bonus tutorials and accompanying scripts
✅ The newly released QlikSense Front End Cheat Sheet
What people are saying
-Ruchi
-Cory
-Loryn
"I think it is an excellent video; you explain it really well, in a calm and clear way. I recently did a Qlik video from Udemy and it has no comparison with the incredible work you do. You are a great teacher!"
-gonzalofuste
"I don't write any comment at all for anyone .... but I want to echo everyone here, this guy is great and a good teacher and I wonder the same thing how come his views aren't where they should be.
I'm not an expert in qlike but I'm not a beginner either ......"
-Mohammed Hassan
"thank you for making these videos. I recently got my 1st job and my training on qlik sense has started. I was able to do my first task with the help of your videos. so thanks again and keep making such videos for more and better understanding :)"
-Sehrish Humayoun
"The explanation was very good. I am so glad that I have taken this course. I am practicing same as what you are doing in the class"
-Devireddy Manaswini
"I've been learning Qlik through Udemy course & YouTube videos and i must say,none of them compares to this one. The course is well structured and the instructor, Kaushal, teaches in a way that is easy to grasp the technicalities with Qlik. Highly recommend for anyone looking to master Qlik"
-Anson lobo
Best Ever explanation on the topics related to Qliksense on entire youtube. Hats off Thanks a lot
-Abhijeet Joshi