Data Analysis
Collect, clean and analyse data with spreadsheets and Python so you can answer business questions.
Power BI training
Connect to data, build interactive dashboards and share business reports with Microsoft Power BI.
Course overview
Learn to turn business data into interactive dashboards with Microsoft Power BI. You will connect to data, clean it, model it and build reports that decision makers can use.
Requirements
- A Windows computer
- Basic Excel knowledge helps
- No coding needed
What you will learn
- Connect to and transform data
- Build a data model with relationships
- Write basic DAX measures
- Design and share interactive dashboards
Practical projects
- A sales dashboard
- A finance or operations report
Skills you will gain
- Power BI
- Power Query
- Data modelling
- DAX basics
- Dashboard design
Career and application opportunities
- Business intelligence analyst
- Reporting analyst
- Data analyst
Curriculum
1Getting started with Power BI
- What Power BI is
- The Power BI interface
- Connecting to data
- Loading data
2Preparing data
- Power Query basics
- Cleaning and shaping data
- Merging and appending
- Handling errors
3Data modelling
- Tables and relationships
- Star schema basics
- Calculated columns
- Introduction to DAX
4Building reports
- Choosing visuals
- Filters and slicers
- Formatting reports
- Telling a story with data
5Sharing and capstone
- Publishing reports
- Dashboards and sharing
- Refresh basics
- Capstone dashboard
Related courses
Data Science
Combine programming, statistics and visualisation to turn raw data into insight and predictions.
Database Management
Learn to design, build, secure and maintain databases that applications depend on.