About the 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
Course starting date: 3rd July | Mode of learning: Self paced videos and activities
What you are going to learn in the course
Introduction to data analytics and visualization
What is data analytics, What is data visualization, The place of data analytics and visualization in social development projects, Elements of data visualization
Getting started with Microsoft Power BI
What is Power Bi, Power BI building blocks, Power BI Interface, Connecting to an Excel file, Using the visualizations pane, Using the Fields pane, Creating a visualization, Interacting with visuals, Formatting, moving and resizing visuals, Using Focus mode and Spotlight
Connecting to data
Connect to Microsoft Access database, Connect to a SQL database, Connect to Google sheets, Connect to KoBo Toolbox/ODK
Cleaning, transforming and loading data
Resolving data quality issues, Evaluating and transforming data types, Modifying Power Query M code, Resolving data importing errors
Modelling the data
Introduction to data modelling, Configuring table and column properties, Dimensions and hierarchies, Creating model relationships, Creating Quick Measures, Configuring many-to-many relationships, Enforcing row-level security
Performing calculations using DAX
Introduction to DAX, DAX context, Advanced DAX, Creating calculated tables, Creating calculated columns, Creating measures, Using the CALCULATE() function, Using Time-intelligence functions
Creating reports
Adding visualization items to reports, Choosing an appropriate visual, Formatting and configuring visuals, Importing custom visuals, Conditional formatting, Slicing and filtering, Configuring the report page, Configuring automatic page refresh, Creating a paginated report
Creating dashboards
Create a dashboard, Realtime dashboards, Enhancing a dashboard, Pin Visuals to dashboards, Configure a dashboard tile alert
Publishing and sharing reports
Publishing from Power BI Desktop, Sharing a dashboard from Power BI
Project: Developing a digital M and E system using KoBo Toolbox and Microsoft Power BI
Course Curriculum
- What is Power BI (4:47)
- The Power BI interface (5:43)
- Power BI building blocks (1:35)
- Overview of building reports and dashboards in Power BI (3:02)
- Connecting to a Microsoft Excel workbook (2:32)
- Creating your first visualizations (9:55)
- Editing and formatting visuals (6:11)
- Using the report (3:29)
- Module summary
- Module practice project
- Introduction (3:16)
- Bar and column charts (15:41)
- Line and carea charts (8:28)
- Line and bar combo chart (6:11)
- Ribbon charts (4:19)
- Waterfall charts (1:44)
- Funnel chart (1:51)
- Scatter plot (3:50)
- Pie and donut chart (3:27)
- Treemap (2:36)
- Maps (4:20)
- Guage (2:35)
- Cards (2:39)
- KPI (4:59)
- Table and matrix (5:55)
- Custom visuals (2:37)
- Configuring and customizing visuals (9:04)
- Customizing pages (4:51)
- Slicing and filtering (7:18)
- Conditional formatting (5:19)
Join the full course
Get this course, plus 7 other self-paced courses including all our weekly live sessions for a low monthly or yearly subscription