QlikSense Class 6 - Analyzing On-Line Customer Sales Performance

Paul Scotchford, Business Intelligence and Analytics developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Videos (1h 59m)
    • Lecture 34 Understanding the new data for the App

    • Lecture 35 Create a new Model and merge data files

    • Lecture 36 Discretize (Band) data for analysis

    • Lecture 37 Resident loads

    • Lecture 38 How to do a Lookup()

    • Lecture 39 Visualize our discretized (Banded) data

    • Lecture 40 Advanced counting using Sum,Aggr() and TOTAL

    • Lecture 41 Testing the advanced counting results

    • Lecture 42 Lets put all this stuff on a data visualization (Dashboard)

    • Lecture 43 Finally we can add maps to our visualization


About This Class

I recommend that you complete QlikSense Class 5 - Analyzing Stock Position before taking this class.

Our start-up has online based sales.

These lectures will teach you how to build a On-line customer sales performance analysis App and as we build the app you will also learn how to ...

  1. Work with This Year / Last Year data calculations
  2. Merge data in the model
  3. Create discretised data using the Class() and Flag methods
  4. Create a data island (Disassociated data tables)
  5. Use the Lookup() function to query data
  6. How to count customer registrations using advanced counting functions Aggr(), TOTAL







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.