BECOME AN EXPERT Exclusive Benefits!

Gain hands on experience and master
Power BI with expert-led training.

Get Ticket

Exam Voucher Included

Complimentary PL-300 exam voucher worth $83

01

Expert Instruction

Learn from Power BI Certified Experts

02

Proven Track Record

Experts behind Kenya’s first Dashboard in a Day.

03

Hands-on Project Work

Apply what you learn by working on real-world.

04

5+

Event Days

15+

Slots Available

2+

Trainers

5+

Technologies

Get Experience What you will Learn

  • Data intergration & Modeling
  • Advanced DAX & Visualization
  • Collaboration & PL-300
9.00 - 10.30 AM

Introduction to Power BI

  • Overview of Power BI and its ecosystem
  • Understanding Power BI Desktop, Service, and Mobile
  • Key features: Data visualization, modeling, and reporting
  • Real-world use cases and industry applications
10.30 - 10.45 AM

BREAK

10:45 - 12:30 PM

Connecting to Excel, SQL, Web, APIs & Cloud Services

  • Connecting Power BI to Excel, CSV, and text files
  • Integrating with SQL databases (SQL Server, MySQL, etc.)
  • Working with cloud-based data sources (Azure, Google BigQuery)
  • Using APIs and web connectors for live data retrieval
12.30 - 1.00 PM

Data Connectivity Modes: Import, DirectQuery, Composite Models, Live Connect

  • Differences between Import, DirectQuery, and Live Connect
  • Performance considerations and best practices
  • Use cases for Composite Models
  • Hands-on demo of connectivity modes
1.00 - 2.00 PM

Lunch

2.00 - 3.30 PM

Power Query for Data preparation & Cleaning

  • Introduction to Power Query Editor
  • Data transformation techniques (filtering, merging, appending tables)
  • Removing duplicates, handling missing data, and applying business rules
  • Advanced data cleaning techniques
3.30 - 4.00 PM

Break

4.15 - 5.00 PM

Q&A Daily Wrap up

  • Open discussion on key takeaways
  • Addressing questions from the day's sessions
Download Bronchure
9.00 - 10.30 AM

Understanding Data Relationships & Normalization

  • Importance of data modeling in Power BI
  • Concept of primary and foreign keys
  • Understanding normalization and its impact on performance
  • Defining and managing relationships in Power BI
10.30 - 10.45 AM

Break

10:45 - 12:30 PM

Star Schema & Fact-Dimension Table Design

  • Introduction to dimensional modeling
  • Difference between fact and dimension tables
  • Benefits of using a star schema in Power BI
  • Hands-on example: Building a star schema
12.30 - 1.00 PM

Performance Optimization in Data Modeling

  • Best practices for improving Power BI performance
  • Reducing data load and optimizing refresh rates
  • Using aggregations and indexing for faster queries
  • Practical demonstration
1.00 - 2.00 PM

Lunch

2.00 - 3.30 PM

Introduction to DAX (Calculated Columns, Measures)

  • Basics of Data Analysis Expressions (DAX)
  • Creating calculated columns and measures
  • Common DAX functions (SUM, COUNT, AVERAGE, etc.)
  • Hands-on practice with real-world scenarios
3.30 - 4.00 PM

Advanced DAX Functions

  • Understanding filter context and row context
  • Advanced functions (CALCULATE, FILTER, ALL, RELATED)
  • Nested DAX functions for complex calculations
  • Performance considerations in DAX
4.00 - 4.15 PM

Break

4.15 - 5.00 PM

Q&A Daily wrap up

  • Recap of key learnings
  • Answering participant queries
Download Bronchure
9.00 - 10.30 AM

Complex DAX Calculations & Performance Tuning

  • Advanced time intelligence functions
  • Using variables in DAX
  • Optimizing DAX expressions for performance
  • Hands-on problem-solving with DAX
10.30 - 10.45 AM

Break

10:45 - 12:30 PM

Creating Dynamic & Interactive Visuals

  • Best practices for choosing the right visuals
  • Enhancing interactivity with slicers and filters
  • Conditional formatting and dynamic visuals
  • Live demonstration and exercises
12.30 - 1.00 PM

Custom Visuals & Best Practices for Data Storytelling

  • Exploring Power BI’s custom visuals marketplace
  • When to use custom visuals over built-in ones
  • Effective data storytelling techniques
  • Case study demonstration
1.00 - 2.00 PM

Lunch

2.00 - 3.30 PM

