QlikSense Class 7 - Analyze Payroll data Premium class

Paul Scotchford, Business Intelligence and Analytics developer

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

    • Lecture 45 Data Modelling 101

    • Lecture 46 Build a Pivot table over the payroll data

    • Lecture 47 Introducing RowNo(),Above(),RangeSum() functions

    • Lecture 48 Use the RowNo(),Above(),RangeSum() functions in a Pareto analysis

    • Lecture 49 Convert the Pareto pivot table to chart

    • Lecture 50 Observe combo chart to scatter chart conversion behaviour

    • Lecture 51 Wrap it all up into an informative data visualization dashboard


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







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.

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.