Description of the training program (data presentation path using Microsoft Power BI)
The Data Visualization Path using Microsoft Power BI training course covers several aspects of data analysis, which are:
- Giving the trainee a good understanding of data analysis using BI Power.
- Visual representation of data.
- Create BI Power services.
- Create BI Power applications for mobile users
Detailed objectives of the training program
The course on data visualization using Microsoft Power BI aims to provide the trainee with the following skills:
- Explore and expand the classic Microsoft Excel Dashboard.
- Explore the Microsoft Excel data model.
- Pre-formatting and CSV import.
- Import data from a SQL Server database.
- Import data from a report.
- Create procedures using advanced DAX functions.
- Create data visualizations in Microsoft Excel.
- Create a BI Power dashboard using Microsoft Excel.
Training program topics
The first week
Determine the data source and connect to it
- Change data source settings
- Select a shared dataset or create a local dataset
- Determine the storage method
- Choose the appropriate type of inquiry
- Identify query performance issues
- Use appropriate metrics
-
The second week
Identify different data
- Examine the data structure
- Check column properties
- Check data statistics
- Determine the data source and connect to it
- Change data source settings
The third week
Select a shared dataset or create a local dataset
- Determine the storage method
- Choose the appropriate type of inquiry
- Identify query performance issues
- Use appropriate metrics
- Identify different data
- Examine the data structure
- Check column properties
- Check data statistics
Fourth week
Resolve inconsistencies, unexpected or null values, and data quality issues
- Apply valuable, easy-to-use alternatives
- Identify and create appropriate keys for connections
- Evaluate and convert column data types
- Apply data shape transformations to the table structure
- Combine queries
- Apply easy-to-use naming conventions to columns and queries
- Utilize the advanced editor to modify Power Query M code
- Initialize data loading
- Handling data import errors