Dashboard Design Principles

  • Principles of effective dashboard design
  • Creating user-friendly layouts
  • Using themes and templates for branding
  • Real-world examples of impactful dashboards
3.30 - 4.00 PM

Hands-on Dashboard Development & Performance Tuning

  • Performance tuning techniques for dashboards
  • Reducing clutter and improving responsiveness
  • Implementing best practices for end-user experience
  • Hands-on exercise: Building a performance-optimized dashboard
4.00 - 4.15 PM

Break

4.15 - 5.00 PM

Q&A Daily wrap up

  • Open discussion and participant questions
  • Key insights from the day
Download Bronchure
9.00 - 10.30 AM

Power BI Service: Publishing & Report Sharing

  • Understanding Power BI Service vs. Power BI Desktop
  • Publishing reports and managing workspaces
  • Sharing dashboards with users and setting permissions
  • Real-world examples of collaborative reporting
10.30 - 10.45 AM

Break

10:45 - 12:30 PM

Row-Level Security (RLS) & Data Governance

  • Implementing Row-Level Security (RLS) for controlled access
  • Creating role-based security
  • Understanding data governance and compliance
  • Practical application of security best practices
12.30 - 1.00 PM

Power BI Gateway & Automated Data Refresh

  • Introduction to Power BI Gateway
  • Setting up scheduled refresh for datasets
  • Best practices for managing large datasets
  • Hands-on demonstration
1.00 - 2.00 PM

Lunch

2.00 - 3.30 PM

Power BI Admin Settings & Security Controls

  • Managing Power BI tenant settings
  • Controlling data access and sharing policies
  • Implementing security best practices
  • Case study discussions
3.30 - 4.00 PM

Power BI Mobile – Optimizing Dashboards for Mobile Viewing

  • Understanding Power BI Mobile capabilities
  • Creating mobile-optimized reports
  • Best practices for usability on mobile devices
  • Best practices for usability on mobile devices
4.00 - 4.15 PM

Break

4.15 - 5.00 PM

Q&A Daily wrap up

  • Review of key concepts from the day
  • Answering remaining participant questions
Download Bronchure
9.00 - 10.30 AM

PL-300 Exam Overview & Key Topics

  • Understanding the PL-300 exam structure
  • Key topics and skill areas covered
  • Exam preparation strategies and resources
  • Q&A session on exam expectations
10.30 - 10.45 AM

Break

10:45 - 12:30 PM

Sample Exam Questions & Practice Tests

  • Solving sample exam questions
  • Time management strategies for the exam
  • Identifying weak areas and improving performance
  • Discussion of correct answers and explanations
12.30 - 1.00 PM

Sample Exam Questions & Practice Tests(..continued.)

1.00 - 2.00 PM

Lunch

2.00 - 3.30 PM

Certification Strategy & Final Review

  • Last-minute preparation tips
  • Key topics recap
  • Best resources for further study
  • Personalized study plan for success
3.30 - 4.00 PM

Hands-on Q&A & Key Takeaways

  • Addressing any remaining doubts
  • Sharing exam experiences and success tips
  • Final confidence-boosting session
4.00 - 4.15 PM

Break

4.15 - 5.00 PM

Final Wrap-Up & Next Steps

  • Recap of the entire training program
  • Guidance on practical implementation in real-world scenarios
  • Future learning and career opportunities with Power BI
  • Closing remarks and participant feedback
Download Bronchure

Pricing Plans Get your Ticket

Early Bird

Ksh82,000

Sold Out

Before 20th March 2025

Buy Ticket

Price inclusive of Exam Voucher

Regular

Ksh100,000

Sold Out

After 20th March 2025

Buy Ticket

Price exclusive of Exam voucher

Premium

KSH102,000

Sold Out

After 20th March 2025

Buy Ticket

Price inclusive of Exam voucher

Reach us Event Details

Radison Blu

Nairobi, Kenya

Contact Us

Name: Sibasi Ltd

Phone: +254 780742274

Email: [email protected]

Microsoft Team

Name: Microsoft Team

Phone: +254 780742274

Email: [email protected]

19th - 23rd

May 2025

Contact Us

Name: Sibasi Ltd

Phone: +254 780742274

Email: [email protected]

Microsoft Team

Name: Microsoft Team

Phone: +254 780742274

Email: [email protected]

Brighton Waterfront Hotel, Brighton, London

1Hd- 50, 010 Avenue, NY 90001
United States

Tickets info

Name: Ronaldo König

Phone: 009-215-5595

Email: [email protected]

Programme Details

Name: Ronaldo König

Phone: 009-215-5595

Email: [email protected]