Baselining and Outliers
Course Content
0 / 55 completedAbout this section- KPI Foundation
Definition and Example
Characteristics of KPIs
Must Have Attributes of KPIs
Advantages and Disadvantages
Leading and Lagging Indicators (KPI Classification)
Course overview
Before we start
About this section- Direction setting
The Three Musketeers Part 1- Vision
The Three Musketeers Part 2- Mission
The Three Musketeers Part 3- Goals
Strategy & KPIs positioning
Recap so far and an assignment for you
About this section- Strategy & Planning
BSC Perspectives
Introduction and advantages of Balance Scorecard
Strategic Planning with BSC
Strategic Planning- Step 1 Change Analysis (and DIY)
Strategic Planning- Step 2 Strategy Mapping and Objectives
Strategic Planning- Step 3 KPI Selection
KPI Selection Tools- KPI Tree
KPI Selection- Case Big Store
KPI Selection Tools- Decision Matrix
About this section- KPI implementation
KPI Plan and Description
Targets and Thresholds
Control Charts- Basics
Baselining and Outliers
XMR Chart in Excel (and DIY)
Quick construction of XMR Chart in a statistical tool & baseline creation
About this section- Performance analysis & reporting
Basic Statistics- Introduction to data and variables
Basic Statistics- Types of Statistical Analyses
Descriptive Statistics- Measures of Central Tendency
Basic Statistics- Measurement Scales
Descriptive Statistics- Measures of Dispersion
Descriptive Analysis in Excel
Dashboards- Generic Steps to create One
Raw Data Cleaning- Part 1
Keys to Success- What's in the following lessons
Raw Data Cleaning- Part 2
Raw Data Cleaning- Part 3
Dashboard Design- Part 1
Dashboard Design- Part 2
Efficient Dashboards- Excel Tables
Efficient Dashboards- Excel Pivot Tables
Awesom'ize Dashboards- Slicers and Timeline
Data Do's and Don'ts
Excel Dashboard- Part 1
Excel Dashboard- Part 3
Power BI- For Beginners
Excel dashboard- Part 2
Dashboard in Power BI
Conclusion and wrap-up