Course Level:
Introduction
This course is designed to equip professionals with the skills needed to analyze, interpret, and visualize data using Microsoft Power BI.
Participants will learn how to connect, clean, analyze, and model data, and then build interactive dashboards that effectively communicate insights to decision-makers.
Duration
5 days
Who Should Attend
- M&E officers and program analysts
- Business and data analysts
- NGO, health, education, and government staff
- Researchers and academics
- Anyone looking to convert raw data into actionable insights
Training Methodology
- Instructor-led sessions with real-world examples
- Hands-on exercises using practical datasets
- Interactive group work and peer reviews
- Downloadable templates, guides, and project files
Learning Outcomes (Course Objectives)
By the end of the course, participants will be able to:
- Perform exploratory and descriptive data analysis using Power BI
- Clean and transform raw data for analysis
- Create calculated metrics and key indicators using DAX
- Use visualizations to uncover and communicate insights
- Build compelling dashboards with filters, drill-downs, and interactivity
- Share and publish reports via the Power BI Service
Course Outline
Module I: Introduction to Data Analysis and Power BI
- What is data analysis? Types: descriptive, diagnostic, predictive
- Introduction to the Power BI ecosystem
- Understanding datasets, models, reports, and dashboards
- The data analysis workflow in Power BI
Module II: Connecting and Preparing Data
- Importing and connecting to multiple data sources (Excel, web, SQL, SharePoint, etc.)
- Data cleaning and shaping in Power Query Editor
- Removing duplicates, handling missing values, and unpivoting data
- Creating relationships between tables (data modeling)
Module III: Data Exploration and Descriptive Analysis
- Creating summary statistics and descriptive tables
- Filtering, grouping, and sorting data
- Exploring patterns using charts: bar, line, column, scatter, matrix
- Visualizing trends, comparisons, and distributions
Module IV: DAX and Analytical Calculations
- Introduction to DAX (Data Analysis Expressions)
- Creating calculated columns and measures
- Using functions: IF, SWITCH, CALCULATE, FILTER
- Time intelligence: YTD, QTD, MoM, rolling averages
- Conditional formatting and KPIs
- Star schema vs snowflake schema
Module V: Designing Visual Dashboards and Communicating Insights
- Choosing the right visual for the story
- Using slicers, filters, bookmarks, and drill-through
- Creating dashboard layouts with design best practices
- Telling a data story with tooltips, titles, and annotations
Module VI: Publishing and Sharing Insights
- Introduction to Power BI Service
- Publishing and sharing reports
- Creating dashboards in Power BI Online
- Row-Level Security and Workspace Management
- Scheduling data refreshes
Module VII: Final Hands-On Project
Participants will complete a capstone project where they:
- Load and clean a raw dataset
- Perform key analysis (trends, outliers, performance metrics)
- Create measures using DAX
- Design a dynamic dashboard that tells a clear story
- Present their analysis to peers for feedback
Related Courses
Course Administration Details:
Methodology
This instructor-led training course is delivered using a blended learning approach and comprises presentations, guided sessions of practical exercise, web-based tutorials, and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals and trainers in these fields. All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.
Accreditation
Upon successful completion of this training, participants will be issued a Tech For Development Certificate of Course Completion.
Training Venue
The training will be held at the Tech For Development Training Centre. The course fee covers the course tuition, training materials, two break refreshments, and lunch. All participants will additionally cater to their travel expenses, visa application, insurance, and other personal expenses.
Accommodation and Airport Transfer
Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.
- Email: letstalk@techfordevelopment.com
- Phone: (+254) 790 824 179
Tailor-Made
This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our Training Centre or at a convenient location. For further inquiries, please contact us on:
- Email: letstalk@techfordevelopment.com
- Phone: (+254) 790 824 179
Payment
Payment should be transferred to our bank account on or before the start of the course. Send proof of payment to letstalk@techfordevelopment.com
Click here to register for this course.
Register NowCustomized Schedule is available for all courses irrespective of dates on the Calendar. Please get in touch with us for details.
Want more details about our courses? Get in touch with us.
