Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analysis, Visualizations and Dashboards using Power BI
Introduction
What is data analytics (2:06)
Types of data analytics (3:15)
What is data visualization (2:43)
Place of data visualization in social develoment projects (2:47)
Elements of data visualizations (1:54)
Examples of data visualizations
Module summary
Getting started with Microsoft Power BI
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
Connecting to data
Connecting to Microsoft Access files (2:43)
Connecting to KoBo Toolbox (8:40)
Connecting to other KoBo servers
Connecting to Google Sheets (4:38)
Module summary
Cleaning, Transforming and loading data
Promoting rows (2:54)
How data transformations work (2:51)
Deleting rows and columns (4:55)
Replacing values (2:53)
Editing field names and types (3:22)
Resolving data importing errors using M code (8:02)
Module summary
Modelling data
Introduction to data modelling (7:26)
Getting started with table relationships (8:22)
Configuring column and table properties (5:44)
Creating and using hierarchies (8:05)
Defining row level security (3:36)
Module summary
Performing calculations using DAX
Introduction to DAX (2:18)
Creating Quick Measures (9:13)
Creating measures (9:49)
Creating calculated columns (2:53)
Using the CALCULATE function (9:37)
Using CALCULATE with multiple conditions (6:34)
Filter modifier functions in CALCULATE (6:29)
Time intelligence YTD (5:39)
Practice exercise
Creating visuals and reports
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)
Project: Developing a digital M and E system using KoBo Toolbox and Microsoft Power BI
Project (51:56)
Practice exercise
Publishing and sharing
Publishing and sharing (3:06)
Your certificate
Your certificate
The Power BI interface
Complete and Continue