QlikSense Class 7 - Analyze Payroll data

Paul S., Business Intelligence and Analytics developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
8 Lessons (1h 16m)
    • 1. Lecture 44 Understanding the payroll data to use

      7:12
    • 2. Lecture 45 Data Modelling 101

      10:46
    • 3. Lecture 46 Build a Pivot table over the payroll data

      18:42
    • 4. Lecture 47 Introducing RowNo(),Above(),RangeSum() functions

      10:42
    • 5. Lecture 48 Use the RowNo(),Above(),RangeSum() functions in a Pareto analysis

      9:49
    • 6. Lecture 49 Convert the Pareto pivot table to chart

      5:14
    • 7. Lecture 50 Observe combo chart to scatter chart conversion behaviour

      5:34
    • 8. Lecture 51 Wrap it all up into an informative data visualization dashboard

      7:59

About This Class

I recommend that you complete QlikSense Class 6 - Analyzing On-Line Customer Sales Performance before taking this class.

Our start-up has staff and are paid wages and benefits.

These lectures will teach you how to build a payroll analysis App and as we build the app you will also learn how to ...

  1. Understand QlikSense data models (Star Schema)
  2. Obfuscation of sensitive data from display
  3. More on functions such as RowNo(), RangeSum(), Above() 
  4. Build a Pareto (80/20) analysis chart
  5. Convert pivot tables to charts

af4feb87