- 1x (Normal)
Lecture 16 Lets load our Sales data11:40
Lecture 17 Create a Pivot table to review the loaded data13:18
Lecture 18 Analyse sales,create master items,use the count() function19:59
Lecture 19 Analyse GP , scoping and conditional expressions12:38
Lecture 20 Analyse GP , calculate variances12:20
Lecture 21 Analyse GP , scatter plot and treemap charts18:02
Lecture 22 Analyse GP , explore more pivot table features12:43
Lecture 23 Duplicating visualizations and modify for other analysis10:02
Lecture 24 Store performance analysis , geomakepoint() for mapping4:53
Lecture 25 Store performance analysis , wrap it up with Maps12:06
About This Class
I recommend that you complete QlikSense Class 3 - Managing Budgets before taking this class.
Our start-up has online and store based sales.
These lectures will teach you how to build a Sales Analysis App and as we build the app we shall also cover topics such as...
- Pivot tables
- Custom formatting
- Create and use master items
- Conditional expressions
- Calculations such as Sales to Budget variance
- Create charts such as Scatter Plots and Treemap
- Displaying maps to demonstrate how our sales performed globally
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.
I've also built quite a few enterprise Data Warehouses and Marts in my time to say the least.
My background is development and entrepreneurship (Having created and operated many business's over the years).
I'm still a geek at heart though, I started coding in Fortran at Grammar School (UK) when doing my 'A' levels. Then I got involved in electronics, but Engineering in those early years didn't offer a lot in IT subjects , so I embarked on a career where companies like DEC (Compaq) provided me with Tech training and certifications, the rest is history.
When I get time I will follow my business passion, and commence my MBA studies.