Category: Data
-
Data Cleaning Project
Part I: Research Question A. Research Question Question: ” What are the primary factors that significantly influence hospital readmission rates?” Context: Understanding these factors is crucial for healthcare organizations striving to mitigate readmission rates, thereby improving both clinical outcomes and financial efficiency. B. Description of Variables Qualitative Variables: Quantitative Variables: 10.585770. Part II:…
-
Data Acquisition Project
A. Question: How does the prevalence of specific health conditions (like Diabetes or Arthritis) vary across different age groups and income brackets within the patient population? A1. To answer this question, I need info from both the original medical_data database and the external mservices.csv file. In the database, I’ll investigate the patient table, specifically looking…
-
NAFT Report
Automated Data Aggregation and Formatting for Engineering Materials Overview This project involved creating an automation solution for engineers to compile and format data relating to engineering materials. The system is implemented as a VBA macro running within Microsoft Excel. The macro performs a range of tasks including data import from external CSV files, table creation,…
-
DVD Rental Business Report – SQL
DVD Rental Business Report Summarize one real-world business report that can be created from the attached Data Sets and Associated Dictionaries. By using the provided data sets and dictionaries, it is possible to create a business report focused on returning customers. This report could help the business understand which customers are returning and how often…