Power BI - Cohort 150 Class Videos

Power BI - Cohort 150 Class Videos

Preview unavailable

You must log in or sign up to view this lesson.

LoginSign up

Microsoft Power BI

Buy nowLearn more

Getting Started

  • 📖 View Power BI Program Brochure
  • Access Demo Class Recordings
  • ☯️ Join a Live Demo Class
  • 📆 View Power BI Academic Schedule
  • 📅 View Power BI Upcoming Schedule
  • 🧑‍💻 Install Power BI for free2
  • 💲 Enroll Now
  • Access Student Study Kit
  • Access Lab Datasets

Power Query - Shaping your Enterprise Data

  • Get Started with Power Query1
  • Get Data from File Sources - Excel Table, PDF Invoices & Others
  • Get Data from Online Sources - SharePoint, Outlook, Dynamics 365, Web APIs & Default connectors.
  • Get Data from Fabric Warehouse – Data Flow
  • Data Access, Path & Permission Settings in Power Query
  • Automate Daily Reports, Timesheets & Invoices using Append & Combine Option
  • Data Validation Steps & Basic Statistics
  • Prepare Summary Tables & Aggregates
  • Reshape your Operational Data using Pivot, Unpivot
  • Transform Tables & Generic Columns
  • Derive KPIs & Flags Using Conditional columns & Custom columns
  • Create a reporting workflow & Enable Process Automation using Applied steps
  • Apply Logical Transformation - On Values
  • Automate Look Up, Filtering & Reconciliation Process using Merge Query (SQL Joins)
  • Query Settings, Selective Load & Performance Troubleshooting
  • Work with PDF

Data Modelling & Relationships between entities

  • What is Data Modelling?
  • Jump Start - Connect with an existing Semantic Model
  • Fact Vs Dimension Table - Difference between Primary Key & Foreign Key
  • Naming & Sorting the Columns
  • Difference between Merge & Relate
  • Understand Relationship types, Cardinality & Cross Filter direction
  • Normalization vs Denormalization - Importance of modelling
  • Design a Consistent Star Schema in the Data Model
  • Lab Exercise - Design a Data Model in Power BI
  • Scenarios for using Snowflake Schema for Parent Child Hierarchical reporting
  • Design Date Dimensions for Automating Periodic Reporting - Monthly, Weekly, Daily, Year Reports
  • Add Bridge Tables & Handle Many-to-Many Relationships for Group of Companies or Portfolio Reporting
  • Create Hierarchy, Groups & Bins for Categorical Analysis
  • Import or Direct Query the tables from the source
  • Publish & Manage Automated Data Refresh to Semantic Model in Fabric
  • Control Row level Access to Reports & Data by Roles
  • Optimize model Performance
  • When to Append, Merge, Relate in Power BI Model

Dax Functions

  • Simplify Multi-Dimensional KPI Reporting Using DAX, Quick Measures, Visual Calculations & Copilot
  • Utilize Dax for Columns, Measures, Tables & Functions
  • Enhance Business Insights with DAX: Monthly, Quarterly, and Yearly Growth Metrics
  • Use DAX for Displaying Core Business Process KPIs using Quick Measures
  • Create Cross Functional KPIs Such as Fin Tech, Marketing Ops, Sales Tech
  • Leverage DAX for Dynamic & Real time Reporting
  • Apply DAX for Forecasting Future Trends Using Historical Data
  • Lab Exercise - Create Advanced DAX Calculations in Power BI Desktop
  • Lab Exercise - DAX Formulas
  • PL 300 - PPT - Use DAX Functions
  • DAX Formula Ebook

Visualisation I

  • PPT- VISUALIZATION I & DAX
  • VIDEO-VISUALIZATION I & DAX
  • Lab Exercise - Create a Power BI Dashboard
  • Lab Exercise - Design a Report in Power BI Desktop
  • PL 300 - PPT - Design Power BI Reports
  • Visualisation Ebook

Visualisation II

  • VIDEO-VISUALIZATION II & DAX
  • Lab Exercise - Perform Data Analysis in Power BI
  • Lab Exercise - Enhance a Report in Power BI Desktop
  • PPT-VISUALIZATION II & DAX
  • PL 300 - PPT - Enhance Reports for user Experience
  • PL 300 - PPT - Create Dashboards
  • PL 300 - PPT - Perform Advanced Analytics
  • PL 300 - PPT - Implement Row level Security
  • PL 300 - PPT - Create and Manage Workspaces

Power BI Sample Dashboards

  • Portfolio Dashboard
  • HR Analysis Dashboard
  • Finance Dashboard
  • Operational Dashboard
  • Project Performance Dashboard
  • Sales Dashboard
  • Planning Dashboard
  • CRM Dashboard
  • HSE Dashboard
  • Analysis of Evaluation level
  • Teamacademy PNL Report
  • PowerBI Dashboards Upload
  • Access Sample Dashboards2

Class Recordings

  • Power BI Cohort - 129 Class Videos
  • Power BI Cohort - 130 Class Videos
  • Power BI Cohort - 131 Class Videos
  • Power BI Cohort - 132 Class Videos
  • Power BI Cohort - 133 Class Videos
  • Power BI Cohort - 134 Class Videos
  • Power BI Cohort - 135 Class Videos
  • Power BI Cohort - 136 Class Videos1
  • Power BI Cohort - 137 Class Videos
  • Power BI Cohort - 138 Class Videos
  • Power BI Cohort - 139 Class Videos
  • Power BI Cohort - 140 Class Videos
  • Power BI Cohort - 141 Class Videos
  • Power BI Cohort - 142 Class Videos
  • Power BI Cohort - 144 Class Videos
  • Power BI Cohort - 143 Class Videos
  • Power BI Cohort - 145 Class Videos1
  • Power Bi Cohort - 146 Class Videos
  • Power BI Cohort - 148 Class Videos
  • Power BI - Cohort 149 Class Videos
  • Power BI - Cohort 150 Class Videos
  • Power Bi - Cohort 151 Class Videos
  • Power BI Cohort - 152 Class Videos
  • Power BI Cohort - 153 Class Videos
  • Power BI Cohort - 154 Class Videos

Special Class Recordings

  • Microsoft Fabric Video
  • Power App and Power Automate
  • Dax Class Recording

Mock Test

  • Mock Test 1
  • Mock Test 2
  • Mock Test 3
  • Mock Exam Books

Internship Project

  • Apply for Internship

Power BI Case Studies & Reports

  • Top 15 Common Business Problems in Reporting
  • Case Study – Sales Performance Reporting
  • Case Study – Project Performance Reporting
  • Resource for PL 300 Exam
  • Enterpise Financial Analytics - Reporting Guidelines
  • KPI Institute for Business Analytics Reporting