Power BI Complete Introduction

Power BI Introduction

Data Visualization
Reporting
Business Intelligence (BI)
Flow of Work in Power BI Desktop
Flow of Work in Report server Power BI Desktop
Power BI Report Server
Power BI Service
Power BI Mobile
Flow of Work in Power BI / Power BI Architecture

Power BI Visualizations 

  • Stacked bar chart
  • Stacked column chart
  • Clustered bar chart
  • Clustered column chart
  • 100% stacked bar chart
  • 100% stacked column chart
  • Line chart
  • Area chart
  • Stacked area chart
  • Line and stacked column chart
  • Line and clustered column chart
  • Ribbon chart
  • Waterfall chart
  •  Scatter chart
  • Pie chart
  • Donut chart
  • Tree map
  • Filled map
  • map
  • Funnel
  • Card
  • Multi row card
  • Table
  • Matrix table

Tool Tips

  • Felid level tool tips
  • Default tool tips
  • Page level tool tips
  • Text level tool tips
  • Visual header tool tips

Conditional Formatting 

  • Text conditional formatting
  • Border conditional formatting
  • Background conditional formatting
  • Font conditional formatting
  • Data bars conditional formatting
  • Conditional formatting icons

Power BI Themes

  • Browse for themes
  • Theme gallery
  • Customize current theme
  • Save current theme
  • Download themes from marketplace
  • Import themes in Power BI Desktop

Power BI Templates

  • Import Templates in Power BI Desktop
  • Create Template Power BI Desktop
  • Save Templates In Power BI Desktop

Power BI (AI Visualizations)

  • Q&A
  • Decomposition Tree

Other Options

  • Buttons
  • Shapes
  • Images
  • New parameter
  • Gridlines
  • Lock objects
  • Bookmarks
  • Advanced bookmarks
  • Selection
  • Sync slicers
  • edit interactions
  • Enter data
  • recent source
  • refresh
  • Data grouping

Introduction to office 365

  • What is office 365
  • Why use office 365
  • Download custom visuals

Custom Visuals

  • Bar chart
  • Chartaccentbarchart
  • Hierarchy slicer
  • Linedotchart
  • Multi slicer
  • Pivotslicer table heatmap
  • Tornado chart

Filters in Power BI

  • Visual Level Filters
  • Page Level Filters
  • Report Level Filters
  • Drill Through Filters
  • Filter Sub Types
  • Basic Filtering, Advanced Filtering
  • Top N
  • Relative Date Filtering
  • Numeric field filters
  • Text field filters
  • Date and Time field Filters

Hierarchies and Drill-Down Reports

  • 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
  • Show Next
  • Level, Expand Next Level
  • Drilling filters other visuals option

Visualizing KPI Data

  • Create and Format Gauge Visual
  • KPI Visual
  • Create and Format Card Visualization
  • Multi Row Card
  • Create and Format Table Visual
  • Matrix Visualization
  • Create and Format Map Visual
  • Filled Map Visual

Power Query

Introduction to Power Query – Extract, Transform & Load

  • 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
  • Advanced Editor – Complete ETL Code
  • Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
  • Power Query Conceptually

Datatypes and Filters in Power Query

  • Datatypes, Changing the Datatype of a Column
  • Filters in Power Query
  • Filter a Column using Text Filters
  • Filter a Column using Number Filters
  • Filter a Column using Date Filters
  • Filter Multiple Columns

Inbuilt Column Transformations

  • Remove Columns / Remove Other Columns
  • Name / Rename a Column
  • Reorder Columns or Sort Columns
  • Add Column / Custom Column
  • Split Columns
  • Merge Column
  • 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 By

Combine Queries (Append Queries & Merge Queries)

  • Append Queries / Merge Queries
  • Query Options
  • Copy Query, Paste Query
  • Delete Query, Rename Query
  • Enable Load, Include in report Refresh
  • Duplicate Query, Reference Query
  • Move to Group, Move Up, Move Down

Power Pivot

  • Power BI Data Modeling – Relationship View
  • 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

Power BI Services


  • 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
  • Import / Getting the Report to PBI Service
  • My Workspace
  • App Workspaces Tabs
  • DATASETS
  • REPORTS
  •  DASHBOARDS
  • Working with Datasets
  • Creating Reports in Cloud using Published Datasets
  • Power BI Datasets Live Connection using Desktop
  • Working with Workbooks
  • working with Reports
  • Sharing Reports
  • Creating new reports in services
  • Embedding to web
  • share report link

