Power BI is the hot topic application in the Microsoft ecosphere, but not many people know what it is, or what it does. Learn what makes Power BI tick, and how you can use it right out of the gate.
There’s no time like the present for getting your hands dirty and creating a Power BI Dashboard. Power BI has one of the steepest learning curves, but you’ll walk away with a clear understanding of where to begin.
Power BI gets its power from its ability to shape and visualize data. This class will introduce to you to different methods for importing data and it will set the best practices for your future work.
Power Query is one of two sister programs that works alongside Power BI to build dashboards. Power Query specializes in getting data from a variety of sources and then cleaning it up for you to use in your dashboards.
- Power BI Desktop vs Power BI Service
- Reports vs. Dashboards
- Learning your Way Around Power BI
- Power BI Terminology
- Views in Power BI Desktop
- Working with Visualizations in Power BI Desktop
- Importing Data
- Folder Names and File Names
- Data Best Practices
- Power BI Theme
- Adding Visualizations
- Fact and Dimension Tables
- Introduction to Power Query
- Data Terminology
- Data Cleanup
- Data Types
- Why you need to build data
- M Code in the Advanced Editor
- Data Source Paths
- Parameters
- Creating Date Tables