Very cool to see this broken down! I wonder why such a decrease in the number of customers affected. Due to more having back up power? Or customers spread out over more power houses. Either way it's fascinating to see!
comment-640-avatar
Vishal Singh Thakur
12 months ago
I like the detailing of this dashboard . Nicely done .
comment-645-avatar
An Pham
12 months ago
Love all the details of this dashboard and how you broke down all the information. Lovely job!
comment-647-avatar
Louise Randall
12 months ago
Great Analysis Katie and insight into the power outage. Thought your dashboard was amazing with helpful date filtering and top 3 event causes. With practice I hope to create something that is as close to your high standard.
comment-688-avatar
Muhammad Huzaifa
11 months ago
Great work Katie
comment-1871-avatar
LAMIAA MOHAMMAD
3 months ago
Great work!
I would like to ask a question—about this part: (Comparing States to Identify States With Higher Demand Loss)
How could you handle the Area Affected field to calculate the population over the years and determine the megawatts per 100,000 people?
This field lacked a consistent format, and the entries varied in number and expression style.
comment-1872-avatar
LAMIAA MOHAMMAD
3 months ago
Another question if your time allows:
What do the following mean?
Updated Power Outage By State Unpivoted
Power Outage By NERC Region Unpivoted
In the modeling snapshot, does this mean that the column containing multiple Affected Areas has been split into several columns, where each column containing only one Affected Area?