Power BI Desktop Training

More than 15 Years of experience Trainer
Has conducted more than 50 Corporate training
Trained 10000+ Students so far
Call us : +91-8802000175

50+ Hours Course Duration   Free Demo Class Available
100% Job Oriented Training   Small Batches- Max 10 Participants

Introduction & Basic Report Design

  • A Brief History of Power BI
  • Data Visualization, Reporting
  • Power BI Products
  • Power BI Desktop (Power Query, Power Pivot, Power View)
  • Flow of Work in Power BI Desktop
  • Power BI Report Server, Power BI Service, Power BI Mobile Flow
  • Of Work in Power BI / Power BI Architecture
Power BI training in Gurgaon

Power Query (Data Transformation)

  • Data Transformation, Benefits of Data Transformation
  • Shape or Transform Data using Power Query
  • Overview of Power Query / Query Editor, Query Editor User Interface
  • The Ribbon (Home, Transform, Add Column, View Tabs)
  • The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar
  • saving the Work
  • Datatypes, Changing the Datatype of a Column Filter
  • In Power Query
  • Auto Filter / Basic Filtering
  • Filter a Column using Text Filters
  • Filter a Column using Number Filters
  • Filter a Column using Date Filters
  • Filter Multiple Columns
  • Remove Columns / Remove Other Columns
  • Name / Rename a Column
  • Reorder Columns or Sort Columns
  • Add Column / Custom Column Split Columns
  • Merge Columns
  • PIVOT, UNPIVOT Columns
  • Transpose Columns
  • Header Row or Use First Row as Headers
  • Keep Top Rows, Keep Bottom Rows Keep Range of Rows
  • Keep Duplicates, Keep Errors
  • Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
  • Remove Duplicates, Remove Blank Rows, Remove Errors
  • Group Rows / Group By

M Language

  • IF..ELSE Conditions, Transform Column () Types
  • Remove Columns (), Split Columns (),Replace Value()
  • Table. Distinct Options and GROUP BY Options Table.
  • Group (), Table. Sort () with Type Conversions PIVOT
  • Operation and Table. Pivot(). List Functions Using
  • Parameters with M Language

Data Modeling

  • Data Modeling Introduction
  • Relationship, Need of Relationship
  • Relationship Types / Cardinality in General
  • One-to-One, One-to-Many (or Many-to-One), Many-to-Many
  • AutoDetect the relationship, Create a new relationship, Edit existing relationships
  • Make Relationship Active or Inactive
  • Delete a relationship

DAX - Data Analysis Expressions

  • What is DAX, Calculated Column, Measures
  • DAX Table and Column Name Syntax
  • Creating Calculated Columns, Creating Measures Calculated
  • Columns Vs Measures
  • DAX Syntax & Operators
  • DAX Operators
  • Types of Operators
  • Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical Operators

Date Functions

  • YEAR, MONTH, DAY
  • WEEKDAY, WEEKNUM
  • FORMAT (Text Function) à Month Name, Weekday Name
  • DATE, TODAY, NOW
  • HOUR, MINUTE, SECOND, TIME
  • DATEDIFF, CALENDAR
  • Creating Date Dimension Table

Text Functions

  • LEN, CONCATENATE (&)
  • LEFT, RIGHT, MID UPPER, LOWER
  • TRIM, SUBSTITUTE, BLANK

Logical Functions

  • IF
  • TRUE, FALSE NOT, OR, IN, AND
  • IFERROR SWITCH

Math & Statistical Functions

  • INT
  • ROUND, ROUNDUP, ROUNDDOWN
  • DIVIDE
  • EVEN, ODD
  • POWER, SIGN
  • SQRT, FACT
  • SUM, SUMX
  • MIN, MINX
  • MAX, MAXX
  • COUNT, COUNTX
  • AVERAGE, AVERAGEX
  • COUNTROWS, COUNTBLANK

Filter Functions

  • CALCULATE
  • ALL
  • RELATED
  • Report View

Report View User Interface

  • Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas Visual
  • Interactions
  • Interaction Type (Filter, Highlight, None)
  • Visual Interactions Default Behavior, Changing the Interaction

Grouping & Binning

  • Using grouping, Creating Groups on Text Columns
  • Using binning, Creating Bins on Number Column and Date Columns
  • Sort using column that is not used in the Visualization
  • Sort using the Sort by Column button
  • Hierarchy Introduction, Default Date Hierarchy
  • Creating Hierarchy, Creating Custom Date Hierarchy
  • Change Hierarchy Levels
  • Drill-Up and Drill-Down Reports
  • Data Actions, Drill Down, Drill Up

Visualizations

  • Visualizing Data, Why Visualizations
  • Visualization types, Create and Format Bar and Column Charts
  • Create and Format Stacked Bar Chart Stacked Column Chart Create
  • Format Clustered Bar Chart, Clustered Column Chart
  • Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart Create
  • Format Pie and Donut Charts
  • Create and Format Scatter Charts
  • Create and Format Table Visual, Matrix Visualization
  • Line and Area Charts
  • Create and Format Line Chart, Area Chart, Stacked Area Chart
  • Combo Charts
  • Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart
  • Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

Visualizations

  • Visualizing Data, Why Visualizations
  • Visualization types, Create and Format Bar and Column Charts
  • Create and Format Stacked Bar Chart Stacked Column Chart Create
  • Format Clustered Bar Chart, Clustered Column Chart
  • Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart Create
  • Format Pie and Donut Charts
  • Create and Format Scatter Charts
  • Create and Format Table Visual, Matrix Visualization
  • Line and Area Charts
  • Create and Format Line Chart, Area Chart, Stacked Area Chart
  • Combo Charts
  • Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart
  • Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

Power BI Service

  • Power BI Service Introduction, Power BI Cloud Architecture
  • Creating Power BI Service Account, SIGN IN to Power BI Service Account
  • Publishing Reports to the Power BI service,
  • Workspace / App Workspaces Tabs
  • DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
  • Working with Datasets, Creating Reports in Cloud using Published Datasets

Creating Dashboards

  • Pin Visuals and Pin LIVE Report Pages to Dashboard
  • Advantages of Dashboards
  • Interacting with Dashboards
  • Formatting Dashboard
  • Sharing Dashboard