Access Demo Class Recordings

Access Demo Class Recordings


Summary

This was an introductory session for a Power BI training program conducted by Team Academy, where instructor Dinesh presented the curriculum and program structure to potential participants. The session covered the training roadmap, which includes four main modules: Power Query for data sourcing and transformation, data modeling to establish relationships between different data sets, DAX (Data Analysis Expressions) for creating measures and KPIs, and visualization techniques for presenting data in meaningful formats. Dinesh explained that the program is designed for professionals from various domains including healthcare, finance, and operations, and will focus on enterprise reporting capabilities using Power BI's ability to connect and transform data from multiple sources including Excel sheets, databases, and SharePoint. The training will be conducted both online and in-person at Regus in Doha, with participants needing to install Power BI and the training dataset before the academic sessions begin the following week.

Power BI Training Discussion

The team conducted a classroom session with Jane, who works as an admin in a Qatar hospital, to discuss a Power BI training program. Jane expressed interest in learning Power BI despite having limited Excel experience, as she aims to advance her career in healthcare data analytics. The team explained that the Power BI training would cover data sourcing, cleaning, and creating professional dashboards for healthcare informatics over a one-and-a-half-month period.


Power BI Training Program Overview

Dinesh introduced a Power BI training program focused on creating dashboards and decision matrix systems for business users, emphasizing foundational navigation skills rather than complex coding. He explained that the program has been running for 7 years and will cover data sourcing and dashboard creation from basic to advanced levels. Joanne Monte de Ramos and Ian joined the session, with Joanne expressing interest in career advancement through the program, and Ian introducing himself as a benefits specialist working with medical insurance claim data.

 

The team discussed a Power BI training program focused on creating dashboards and enterprise reporting. The instructor explained that Power BI helps organizations connect scattered data from various sources like Excel sheets, databases, and SharePoint folders into meaningful reports and visualizations. The training roadmap was outlined, starting with data sourcing as the first step, similar to gathering ingredients when making pizza. Technical issues with audio were addressed throughout the session.

 

The team discussed a Power BI training program that covers data sourcing, transformation, and visualization. The program consists of four main modules: Power Query for data preparation, data modeling to establish relationships between data sets, DAX for creating measures and KPIs, and visualization for presenting data in meaningful formats. The training will be conducted online and in-person at Regus in Deering Road, starting with Power BI installation on Tuesday followed by academic classes from the next Sunday. Participants will have access to lab exercises, mock exams through the LMS portal, and can bring their own datasets to practice with. The program aims to prepare students for the PL300 certification, which requires passing a 120-question exam with a 70% score.

 Power Bi Installation Link:

Power Bi Installation Link

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
  • Surgery 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 Videos2

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