QlikSense Class 5 - Analyzing Inventory Position
Paul S., Business Intelligence and Analytics developer
-
-
1. Lecture 26 Introducing a model change adding another fact table
10:43 -
2. Lecture 27 Handling synthetic keys and circular references
17:47 -
3. Lecture 28 Introducing the hierarchical dimension
15:56 -
4. Lecture 29 Using the Count() function
19:48 -
5. Lecture 30 Conditional formatting and chart axis
11:19 -
6. Lecture 31 Create calculated dimensions
18:17 -
7. Lecture 32 Getting started with Set Analysis
12:22 -
8. Lecture 33 Understand and use Set Analysis
11:12
-
About This Class
I recommend that you complete QlikSense Class 4 - Analyzing Sales Performance before taking this class.
In this class you will create an App to Analyse your start-up Stock position and learn how to ...
- Change the data model to add another fact table
- Fix synthetic keys and circular references
- Create a hierarchical dimension
- Use distinct count to count stock levels
- Understand Primary and Secondary axis on charts
- Create a calculated dimension
- Set limitations e.g. Top 25 overstocks
- Work with orphaned data
- Understand Set Analysis for more advanced calculations
Class Projects See All
Students
Projects
-
- --
- Beginner
- Intermediate
- Advanced
- All Levels
- Beg/Int
- Int/Adv
Level
Community Generated
The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.
I have over 12 years experience as a Business Intelligence and Analytics developer specialising in both the Microsoft and Qlik technology environment.
Since 2012 I have been developing QlikView and in late 2014 I discovered QlikSense, my QlikView skills were immediately transferable to QlikSense too.
I have also been developing with SQL since the late 90's and have extensive experience in data extraction, modelling and analytics directly from ERP and Data Warehouse structures.
Related Classes
