Information Systems Course Project-
You will be provided with simulated data from a hospital. The primary data set will include ER wait times, and supporting tables ranging from ER Staffing schedules to bed turnaround time. You will use this data to conduct an analysis into potential factors impacting ER wait times and recommend possible process improvements based on the dataand any additional research you have conducted. If you use external data resources make sure they are credible and properly cited in your presentation.
Your project must include the following components:
1. Import and Structure Data
a. Use the provided data sets to import tables into a blank access database
b. Use database normalization techniques to split the flat file databases into a relational database.
c. Make sure to utilize primary and foreign keys so the data can be queried effectively.
2. Exploratory Data Analysis & Reporting
a. Review the provided data sets to explore ER wait times, summarize the data and correlate it to the provided data sets. I.e. are wait times lower when more staff is assigned? Hint: do not stop there.
b. Your exploratory analysis must use one query that aggregates and at least one chart.
c. Use the queries from your exploratory analysis to create Access Report objects summarizing what you have discovered.
3. Interactivity
a. Create an Access Form that has an interactive component (drop down box, radio button, etc.)
b. When interacted with your form should requery and display the requested information, taking into account the users direct input?
4. Presentation
a. Create a PowerPoint presentation, it should include data from the reports you created as well as recommendations for how best to address the length of wait times in the ER.
b. Recommendations will be evaluated based on how feasible they are. You must consider patient safety, quality of care, cost of implementation and other limitations. No solution is perfect or free, but your recommendations should reflect consideration of these factors.
c. You should have more than one recommendation, but be sure to support your recommendations with data and detail. A single sentence is not a recommendation.
Data link- https://www.dropbox.com/s/1apq8g2nmlhldba/Project%20Data.xlsx?dl=0