Microsoft Power BI Training

The Microsoft Power BI training introduced Power BI to delegates and how to use it for data mashup and Power Pivot for data modeling

ABOUT THE PROGRAM

The Microsoft Power BI training introduced Power BI to delegates and how to use it for data mashup and Power Pivot for data modeling. With the help of this training, participants will be able to understand (DAX) data analysis expressions and data visualization through Power BI Desktop, Power Map and Power View. The training also provided the delegates with knowledge about variables in DAX expressions and table relationships in DAX. Delegates will also learn about dashboards, reports, Tiles Quick Insights and Power BI Publisher. At the end of the training, delegates will be able to connect directly to Azure, HD Spark, My SQL and create interactive dashboards.

CLASSROOM TRAINING: DATES, PRICES AND EVENTS

Course Name Dates Duration Price
Microsoft Power BI Training 18/04/2024 Online Live Instructor
1 day
$ 599
Microsoft Power BI Training 18/04/2024 London
1 day
$ 1299
Microsoft Power BI Training 18/04/2024 Birmingham
1 day
$ 1299
Microsoft Power BI Training 18/04/2024 Leeds
1 day
$ 1299
Microsoft Power BI Training 18/04/2024 Riyadh
1 day
$ 1299
Microsoft Power BI Training 18/04/2024 Jeddah
1 day
$ 1299
Microsoft Power BI Training 18/04/2024 Dammam
1 day
$ 1299
Microsoft Power BI Training 18/04/2024 New York
1 day
$ 1299
Microsoft Power BI Training 18/04/2024 Las Vegas
1 day
$ 1299
Microsoft Power BI Training 18/04/2024 San Francisco
1 day
$ 1299

Reach us at +19661254487 or info@thehubofknowledge.com for more information.

PREREQUISITES

In order to participate in the Microsoft Power BI training, participants should have experience in navigating in a Microsoft Windows environment. It is recommended that you have experience with Microsoft Excel pivot tables and pivot charts.

TARGET AUDIENCE

The course is designed for below professionals

  • Business Analysts
  • Project Managers
  • Statisticians and Analysts
  • Data Scientists
  • Business Intelligence Manager

WHAT WILL YOU LEARN?

After receiving Microsoft Power BI training in MSP training, delegates will be able to:

  • Understand data visualization and integration concepts Perform data binding and formatting
  • Learn how to use Data Gateway, Content Pack and Power BI Report Server
  • Learn how to use and implement custom vision

PROGRAM OVERVIEW

This course will explain the knowledge about Power BI, its building blocks, and several different basic concepts of Power BI. The course also introduced representatives to Power BI Desktop. The training helps delegates understand the relationship between data sheets. Delegates will also learn the following content-DAX calculation types, DAX functions for advanced calculations and time intelligence functions. With the help of the training, the participants will be able to understand the benefits of data visualization, Power BI Desktop visualization, custom vision in Power BI, formatting vision and creating charts. Throughout the training process, delegates will be able to understand the Azure machine learning model in Power BI.


PROGRAM CONTENT

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