Course Overview:

Microsoft Power BI is a complete set of applications, software services, and connectors. These tools work together to change different and unconnected data sources into clear, interactive, and visually appealing insights. It is a business analytics service from Microsoft. It helps users connect to different data sources easily. Users can also visualize data in a clear and meaningful way.

With Power BI, people can get data from many cloud-based systems. They can also create dashboards to track the metrics that matter most to them. This technology empowers organizations to closely monitor operational performance and gain immediate insights through real-time dashboards accessible across all devices.
By enrolling in the Microsoft Power BI training course, participants can become competent and confident data analysts. All topics and modules are easy to learn. This makes the course engaging. Our friendly and experienced instructors help learners use Power BI successfully and professionally.

Course Objectives:

In this course, you will learn how to analyze data using Microsoft Power BI. By the end of the course, you will be able to:

• Analyze data using Self-Service Business Intelligence (BI)
• Connect to various data sources
• Perform data cleaning, profiling, transformation, and shaping
• Visualize data using Power BI
• Enhance data analysis by adding and customizing visual elements
• Build data models using calculations
• Create interactive visualizations
• Apply advanced analytics techniques
• Optimize reports and dashboards
• Publish and share reports and dashboards
• Extend Power BI usage beyond the desktop environment

Course Modules:

Module 1: Introduction to Power BI Desktop

• Designing queries using the Query Editor
• Importing data using the Star Schema model
• Building data models using DAX language
• Designing interactive reports using Bookmarks
• Creating reports with Drill-through pages
• Publishing PBIX project files to the Power BI Service

Module 2: Advanced Query Design Using M Language

• Understanding query design and the ETL process
• Introduction to programming with M language
• Understanding the concept of Query Folding
• Designing queries using functions
• Designing queries using Query Parameters
• Creating reusable project template files

Module 3: Developing Custom Data Connectors

• Understanding the role of custom data connectors
• Development using Power Query SDK
• Packaging, publishing, and testing custom data connectors
• Configuring authentication for custom data connectors
• Understanding authentication flows using OAuth2
• Creating a custom data connector for Microsoft Graph API

Module 4: Programming with TypeScript and D3.js Library

• Introduction to TypeScript
• Getting started with D3 and SVG graphics
• Creating data-driven visualizations
• Enhancing visuals with scales and axes
• Using D3 layouts
• Handling events and transitions

Module 5: Getting Started with Power BI Developer Tools

• Developing custom visuals in Power BI
• Getting started with Visual Studio Code
• Working with Node.js and NPM package manager
• Creating custom visual projects using PBIVIZ
• Understanding the custom visuals build process
• Testing and debugging custom visuals

Module 6: Developing and Publishing Custom Visuals

• Understanding the Power BI Visuals API
• Defining visual capabilities and data bindings
• Programming data bindings using D3 with categorical data
• Extending visuals with custom properties
• Packaging and publishing custom visuals

Module 7: Programming with Power BI Service API

• Overview of Power BI Service API
• Registering applications in Azure Active Directory
• Implementing authentication and managing access tokens
• Developing custom applications to publish PBIX files
• Updating data source credentials and refreshing datasets

Module 8: Development Using Power BI Embedded

• Overview of embedding features in Power BI
• Understanding the differences between Premium capacities and Embedded capacities
• Retrieving embed details using Power BI Service API
• Creating and managing Embed Tokens
• Using Power BI JavaScript API to embed reports and dashboards
• Writing client-side code to interact with embedded reports

Module 9: Securing Datasets Using Row-Level Security (RLS)

• Understanding the concept of Row-Level Security
• Implementing RLS in Power BI Desktop projects
• Designing using the User-Owns-Data model
• Applying dynamic RLS using the USERNAME function
• Designing using the App-Owns-Data model
• Creating embed tokens restricted by RLS roles

Module 10: Developing Streaming Datasets and Real-Time Dashboards

• Introduction to Real-time Datasets
• Creating a streaming dataset using C#
• Designing dashboards using streaming data tiles
• Creating Push Datasets with real-time data
• Integrating Azure Streaming Analytics tasks

Module 11: Getting Started with R Language in Power BI

• Overview of R as a data analytics platform
• Introduction to R programming language
• Writing and testing scripts using RStudio
• Using R packages to create charts and visualizations
• Using R scripts to import data into Power BI Desktop
• Creating reports using R Script Visual

Module 12: Developing Custom Visuals Using R

• Architecture of custom visuals using R
• Defining dependencies for CRAN packages
• Binding data fields to R script files
• Developing and debugging R scripts
• Packaging and publishing custom visuals using R

Power BI Training Course