Strategic Data Analytics
Advance your analytical skills by working on real business challenges with data modelling and advanced analytics techniques. This two-day course combines data from multiple sources, advanced Power BI analysis and hands-on work with departmental data. Through workshops and small-group coaching, participants develop an analytics model or dashboard, refine it for practical use and prepare a plan for applying it in their work.
Course at a Glance
| Description | Detail |
|---|---|
| Duration | 2 days · 12 hours |
| Format | Classroom · Action learning and group coaching |
| Prerequisites | Completion of Data Insight Discovery or proficiency in advanced Excel |
| Course Output | Analytics model or dashboard for practical business use |
Learning Objectives
By the end of the course, participants will be able to:
- Apply data modelling principles to connect multiple data sources.
- Use advanced Power BI analytics techniques to investigate business questions.
- Translate a business challenge into a practical analytical task.
- Develop and refine an analytics model or dashboard using departmental data.
- Present findings and prepare a plan for applying the solution at work.
Course Outline
Day 1 — Build the Analytical Foundation
Module 1 — Data Modelling & Multiple Data Sources
Explore data modelling principles and approaches for connecting data from different sources.
Module 2 — Advanced Analytics with Power BI
Practise advanced analytics techniques in Power BI to investigate business questions.
Module 3 — From Business Challenge to Analysis
Translate a real business challenge into an analytical task and begin working with departmental data.
Module 4 — Small-Group Coaching
Work with a coach to review and develop your initial model.
Day 2 — Develop, Refine & Apply
Module 5 — Analytics Model / Dashboard Workshop
Continue building your analytics model or dashboard with guidance from your group coach.
Module 6 — Refinement for Practical Use
Refine the model or dashboard to support its intended business application.
Module 7 — Presentation & Implementation Plan
Present your work, receive feedback and prepare a plan for applying the solution in your department.
Who Should Attend
Professionals who already have foundational data analysis skills and want to tackle more complex business questions using multiple data sources, analytical models and dashboards.