Learn how to use one of the most popular analytics tools available: Microsoft Power BI.
Overview
Syllabus
Introduction
- Top skills for Power BI
- What is Power BI?
- Connecting to multiple data sources
- Data modeling
- Data Analysis Expressions (DAX)
- Data visualization
- Download and install Power BI
- Interface introduction
- How to connect to data
- Query Editor
- Basic table transformations
- Date transformations
- Aggregation
- Text transformations
- What is a data model?
- Database normalization
- Types of tables
- Cardinality
- Creating a data model
- Introduction to DAX
- Calculated columns
- Measures
- Report view interface
- Bar chart
- Line graph
- Map
- Building dashboards
- Creating slicers
- Customizing the view
- Next steps
Taught by
John David Ariansen and Madecraft
