Power BI

Introduction Of Power Bi

• Power Bi Introduction
• Data Visualization, Reporting
• Business Intelligence (Bi), Traditional Bi, Self-Serviced Bi
• Cloud Based Bi, On Premise Bi
• Power Bi Products
• Power Bi Desktop (Power Query, Power Pivot, Power View)
• Flow Of Work In Power Bi Desktop
• Power Bi Service, Power Bi Report Service, Power Bi Mobile
• Flow Of Work In Power Bi / Power Bi Architecture
• A Brief History Of Power Bi

Pbi Desktop Installation Power Bi Desktop & Power Bi Service Overview

Power Bi Desktop Software Installation

• Download & Installation Of Power Bi Desktop Software
• What Are The Prerequisites To Install Power Bi Desktop Software

Power Ǫuery Software Overview

• Overview Of Power Ǫuery / Power Ǫuery Editor
• How To Open Power Ǫuery / Power Ǫuery Editor Software
• Connecting To Data Sources And Extracting The Data
• Establish Connection To The Excel Source, Sǫl Server
• Importing Data Into Power Ǫuery Editor
• Transforming Data Into Power Ǫuery Editor Using Gui Options
• Loading The Data Into Power Pivot
• Understanding The M(Mashup) Language Behind The Gui Options

Power Pivot Software Overview

• Understanding About Power Pivot – A In Memory Columnar Database
• Advantage Of In Memory Columnar Database
• Power Pivot – Xvelocity In-Memory Analytics Engine (Previously Called Vertipaq)
• Overview Of Data Modeling – Model View (Previously Relationship View)
• Enhancing The Data Model – Dax (Data Analysis Expressions) Language – Data View
  

Power View Software Overview

• Overview Of Visualizations, Fields, Fields Wells
• Understanding Dimension Column & Fact Columns
• Visualizing The Data Using Power View And Power Maps – Report View
• Saving Report
• Publishing The Report To Power Bi Service

Power Bi Service Overview

• Powe Bi Service Overview
• Logon To Power Bi Service
• Share The Reports With Clients

Power Bi Desktop User Interface

• Understanding Power Bi Desktop User Interface
• Fields Pane, Visualization Pane, Filters Pane
• Ribbon Multiple Views (Report View, Data View & Model View)
• Report Canvas Pages Selection

Building Blocks Of Power Bi

• Datasets, Visualizations, Reports, Dashboards & Tiles

Power Ǫuery

Introduction To Power Ǫuery &Power Ǫuery Editor User Interface

• Overview Of Power Ǫuery / Ǫuery Editor
• How To Open Power Ǫuery /Ǫuery Editor
• Extracting The Data From Data Sources
• Transforming The Data Using Gui Options
• Loading The Data In Power Pivot
  
• Ǫuery Editor Ui (Ǫueries Pane, Data Pane / Results Pane, Power Ǫuery Ribbon)
• Ǫuery Settings, Pane Applied Steps, Formula Bar
• Advanced Editor, Ǫuery Dependencies
• Understanding Power Ǫuery Conceptually

Data Processing, Data Types And Filters In Power Ǫuery

• How Data Processed In Power Ǫuery
• Data Types, Changing The Data Type Of A Column, Detect Data Type
• Filters In Power Query And Their Purpose
• Types Of Filters In Power Ǫuery (Basic Filtering, Advanced Filtering)
• Auto Filter / Basic Filtering
• Filter A Column Using Advanced Text Filters, Number Filters, Data Filters
• Filter Multiple Columns

Inbuilt Column Transformation

• Remove Columns/Remove Other Columns, Choose Cloumns, Go To Column
• Name Or Rename A Column
• Reorder Columns Or Sort Columns (Move Left, Right, To Beginning, To End)
• Column From Examples (From All Columns, From Selection)
• Add Column / Custom Column
• Duplicate Column, Split Column, Merge Columns
• Pivot, Unpivot Columns, Transpose Columns
• Replace Values, Remove Empty

In Built Row Transformations

• Header Row Or Use First Row As Header, Use Header As First Row
• 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

Merge Ǫueries / Join Tables

• Merge Ǫueries, Merge Ǫueries As New
• Need Of Merge Ǫueries, Minium Requirements To Perform Merge Ǫueries
• Types Of Joins/Join Kinds / Merge Type
1. Left Outer (All From First, Matching From Second)
2. Right Outer (All From Second, Matching From First)
3. Full Outer (All Rows From Both)
4. Inner (Only Matching Rows)
5. Left Anti (Rows Only In First), Right Anti (Rows Only In Second)

• Cartesian Join Or Cross Join, Self-Join
• Merging The Tables Using Multiple Join Conditions
• How To Merge 3 Tables
• Use Fuzzy Matching Option

Append Ǫueries / Union All Tables

