Power BI Course

A Power BI course is a program of study that teaches students how to use Power BI, a business analytics service provided by Microsoft that allows users to analyze data and share insights. The course focuses on using Power BI to create interactive dashboards, reports, and data visualizations.

In a Power BI course, students will learn about the basics of Power BI, including data sources, data modeling, data visualization, and report building. They will also learn about advanced Power BI features such as DAX (Data Analysis Expressions), Power Query, and Power Pivot.

The course may cover topics such as creating and formatting visualizations, designing interactive dashboards, sharing reports and dashboards, and the use of Power BI Desktop and Power BI Service. Additionally, students may learn how to connect to various data sources such as Excel, CSV, SQL Server, and cloud-based sources.

Course Modules

Getting started

• Introducing Power BI
• A quick look at Power BI Desktop
• A quick look at the Power BI service

Power BI and Excel

• Introduction - using Excel data in Power BI
• Upload Excel data to Power BI
• OneDrive for Business with Excel
• Import Power View and Power Pivot to Power BI

Shaping and Transforming Data

• Introduction to the Query Editor
• Clean and transform your data with the Query Editor
• Cleaning irregularly formatted data

Modeling

• Introduction to modeling your data
• How to manage your data relationships
• Optimizing data models
• Introduction to DAX
• DAX calculation types
• DAX functions
• Create calculated columns
• Create calculated measures
• Create calculated tables Explore your time-based data

Visualizations

• Introduction to visuals in Power BI
• Create and customize simple visualizations
• Modify colors in charts and visuals
• Shapes, text boxes, and images
• Page layout and formatting
• Interactions among visualizations
• Visual hierarchies and drill-down
• Using custom visualizations
• R integration in Power BI Desktop

Publishing and sharing

• Introduction to the Power BI service
• Publish Power BI Desktop reports
• Create and configure a dashboard
• Share dashboards with your organization
• Quick insights in Power BI
• Introduction to security, and workspaces
• Create workspaces in Power BI
• Manually republish and refresh your data
• Install and configure a personal gateway
• Print and export dashboards and reports
• Publish to web

Getting Data

• Available data sources in Power BI Desktop
• Connecting to data sources
• Connecting to a database
• Connecting to a CSV file