What You Will Learn
By the end of this course you will be able to connect to data sources, build interactive dashboards, and share insights confidently using Microsoft Power BI.
Course Content
- What Power BI is and how it fits into Microsoft 365
- The Power BI Desktop interface and views
- Connecting to Excel and CSV data sources
- Understanding the data model — tables and relationships
- The Report, Data and Model views
- Saving and publishing your first report
- Bar charts, column charts and line charts
- Tables, matrices and card visuals
- Maps and filled maps for geographic data
- KPI and gauge visuals
- Formatting visuals for a professional finish
- Arranging visuals on the report canvas
- Page filters, visual filters and report filters
- Adding slicers for interactive filtering
- Cross-filtering between visuals
- Drill-down in charts and hierarchies
- Bookmarks for saved views
- Tooltips and visual interactions
- Publishing from Power BI Desktop to the Service
- Navigating the Power BI web interface
- Creating and sharing dashboards
- Setting up scheduled data refresh
- Row-level security basics
- Mobile layout and the Power BI app
Who Should Attend?
Excel Users Ready for the Next Step
Comfortable with Excel and wanting to create more powerful, visual reports
Analysts and Reporting Professionals
Spending too long creating manual reports and ready to automate them
Managers and Team Leaders
Needing clear, visual dashboards to monitor team and business performance
Anyone Working with Data
Who wants to present data more compellingly and share insights across their organisation
Before & After This Course
Before
- Spending hours building reports manually in Excel
- Sharing static spreadsheets that go out of date immediately
- Unable to create the visual dashboards your management team wants
After
- Building interactive visual reports in a fraction of the time
- Publishing dashboards that refresh automatically
- Sharing clear, compelling insights across your organisation
