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:
- Understand Business Intelligence concepts and Microsoft Power BI architecture.
- Design efficient data models using star and snowflake schemas.
- Transform and prepare data using Power Query (M).
- Develop advanced DAX calculations and analytical measures.
- Create interactive dashboards and executive reports.
- Implement Row-Level Security and Power BI Service deployment.
- Build business applications using Microsoft Power Apps.
- Automate organizational workflows using Power Automate.
- Develop intelligent AI assistants using Microsoft Copilot Studio.
- Apply governance, security, responsible AI, and enterprise deployment best practices.
Organizational Benefits
Organizations participating in this training will benefit by:
- Improving enterprise data-driven decision-making.
- Enhancing business reporting accuracy and efficiency.
- Automating repetitive business processes.
- Reducing operational costs through workflow automation.
- Increasing employee productivity using low-code applications.
- Strengthening enterprise data governance and security.
- Improving executive dashboard reporting capabilities.
- Accelerating digital transformation initiatives.
- Supporting innovation using AI-powered business solutions.
- 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
- Customized Training: All our courses can be tailored to meet the specific needs of participants.
- Language Proficiency: Participants should have a good command of the English language.
- 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.
- Certification: Upon successful completion of training, participants will receive a certificate from Foscore Development Center (FDC-K).
- 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.
- Flexible Duration: Course durations are adaptable, and content can be adjusted to fit the required number of days.
- 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.
- Additional Services: Accommodation, pickup services, flight booking, and visa processing arrangements are available upon request at discounted rates.
- Equipment: Tablets and laptops can be provided to participants at an additional cost.
- Post-Training Support: We offer one year of free consultation and coaching after the course.
- Group Discounts: Register as a group of more than two and enjoy a discount ranging from 10% to 50%.
- 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.
- Contact Us: For any inquiries, please reach out to us at training@fdc-k.org or call us at +254712260031.
- Website: Visit www.fdc-k.org for more information.