US Electric Outage

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