Data must sometimes be modeled for use in analytic software such as Power BI. This can reveal patterns and relationships that can be conveyed in a quick and compact form using visualizations.
Learning Objectives
Data Modeling
- start the course
- recognize when to use Data View in Power BI Desktop
- recognize when to use Relationship View in Power BI Desktop
- navigate through Desktop View in Power BI Desktop
- navigate through Relationship View in Power BI Desktop
- explain the purpose of DAX, including syntax
- create a DAX measure formula
Data Visualization
- define how visualization can quickly convey messages from large datasets
- explain how KPIs are used to measure progress
- explain how to work with and create reports
- create a report in Power BI
- explain how dashboards can be used to monitor data at a glance
- create a custom Power BI dashboard
- share a Power BI dashboard with other users
- filter visualizations using slicers
Practice: Prepare Data for Visualizations
- ensure data is in a form usable by Power BI for querying and visualization