Learn how to clean, transform, model, and visualize data with Microsoft Excel and Power BI.
Overview
Syllabus
Introduction
- Transforming and refining your data
- Power BI desktop vs. Excel
- Business intelligence (BI) with Excel
- Excel business intelligence add-ons
- Pros and cons of Excel
- Cleaning data in Excel
- Combining data in Excel
- Creating calculations in Excel
- Visualizing trends in Excel
- What is Power BI?
- Connecting to multiple data sources
- Data modeling
- Introduction to DAX
- Visualizing data
- Connecting to and cleaning data
- Creating calculated columns in Power BI
- Implicit vs. explicit measures
- Building a data model
- Data tables vs. lookup tables
- Building line graphs
- Building bar charts
- Building geomaps
- Creating a slicer
- Creating a dashboard
- Next steps
Taught by
John David Ariansen and Madecraft
