COURSE DURATION: 5 Weekdays | 3 Weekends
Data Analysis using Power BI Training - Overview
This official Microsoft Analyzing Data with Power BI 20778 course provides a comprehensive understanding of how to analyze data with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
Power BI (Business Intelligence) is a business analytics service that delivers insights for analyzing data. It can share those insights through data visualizations which make up reports and dashboards to enable fast, informed decisions. Power BI scales across an organization, and it has built-in governance and security allowing businesses to focus on using data more than managing it.
The Power BI Training prepares you for Microsoft exam 70-778, a core requirement for the MCSA: BI Reporting
Why MCSA BI Certification
- Gaining an international Microsoft Certification is a mark of capable data Analyst
- It identifies you as a proven Power BI (Business Intelligence) professional to colleagues, employers, customers
- Benefits from guidance and feedback of experienced Microsoft Trainer
Data Analysis with Power BI Learning Outcome
At the end of the Power BI training, participants will be able to demonstrate the following knowledge and be able to write and pass the MSCA: BI Reporting Certification exam.
- Good understanding of how to use Power BI to perform data analysis.
- Proficient in connecting to data sources and performing data transformations,
- Modelling and visualizing data by using Microsoft Power BI Desktop,
- Configuring dashboards by using the Power BI service.
- Implementing direct connectivity to Microsoft SQL Azure and SQL Server Analysis Services (SSAS), and implementing data analysis in Microsoft Excel.
Audience Profile
Participants in this Power BI Training may include BI professionals, data analyst, and other roles responsible for creating a report using Power BI.
Pre-requisite
Before attending this course, students must have:
- Some basic knowledge of data warehouse schema topology.
- Some exposure to basic programming constructs (such as looping and branching).
- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
- Familiarity with Microsoft Office applications – particularly Excel.
Data Analysis Using Power BI - Course Outline
Module 1 – Introduction to self-service BI Solutions
- Labs: Exploring an Enterprise BI solution
Module 2 – Introducing Power BI
- Lab: Creating a Power BI dashboard
Module 3 – Power BI Data
- Importing data into Power BI
Module 4 – Shaping and Combining Data
Module 5 – Modelling Data
Module 6 – Interactive Data Visualizations
- Lab: Creating Power BI reports
Module 7 – Direct Connectivity
Module 8 – The Development with Power BI
Module 9 – Power BI mobile app