__STYLES__
Tools used in this project
US Electric Outage

Power BI Dashboard

About this project

The dashboard represents the outages frequency of areas in US

  • First i combined tables for data about electric outage from 2009 to 2023

but i had to unify the structure of tables to combine them easily

-after creating on consolidated table, i made 2 dimensions: Dim Date & Dim Time to track outage frequency

over years and different hours of the day

  • created a heat map to specify where is the area has the most outage durations

  • summary cards

-YOY changes

  • Top 5 areas with most affected customers

  • Top 5 areas with longest outage duration

  • correlation between MW losses and number of outages

Additional project images

Discussion and feedback(14 comments)
comment-504-avatar
mohamed magdy
mohamed magdy
Project owner
7 months ago
Project owner
i changed the column names to be the same in every sheet and then used append to union them in one sheet vertically, so i can apply the same process of cleaning on one table, then created tim

comment-508-avatar
chikwe james
chikwe james
7 months ago
Please can we talk better privately, I really need help on some of the data cleaning. Do you use whatsapp or Linkedln

comment-512-avatar
mohamed magdy
mohamed magdy
Project owner
7 months ago
Project owner
WhatsApp and linkedin all is good https://www.linkedin.com/in/mohamed-magdy-15b298129?utm_source=share&utm_campaign=share_via&utm_content=profile&utm_medium=android_app Contact me over linked

comment-521-avatar
chikwe james
chikwe james
7 months ago
I couldn't click on the link and I searched for Mohamed Magdy, I saw so many users sharing your name. This is my whatsapp number please 09018358182 Please send me a message

comment-522-avatar
mohamed magdy
mohamed magdy
Project owner
7 months ago
Project owner
I saved the number but it didn't show on my contacts Here is my number +201159544007

comment-538-avatar
yousafkhan datascientist
yousafkhan datascientist
7 months ago
how much time it took to complete the challenge?

comment-540-avatar
mohamed magdy
mohamed magdy
Project owner
7 months ago
Project owner
3 days

comment-545-avatar
yousafkhan datascientist
yousafkhan datascientist
7 months ago
how you handled unknown values in excel?
2000 characters remaining