About this course
This is a beginner’s course and aims to give the new Power BI user a thorough grounding in the basics of working with spreadsheet data from Excel to create visualisations, charts and reports in Microsoft Power BI.
Business Intelligence software tools help you to clearly visualise and analyse reports for your business organisation.
Review the course outline below to see what is covered.
Face-to-Face Delivery:
- Learn from certified trainers with real-world experience.
- Participate in interactive learning experiences.
- Feel supported through your studies with our dedicated Student Support Days to provide one on one guidance.
Rather study online?
Check out our Microsoft Power BI – Level 1 Online Course for online delivery.
Prerequisites
This course requires at least an Intermediate – Level 2 knowledge of Microsoft Excel with at least several months’ experience in using Excel at this level prior to attending Power BI Level 1.
Is Power BI the same as Excel?
Power BI does not edit, add or change data like Excel does. It allows the creation of powerful dashboards and visually appealing graphical visualisations of existing data provided by Excel and other programs. It also leverages powerful tools to tidy up and fully normalise data from Excel into “Fact” and “Dimension” tables to allow much more efficient manipulation of the data.
Course structure and content
The following topics are covered in Level 1:
- Introduction
- Using Data from Excel
- Power Bi Desktop
- Data Normalisation
- Visualisations
- From Visualisations to Reports
- More Visualisations
- Using Visual Interactions
- Working with Filters
- Spatial Visuals
- Q&A and Analysis
- Custom Visuals
- Publish to Power BI Service
- Create Dashboards
- Working with dashboards
- Refreshing Data
- Share reports and dashboards
- Getting help
- Working with Formats in a Visualisation
- Power BI Mobile
- Data Samples
View the attached document below for further information.