Power BI

Module 1: Introduction to Power Bi:

• Introduction to Business Intelligence (BI)

• Stages of business intelligence (BI)

• Use cases of BI

• Various BI tools

• Overview of Data warehouse & concepts

• Introduction to Power BI

• Why Power BI

• Power BI Components

• Power BI pricing structure

• Building blocks of Power BI

• Architecture of Power BI

• Power BI vs Tableau vs QlikView

• Introduction of Power BI Desktop

• Installation of Power BI Desktop

• The key features of Power BI workflow

• Process of creating reports in Power BI

Module 2: Data Extraction:

• Overview of Power BI desktop

• Data sources in Power BI

• Using files (excel, pdf, csv, etc.) as a data source

• Using SaaS connectors

• Extracting data from folders, and databases

• Working with Azure SQL database and database sources

• Connecting to Analysis Services

• Other data sources (OData, web, SharePoint etc.)

• Python & R script in Power BI

• Introduction of power query editor

• Advance editor

• Query dependency editor

Module 3: Data Transformation – Shaping & Combining Data:

• Shaping data using Power Query Editor

• Formatting data

• Transformation of data

• Understanding of Data types

• Data profiling for data quality check

• Naming conventions & best practices to consider

• Identify and create appropriate keys for joins

• Working with Parameters

• Merge Query

• Append Query

• Group by of data (aggregation of data)

• Applied steps (query settings)

• Duplicate & Reference tables

• Transpose of data

• Fill

• Pivot & Un-pivot of data

• Custom columns

• Conditional columns

• Replace data from the tables

• Split columns values

• Move columns & sorting of data

• Detect data type, count rows & reverse rows

• Promote rows as column headers

• Hierarchies in Power BI

• M query

Module 4: Data Modelling & Dax:

• Introduction of relationships

• Creating relationships

• Cardinality

• Cross filter direction

• Use of inactive relationships

• Introduction of DAX

• Why DAX is used

• DAX syntax

• DAX functions

• Context in DAX

• Calculated columns using DAX

• Measures using DAX

• Calculated tables using DAX

• Learning about table, information, logical, text, iterator

• Time intelligence functions (YTD, QTD, MTD)

• Cumulative values, calculated tables, and ranking and rank over groups

• Date and time functions

• identify poorly performing measures, relationships, and visuals

• DAX advanced features

Module 5: Data Visualization With Analytics:

• Deep dive into Power BI data visualization

• Understanding Power View and Power Map

• Data visualization techniques

• Page layout & Formatting

• Power BI Desktop visualization

• Formatting and customizing visuals

• Visualization interaction

• Custom visualization in Power BI

• Top-down and bottom-up analytics

• Drill down

• Drill through

• Page navigations

• Bookmarks

• Selection pane to show/hide visuals

• omparing volume and value-based analytics

Module 6: Power Bi Service (Cloud), Q & A and Data Insights:

• Introduction to Power BI Service

• Introduction of workspaces

• Dashboard

• Creating & Configuring Dashboards

• Dashboard theme

• Reports vs Dashboards

• Building workspace Apps

• Sharing reports & dashboards

• configure subscriptions and data alerts

• Paginated report

• Introduction to Power Q & A

• Ask questions about your data using Natural Query Language

• Getting answers in the form of charts, graphs, and data discovery methodologies

• Configure custom questions for Q&A like FAQ

• Ad-hoc analytics building

• Power Q&A best practices

• Quick Ins

• Subscribe, Alerts, Usage statics, Related content

• Design reports on Power BI Service

• Collaboration using Power BI Service

Module 7: Power Bi Settings, Administration & Direct Connectivity:

• Getting to understand Power BI Desktop settings

• Aggregating data from multiple data sources

• Power BI Service settings

• Power BI Admin Portal

• Administration activities

• Power BI usage analysis

• Introduction of Office 365 admin activities

• Introduction of Data Gateway

• Installation & Configuration of data gateways

• Scheduling auto data refresh

• Managing groups, row-level security, datasets, reports, and dashboards

• Real time data analysis using Direct Connectivity

• Direct Query vs Import Mode

Module 8: Embedded Power Bi With API & Power Bi Mobile:

• Introduction to embedded Power BI

• Create embedded code

• Manage embedded code

• Integration of Power BI in SharePoint

• Introduction of Power BI API

• Power BI Embedded playground

• Introduction to Power BI Mobile

• Creating mobile based reports & dashboards

• Optimizing report for Power BI mobile app

• Features of Power BI mobile app

• Introduction of integrating Power BI & Excel

• Power BI Analyze in Excel

Module 9: Power Bi Advance & Power Bi Premium:

• Introduction of Power BI Premium

• Power BI Premium per user

• Power BI Premium features

• Introduction to Data Flow

• Create Data Flow

• Advantages of Data Flow

• Create reports using Data Flow

• Introduction to Power BI Deployment Pipelines

• Create Deployment Pipelines

• Benefits of Deployment Pipelines

• Introduction of Sensitivity Labels

• Introduction of Power BI Goals feature

• Incremental data load in Power BI

• use AI visuals

• use the Forecast feature

• Power BI best practice rules to improve performance