Microsoft Power BI - Beginner

Learn how to transform raw data into meaningful insights with Microsoft Power BI. This course covers data modeling, visualization, and reporting techniques, enabling you to create interactive dashboards for informed decision-making.

Telecommunication Engineering College (TEC)
Next In Career
Office Automation
Microsoft Power BI

The Microsoft Power BI Beginner course is designed to provide participants with a comprehensive understanding of how to leverage Power BI for business intelligence, data analysis, and interactive data visualizations. Participants will learn how to implement self-service BI solutions, connect to multiple data sources, model data, and create powerful visual reports. This course is ideal for professionals seeking to transform raw data into meaningful insights to support data-driven decision- making. The course consists of six modules, each covering essential aspects of Power BI.

This course is specifically designed to provide participants with :

An understanding of the essential elements that comprise a self-service business intelligence solution.
A comprehensive introduction to Power BI and its various data sources.
Skills to model, shape, and combine data effectively for analysis.
Insight into the various data visualization options available in Power BI for clear and effective presentation of insights.

Module 1: Introduction to Self-Service BI Solutions

- Introduction to business intelligence.
- Introduction to data analysis.
- Introduction to data visualization.
- Microsoft tools for self-service BI.

Module 2: Introducing Power BI

- Power BI Desktop.
- Creating a Microsoft account and its advantages.
- Creating a Microsoft account and its advantages.
- Microsoft Power BI vs Other BI applications.

Module 3: Power BI Data

- Identify and connect to a data source.
- Handling data from multiple sources.
- Changing the data source settings.
- Select a storage mode/ load setting.
- Examine data structures, interrogate column properties.
- Remove unnecessary rows / columns for optimisation of performance.

Module 4: Interactive Data Visualizations

- Creating Power BI reports.
- Adding visuals to reports & choosing the right visuals.
- Configure and formatting visuals.
- Importing custom visuals from App Source.
- Importing downloaded visuals from file.
- Using slicers to filter visuals.
- Using the filter pane to filter visuals & reports.
- Perform top N analysis.
- Sorting visuals and configuring a custom sort.
- Creating a hierarchy and performing drilldown into data.
- Use built-in measures to summarize data.
- Edit and configure interactions between visuals.
- Design and configure for accessibility.

Module 5: Shaping and Combining Data

- Introduction to Power Query.
- Resolve inconsistencies, unexpected / null values, and data quality issues.
- Identify and create keys for joins.
- Transforming and re-shaping data, date transformations.
- Apply user-friendly naming conventions to columns and queries.
- Multiple scenarios in appending data.
- Merging data vs related tables.
- Configure data loading.
- Formulas in Power Query.

Module 6: Modelling Data

- Introduction to Power Pivot.
- Understanding Relationships.
- Introduction to Data Analysis Expression (DAX).
- Formulas in Power Pivot - Calculated columns and measures.
- Handling dates in Power Pivot.
- Best practice in data modelling.
- Building an Interactive Report.

Office Automation

Microsoft Power Automate

Microsoft Power BI - Beginner

PRICE (2 Days) Physical
PRICE (2 Days) Online

Language English, Malay

Office Automation More Course