Subscribe for Course Updates

Be the first to know when new training courses are scheduled or dates are updated.

Verification code Click image to refresh

You can unsubscribe at any time • training@fdc-k.org

Chat with our consultants

Power BI and Power Platform Training Course

Online Training Download PDF
How to Register Click View Schedule for your preferred location, select your training dates, then register as an individual, group, or online participant. You will receive an invitation letter and invoice promptly after submission.
Training Locations Kenya (Nairobi, Mombasa, Malindi, Kisumu, Nakuru, Nanyuki) · Tanzania (Dodoma, Zanzibar, Dar es Salaam) · Dubai UAE · South Africa (Pretoria, Cape Town) · Istanbul · Accra · Banjul more ▾
Groups & Payment Groups of 5+ receive one complimentary place — see group rates. Payment due at least 1 month before (Europe & Asia) or 2 weeks before (Africa programs).
Upcoming Training Schedules 14 locations
Location Duration Next Start Date Dates Available Action
Nairobi, Kenya 10 days Oct 12, 2026 91 dates
Accra, Ghana 10 days Nov 2, 2026 44 dates
Addis Ababa, Ethiopia 10 days Oct 12, 2026 46 dates
Cape Town, South Africa 10 days Oct 26, 2026 48 dates
Dar es Salaam, Tanzania 10 days Oct 12, 2026 45 dates
Dubai, UAE 10 days Oct 12, 2026 63 dates
Istanbul, Turkey 10 days Oct 12, 2026 49 dates
Kampala, Uganda 10 days Oct 12, 2026 48 dates
Kigali, Rwanda 10 days Oct 12, 2026 47 dates
Kuala Lumpur, Malaysia 10 days Oct 12, 2026 46 dates
Mombasa, Kenya 10 days Oct 12, 2026 46 dates
Pretoria, South Africa 10 days Oct 19, 2026 47 dates
Singapore 10 days Oct 12, 2026 45 dates
Zanzibar, Tanzania 10 days Oct 19, 2026 44 dates

Power BI and  Power Platform Training Course

Course Overview

Organizations across all sectors are increasingly relying on Business Intelligence (BI), data analytics, artificial intelligence, workflow automation, and low-code application development to improve operational efficiency and support strategic decision-making. The Power BI & Power Platform Training Course is designed to equip professionals with practical knowledge and hands-on skills in Power BI, Power Query, DAX, Microsoft Dataverse, Power Apps, Power Automate, and Microsoft Copilot Studio. Participants will learn how to transform raw data into meaningful insights, automate business processes, build enterprise applications, and implement secure governance frameworks that drive digital transformation and organizational excellence. The course is based on the topics outlined in the attached Power BI & Power Platform training document.

This practical training provides participants with comprehensive expertise in data modeling, dashboard development, data visualization, advanced DAX calculations, performance optimization, Power Platform application development, workflow automation, AI-powered business solutions, enterprise governance, and deployment strategies. Participants will gain hands-on experience in designing interactive dashboards, developing Canvas and Model-driven Apps, building automated workflows, implementing Row-Level Security, integrating Power BI with Power Platform, and leveraging Microsoft Copilot to enhance productivity and innovation.

Through real-world business scenarios, practical laboratory exercises, collaborative workshops, and instructor-led demonstrations, participants will develop the competencies required to implement enterprise Business Intelligence solutions using Microsoft technologies. The course emphasizes industry best practices in data governance, responsible AI, business analytics, cloud deployment, digital transformation, and enterprise reporting, enabling organizations to improve operational performance and evidence-based decision-making.

Upon successful completion of this course, participants will possess the practical capabilities to design scalable analytics solutions, automate complex business processes, develop low-code business applications, implement secure data governance frameworks, and deploy enterprise-grade Power BI and Power Platform solutions that enhance organizational productivity, operational efficiency, customer experience, and digital innovation.

Course Objectives

