Gain insights into your data! Power BI (business intelligence) is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free. In this course, you will discover how to quickly extract, transform, and load data with just a few clicks. You will create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions.
Agenda
Unit 1: Overview
- Power BI Components
- Install Power BI Desktop (free software)
- Getting started
Unit 2: Connect with Data Sources
- Types of data sources
- Import Excel and text files
- Connect to databases (Access)
- Import data from the Web
Unit 3: Transform Data
- Introduction to Power Query
- Shape data
- Filter data
- Understand the Data Model
Unit 4: Creating Reports
- Overview
- Create visuals
- Format reports
- Share your files