-
Unleash the power of Microsoft Excel with Power BI. Learn how to clean, transform, model, and visualize data with Excel and Power BI.
Take your analysis skills to the next level. Power BI is a powerful data analytics tool that is streamlining the way business works with data. In this course, you can learn how to combine the power of a familiar tool, Microsoft Excel, with all the potential offered by Power BI. Discover how to conduct power pivots, import data, clean and shape data, as well as model data, perform calculations with Data Analysis Expressions (DAX), and visualize data with the variety of built-in charts and graphs in Power BI. Plus, explore a great primer on PivotTables and PivotCharts. By the end of this course, you will be equipped with new skills to take your data analysis to the next level.
This course was created by Madecraft. We are pleased to host this content in our library.
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
