Course Objectives
- Introduction and welcome
- Our startup needs a business plan, but what is it meant to do ?
- Business Planning
- Getting started with Qlik Sense
- Download , Install & Register Qlik Sense
The Language
- Metrics and KPI's what are they ?
- The language
Budgeting and KPI (goal) setting
- Where to find everything ?
- Introduction to navigating the Qlik Sense hub
- Qlik Sense overview
- Dimensions and Measures, what are they?
- Dimensions and measures
- Create your first application (App)
- The first data load
- Import and load data
- Create a Pivot table
- Using the pivot table for data review
- Creating charts and expression sorts
- How to create and use a KPI object
- Year and month filter objects
- Review the section and personalize the App
- Overall review of this chapter
Data Science For Sales Performance
- Loading new sales data to the model
- Review and check the sales data
- Learn about Master Items and start using count()
- Basic expressions for calculating measures
- Changing the scope using conditional expressions
- More advanced expressions to calculate a variance
- How to Visualise Correlation
- Lateral thinking
- Adding more features to the Pivot table
- Think you're an expert yet ?
- Geo Analysis (Part 1)
- Geo Analysis (Part 2)
- Maps and other items
Inventory Analytics
- A conversation about the data we shall use for this section
- Loading data and how to fix synthetic keys and circular references
- Loading data and how to fix circular references
- What have you learned about data so far
- Creating a straight table and hierarchical drill down dimensions
- Creating KPI objects and coding measures
- Creating combo charts and a conversation about coding Set Analysis
- Dimensions and other ideas
- A conversation about coding Set Analysis
- A continuation of our coding Set Analysis conversation
- Coding Set Analysis for measures (Part 1)
- Coding Set Analysis for measures (Final)
- Check your Set Analysis status
Online Customer Sales Analytics
- Overview the tons of new stuff in this section
- Brace yourself, things are getting more advanced
- Make a new model and merge like file structures
- How to discretize data for analysis (Market Segmentation)
- What of banding,discretization,bucketization
- Understand what Resident loads are
- What is the Lookup() function ?
- Data islands and loads
- Start creating our visualizations with discretized data (Market Segmentation)
- Using Sum(), Aggr() and TOTAL for advanced counting explained
- Surface and test the advanced counting
- Advanced counting
- Bringing it all together on a dashboard sheet
- Enhance the dashboard sheet with mapping
Payroll Analytics and Pareto analysis
- Introducing Payroll with some cool new functions
- Data modelling 101 in Qlik Sense
- Data modelling 101
- Create a data analysis review sheet (Pt 1)
- Create a data analysis review sheet (Pt 2)
- Combining functions the RowNo(), Above() and RangeSum() for 80/20 analysis
- How to do 80/20 analysis (Pt 1)
- How to do 80/20 analysis (Pt 2)
- How to do 80/20 analysis (Pt 3)
- Bringing it all together
- Final for section
Profit and Loss including the magic of variables
- Lets explore another example of a compound key
- Keys quickly
- What is a variable and how do we use them in Qlik Sense (Part 1) ?
- What is a variable and how do we use them in Qlik Sense (Part 2) ?
- The magic of variables
- Setting variables with date functions
- Using variables in Set Analysis
- Replacing simple expressions with expression variables
- Embed conditional formatting expressions in variables
- How to code string delimiters in a variable ?
- Double check
Tips and Tricks (Bonus lectures)
- How to create a bookmark and start on your story
- How to create your story
- How to share your story with others
- Exporting data from Qlik Sense
- Connect and extract data from a SQL Server database
- Connect to and extract data from a web page
- On tips and other aspects
