QlikSense Class 5 - Analyzing Inventory Position Premium class

Paul Scotchford, Business Intelligence and Analytics developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
8 Videos (1h 57m)
    • Lecture 26 Introducing a model change adding another fact table

      10:43
    • Lecture 27 Handling synthetic keys and circular references

      17:47
    • Lecture 28 Introducing the hierarchical dimension

      15:56
    • Lecture 29 Using the Count() function

      19:48
    • Lecture 30 Conditional formatting and chart axis

      11:19
    • Lecture 31 Create calculated dimensions

      18:17
    • Lecture 32 Getting started with Set Analysis

      12:22
    • Lecture 33 Understand and use Set Analysis

      11:12

About This Class

I recommend that you complete QlikSense Class 4 - Analyzing Sales Performance before taking this class.

In this class you will create an App to Analyse your start-up Stock position and learn how to ...

  1. Change the data model to add another fact table
  2. Fix synthetic keys and circular references
  3. Create a hierarchical dimension
  4. Use distinct count to count stock levels
  5. Understand Primary and Secondary axis on charts
  6. Create a calculated dimension
  7. Set limitations e.g. Top 25 overstocks
  8. Work with orphaned data
  9. Understand Set Analysis for more advanced calculations

e117cbad

9

Students

--

Projects

0

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.

Paul