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 Lessons (2h 8m)
    • 1. Lecture 16 Lets load our Sales data

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

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

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

      12:38
    • 5. Lecture 20 Analyse GP , calculate variances

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

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

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

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

      4:53
    • 10. 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