Course Overview

Course Description:

The skills provided in this course are a part of the services provided by Power Platform. It is an intermediate-level certification offered by Microsoft. It is designed to help students measure their skills in preparing data, modelling data, visualizing, and analysing data, deploying, and maintaining assets.

Audience Profile:

This course is suitable for Data professionals, Business Intelligence professionals, power BI Data Analysts. Students in this course will gain confidence to take other role-based courses and certifications, such as Power Platform App maker associate, Power platform developer associate, Microsoft Power BI data analyst and Microsoft Power Platform Functional Consultant. This course combines lecture, demonstrations, and hands-on labs. This course will also help prepare someone for the PL-900 exam.

Course Syllabus:

Module 1: Getting Started with Microsoft Data Analytics

• Overview of Data analysis.
• Roles in Data.
• Tasks of a data analyst.
• Self-service BI lifecycle.
• Understanding the role self-service BI plays with IT.
• Use Power BI.
• Building blocks of Power BI

Module 2: Data Discovery with Power BI Desktop.

• Querying Overview
• Data source flexibility
• Identify and connect to a data source.
• Get data from a relational database, like Microsoft SQL Server
• Get data from a file, like Microsoft Excel
• Get data from applications.
• Get data from Azure Analysis Services
• Select a storage mode.
• Fix performance issues
• Resolve data import errors.

Module 3: Transforming Data

• Add Column from Example
• Appending Queries
• Basic Transforms
• Combine Files
• M Query Basics
• Merging Queries
• Other Query Features

Module 4: Design a semantic model in Power BI

• Why is it important to put Data in a Data model?
• Understanding the Modelling engine.
• Model Enhancements.
• Modelling basics.
• What If Parameters.
• Create common data tables.
• Configure many-to-many relationships.
• Resolve circular relationships.
• Design star schemas.

Module 5: Add measures to Power BI model.

• Determine when to use implicit and explicit measures.
• Measure Basics
• DAX Basics.
• Navigation Function.
• Time intelligence functions.

Module 6: Creating calculated columns and Tables.

• Create calculated tables.
• Create calculated columns.
• Identify row context.
• Determine when to use a calculated column in place of a Power Query custom column.
• Add a date table to your model by using DAX calculations.

Module 7: Introduction to Visualizing Data

• Data visualization overview.
• Data visualization best practices

Module 8: Creating Basic Reports in Power BI Desktop

• Creating Bar and Line Charts.
• Combining Charts.
• Using filters.
• Editing the interactions between visuals.

Module 9: Creating Interactive reports.

• Adding Slicers for Filters
• Digital Storytelling
• Other Features
• Using Custom Visuals
• Visualizing Categorical and Trend Data Together
• Visualizing Categorical Data
• Visualizing Data Trends
• Visualizing Geographical Data with Maps
• Visualizing Goal Tracking
• Visualizing Tabular Data

Module 10: Using Power BI Services

• Creating and Sharing Dashboards
• Deploying to the Power BI Service
• Excel Integration
• Export and Embed Options
• Setting up App Workspaces
• Subscriptions and Alerts
• Using Power BI Q&A

Module 11: Refreshing the Data

• Installing the Data Gateway
• Refreshing Data overview
• Scheduling a data refresh

Module 12: Mobile BI

• Designing reports and dashboards for mobile
• Interacting with the Power BI Mobile App
• Power BI Mobile overview

Duration: Two (5) Days

Time Zone: EMEA, NOAM, APAC

Course Fee: 1250 USD

Course Package include:

• Instructor-Led Training
• Exam voucher
• Certificate of Participation
• Labs
• Practice test
• Class recording download
• After Training Career Development Support
• Learning Community free membership for 12 Months (Subsequent membership fee is 20USD /month)

READY TO GET STARTED? ENROLL NOW