Power BI essentials (draft)

Notes:

PlayGround: link
Hashtags: Introduction
Create everyday quiz in Google forms

🧰 : Excel online + Power BI

Teacher essentials:

Power BI website: link
Excel online: link
Go to meeting: link [7687008219]
data stories: link

Day 1: Break the ice

Topics to be discussed

1. Set expectations
2. Speak on Pre-requisites
2.a Work Email
2.b Desktop Download
2.c App-demo link
2.d Open Microsoft Account
3. Introduce to Titanic Dataset
4. Other BI tools - QlikView / Tableau/ *Google Data Studio*
5. Technical aspects
5.a Data Types
5.b File Types
5.c Pet Datasets
6. Job description/ Opportunities/ Certification ⚠️

Challenge for the Day:

Try to do this in both Excel and Power BI

⬇️ Jam Board link

here

— — —

Class Notes

Expectations:

1. Gain knowledge on Tool
2. Add a line on Resume
3. Excel — 5/10
4. Pivot Tables — Basic Knowledge

COVID Command Center:

• How many Persons got infected on daily basis (Infection Ratio)
• How many got vaccinated on a particular day (Population coverage ~ 40 %)
• Death rate
• Trend line for the last 14 days
• Restrictions on Mass Gatherings ( > 100)
• Weekly call on Lockdown
• Hospital Bed Occupancy (ICUs)
• Demand for Oxygen Cylinders
• Doctor/Nurse per 500 persons
• RT-PCR Tests
• Take a survey from Ambulance Drivers

-x-

Day 2: The world of visuals

✨ My slides: link

Notes : link

Tableau Quiz: link

✎ Quiz for the day !

NRE23 who host Power BI ?
[a] Apple
[b] Microsoft
[c] Google
[d] Amazon
NRE42 What is the difference between Power BI Desktop and Power BI Service ?
NRE21 What are the common data insights on Titanic dataset
NRE46 What are the building blocks of Power BI ?
NRE99 Who are the key stakeholders of Power BI ?
NRE69 What is DAX ?
NRE56 What are the different types of filters in Power BI ?
NRE88 What are the most common file types that are used as connectors ?
NRE12 What is the function of 'Get Data' ?
NRE222 What are the best books ?
NRE111 What are the best online resources ?
#️⃣ #Career | #ResumeBuilding

Day 3: Grammar of Visuals

Introduction to Power BI

✎ Quiz for the day ! [link]

What are the Axis available in a Bar Chart ?
What are legends ?
What are values ?
What are Tool tips ?
What are filters ?
What are data colors ?
What are data labels ?
What is plot area ?
What is background area ?
What is the title ?
What is the description ?

Day 4: Exploratory data analysis

Online Tools:

NRE23: link #It helps in 

✎ Quiz for the day !

What is the Min, Max, Mean, Median and Mode of Age of passengers ?
Draw Histogram on Age?
Draw Box and Whisker Plot on Age ?
What is the Standard Deviation, Variance and Range on Age ?
What is the difference between continuous and Categorical values ?
What is the skewness (negative or positive) for Age
How many null values in Age, and how to address them ?

Day 5