Microsoft Power BI Training

Microsoft Power BI Training introduces the delegates with the Power BI and how it is used for data mashup along with Power Pivot for Data Modeling. With the help of this training, the delegates will able to learn about the (DAX) Data Analysis Expressions and Data Visualization with Power BI Desktop, Power Map and Power View. The training also provides knowledge to the delegates about the Variables in DAX expressions and Table Relationships in DAX. The delegates will also learn about Dashboards, Reports, Tiles Quick Insights and Power BI Publisher. At the end of the training, the delegates will able to connect directly to Azure, HD Spark, My SQL, and create interactive dashboards.

This course will explain about the Power BI, its building blocks and the several different fundamental concepts of Power BI. The course also introduces the delegates to the Power BI Desktop. The training helps the delegates to understand the relationships between data tables. The delegates will also learn the following - DAX Calculation Types, DAX Functions for Advanced Calculations and Time Intelligence Functions. With the help of training, the delegates will able to understand the benefits of Data Visualization, Power BI Desktop Visualization, Custom Visuals in Power BI, Formatting Visuals and creating charts. Throughout the training, the delegates will able to learn about the Azure Machine Learning model inside Power BI.

Introduction to Power BI

• Overview of BI concepts
• Why we need BI?
• Introduction to SSBI
• SSBI Tools
• Introduction to Power BI
• Why Power BI?
• Building Blocks of Power BI
• Getting started with Power BI Desktop

Data Analysis Expressions (DAX)

• Manage Data Relationship
• Optimize Data Models
• What is DAX?
• Data Types in DAX
• Calculation Types
• DAX Functions: Date and Time, Time Intelligence, Information, Logical, Mathematical, Statistical, Text and Aggregate
• Measures in DAX

Power BI desktop

• Extracting data from various sources
• Workspaces in Power BI
• Data Transformation
• Measures and Calculated Columns
• Query Editor

Data Visualization

• How to use Visual in Power BI?
• Charts in Power BI
• Matrixes and tables
• Slicers
• Map Visualizations
• Gauges and Single Number Cards
• R Visuals in Power BI
• What Are Custom Visuals?
• KPI Visuals
• Data Binding
• Power BI report server

Introduction to Power BI Q&A and Data Insights

• Why Dashboard?
• Dashboard vs. Reports
• Creating Dashboards
• Configuring a Dashboard: Dashboard Tiles, Pinning Tiles
• Power BI Q&A
• Quick Insights in Power BI
• Power BI embedded
• REST API

Direct Connectivity

• Custom Data Gateways
• Exploring live connections to data with Power BI
• Connecting directly to SQL Azure, HD Spark, and SQL Server Analysis Services/ My SQL
• Introduction to Power BI Development API
• Excel with Power BI: Connect Excel to Power BI, Power BI Publisher for Excel
• Content packs
• Update content packs

Integrating Power BI and Azure ML

• Extracting data out of Azure SQL using R
• Using R, call the Azure ML web service and send it the unscored data
• Writing the output of the Azure ML model back into SQL
• Read scored data into Power BI using R
• Publishing the Power BI file to the Power BI service
• Scheduling a refresh of the data using the Personal Gateway