Business Problem

The Maryland Department of Public Safety needs to understand crime trends over the past decades to inform their strategic planning. They aim to reduce crime rates by 10% in the next five years. To achieve this, they need a detailed analysis of the historical data.

Key Insights

Maryland crime rates have been steadily declining since the mid-1990s. Larceny theft has consistently been the most frequently occurring crime in Maryland, while rape and murder rates have experienced the greatest volatility. Population size appears to be a contributing factor to crime occurrence. Out of the highest crime rate areas, Baltimore City and Baltimore County crime rates are primarily driven by violent crimes, while in Worcester and Allegany Counties, high overall crime rates can largely be attributed to property crimes.

Recommendations

🎯 Targeted Approach to Reduce Crime: To reduce violent crime in Baltimore City and Baltimore County, increase law enforcement presence, enhance community policing, and implement violence prevention programs. In Worcester and Allegany Counties, focus on theft prevention, improved surveillance, and community education to address high property crime rates. Model additional strategies after successful crime reduction efforts in counties that have significantly lowered their crime rates over the years.

🔍 Pinpoint Aggravating Factors: Larger jurisdictions with higher crime rates should implement targeted interventions, while smaller areas should maintain low crime rates through community engagement. Evaluate factors like poverty, unemployment, education access, and substance abuse to refine crime prevention strategies.

🚨Address Crime Rate Volatility: To stabilize rape and murder rates, establish specialized units charged with handling associated cases. Enhance training for officers in handling sensitive cases and provide additional resources for victim support services.

📢 Community Education Campaigns: Launch public awareness campaigns in high-crime areas to educate residents on crime prevention, encourage crime reporting, and promote the benefits of increased community policing for enhanced safety.

Data Source

Data in Motion

Tools used

Python

Business Problem

The National Campus Inclusion Initiative (NCII) aims to identify factors that lead to high campus inclusivity ratings and analyze how community size and type influence these ratings. This will help the NCII prioritize resources for campuses needing improvement.

Key Insights

The country-wide average inclusion rating was 3.97. States with the highest average inclusion rating included Vermont, Indiana, and Nebraska. Larger campuses tend to receive higher inclusion ratings, though this relationship is only moderate, indicating that other factors also impact the ratings received. Campuses located in more urban settings generally have higher inclusivity ratings. Overall, campuses located in medium-sized communities with small or medium-sized student populations in the Northeast and Midwest regions received the highest inclusivity ratings.

Recommendations

🏫 Support Small & Rural Campuses: Prioritize resources for campuses with small student populations and those in rural areas, which often have lower inclusivity ratings.

📋 Adopt Best Practices: Identify and document effective inclusivity strategies from high-rated campuses. Develop and share guidelines based on these practices to assist other campuses in enhancing their inclusivity.

🗄️ Expand Data Collection Efforts: Broaden data collection effortd to include campuses in currently unrepresented states (e.g., Alaska, Delaware, etc.). This will provide a more comprehensive view of inclusivity across regions and help identify new patterns or outliers.

🤝 Foster Collaboration: Promote partnerships between high-inclusivity urban campuses and those in smaller or rural areas through academic, sports, and social engagements. These collaborations can facilitate knowledge and resource sharing to improve inclusivity across various community types.

🏆 Reward Excellence: Create awards or recognition programs for campuses with exemplary inclusivity practices. Public acknowledgment can inspire campuses to improve their inclusivity efforts and share successful strategies, fostering overall improvement across the board.

Data Source

Data in Motion

Tools used

MySQL, Python, Tableau

Business Problem

The Customer Experience Team of NexWave Communications aims to enhance customer satisfaction by analyzing key performance indicators (KPIs) at a call center. The goal is to understand and improve call resolution rates, agent performance, and overall customer satisfaction. By identifying areas for operational efficiency and service quality improvements, the team will prioritize strategies to optimize call center performance.

Key Insights

The highest number of calls were received on Mondays, Tuesdays, and Thursdays. In the past month, 70% of incoming calls were resolved. On the most recent day of the current month, the call center received 27 calls, each lasting approximately 4 minutes. Most calls received satisfaction ratings between 3 and 5. The top three agents with the fastest call response rates were Stewart, Becky, and Diane, while those with the slowest response rates were Martha, Greg, and Dan. The top three agents with the highest resolution rates were Martha, Stewart, and Jim, while those with the lowest resolution rates were Diane, Joe, and Dan.

Recommendations

📅 Staffing Adjustments: On Mondays, Tuesdays, and Thursdays, when the highest call volumes are received, increase staffing to effectively manage the increased workload.

Data Source

Analyst Builder

Tools used

Tableau

Business Problem

Massachusetts General Hospital's Board of Directors seeks to evaluate the hospital's performance over the past decade to optimize operations. Their primary goals are to improve admission and readmission rates and identify departments for potential expansion. The hospital's short- and long-term strategic objectives will be guided by a high-level KPI report that analyzes patient and visit trends.

Key Insights

Ambulatory visits (12,537 total visits) were by far the most common visit type. Out of 284 readmissions, males represented a higher proportion (215 patients) than females (69 patients) and had a higher mortality rate (100%) compared to their female counterparts (56.52%). A breast cancer diagnosis was among the 3 most common diagnoses accounting for hospital admissions and readmissions, especially among Hispanic and Black female patients. Dual Eligible, Medicare, and Medicaid provided the highest coverage per visit.

Recommendations

🏥 Invest in ambulatory care: Increase staffing for hospital departments serving ambulatory visits (e.g., physician offices, clinics) and expand facilities supporting these visit types to effectively manage the high patient volume.

🎗️ Community-Engaged Education: Partner with community leaders to educate women about preventative breast cancer screening to ultimately reduce admission, readmission, and mortality rates related to this diagnosis.

📞 Post-discharge follow-ups: Implement virtual post-discharge follow-up appointments for patients characterized by demographic (e.g., elderly patients) or diagnostic (e.g., breast cancer, congestive heart failure, COVID-19) factors more frequently seen among the readmitted.

👩‍⚕️ Stakeholder collaboration: Work with insurance companies to offer affordable preventative services (e.g., nutritionist visits, blood tests) to reduce payer expenses long-term and improve the admission, readmission, and mortality rates associated with diagnoses for which obesity is a risk factor (e.g., congestive heart failure, hyperlipidemia). Educate patients about the out-of-pocket costs and long-term health benefits of such preventative care programs.

Data Source

Maven Analytics

Tools used

PostgreSQL,Tableau