California Wildfire Analysis Dashboard

This comprehensive analytical dashboard provides deep insights into California wildfire incidents and their impacts from 2014-2023, enabling data-driven decision making for disaster management and environmental policy planning.

Key Insights

Damage Assessment

  • Total Financial Loss: $239.61K in damages across the decade

  • Structural Impact: 94K houses destroyed by wildfires

  • Human Toll: 993 total fatalities with injuries consistently outnumbering fatalities by 5:1 ratio

Geographic Distribution

  • Shasta County: Highest percentage of area burned (13.42%, 356K acres)

  • Sonoma County: Second most impacted with 12.13% (322K acres) of total burned area

  • Coastal Counties: Business damage shows strong correlation with population density

Cause Analysis

  • Lightning-caused wildfires: Resulted in the highest fatality count (365)

  • Human activity: Second leading cause of fatalities (345)

  • Environmental factors: Clear patterns in cause attribution support targeted prevention

Visualization Components

  • Interactive KPI Tracking: Critical metrics with trend sparklines showing historical patterns

  • Temporal Analysis: Time-series visualizations with year-over-year comparisons

  • Geographical Distribution: Interactive donut charts showing proportional area burned by county

  • Multi-dimensional Assessment: Specialized visualizations comparing injuries vs fatalities and business damage

Technologies Leveraged

  • Power BI Desktop, Python, DAX (Data Analysis Expressions)

  • Power Query (M), Custom color palette, Advanced visualization techniques

Next
Next

Customer Segmentation and Retention Analysis