Data Analyst
Influenza Analysis
An Excel based predictive analysis of influenza trends in the US to advise the deployment of medical staff for the upcoming influenza season
Project Overview
Objective
Objective
Objective
Perform a predictive analysis using historical flu data to examine trends and seasonality of influenza to assist medical staffing agency with the planning and deployment of additional staff to support influenza season
Data
Objective
Objective
Data was provided as part of the CareerFoundry Data Course, sourced from CDC and US Census Bureau
Skills
Skills
Skills
Translating business requirements, Data cleaning, Data integration, Data transformation, Statistical hypothesis testing, Visual analysis, Forecasting, Storytelling in Tableau, Presenting to an audience
Tools
Skills
Skills
Excel, Tableau
Project Flow
Sourcing the Right Data
Data Profiling
Data Consistency Checks
Data Cleaning
Summary Statistics
Data Transformation & Integration
Data Mapping
Data Integration
Pivot Tables
V-Lookup
Statistical Analysis
Create and Test a Statistical Hypothesis
Data Visualizations
Utilize Tableau to create various charts
Presenting to an Audience
Tableau dashboard video presentation
Analysis
Final Report
Recommendations
•Prioritize additional staffing to states with the highest vulnerable population: California, New York, and Texas
•Staff should be sent beginning in November to adequately cover the spike in influenza deaths during the winter months, December-March
TAKEAWAYS
•A large amount of data for deaths was listed as suppressed which can represent a number from 0 to 9 so I used the average of 5. This could skew my results.
•Having minimal instances of under or over staffing was a success factor for the staffing agency but I was unable to provide specifics about how many staff members to send as no data was available for this.
Copyright © 2022 Shey LeGras - All Rights Reserved.
Powered by GoDaddy
This website uses cookies.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.