Digital Office Essentials
Microsoft Excel: Beginner to Advanced
Learn to work confidently with spreadsheets.
Beginner to Intermediate
Power BI & Dashboard Design
Transform raw data into interactive dashboards and business stories.
Part of: Data & Reporting
Recommended prerequisite: Basic Excel and Data Analytics recommended
Course introduction
Meet the course.
Watch a short introduction to what this course covers before you enrol.
Outcomes
What you’ll learn
Drawn from the actual modules in this course.
- Power BI Foundations
- Power Query
- Data Modelling
- DAX Fundamentals
- Visualisation
- Complete Dashboard Project
Certificate of Completion
How you earn the certificate
- Complete the lessons in each module
- Pass each module checkpoint (70% or higher)
- Pass the final assessment (70% or higher)
- Receive a verifiable Certificate of Completion with a unique credential ID
One-time payment
Lifetime access
Verified credential
Full curriculum
Course modules & lessons
Open any module to see its lessons. Each module except the last ends with a short “Test Your Knowledge” checkpoint.
Module 1
Power BI Foundations
Power BI Foundations
1What Power BI Is
2Understanding the Power BI Interface
3Importing Your First Dataset
Module 2
Power Query
Power Query
1Inspecting Data
2Cleaning and Transforming Data
3Combining Multiple Data Sources
Module 3
Data Modelling
Data Modelling
1Understanding Tables and Relationships
2Fact and Dimension Tables
3Building a Simple Star Schema
Module 4
DAX Fundamentals
DAX Fundamentals
1Calculated Columns vs Measures
2Core DAX Measures: CALCULATE, DIVIDE and Iterator Fundamentals
3KPIs, Filter Context and Time Intelligence Fundamentals
Module 5
Visualisation
Visualisation
1Charts, Tables and Cards
2Slicers, Filters and Interactions
3Designing a Clear Dashboard Layout
Module 6
Complete Dashboard Project
Complete Dashboard Project
1Building the Dashboard
2Testing, Accessibility and Improving Dashboard User Experience
3Publishing, Sharing and Presenting Insights in Power BI Service