Course Overview
This course is designed as an introduction to Power BI for data analysis and reporting. Skills include connecting to data and basic data preparation tasks using Power Query, designing report pages for optimal user experience, and exploring how Copilot in Power BI aids the report development process.
Who should attend
This course is intended for professionals interested in transforming data into interactive reports using Power BI to deliver insights and support decision-making. No prior experience with Power BI is required.
Prerequisites
Completion of the Get started with Microsoft data analytics is recommended as you should be familiar with data and analytics concepts.
Course Content
Course Modules
- Get started building with Power BI
- Learn about Power BI, the building blocks and flow of Power BI, and how to create compelling, interactive reports.
- Get data in Power BI
- You'll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data.
- Clean, transform, and load data in Power BI
- Power Query has an incredible number of features that are dedicated to helping you clean and prepare your data for analysis. You'll learn how to simplify a complicated model, change data types, rename objects, and pivot data. You'll also learn how to profile columns so that you know which columns have the valuable data that you’re seeking for deeper analytics.
- Configure a semantic model in Power BI
- Semantic models organize complex data into an intuitive structure, enhancing data visualization and enabling efficient, insightful reporting for better decision-making.
- Design Power BI reports
- Design effective Power BI reports that are visually appealing and easy to understand with consistent report structure, interactive objects, and filtering.
- Get started with Copilot in Power BI
- Copilot in Power BI increases productivity when developing semantic models and reports using Power BI. Copilot also allows you to interact with your data using natural language to gain insights.
- Introduction to end-to-end analytics using Microsoft Fabric
- Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Learn about Microsoft Fabric, how it works, and identify how you can use it for your analytics needs.