Power BI Mastery in a Day

Power BI Mastery in a Day

Design, Govern, and Deliver Cutting-Edge Data Solutions

Date:
27th February 2026

Time:
9:00am – 5:00pm

Cost:
Free of Charge (FOC)

Mode:
VILT (Live Virtual)

Trainer:
Richard Doraisamy

Power BI Mastery in a Day: Design, Govern, and Deliver Cutting-Edge Data Solutions is a free, instructor-led virtual workshop designed to provide a strategic and conceptual understanding of building enterprise-grade Power BI analytics solutions.

Participants will gain clarity on how modern Power BI solutions are structured, from data sourcing and transformation strategies through semantic model design, DAX logic, report storytelling, and enterprise governance.

This live virtual event emphasizes how design choices impact performance, scalability, security, and usability across organizational reporting environments.

Target Audience:

Data Analysts, Business Intelligence (BI) Professionals, and Report Developers who are responsible for designing, building, and maintaining Power BI solutions.

Skills and prerequisites:

Intermediate level. Attendees should be familiar with fundamental data concepts (e.g., tables, fields) and have basic conceptual exposure to the Power BI environment.

Event Agenda

Time Duration Module Title and Topics
9:00 AM 30 mins Introduction: The Power BI Analyst Role & Platform Overview

  • The scope of the Power BI Data Analyst
  • Overview of the Power BI ecosystem (Desktop, Service, Gateways).
9:30 AM 60 mins Module 1: Prepare and Shape Data – Data Sourcing and Connectivity

  • Identifying data source requirements and connectivity types.
  • Conceptual comparison: Direct Query vs. Import Mode vs. Composite Models.
10:30 AM 15 mins Morning Break
10:45 AM 30 mins Module 1 (Cont’d): Data Transformation Best Practices (Power Query)

  • Conceptual principles of data cleaning, shaping, and combining queries.
11:15 AM 60 mins Module 2: Data Modeling Design Principles – Designing Star Schemas and Relationships

  • The importance of a Star Schema (Fact and Dimension Tables).
  • Defining relationships, cardinality, and cross-filter direction.
12:15 PM 45 mins Module 2 (Cont’d): Optimizing Model Performance

  • Strategies for reducing model size and improving query speed.
  • Conceptual introduction to aggregations and performance tuning.
1:00 PM 60 mins Lunch Break
2:00 PM 45 mins Module 3: DAX Calculations and Logic – DAX Fundamentals

  • Understanding Filter Context vs. Row Context (Conceptual Deep Dive).
  • Deciding when to use Calculated Columns vs. Measures.
2:45 PM 45 mins Module 3 (Cont’d): Advanced DAX Concepts and Time Intelligence

  • The power of the CALCULATE function.
  • Conceptualizing Time Intelligence (e.g., Year-over-Year calculations).
3:30 PM 10 mins Afternoon Break
3:40 PM 30 mins Module 4: Report Design and Storytelling – Report Design Principles

  • Principles of effective visualization (choosing the right chart).
  • Enhancing reports for usability (Bookmarks, Custom Tooltips, Navigation).
4:10 PM 30 mins Module 4 (Cont’d): Managing and Securing the Solution

  • Deploying and distributing content (Workspaces and Apps).
  • Conceptual implementation of Row-Level Security (RLS) and Data Gateways.
4:40 PM 20 mins Q&A and Workshop Wrap-up
5:00 PM – End of Event

By the end of the session, attendees will be able to:

Governance & Security

Understand the mechanisms for sharing & distributing content (Workspaces and Apps), and describe how to implement and manage core security features like Row-Level Security (RLS) and Data Gateways.

Modeling Design

Architect scalable and high-performance semantic models using industry best practices like the star schema, and strategically choose the correct data storage mode (Import vs. DirectQuery).

DAX Concepts

Explain the difference between implicit measures, explicit measures, and calculated columns, and understand the role of DAX in implementing complex business logic like time intelligence.

Data Strategy

Determine the optimal approach for connecting to and preparing data, conceptually applying Power Query best practices for data cleaning and transformation.

Report Storytelling

Apply principles of effective data visualization and report design to create interactive, user-friendly reports that facilitate data-driven decision-making.

Sign Up Today!

Richard Doraisamy

Speaker of the Day

A seasoned learning and development leader with over 20 years of global experience in driving enterprise upskilling, technical enablement, and organizational transformation.

Recognized for blending technical depth with consultative delivery, Richard has led large-scale AI, cloud, and Copilot adoption programs for multinational clients, achieving measurable productivity gains and early adoption success across industries.

With a strong track record in managing training strategy, content development, and enterprise delivery, he is passionate about empowering professionals and organizations to unlock the full value of Microsoft technologies.