Power BI
  • Introduction to Power BI
    • What is Power BI and Why Power BI
    • Installing Power BI Desktop
    • Exploring the Power BI Workflow
    • Adjusting the settings of the Power BI Desktop
    • Comparison of Power BI vs Other Reporting Tools
  • Getting and Transforming Data with Power BI Desktop
    • Connecting to different sources
    • Connecting to multiple sources
    • Different connecting Options(DirectQuery vs Import Data Vs Live Connection)
    • Shaping and transforming data with Power Query
    • Editing,Merging,Appending queries etc
  • Advance Importing techniques without coding
  • Data cleaning & Advance data cleaning
  • Modeling with Power BI
    • Introduction to Modeling
    • Building Relational Models(Setup and Manage Relationships)
    • Creating table relationships
    • Understanding the filter flow
    • Cardinality and Cross filtering
  • DAX
    • Understanding Dax Syntax
    • Calculated Columns vs Measures
    • Common Dax functions and formulae
    • Understanding the evaluation context in DAX
  • Visualising Data with Reports
    • Creating Visualisations
    • Color & Conditional Formatting
    • Setting Sort Order
    • Scatter & Bubble Charts & Play Axis
    • Tooltips
    • Slicers, Timeline Slicers & Sync Slicers
    • Cross Filtering and Highlighting
    • Visual, Page and Report Level Filters
    • Drill Down/Up
    • Hierarchies
    • Constant Lines
    • Tables, Matrices & Table Conditional Formatting
    • KPI's, Cards & Gauges
    • Map Visualisations
    • Custom Visuals
    • Managing and Arranging
    • Drillthrough
    • Custom Report Themes
    • Grouping and Binning
    • Bookmarks & Buttons
  • Introduction to Power BI Service
    • Introduction to the Power BI Service
    • Quick Tour of Power BI Service
    • Connecting to Data from Power BI service
    • Building Blocks of Power BI Service
  • Sharing and Collaboration Tools in Power BI Service
    • Sharing and Collaboration Options Overview
    • Publish from Power BI Desktop
    • Publish Reports to Web
    • Printing and Exporting from Power BI Service
    • Sharing Reports & Dashboards
    • Workspaces (My Workspace vs App Workspace)
    • Publishing Apps in Power BI Service
    • Row Level Security in Power BI Desktop and Service
  • Power BI Gateway and Refreshing Datasets
    • Understanding Gateways in Power BI
    • Difference between Personal and On-Premise Gateway
    • Installation of Personal Gateway
    • Installation of On Premise Enterprise Gateway
    • Setting Up a Gateway in Power BI Service
    • Understanding Data Refresh(Manual vs Scheduled Refresh)
    • Troubleshooting Refreshing scenarios
  • A.I. in Power BI
  • Advance Report techniques
  • Best Practices