Microsoft PowerBi (MPBi)
Overview
It is intended for users to master how to use the Power BI application to build reports through visuals. The course will focus on connecting to data and creating reports using the Power BI Desktop application.
Additional Information
Who should do this course?
Anyone who wants to gain knowledge of Microsoft Power BI by learning to connect to data files and using the data to build reports using various visuals and then Publish it to Power BI Service.
Pre-requisites
No prior knowledge of Microsoft Power BI is required. It would be beneficial if you have some knowledge of Excel intermediate in place.
Outcomes
- Introduction to Microsoft Power BI.
- Understand the elements of Microsoft Power BI.
- Using the Microsoft Power BI Desktop element.
- Connect to data.
- Transform data using the Power Query Editor.
- Changing data types.
- Find and replace data and errors.
- Using Split on columns.
- Refresh data from the source.
- Understanding basic DAX calculations.
- Understanding how to model data through relationships.
- Inserting visuals to build a report.
- Formatting visuals.
- Insert and manage report pages.
- Sorting information within visuals.
- Apply conditional formatting on visuals.
- Manage a visual’s aggregation.
- Using the highlight feature on visuals.
- Manage how visuals interact.
- Using focus mode.
- Understanding and using various filter options.
- Insert text boxes.
- Inserting and managing themes.
- Introduction to Power BI Service.
- Publish a report to Service.
- Navigate around Power BI Service.
- Create a dashboard in Power BI Service.
- Share a report.
Learning Methodologies:
Duration:
2 Days
*Pricing available upon request.
Contact training@dev.metrominds.co.za
for group pricing