Dashboards Development

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

Data Gateways

  • Introduction to Data Gateways
  • How Data Gateways work
  • Connect to an on-premise Data Source by using a Data Gateway
  • Download Data Gateway
  • Installing a Data Gateway
  • Types of Gateways
  • On-premises Data Gateway
  • On-premises Data Gateway (personal mode)
  • Manage Data Gateway
  • Add and Remove Administrators
  • Add Data Source
  • Add or Remove Users to a Data Source
  • Refresh on Premise Data

Configuring Automatic Refresh using Schedules

  • Collaboration in Power BI using App Workspace
  • Introduction to App Workspaces
  • Create an App Workspace
  • Add Members to App Workspace to Collaborate
  • App Workspace Access
  • Admin
  • Member
  • Contributor

Sharing Power BI Content using Apps

      Introduction to App

  • Publish an App
  • Update a Published App
  • Manage Content in App
  • Include in App
  • Exclude in App
  • Include in App
  • Exclude in App
  • Entire Organization
  • Specific individuals or group
  • Un publishing an App

Power BI Row level Security

  • Introduction of Row Level Security in Power BI
  • Types of row level security in Power BI
  • Dynamic row level security in power bi
  • Static row level security in power bi

Power BI DAX

Introduction to DAX

  • Introduction
  • How to import data into power bi
  • Data types in power bi
  • Calculated columns
  • Dax measures
  • Logical function & operators

Date and Time Functions

  • Calendar
  • Calendarauto
  • Date
  • Datediff
  • Datevalue
  • Day
  • Edate
  • Eomonth
  • Hour
  • Minute
  • Month
  • Now
  • Second
  • Time
  • Timevalue
  • Today
  • Utcnow
  • Weekday
  • Weeknum
  • Year

Filter Functions

  • All
  • Allexcept
  • Allselected
  • Calculate
  • Earlier
  • Filter
  • Keepfilters
  • Lookup value
  • Selectedvalue

Information Functions

  • Contains
  • Iblank
  • Iserror
  • Iseven
  • Innontext
  • Isodd
  • Istext
  • Username

Logical Functions

  • And
  • If
  • True
  • Falese
  • Iferror
  • Not
  • Or
  • Switch
  • True

Math and Trig Functions

  • Abs
  • Ceiling
  • Convert 
  • Currency
  • Divide
  • Even
  • Fact
  • Power
  • Rand
  • Randbetween
  • Round
  • Raoundown
  • Roundup
  • Sign
  • SQRT

Other Functions

  • Blank
  • Error

Parent and Child Functions

  • Path
  • Pathcontains
  • Pathitem
  • Pathitemreverse
  • Pathlength

Relationship Functions

  • Related
  • Userrelationship

Statistical Functions

  • Median
  • Medianx
  • Rankx

Table Manipulation Functions

  • Addcolumns
  • Crossjoin
  • Datatable
  • Flters
  • Generateseries
  • Row
  • Selectcolumns
  • Summarize
  • Topn
  • Union
  • Values

Text Functions

  • Combinevalues
  • Concatenate
  • Exact
  • Find
  • Fixed
  • Format
  • Left
  • Len
  • Lower
  • Mid
  • Replace
  • Rept
  • Right
  • Search
  • Substitute
  • Trim
  • Unichar
  • Unicode
  • Upper

Time Intelligence Functions

  • Closingbalsmonthe
  • Dateadd
  • Datesbetween
  • Datesmtd
  • Datesytd
  • Endofmonth
  • Firstdate
  • Lastdate
  • Openingbalancemonth
  • Parallelperiod
  • Totalmtd
  • totalqtd
  • totalytd

DAX Statements

var

Errors Handling and Variables

  • Error handling
  • Aggregation functions
  • Variables in DAX

Secrets of Context in DAX

  • Filter context
  • Row context

Secrets of Calculate Function

  • Calculate function to change the filter context
  • Power bi calculate with all to ignore the filter context
  • Power bi calculate with allselected
  • Power bi calculate with alleselected
  • Power bi keepfilters function in DAX
  • Power bi nested calculate

Count Functions

  • Power bi count vs counta functions
  • Power bi countrowns distinctcount and countblank

Time Intelligence

  • Calendarauto function in DAX
  • Datesbetween function in DAX
  • Datesytd function in DAX
  • Sameperiodlastyear in Power BI