Course Overview
This Introduction to Power BI training class teaches how to build and share Power BI reports. Attendees learn how to shape, combine, and organize data from multiple sources to support their reporting needs. They learn how to create interactive visualizations, reports, and dashboards for maximum impact. Participants can take their new skills and immediately apply them to their current projects.
Key Learning Areas
- Navigate the Power BI environment
- Prepare data for building reports
- Understand data modeling
- Work with Power Query to shape data
- Use common DAX functions
- Build interactive visualizations and reports
- Design Power BI reports for maximum clarity and impact
- Generate actionable insights from your data
- Share reports using the Power BI Service
Course Outline
Overview of Power BI
- Reviewing the Power BI environment & flow
- Working with data sources
- Review storage mode options
- Modifying data source settings
- Examine the data, model, and report panes
- Building a visualization
- Publishing a visualization
Introduction to Data Modeling
- Review data terminology
- Understand relationships
- Unions of data
Using Power Query
- Introduce Power Query and tour the interface
- Remove rows and columns
- Fill data
- Unpivot data
- Combining queries
- Add custom columns
Introduction to DAX
- Introduction to DAX
- Understanding context
- Common functions
Building Basic Visualizations
- Building a visualization
- Sorting
- Filtering
- Using slicers
- Creating new columns and measures
- Using tooltips
- Grouping data
- Conditional formatting
- Creating bookmarks
Using the Power BI Service
- Publishing reports
- Understanding Workspaces
- Building dashboards
- Sharing dashboards and reports
- Data alerts and subscriptions
- Analyze in Excel
Prerequisites
No prior experience is required.