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
What is data analytics
Complete and Continue
Discussion
10
comments
Load more
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login
10 comments