Power BI Training in Hyderabad

Introduction to Power BI

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

Hands-On:

  • Explore Power BI Desktop
  • First Report on Power BI Desktop
  •  

Power BI Desktop

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

Hands-On:

  • Install Power BI Desktop
  • Data Transformation
  • Using Query Editor
  •  

Data Analysis Expressions (DAX)

  • Modelling Data
  • 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

Hands-On:

  • Create relationships
  • Calculated Columns
  • Data Types in DAX
  • Explore DAX Functions such as Aggregation, Counting, Logical, Information, Text
  • Creating Calculated Measure
  • Time Intelligence Functions

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

Hands-On:

  • Explore Power BI Q&A
  • Creating a Dashboard
  • Pinning a Tile to a Dashboard
  • Run Quick Insights on a Dataset
  • Pin a range to a Dashboard
  • Connect to Power BI Data in Excel
  • Monitor Real-time Data with 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

Hands-On:

  • Connecting Power BI with Azure, HD Spark, SSAS
  • Use the developer API to create custom visuals
  • Connecting Excel to Power BI
  • Creating 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

Hands-On:

  • Extracting data from Azure SQL using R
  • Calling Azure ML web service using R
  • Writing the Output of the Azure ML back to SQL
  • Reading scored data into Power BI
  • Publishing the file to Power BI service
  • Scheduling a refresh of the data