Achieve professional Power BI competence — data import, modelling, advanced DAX, interactive dashboards and enterprise deployment.
What You Will Learn
✓Import and transform data using Power Query
✓Build star schema data models
✓Write DAX measures for business KPIs
✓Create interactive dashboards
✓Apply advanced visualisation techniques
✓Publish and share reports
2
Modules
4
Lessons
25 hours
Duration
🎍 Certificate & NITA Accreditation
On passing the final exam (50 MCQs, 70% pass mark, unlimited retakes) you receive a GLI-branded PDF certificate with QR verification. CCS is NITA-accredited — eligible employers can claim NITA levy reimbursement for this course.
Course Curriculum
2 modules · 4 lessons · Interactive quizzes · Study notes · Practical exercises · Final exam
1
Module 1: Power BI Foundations and Data Modelling
2 lessons · 105 min · 5 hours
⌄
▶
Lesson 1: Power BI Platform and Power Query Data Preparation
55 min · Video + Reading
⌄
Power BI Platform and Power Query Data Preparation
This module explores the core principles and practical applications of power bi platform and power query data preparation within Power BI Professional Certification.
Foundational Framework
Professional excellence in this area is built on three pillars:
1. Conceptual understanding: Knowing WHY the frameworks work and the evidence behind them 2. Applied skill: Being able to deploy the tools in real-world situations with sound judgment 3. Contextual intelligence: Adapting global frameworks to Kenya's specific organisational and cultural context
Core Framework 1: Situational Analysis Before applying any tool or framework, assess the specific situation:
What is the current state? (What data do we have?)
What is the desired state? (What are we trying to achieve?)
What are the key gaps and constraints?
What stakeholders are involved and what are their interests?
Core Framework 2: Systematic Application Apply frameworks systematically, not selectively:
Follow the complete process, not just the comfortable parts
Document your reasoning and decisions
Build in checkpoints for review and adjustment
Share your approach with relevant stakeholders
Core Framework 3: Evidence-Based Practice Base decisions on data, not intuition alone:
Gather relevant quantitative and qualitative data
Apply analytical frameworks to interpret the data
Make explicit the assumptions underlying your conclusions
Test conclusions against alternative interpretations
Kenya and Africa Context Leading Kenyan organisations in Power have demonstrated that systematic application of evidence-based frameworks produces measurably superior results compared to ad hoc approaches. The professionals who advance fastest in Kenya's competitive job market are those who combine technical competence with strong practical application skills.
Case Study: Professional Excellence in Practice Kenya's most respected professional associations (IHRM, ICPAK, CPA Kenya, CIPS Kenya) consistently emphasise that the gap between knowing frameworks and applying them effectively is where most professionals fall short. Deliberate practice — applying frameworks to real situations and reflecting on the results — is the path to genuine competence.
Summary Power BI Platform and Power Query Data Preparation is a foundational competency for professionals in Power BI Professional Certification. Master the frameworks, practice consistently, seek feedback, and build the habit of evidence-based application in every relevant situation.
Key Concepts
Power BI Platform and Power Query Data PreparationPower BI Professional CertificationProfessional FrameworksKenya Context
🌍 Real-World Example
Kenya's leading organisations in Power BI Professional Certification consistently demonstrate that systematic application of evidence-based frameworks produces superior results — and their professionals advance faster in their careers.
💬 Lesson Quiz
1. The most important foundation for professional excellence in Power BI Professional Certification is:
2. In Kenya's professional context, the fastest-advancing professionals are those who:
3. The three pillars of professional competence in this area are:
4. Evidence-based practice means:
▶
Lesson 2: Star Schema Data Modelling and Relationships
50 min · Video + Reading
⌄
Star Schema Data Modelling and Relationships
Building on the foundations established in Lesson 1, this lesson develops advanced application skills for star schema data modelling and relationships.
Advanced Application Framework
Moving from understanding frameworks to applying them consistently is where most professionals get stuck. This lesson provides the practical bridge through:
Step 1: Situation Assessment Before any intervention, accurately diagnose the situation:
Gather relevant data (both quantitative and qualitative)
Identify key stakeholders and their perspectives
Assess constraints and enablers
Define success criteria explicitly
Step 2: Framework Selection Choose the appropriate tool for this situation:
Match framework to problem type
Consider organisational context and culture
Assess available resources and timeline
Identify potential risks and mitigation strategies
Communicate clearly with stakeholders at each stage
Document decisions and reasoning
Build in review points
Step 4: Evaluation and Learning Assess results and extract learning:
Compare outcomes against defined success criteria
Identify what worked well and what could be improved
Document lessons for future application
Share learning with colleagues and team
Professional Development Pathway
Building genuine expertise in Power BI Professional Certification requires:
Formal learning (this course provides the foundation)
Deliberate practice (applying frameworks to real situations)
Feedback (from mentors, peers and performance data)
Reflection (systematic review of what worked and why)
The most effective Kenyan professionals in this field invest 2-3 hours per week in deliberate professional development — reading, reflecting, and applying new approaches.
Integration with Broader Professional Practice
Star Schema Data Modelling and Relationships does not exist in isolation. It connects to:
Strategic organisational priorities
Team and stakeholder dynamics
Available resources and constraints
Regulatory and compliance requirements
Kenya's specific cultural and business context
Summary
Star Schema Data Modelling and Relationships is mastered through consistent, deliberate practice combined with structured reflection. The frameworks provided in this course give you the tools — your application and learning mindset determines the results.
Key Concepts
Star Schema Data Modelling and RelationshipsAdvanced ApplicationProfessional DevelopmentDeliberate Practice
🌍 Real-World Example
The Institute of Human Resource Management (IHRM) Kenya's competency framework for certified professionals explicitly emphasises the application of structured frameworks over ad hoc approaches.
💬 Lesson Quiz
1. The most effective approach to building genuine expertise in Power BI Professional Certification is:
2. Before applying any framework to a real situation, you should:
3. Step 4 in the Advanced Application Framework involves:
4. Professional development requires investing approximately how much time per week according to best practice?
MODULE 1: POWER BI FOUNDATIONS Power BI Suite: Desktop(develop)|Service(share)|Mobile(view)|Premium(enterprise) Workflow: Get Data→Transform(PQ)→Model→Visualise→Publish→Distribute Star Schema: Fact tables(measures+foreign keys) + Dimension tables(attributes) Relationships: One-to-Many preferred | Single cross-filter direction | Integer keys faster Calc Columns: Row-level, stored in model | Measures: Dynamic aggregations, computed on demand Date Table: Required for time intelligence | Mark as Date Table | One row per date
Data Modelling Exercise: 1. Design a star schema for a sales analytics model 2. Connect to 3 Excel files and clean each using Power Query 3. Build relationships between all tables 4. Create 5 measures: Total Sales, Average Order Value, YTD Sales, Sales Growth %, Gross Margin % 5. Build a calculated column: Employee Full Name from separate First and Last Name fields
Submit your completed exercise through the LMS dashboard for instructor review.
2
Module 2: DAX Formulas and Dashboard Design
2 lessons · 105 min · 5 hours
⌄
▶
Lesson 1: DAX: Writing Business Calculations in Power BI
55 min · Video + Reading
⌄
DAX: Writing Business Calculations in Power BI
This module explores the core principles and practical applications of dax: writing business calculations in power bi within Power BI Professional Certification.
Foundational Framework
Professional excellence in this area is built on three pillars:
1. Conceptual understanding: Knowing WHY the frameworks work and the evidence behind them 2. Applied skill: Being able to deploy the tools in real-world situations with sound judgment 3. Contextual intelligence: Adapting global frameworks to Kenya's specific organisational and cultural context
Core Framework 1: Situational Analysis Before applying any tool or framework, assess the specific situation:
What is the current state? (What data do we have?)
What is the desired state? (What are we trying to achieve?)
What are the key gaps and constraints?
What stakeholders are involved and what are their interests?
Core Framework 2: Systematic Application Apply frameworks systematically, not selectively:
Follow the complete process, not just the comfortable parts
Document your reasoning and decisions
Build in checkpoints for review and adjustment
Share your approach with relevant stakeholders
Core Framework 3: Evidence-Based Practice Base decisions on data, not intuition alone:
Gather relevant quantitative and qualitative data
Apply analytical frameworks to interpret the data
Make explicit the assumptions underlying your conclusions
Test conclusions against alternative interpretations
Kenya and Africa Context Leading Kenyan organisations in Power have demonstrated that systematic application of evidence-based frameworks produces measurably superior results compared to ad hoc approaches. The professionals who advance fastest in Kenya's competitive job market are those who combine technical competence with strong practical application skills.
Case Study: Professional Excellence in Practice Kenya's most respected professional associations (IHRM, ICPAK, CPA Kenya, CIPS Kenya) consistently emphasise that the gap between knowing frameworks and applying them effectively is where most professionals fall short. Deliberate practice — applying frameworks to real situations and reflecting on the results — is the path to genuine competence.
Summary DAX: Writing Business Calculations in Power BI is a foundational competency for professionals in Power BI Professional Certification. Master the frameworks, practice consistently, seek feedback, and build the habit of evidence-based application in every relevant situation.
Key Concepts
DAX: Writing Business Calculations in Power BIPower BI Professional CertificationProfessional FrameworksKenya Context
🌍 Real-World Example
Kenya's leading organisations in Power BI Professional Certification consistently demonstrate that systematic application of evidence-based frameworks produces superior results — and their professionals advance faster in their careers.
💬 Lesson Quiz
1. The most important foundation for professional excellence in Power BI Professional Certification is:
2. In Kenya's professional context, the fastest-advancing professionals are those who:
3. The three pillars of professional competence in this area are:
4. Evidence-based practice means:
▶
Lesson 2: Dashboard Design, Publishing and Row-Level Security
50 min · Video + Reading
⌄
Dashboard Design, Publishing and Row-Level Security
Building on the foundations established in Lesson 1, this lesson develops advanced application skills for dashboard design, publishing and row-level security.
Advanced Application Framework
Moving from understanding frameworks to applying them consistently is where most professionals get stuck. This lesson provides the practical bridge through:
Step 1: Situation Assessment Before any intervention, accurately diagnose the situation:
Gather relevant data (both quantitative and qualitative)
Identify key stakeholders and their perspectives
Assess constraints and enablers
Define success criteria explicitly
Step 2: Framework Selection Choose the appropriate tool for this situation:
Match framework to problem type
Consider organisational context and culture
Assess available resources and timeline
Identify potential risks and mitigation strategies
Communicate clearly with stakeholders at each stage
Document decisions and reasoning
Build in review points
Step 4: Evaluation and Learning Assess results and extract learning:
Compare outcomes against defined success criteria
Identify what worked well and what could be improved
Document lessons for future application
Share learning with colleagues and team
Professional Development Pathway
Building genuine expertise in Power BI Professional Certification requires:
Formal learning (this course provides the foundation)
Deliberate practice (applying frameworks to real situations)
Feedback (from mentors, peers and performance data)
Reflection (systematic review of what worked and why)
The most effective Kenyan professionals in this field invest 2-3 hours per week in deliberate professional development — reading, reflecting, and applying new approaches.
Integration with Broader Professional Practice
Dashboard Design, Publishing and Row-Level Security does not exist in isolation. It connects to:
Strategic organisational priorities
Team and stakeholder dynamics
Available resources and constraints
Regulatory and compliance requirements
Kenya's specific cultural and business context
Summary
Dashboard Design, Publishing and Row-Level Security is mastered through consistent, deliberate practice combined with structured reflection. The frameworks provided in this course give you the tools — your application and learning mindset determines the results.
Key Concepts
Dashboard Design, Publishing and Row-Level SecurityAdvanced ApplicationProfessional DevelopmentDeliberate Practice
🌍 Real-World Example
The Institute of Human Resource Management (IHRM) Kenya's competency framework for certified professionals explicitly emphasises the application of structured frameworks over ad hoc approaches.
💬 Lesson Quiz
1. The most effective approach to building genuine expertise in Power BI Professional Certification is:
2. Before applying any framework to a real situation, you should:
3. Step 4 in the Advanced Application Framework involves:
4. Professional development requires investing approximately how much time per week according to best practice?
MODULE 2: DAX & DASHBOARDS Key DAX Functions: SUM|AVERAGE|COUNT|CALCULATE|TOTALYTD|DIVIDE|DISTINCTCOUNT CALCULATE: Most important function — changes filter context Time Intelligence: TOTALYTD|SAMEPERIODLASTYEAR|DATESINPERIOD|DATEADD DIVIDE(): Always use for division — handles zero denominators Variables (VAR): Use for complex measures — improves readability and performance
Dashboard Principles: User questions first|Right visual|Data-ink ratio|Consistent colour|Narrative flow Publishing: Desktop→Publish→Service→Workspace→App→Share RLS: Define roles in Desktop|Manage Roles|DAX filter|Assign users in Service
Power BI Capstone Project: 1. Connect to a multi-table dataset (HR + Sales + Finance) 2. Build a star schema with proper Date table 3. Create 10 DAX measures including YTD, YoY growth and calculated ratios 4. Build a 3-page report: Executive Summary|Detailed Analysis|Data Table 5. Apply Row-Level Security for 2 user roles 6. Publish to Power BI Service and configure scheduled refresh
Submit your completed exercise through the LMS dashboard for instructor review.
🎓
Final Examination
50 MCQs · 70% pass mark · Unlimited retakes · Auto-graded · GLI Certificate issued immediately on passing.
Who Should Take This Course
✦Data analysts and BI developers
✦Finance and HR reporting staff
✦IT professionals
✦Operations managers
✦Anyone building reporting solutions
Learning Outcomes
✓Import and transform data using Power Query
✓Build star schema data models
✓Write DAX measures for business KPIs
✓Create interactive dashboards
✓Apply advanced visualisation techniques
✓Publish and share reports
Quick Details
Duration25 hours
Modules2 modules
Lessons4 lessons
LevelExecutive
PriceKES 18,000
Ready to Get Certified?
Join thousands of professionals across Kenya and Africa advancing their careers with CCS.