QlikSense Class 4 - Analyzing Sales Performance | Paul Scotchford | Skillshare

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

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

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

    • Lecture 19 Analyse GP , scoping and conditional expressions

    • Lecture 20 Analyse GP , calculate variances

    • Lecture 21 Analyse GP , scatter plot and treemap charts

    • Lecture 22 Analyse GP , explore more pivot table features

    • Lecture 23 Duplicating visualizations and modify for other analysis

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

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


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 






  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


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.

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

Report class