Course Overview:

The Power BI Training Course is an integrated suite of applications, software services, and connectors that work together to transform disparate and unconnected data sources into clear, interactive, and visually rich insights. This interactive business analytics system from Microsoft helps you easily connect to various data sources and visualize them effectively.

With Power BI, individuals can obtain data from a wide range of cloud systems and create dashboards that track their most important indicators. This technology enables organizations to closely monitor their operational performance and get instant results through real-time dashboards that work on all devices.

By enrolling in the Power BI Training Course, anyone can become a proficient data analyst. All topics and modules are structured for easy learning, making the course highly engaging. Our friendly instructors ensure all trainees are empowered to use Power BI successfully and professionally.

Course Objectives:

In this course, you will learn how to analyze data using Power BI Training Course, enabling you to:

1. Analyze data using Self-Service Business Intelligence
2. Connect to various data sources
3. Perform data cleaning, initial analysis, processing and shaping
4. Visualize data using Power BI
5. Enhance data analysis by adding and customizing visual elements
6. Model data using calculations
7. Create interactive visualizations
8. Use advanced analytics techniques
9. Optimize reports and dashboards
10. Publish and share reports and dashboards
11. Extend Power BI usage beyond the desktop environment

Course Modules:

Module One: Introduction to Power BI Desktop

1. Design queries using Query Editor window
2. Import data according to Star Schema model
3. Build data model using DAX language
4. Design interactive reports using Bookmarks
5. Design reports using Drill-through pages
6. Publish PBIX project files to Power BI Service

Module Two: Designing Advanced Queries using M Language

1. Understand query design and ETL process
2. Introduction to programming using M language
3. Understand Query Folding concept
4. Design using query functions
5. Design using Query Parameters
6. Create reusable project template files

Module Three: Developing Custom Data Connectors

1. Understand the role of custom data connectors
2. Development using Power Query SDK
3. Package, deploy and test custom data connector
4. Configure authentication for custom data connector
5. Understand authentication flows using OAuth2
6. Create custom data connector for Microsoft Graph API

Module Four: Programming with TypeScript and D3.js Library

1. Introduction to TypeScript language
2. Getting started with D3 and SVG graphics
3. Create data-driven visualizations
4. Enhance visualizations using scales and axes
5. Use D3 layouts
6. Handle events and transitions

Module Five: Getting Started with Power BI Developer Tools

1. Develop custom visuals in Power BI
2. Getting started with Visual Studio Code
3. Work with Node.js and NPM package manager
4. Create custom visual projects using PBIVIZ
5. Understand custom visual build process
6. Test and debug custom visuals

Module Six: Developing and Deploying Custom Visuals

1. Understand Power BI Visuals API interface
2. Define visual capabilities and data binding
3. Program data binding using D3 style with categorical data
4. Extend visuals with custom properties
5. Package and publish custom visuals

Module Seven: Programming with the Power BI Service API

1. Overview of Power BI Service API
2. Register applications in Azure Active Directory
3. Program authentication and manage Access Tokens
4. Develop custom applications for publishing PBIX files
5. Update data source credentials and refresh datasets

Module Eight: Developing with Power BI Embedded

1. Overview of Power BI embedding capabilities
2. Understand differences between Premium and Embedded capacities
3. Retrieve embedding data using Power BI Service API
4. Create and manage Embed Tokens
5. Use Power BI JavaScript API to embed reports and dashboards
6. Write client-side code to interact with embedded reports

Module Nine: Securing Datasets with Row-Level Security (RLS)

1. Understand Row Level Security concept
2. Apply RLS in Power BI Desktop projects
3. Design using User-Owns-Data model
4. Apply dynamic RLS using USERNAME function
5. Design using App-Owns-Data model
6. Create embed tokens restricted by RLS roles

Module Ten: Developing Streaming Datasets and Real-time Dashboards

1. Introduction to Real-time Datasets
2. Create streaming dataset using C#
3. Design dashboards using streaming data elements
4. Create Push Dataset with real-time data
5. Integrate Azure Streaming Analytics tasks

Module Eleven: Getting Started with R in Power BI

1. Overview of R language as data analysis platform
2. Introduction to R programming language
3. Write and test scripts using RStudio
4. Use R packages to create charts and graphs
5. Use R script to import data into Power BI Desktop
6. Create reports using R Script Visual element

Module Twelve: Developing Custom Visuals with R

1. Structure of custom visualizations using R
2. Define dependencies for CRAN packages
3. Bind data fields to R script file
4. Develop and debug R script
5. Package and publish custom visualizations using R

Power BI Training Course