Introduction to Power BI, Clean, Transform, and Load Data with Power Query, Data Modelling

Microsoft

Jun 27, 2022

Let's Take Account of Our Learnings

From Introduction to Power BI, Clean, Transform, and Load Data with Power Query, Data Modelling in Power BI, Data Analysis Expression (DAX) for Beginners, and many more. Week 2 was nothing less than a super-packed week.

Before I share a recap of what we co-learn this week, let me call your attention to some of the stories and testimonies in the community.

Community Spotlights

We are constantly looking for opportunities to showcase the amazing work you are building with your skill. I met with some participants in the 30Days of Learning to hear from them what their experience has been like, I was more than impressed with the results. check the video for the details

Meet Temidayo Adeyonu

Temidayo is a year 4 Medical Student from the University of Ilorin, Nigeria Participating in the 30Days of Learning engagement. Temidayo counts it an amazing opportunity to be part of the 30Days of Learning opportunity and share with us how she has been able to apply things she was learning in her personal projects. Yes, she still wants to become a Medical Doctor, but she believes these skills are needful in helping her better manage patients with medical challenges.

Meet Adetunji Sunday Lawrence

Sunday, a Law Student from University of Ibadan, Nigeria Participating in the 30Days of Learning engagement. He counts it a miracle to come across the learning opportunity and share with us what he has been able to learn during this engagement. While he will continue in the Legal Sector as a Barrister, he believes the knowledge of data and skill acquired will help him support businesses better in the future.

Meet Abdul-Roqeeb Ismail

Meet Abdul-Roqeeb, a Medical Student from Ladoke Akintola University of Technology (LAUTECH), Nigeria Participating in the 30Days of Learning engagement. He is fascinated by the things he has learnt which includes ability to scrape data from the web with Excel, Build Dashboard with Excel, Create Power BI Dashboard from SharePoint List and MS Teams and being able to embed the report into PowerPoint slide, and many more. He hopes to infuse data analysis into his decision making as a practicing Medical Personnel in the future.

What an Experience!

This is barely 8 Days into the program, and we have seen this level of transformation. Another interesting thing about this spotlight is the current course of study by the participants. coming from non-STEM background and learning as much as this in barely 8 days is amazing.

It's finally time to go through recap

What does this mean? It simply means if you are yet to do all these amazing stuffs, here is yet another opportunity to catch-up.

Let's have the recap below:

Day 7: Cloud Skill Challenge

Learning Objectives

Enroll for the Cloud Skill challenge here https://aka.ms/30DLDataAnalysis
Complete at least 1 Module

Access the session content here: https://aka.ms/30DLDATDay7

Day 8: Introduction to Power BI Desktop

Learning Objective

Understand the Anatomy of Microsoft Power BI Dashboard

Learn how to connect Microsoft Power BI to several Data Sources

Topics Covered

Connect and Import Data from six (6) Sources to Microsoft Power BI

Access the session video contents here: https://aka.ms/30DLDATDay8

Day 9: Power Query for Beginners in Power BI

Learning Objective

Participants should be able to understand and be familiar with power query editor as well as use Power Query to clean, transform, and load data.

Access the session video contents here: https://aka.ms/30DLDATDay9

Day 10: Introduction to Data Modelling in Power BI

Learning Objective

Participants should be able to understand what Data Modelling is in Power BI
Participants should be able to model data based on the sample dataset provided
Participants should be able to build a dashboard from the data modelled
Participants should be able to document their learning on GitHub and share on social media platform

Topics Covered

Data Modelling concepts

Star Schema and Snowflakes schema

Practical Modelling session

Access the session video contents here: https://aka.ms/30DLDATDay10

Day 11: Introduction to Data Analysis Expression (DAX)

Learning Objective

Our facilitator, Ahmed Oyelowo demystified Data Analysis Expression (DAX). In his word, if you don't know Data Analysis Expression, it will become Difficult Analysis Expression.

Access the session video contents here: https://aka.ms/30DLDATDay11

Day 12: ToolTips, Navigation Buttons and Bookmark in Power BI Desktop

Learning Objective

This session works participants through when to use ToolTips and how to create one in Power BI Desktop. It also introduces them to Bookmarking and adding navigation to Power BI Reports

Link currently unavailable. it will be updated here once available.