Data Analysis, Visualizations and Dashboards using Power BI

Learn how to use Microsoft Power BI to create data reporting and dashboard solutions for social development projects

1,000+ enrolled

About this course

Microsoft Power BI is one of the best data analysis and visualization software available. With it, you can develop dynamic reports and dashboards, integrating data from multiple sources such as Excel files, databases and online platforms like KoBo Toolbox.

In this course, you will learn move from beginner to pro Power BI user using case studies in social/humanitarian programming

What you’ll learn

  • Connecting to different data sources
  • Transforming data and editing queries
  • Creating visuals
  • Creating calculated columns and measures using DAX
  • Putting visuals together to form dashboards
  • Publishing and sharing dashboards

Course content

  1. What is data analytics
  2. Types of data analytics
  3. What is data visualization
  4. Place of data visualization in social development projects
  5. Elements of data visualizations
  6. Examples of data visualizations
  7. Module summary
Getting started with Microsoft Power BI
  1. What is Power BI
  2. The Power BI interface
  3. Power BI building blocks
  4. Overview of building reports and dashboards in Power BI
  5. Connecting to a Microsoft Excel workbook
  6. Creating your first visualizations
  7. Editing and formatting visuals
  8. Using the report
  9. Module summary
  10. Module practice project
Connecting to data
  1. Connecting to Microsoft Access files
  2. Connecting to KoBo Toolbox
  3. Connecting to other KoBo servers
  4. Connecting to Google Sheets
  5. Module summary
Cleaning, transforming and loading data
  1. Promoting rows
  2. How data transformations work
  3. Deleting rows and columns
  4. Replacing values
  5. Editing field names and types
  6. Resolving data importing errors using M code
  7. Module summary
Modelling data
  1. Introduction to data modelling
  2. Getting ed with table relationships
  3. Configuring column and table properties
  4. Creating and using hierarchies
  5. Defining row level security
  6. Module summary
Performing calculations using DAX
  1. Introduction to DAX
  2. Creating Quick Measures
  3. Creating measures
  4. Creating calculated columns
  5. Using the CALCULATE function
  6. Using CALCULATE with multiple conditions
  7. Filter modifier functions in CALCULATE
  8. Time intelligence YTD
Creating visuals and reports
  1. Introduction
  2. Bar and column charts
  3. Line and area charts
  4. Line and bar combo chart
  5. Ribbon charts
  6. Waterfall charts
  7. Funnel chart
  8. Scatter plot
  9. Pie and donut chart
  10. Treemap
  11. Maps
  12. Gauge
  13. Cards
  14. KPI
  15. Table and matrix
  16. Custom visuals
  17. Configuring and customizing visuals
  18. Customizing pages
  19. Slicing and filtering
  20. Conditional formatting

Project: Developing a digital M and E system using KoboToolbox and Microsoft Power BI

Publishing and sharing

Publishing and sharing


Alexander Mtembenuzeni

Data Analyst, Instructor

Alexander has over 8 years experience training social impact organizations in data analytics. He also has consulted for small and big organizations alike – developing data collection tools, building M and E systems and analyzing data. He is a 4.5/5-rated instructor on where he has several courses with a combined over 6,000 students. He also loves blogging and creating tutorial videos for the Data for Development YouTube channel.

Frequently asked questions 

Does this course offer a certificate?

Yes. You will automatically get a certificate of completion as soon as you complete the course and pass the graded quizzes and project

How long will it take for me to complete the course?

We recommend investing 2 hours of learning per day. With that time investment, you will finish the course including the hands-on practices in 7 days.

Which days and times does the course run?

This course is self paced. Once you enroll, you can go through the learning content at any time, and at your own pace!

Instant access

Start as soon as you enroll

Approximately 14 days to complete

Suggested 2 hours per day


Beginner to Intermediate