By the end of this course, participants will be able to:

  1. Understand Business Intelligence concepts and Microsoft Power BI architecture.
  2. Design efficient data models using star and snowflake schemas.
  3. Transform and prepare data using Power Query (M).
  4. Develop advanced DAX calculations and analytical measures.
  5. Create interactive dashboards and executive reports.
  6. Implement Row-Level Security and Power BI Service deployment.
  7. Build business applications using Microsoft Power Apps.
  8. Automate organizational workflows using Power Automate.
  9. Develop intelligent AI assistants using Microsoft Copilot Studio.
  10. Apply governance, security, responsible AI, and enterprise deployment best practices.

Organizational Benefits

Organizations participating in this training will benefit by:

  1. Improving enterprise data-driven decision-making.
  2. Enhancing business reporting accuracy and efficiency.
  3. Automating repetitive business processes.
  4. Reducing operational costs through workflow automation.
  5. Increasing employee productivity using low-code applications.
  6. Strengthening enterprise data governance and security.
  7. Improving executive dashboard reporting capabilities.
  8. Accelerating digital transformation initiatives.
  9. Supporting innovation using AI-powered business solutions.
  10. Building sustainable enterprise Business Intelligence capabilities.

Target Participants

This course is suitable for:

  • Business Intelligence Analysts
  • Data Analysts
  • Business Analysts
  • Data Scientists
  • IT Managers
  • Digital Transformation Managers
  • Database Administrators
  • Power BI Developers
  • Power Platform Developers
  • Microsoft 365 Administrators
  • Project Managers
  • Monitoring and Evaluation Specialists
  • Finance and Business Reporting Officers
  • Operations Managers
  • Decision Makers
  • Government Officers
  • NGO Professionals
  • ICT Officers
  • Business Consultants
  • Anyone interested in Business Intelligence and Microsoft Power Platform.

Course Outline

Module 1: Introduction to Power BI and Business Intelligence

  • Overview of Business Intelligence (BI) concepts
  • Introduction to Microsoft Power BI ecosystem
  • Power BI Desktop, Service, and Mobile applications
  • Data-driven decision-making principles
  • Business Intelligence implementation lifecycle
  • Installing and configuring Power BI environment

Case Study: Implementing a Power BI solution for executive performance reporting.

Module 2: Data Modeling in Power BI

  • Star schema versus snowflake schema
  • Fact tables and dimension tables
  • Building relationships between tables
  • Cardinality and relationship types
  • Cross-filter direction and model optimization
  • Best practices for scalable data models

Case Study: Designing a sales and inventory data model

Module 3: Power Query (M) for Data Transformation

  • Introduction to Power Query Editor
  • Query folding concepts
  • Merge versus append queries
  • Parameters and reusable queries
  • Custom functions using M language
  • Data cleansing and transformation techniques

Case Study: Preparing multiple ERP datasets

Module 4: DAX Fundamentals and Advanced Calculations

  • Understanding row context and filter context
  • CALCULATE function and filter modification
  • Iterator functions (SUMX, AVERAGEX, COUNTX, RANKX)
  • Variables using VAR and RETURN
  • Advanced CALCULATE patterns
  • ALL, ALLEXCEPT and ALLSELECTED functions

Case Study: Developing dynamic financial KPIs using DAX.

Module 5: Time Intelligence and Advanced Reporting

  • Creating date tables
  • Year-to-Date (YTD) calculations
  • Month-to-Date (MTD) calculations
  • DATEADD and PARALLELPERIOD functions
  • Dynamic measures using SWITCH
  • Dynamic Top-N reporting and ranking

Case Study: Executive dashboard for annual financial performance analysis.

Module 6: Dashboard Design, Visualization and Performance Optimization

  • Interactive dashboard design principles
  • DAX-driven conditional formatting
  • Performance Analyzer usage
  • Identifying and optimizing slow measures
  • Report usability and visualization best practices
  • Publishing professional dashboards

Case Study: Optimizing a national performance monitoring dashboard.

