8
Slots Remaining
Power BI Masterclass - Physical training Date: 11th to 15th August
Location: 327B Nyati Drive, Thome, Nairobi, Kenya
Date: 11th to 15th August
Location: 327B Nyati Drive, Thome, Nairobi, Kenya
This hands-on Power BI Masterclass is designed to equip participants with practical skills in data analysis, visualization, and business intelligence using Microsoft Power BI. Delivered in a physical classroom setting, the session offers direct interaction with expert instructors, real-world case studies, and guided exercises to help learners build dashboards, generate insights, and make data-driven decisions with confidence. Ideal for professionals seeking to enhance their data literacy and reporting capabilities.
What to bring
- A working laptop
- Your questions and enthusiasm
- An open mind
What we provide
- Meals & Refreshments
- Writing Materials
- Certificate of Completion
Training Schedule
Introduction, Data Connectivity & Transformation
- Overview of Power BI and Excel as BI tools
- Navigating Power BI Desktop and Excel Power Pivot
- Connecting to Excel, SQL Server, Web APIs, and cloud sources
- Import, DirectQuery, Live Connect (Power BI)
- Power Query for data cleansing in both Excel and Power BI
Data Modeling, Relationships and Dax
- Understanding Fact and Dimension tables
- Building star schema models
- Creating and managing relationships in both Excel and Power BI
- Optimizing model performance
- DAX foundations in Excel and Power BI
Visual Data Exploration & DAX Calculations
-Explore your data using visuals to uncover patterns, trends, and key business insights
- Build PivotCharts in Excel to slice and explore data dynamically
- Use Power BI native visuals: column charts, line graphs, cards, matrix, bar charts
- Discover and apply custom visuals from the Power BI marketplace
- Learn how visual exploration supports better DAX writing and storytelling
- Introduction to DAX: calculated columns, basic measures, and KPIs
- Understand row context vs filter context in visuals
Dashboards, Storytelling & Interactive Report
- Build complete dashboards that communicate insights clearly and persuasively
- Understand key storytelling concepts: narrative flow, guided insights, and business context
- Use visuals purposefully, align every chart with a question or decision point
- Design Excel dashboards with PivotTables, PivotCharts, slicers, timelines, and conditional formatting
- Create interactive Power BI reports using slicers, cards, tooltips, drillthrough, and bookmarks
- Apply layout best practices: whitespace, visual hierarchy, focus areas
- Optimize dashboards for mobile responsiveness and export/print layouts
Deployment, Security & Enterprise Reporting
- Using external tools (DAX Studio, Tabular Editor, ALM Toolkit)
- Creating pixel-perfect Paginated Reports with Report Builder
- Sharing via Power BI Service, OneDrive, SharePoint, Teams
- Row-Level Security (RLS) and Power BI Gateway setup
- Refresh scheduling, collaboration and governance practices
Secure your slot today and enjoy the early bird Discount!
Select Payment Method below:
Registration Form
Please fill the Registration form
