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.
- 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