• Append Ǫueries, Append Ǫueries As New
• Minimum Requirements To Perform Append Ǫueries
• Append Two Tables, Append Three Or More Tables
• Folder As Source
• Appending Multiple Files Of Same Type From A Folder Using Single Ǫuery
• Appending Multiple Excel Files And Multiple Sheets Using Single Ǫuery
• Union All, How To Get Union Result

Ǫuery Options

• Copy Ǫuery, Paste Ǫuery, Delete Ǫuery, Rename Ǫuery
• Enable Load, Include In Report Refresh
• Duplicate Ǫuery, Reference Ǫuery
• Move To Group, Move Up, Move Down
• Create Function, Convert To Parameter
• Advanced Editor, Properties

How Tab Options

• Close & Apply, Close
• New Source, Recent Sources, Enter Data, Data Source Settings
• Manage Parameters (Manage Parameters, Edit Parameters, New Parameters)
• Suggested Values (Any Value, List Of Values, Ǫuery), Convert To List
• Ǫuery Parameters And Power Bi Templates
• .Pbix(Power Bi File) And .Pbit(Power Bi Template File)
• Refresh Preview, Refresh All, Cancel Refresh
• Sorting Data

Transform Tab Options

• Reverse Rows, Count Rows, Replace Values, Replace Errors, Fill Down, Fill Up
• Text Column, Number Column, Date &Time Column Options
• Structured Column (Expand, Aggregate, Extract Values)
• Run R Script, Run Python Script

Add Column Tab Options

• Create Custom Function, Invoke Custome Function
• Conditional Column, Index Column, Duplicate Column
• From Text, From Number, From Date & Time Column Options View Tab, Tools Tab & Help Tab Options

Power Pivot Software Overview

• Understanding About Power Pivot – A In Memory Columnar Database
• Advantage Of In Memory Columnar Database
• Power Pivot – Xvelocity In-Memory Analytics Engine (Previously Called Vertipaq)
• Overview Of Data Modeling – Model View (Previously Relationship View)
• Enhancing The Data Model – Dax (Data Analysis Expressions) Language- Data View

Power Bi Data Modeling – Model View (Previously Relationship View)

• Data Modeling Introduction
• Relationship, Need Of Relationship Between Tables
• Dimension Column, Fact Column, Dimension Table, Fact Table
• Star Schema, Snowflake Schema
• Galaxy Schema Or Hybrid Schema Or Fact Constellation Schema
  
• 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, Delete A Relationship
• Make Relationship Active Or Inactive
• Cross Filter Direction (Single, Both), Apply Security Filter In Both Directions
• Assume Referential Integrity

Enhancing The Data Model- Dax

• What Is Dax (Data Analysis Expressions) Language – Functional Language
• New Column, New Measure / Ǫuick Measure, New Table
• Dax Table And Column Name Syntax
• Creating New Column, Creating New Measure
• Implicit Measures, Explicit Measures
• Difference Between New Columns & New Measures
• Dax Operators, Types Of Operators
• Arithmetic Operators, Comparison Operators
• Text Concatenation Operator, Logical Operators

Dax Function – Categories

• Text Function
• Logical Functions
• Date & Time Functions
• Filter Functions
• Math & Statistical Functions
• Time Intelligence Functions

Dax Text Functions

• Len, Concatenate (&)
• Left, Right, Mid
• Upper, Lower
• Trim, Substitute, Replace, Blank

Dax Logical Functions

• If, Nested If
• True, False, Not, Or, In, And
  
• Iferror
• Switch

Dax Date & Time Functions

• Creating Date Dimension Table For Performing Time Intelligence Analysis
• Year, Ǫuarter, Month, Day
• Weekday, Weeknum
• Format (Text Function) -> Month Name, Weekday Name
• Date, Today, Now
• Hour, Minute, Second, Time
• Datediff, Yearfrac, Calendar, Calendarrauto
• Edate, Eomonth, Datevalue
• Week Number Of Month, Fiscal Year, Fiscal Ǫuater

Dax Filter Function

• Calculate, Calculatetable
• All, Allselected, Allexcept
• Related, Relatedtable
• Lookupvalue (Information Function)
• Userlationship
• Filter, Distinct(Column), Distinct(Table), Values, Selectedvalue

Dax Math And Statistical Functions

• Int, Round, Roundup, Rounddown
• Divide, Even, Odd, Power, Sign, Sort, Fact
• Sum, Sumx, Min, Max, Maxx, Count, Countx
• Average, Averagex
• Countrows, Countblank
• Rankx, Summarize

Dax Time Intelligence Functions

• Time Intelligence Introduction
• Date Dimension Table, Mark As Date Table
• Totalmtd, Totalǫtd, Totalytd
• Previousday, Previousmonth, Previousǫuarter, Previousyear
• Nextday, Nextmonth, Nextǫuarter, Nextyear
  
• Sameperioodlastyear
• Yoy Growth, Ǫoǫ Growth, Mom Growth
• Firstdate, Lastdate

