This training covers some practical methods for creating and managing reports for business users by preparing data and visualizing information.
The training covers some practical methods for visualizing, analyzing, preparing, and modeling a typical business environment. Participants will learn about major tools that assist in designing and building scalable data models, cleaning and transforming that data, and enabling analytical capabilities that provide meaningful business value via easy-to-comprehend data visualizations. Participants will learn about major tools that assist in designing and building scalable data models, cleaning and transforming that data, and enabling analytical capabilities that provide meaningful business value via easy-to-comprehend data visualizations.
Participants are expected to demonstrate correct applications of the basic features of PowerBI and complete tasks independently.
Knowledge of MS Excel
1. Prepare the data (4 hours: 2h theory, 2h practice)
1.1. Get data from different data sources
1.2. Clean, transform, and load the data
1.3. Profile the data
2. Model the data (4 hours: 2h theory, 2h practice)
2.1. Design a data model
2.2. Create measures by using DAX
2.3. Optimize model performance
3. Visualize the data (2 hours: 1h theory, 1h practice)
3.1. Create reports
3.2. Enrich reports for usability
TOTAL: 10 hours (50% theory, 50% practice)
Viacheslav Plastun