QlikSense Class 4 - Analyzing Sales Performance

Paul Scotchford, Business Intelligence and Analytics developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Videos (2h 8m)
    • Lecture 16 Lets load our Sales data

      11:40
    • Lecture 17 Create a Pivot table to review the loaded data

      13:18
    • Lecture 18 Analyse sales,create master items,use the count() function

      19:59
    • Lecture 19 Analyse GP , scoping and conditional expressions

      12:38
    • Lecture 20 Analyse GP , calculate variances

      12:20
    • Lecture 21 Analyse GP , scatter plot and treemap charts

      18:02
    • Lecture 22 Analyse GP , explore more pivot table features

      12:43
    • Lecture 23 Duplicating visualizations and modify for other analysis

      10:02
    • Lecture 24 Store performance analysis , geomakepoint() for mapping

      4:53
    • Lecture 25 Store performance analysis , wrap it up with Maps

      12: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...

  1. Pivot tables
  2. Custom formatting
  3. Create and use master items
  4. Conditional expressions
  5. Calculations such as Sales to Budget variance
  6. Create charts such as Scatter Plots and Treemap
  7. Displaying maps to demonstrate how our sales performed globally 

5eeddce0

12

Students

--

Projects

0

Reviews (0)

Paul Scotchford

Business Intelligence and Analytics developer

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.

See full profile