Data Science

Arcane Falls Healthcare Project

  • Microsoft Excel
  • Data Visualization
  • Data Transformation and Exploration
Arcane Falls Healthcare Project
overview

About this engagement

Project Title: Analysis of Arcane Falls City Healthcare Data

Date: February 2024

Introduction

The Arcane Falls City Healthcare Data project provides insights into the city’s healthcare landscape. By analyzing trends, patterns, and key metrics, stakeholders can make informed decisions to improve services, optimize resources, and enhance community well-being. Microsoft Excel will be used for data analysis, visualization, and interpretation to extract meaningful insights that guide future strategies.

Objectives

  • Demographic Analysis
    • Distribution of Patients by Age and Gender
    • Distribution of Patients by Blood Type
    • Common Medical Conditions among Patients
  • Hospital Performance Analysis
    • Total Number of Patients
    • Top Ten Hospitals with the Highest Billing Amounts
    • Most Common Insurance Providers Associated with Hospitals
  • Patient Treatment Analysis
    • Most Common Medications Prescribed
  • Financial Analysis
    • Total Billing Amount Per Insurance Provider

Data Source

Dataset obtained from kaggle.com.

Conclusion

The analysis provided valuable insights and recommendations for improving healthcare performance in Arcane Falls City. Implementing these recommendations should optimize services and enhance the overall healthcare system.

Want results like this for your business?

Tell us the decision you're trying to improve — we'll outline scope, timeline, and what it takes to ship.