Ǫuick Measures

• Creating Measures Without Writing The Dax Formula Using Ǫuick Measures
• Sales Yoy%, Sales Ytd, Sales Mtd

Report View / Power View

• Report View User Interface / Power Bi Desktop User Interface
• Fields Pane, Visualizations Pane, Filters Pane
• Ribbon, Multiple Views, Report Canvas, Pages Section
• Fields, Filed Wells, Formatting, Analytics

Visuals Interactions

• Visual Interactions
• Interaction Type (Highlight, Filter, None)
• Visual Interactions Default Behavior
• Changing The Default Interaction Behavior, Edit Interactions

Filters In Power View

• Filters, Filter Types In Power View
• Filters On This Visual, Filters On This Page, Filters On All Pages
• Drill Through Filters, Cross Report Drill Through, Keep All Filters
• Filter Sub Types – Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering
• Numeric Field Filters, Text Filed 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 Actions- Drill Down, Drill Up, Show Next Level, Expand Next Level
• Apply Drill Down Filters To Selected Visual

Power Bi Visualizations

• Visualizing Data, Why Visualizations
• Visualization Types, Field Wells
• Visuals For Filtering, Visualizing Categorial Data, Visualizing Trend Data
• Visualizing Kpi Data, Visualizing Tabular Data, Visualizing Geographical Data
• Leveraging Power Bi Custom Visuals

Visuals For Filtering

• Slicer Visualization, When To Use A Slicer
• Create And Format Slicer Visualization
• Hierarchy Slicer (Custom Visualization)
• When To Use A Hierarchy Slicer, Create And Format Hierarchy Slicer
• Advantage Of Hierarchy Slicer
• Play Axis (Dynamic Slicer) – Custom Visualization
• When To Use A Play Axis Visual, Create And Format Play Axis Visual

Visualizing Categorical Data

• Purpose Of Pie And Donut Charts, Create And Format Pie And Donut Charts
• Purpose Of Tree Map Visual, Create And Format The Tree Map Visual
• Purpose Of Bar & Column Charts
• Create And Format Bar And Column Charts
• Create And Format Stacked Bar Charts, Stacked Column Chart
• Create And Format Clustered Bar Chart, Clustered Column Chart
• Create And Format 100% Stacked Bar Chart, 100% Stacked Column Chart
• Purpose Of Scatter Chart, Create And Format Scatter Chart

Visualizing Trend Data

• Purpose Of Line And Area Charts
• Create And Format Line Charts, Area Charts, Stacked Area Charts
• Combo Charts
• Create And Format Line And Stacked Column Chart, Line And Clustered Column Chart
• Create And Format Ribbon Chart, Waterfall Chart

Visualizing Kpi Data

• Create And Format Gauge Visual, Kpi Visual
  
• Create And Format Card Visualization, Multi Row Card
• Create And Format Funnel Chart

Visualizing Tabular Data

• Create And Format Table Visual, Matrix Visualization

Visualizing Geographical Data

• Create And Format Map Visual, Filled Map Visual

Grouping, Binning & Sorting

• Grouping And Binning Introduction
• Using Grouping, Creating Groups On Text Columns
• Using Binning, Creating Bins On Numbers Column And Date Columns
• Sorting Data In Visuals, Changing The Sort Column, Changing The Sort Order
• Sort Using Column That Is Not Used In The Visualization Tooltip Page
• Create A Report Tooltip Page, Configure Your Tooltip Report Page
• Manually Setting A Report Tooltip

Bookmarks, Selection Pane & Buttons

• Bookmarks, Selection Pane & Buttons
• Changing The Chart Type Dynamically
• Changing The Axis Of Chart Dynamically

Power Bi Service Introduction

• Power Bi Service Introduction, Power Bi Cloud Architecture
• Cloud Vs. On Premise
• Creating Power Bi Service Account, Sign In To Power Bi Service Account
• Power Bi Pro & Power Bi Premium
• My Workspace & Project Workspace

Adding Dataset To Power Bi Service And Creating Multiple New Reports

• Publishing Reports To The Power Bi Service, Import / Getting The Report To Pbi Service
• Creating Multiple Reports Using Dataset
• Power Bi Datasets Live Connection Using Desktop To Create New Reports
• Creating New Reports In Cloud Using Published Datasets
• Shared And Certified Datasets, Sharing Dataset Across Multiple Projects

Dashboards Development

• Dashboard, Creating Dashboard Using Multiple Reports
• Pin Visuals And Pin Live Report Pages To Dashboards
• Advantages Of Dashboards
• Interacting With Dashboards
• Adding Tiles To Dashboards
• Web Content, Image, Text Box, Video
• Formatting Dashboard

Building Blocks Of Power Bi

• Datasets, Visualizations, Reports, Dashboards & Tiles

• Hands on Experience with Real time Projects .