This is our intermediate level Power BI course. It is designed for people who have some experience with MS Power BI Desktop. It builds on our Get Started with Power BI (Beginners) course.

The course is built around Power BI Desktop - you need your own copy (free from Microsoft). Like all our Power BI courses, we put a lot of emphasis on practical, hands-on activities in Power BI Desktop.

Course content includes:

1. Quick refresh - importing data from MS Excel and why the format matters.
2. Building more complex reports.
3. Multiple data sources - not just Excel.
4. Connecting tables - building relationships.
5. Doing more with DAX and Measures.
6. Report design - understand your audience.
7. Sharing reports via the online Power BI service - data refresh & permissions.

The course is designed so that you:

1. Strengthen your Power BI data analysis skills.
2. Learn how to use DAX to build more sophisticated reports in Power BI.
3. Know how to create interactive Power BI reports that make it easy for people to explore complex datasets and understand the insights that come from your data analysis.

Prerequisites

To get maximum value from the course you need to have reasonable MS Excel skills. You should know how to use Power BI Desktop to:

1. Import data tables from Excel
2. Build basic reports with visualisations like slicers, line graphs, bar & column charts.
3. Extend your data model with calculated columns and measures
4. Export your report to the online Power BI service

Can I bespoke the course?

The best way to bespoke the course is to ask us to build around your own data. We can replace our own course sample data with some of your spreadsheets. That way at the course you have a working, fully interactive report built in Power BI Desktop that you can use and share with colleagues.

Online training requirements

You will need:

• A good internet connection
• Webcam & audio
• MS Windows PC with Power BI Desktop (download is free from Microsoft).

Payment

We invoice for payment before the course starts.