CHOLERA OUTBREAK, STOCKHOLM, 1853.

Analyzed historical data from the 1853 cholera outbreak in Stockholm, which resulted in 248 deaths over 365 days. Through data cleaning, trend analysis, and visualization, the following insights were uncovered:

September 15th was the deadliest day, with 15 deaths recorded.

September had the highest fatalities by month, accounting for 183 deaths (73.8% of the total).

Children aged 1 year old recorded the most fatalities by age, with 13 deaths.

52.2% of all deaths were female, indicating a slight gender disparity.

The occupations Mamsell and Gossebarn recorded the highest deaths, with 10 and 9 fatalities, respectively.

The outbreak escalated rapidly throughout September, with a cumulative total of 183 deaths in just 30 days.

Forecasting analysis suggested a significant decline in fatalities by December, marking the tapering off of the outbreak.

Tools Used: SQL, Power BI.
Skills Demonstrated: Data Cleaning, Time Series Analysis, Forecasting, and Visualization.

Note: Interactive filters for Occupation and Gender have been added to allow users to explore specific aspects of the visualization with ease.

This project demonstrates the power of historical data in uncovering critical insights, trends, and predictions.

Skills: Intelligence Analysis · POWER BI · Analytical Techniques · Business Intelligence (BI) · Microsoft Power BI · Attention to Detail · Communication · Analytical Solutions · Data Analysis · MSSQL · SQL · Pivot Tables · Data Storytelling.

PLS CLICK ON THE VIDEO BELOW TO TOGGLE FULL SCREEN