Module 7: Security, Power BI Service and Deployment

  • Row-Level Security (Static and Dynamic)
  • Power BI Service overview
  • Workspaces and Apps
  • Dataflows and shared datasets
  • Deployment pipelines
  • Gateway configuration and scheduled refresh

Case Study: Securing departmental dashboards

Module 8: Microsoft Power Platform Ecosystem

  • Overview of Microsoft Power Platform
  • Power Apps
  • Power Automate
  • Microsoft Dataverse
  • Copilot Studio
  • Integration with Microsoft 365

Case Study: Building an integrated digital business solution using Power Platform.

Module 9: Power Apps and Dataverse Development

  • Dataverse tables and relationships
  • Canvas versus Model-driven Apps
  • Power Fx fundamentals
  • Forms and galleries
  • Linked data sources
  • Component libraries

Case Study: Developing a field inspection mobile application.

Module 10: Power Automate Process Automation

  • Types of automation flows
  • Triggers and actions
  • Conditions and loops
  • Approval workflows
  • Error handling techniques
  • Connecting Power Automate with Power Apps and Power BI

Case Study: Automating procurement approval processes.

Module 11: Microsoft Copilot Studio and AI Agents

  • Conversational versus autonomous agents
  • Building copilots using templates
  • Natural language authoring
  • Trigger phrases and conversation topics
  • Knowledge grounding using SharePoint, Dataverse and files
  • Connecting Copilot with Power Automate

Case Study: Creating an AI-powered employee support assistant.

Module 12: Governance, Responsible AI and Enterprise Deployment

  • Autonomous triggers and generative orchestration
  • Testing Power Platform applications
  • Responsible AI principles
  • Governance and Data Loss Prevention (DLP) policies
  • Publishing solutions to Microsoft Teams
  • Post-deployment monitoring and continuous improvement

Case Study: Enterprise-wide governance framework for secure Power Platform adoption.

General Information

  1. Customized Training: All our courses can be tailored to meet the specific needs of participants.
  2. Language Proficiency: Participants should have a good command of the English language.
  3. Comprehensive Learning: Our training includes well-structured presentations, practical exercises, web-based tutorials, and collaborative group work. Our facilitators are seasoned experts with over a decade of experience.
  4. Certification: Upon successful completion of training, participants will receive a certificate from Foscore Development Center (FDC-K).
  5. Training Locations: Training sessions are conducted at Foscore Development Center (FDC-K) centers. We also offer options for in-house and online training, customized to the client's schedule.
  6. Flexible Duration: Course durations are adaptable, and content can be adjusted to fit the required number of days.
  7. Onsite Training Inclusions: The course fee for onsite training covers facilitation, training materials, two coffee breaks, a buffet lunch, and a Certificate of Successful Completion. Participants are responsible for their travel expenses, airport transfers, visa applications, dinners, health/accident insurance, and personal expenses.
  8. Additional Services: Accommodation, pickup services, flight booking, and visa processing arrangements are available upon request at discounted rates.
  9. Equipment: Tablets and laptops can be provided to participants at an additional cost.
  10. Post-Training Support: We offer one year of free consultation and coaching after the course.
  11. Group Discounts: Register as a group of more than two and enjoy a discount ranging from 10% to 50%.
  12. Payment Terms: Payment should be made before the commencement of the training or as mutually agreed upon, to the Foscore Development Center account. This ensures better preparation for your training.
  13. Contact Us: For any inquiries, please reach out to us at training@fdc-k.org or call us at +254712260031.
  14. Website: Visit www.fdc-k.org for more information.

 

Explore:

M&E Research & Data Analysis GIS & Remote Sensing ICT Skills Humanitarian Agriculture Business & Governance All Courses Download Training Calendar (PDF) Virtual / Online Training Courses Contact Us Subscribe Group Rates Gallery Trainer Consultancy

Ready to advance your career?

Join thousands of professionals from 30+ countries trained by FDC — classroom sessions across Africa, Middle East & Asia.

Browse All Courses Get Course Updates

Enquire

Captcha code Click image to refresh

training@fdc-k.org • +254 712 260 031 • Nairobi, Kenya