Prerequisites
Participants should have a average knowledge of Excel 2016 or later and have an understanding of Power Pivot and Power Query in Excel.
Course Overview
This course is designed to provide participants with a fundamental understanding of the capabilities of Power BI. Students will discover how to quickly gather, clean and transform data with just a few clicks. They will also learn how to enhance results by integrating disparate data sources and add simple calculations using DAX functions and queries. Participants will create visualizations and incorporate them into dashboards that can provide up to the minute reporting. At the end of this course, participants will have a solid understanding of the skills required to use Power BI Desktop.
Power BI Desktop Topics
1. What is Business Intelligence? Why do I need it?
2. Getting Started with Power BI desktop
3. Explore Power BI interface:
4. Get Data from: Wherever it exists!
5. Power BI data Sources
6. Connecting to Excel Data
7. Connecting to CSV file
8. Connecting to an Access database
9. Shaping Combining and Merging Data
10.Reducing Data with Query Editor
11.Transforming Data
12.Inserting Custom Columns
13.Appending Data to a Query
14.Adding an Index Column
15.Cleaning up Data
16.Creating Relationships between tables
17.Merging data
18.Using Lookup tables in a dataset
19.Create Visualizations & Reports
20.Creating and arranging Visualizations21.Creating text visuals, Cards, table, matrix
22.Creating and formatting chart visuals
23.Using a slicer to filter visuals
24.Creating a map visualization
25.Publish to Power BI services
