Prerequisites:
Participants should have a strong knowledge of Excel 2010, 2013 or 2016 and have an understanding of data analysis.
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, cleanse and transform data with just a few clicks. They will also learn that 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.
Advanced Project Topics
- Getting Started
- Explore Power BI interface:
- Get Data
- Power BI data Sources
- Connecting to Excel Data
- Connecting to CSV file
- Connecting to an Access database
- Connecting to Facebook
- Importing Excel Data Model
- Shaping Combining and Merging Data
- Reducing Data with Query Editor
- Transforming Data
- Inserting Custom Columns
- Appending Data to a Query
- Adding an Index Column
- Cleaning up Data
- Creating Relationships between tables
- Merging data
- Using Lookup tables in a dataset
- Create Visualizations & Reports
- Creating and arranging Visualizations
- Creating text visuals, Cards, table, matrix
- Creating and formatting chart visuals
- Using a slicer to filter visuals
- Creating a map visualization
- Share your work
- Publish to Power BI services
- Republishing a dataset to Power BI services
- Refreshing and removing datasets and reports
- Sharing and unsharing reports
