Steps to get ready for the Data Project Steps to get ready for the Data Project
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
For This or a Similar Paper Click To Order Now
Steps to get ready for the Data Project
Steps to get ready for the Data Project
Install Tableau Desktop on your computer
Watch Tableau videos/tutorials and the ones I posted in the Tableau tutorials folder
Watch the Lynda.com tutorials below (optional)
Hands-on experience with TableauUse the sample data provided to follow along with the tutorials provided, don’t just watch the videos
Consult the Tableau Manual, if needed.
Steps to get ready for the Data Project
Steps to get ready for the Data Project
Install Tableau Desktop on your computer
Watch Tableau videos/tutorials and the ones I posted in the Tableau tutorials folder
Watch the Lynda.com tutorials below (optional)
Hands-on experience with TableauUse the sample data provided to follow along with the tutorials provided, don’t just watch the videos
Consult the Tableau Manual, if needed.
Steps to get ready for the Data Project
Steps to get ready for the Data Project
Install Tableau Desktop on your computer
Watch Tableau videos/tutorials and the ones I posted in the Tableau tutorials folder
Watch the Lynda.com tutorials below (optional)
Hands-on experience with TableauUse the sample data provided to follow
CASE DETAILS
Case Details
You are the chief data analyst for a hospital and are tasked to build a dashboard to analyze readmissions data provided by CMS, so the hospital management and board can quickly look at how the hospital is performing in comparison with other hospitals in the region and the country. The dashboard should be simple enough to be understood by providers and managers without extensive data training. Assume that national level data will be updated annually; however, for recommendation purposes, also assume you would have access to facility level data on a regular basis.
The point of this exercise is not only to learn how to think like a data analyst and use BI tools, but to also learn how to communicate business-relevant implications of data analyses. By the end of this assignment, you will know how to structure your data analysis projects to ensure the fruits of your hard labor yield results for your stakeholders. You will also learn how to streamline your analyses and highlight their implications efficiently using visualizations in Tableau, the most popular visualization program in the business world.
Don’t forget that this is not ONLY about crunching the numbers; there is a reason why these are called business analytics/intelligence tools. Healthcare is a business and in fact many healthcare organizations will have to rediscover their business side if they want to survive in this environment.
What you will have to do–the big picture:
craft the right questions to ensure your analysis project succeeds;
leverage questions to design logical and structured analysis plans;
create the most important graphs used in business analysis and transform data in Tableau;
design business dashboards with Tableau;
tell stories with data;
Tableau Installation Link
Tableau Installation LinkClick the link above to be directed to download Tableau.
Tableau for Students
Excel Data–these are the data files we will be importing into Tableau and use for analysis. To gain a better understanding of what is going on, we can merge the files and link various hospital characteristics to readmissions measures and penalties. attached as zip file
Note: this project is intended to teach you use the tool (aka Tableau) and basic data manipulation, but assumes basic knowledge of statistics and the health system. The source of the data, years, etc, are not important given the goals above, but if you would like to know more about the way these metrics are calculated, how often, and all the details about where these files come from, visit the links included in the general readmissions info (or run a basic google search). Some of these are copied belowhttps://www.medicare.gov/hospitalcompare/readmissi…https://www.medicare.gov/hospitalcompare/search.ht…
Final Submission for the Data Analysis Project
Final Submission for the Data Analysis Project
By now you have explored the data in detail and have selected the best visuals to support your arguments for how to improve your hospital’s readmissions status.
1) Finalize your Tableau charts:Include a total of 9 charts with visuals (1 visual=1 chart or 1 dashboard)
Try to include at least one chart of each type (one map, one scatterplot, one bar chart) and one dashboard
Make sure each chart has a clear and meaningful title (e.g., not “Readmissions bar chart”)
Remove the legend if it does not add additional information not on the labeled axes
Increase font for data labels and text to at least 10 or 11 to make sure they are readable (and use black font, default is gray)
Export the charts from Tableau to PPT in bulk or as images. Do NOT use screenshots, they will make your visuals blurry
Be consistent in naming and colors chosen to represent the same concepts
No pie or bubble charts ?
2) Put together your PPT presentation (no audio necessary unless you want to explain further). Remember that the goal is to recommend a course of action for your hospital leadership based on the data you have available. Recommended slides for your PPT are (you can add a few more if it helps you make your point):title page (1 slide)
background of the readmissions program–why is it important for hospitals and patients (1 slide); explain why we care about under 1 and over 1 for ERRs
background of your chosen hospital (1 slide)
analysis goals(1 slide)
9 slides with your chosen visuals as indicated above (Use the export function. Make sure charts are readable and fit on the slides, and are formatted appropriately.)
a brief description of each visual on that respective slide that explains the viewer what the main message is; these brief explanations are very important, as they guide your audience through and are the bread crumbs you leave behind on the way to your recommendation :). Make sure you do not repeat the info from the title and describe how we created the chart twice. Example: a good dashboard title would be Excess readmission ratios for X hospital and state and national averages. The blurb that provides insights on the side should not repeat that same info, but read something like: Heart failure readmissions are higher in our hospital compared to regional and national averages.
a findings slide that summarizes what you found in those 9 visuals–what do those charts tell us about readmissions and how do those findings relate to the deficiencies you observed in your chosen hospital?
a recommendations slide—what do you think the hospital should do in short/long term to address readmissions (there is a lot of research on causes and approaches to reduce readmissions, and I added examples of that below for COPD, but you don’t have to go that far if you don’t want to; instead, just look at the basics of how to improve readmissions such as transitional care, 7-day follow ups, chronic disease management–see the articles below, for example)
https://www.beckershospitalreview.com/quality/10-proven-ways-to-reduce-hospital-readmissions.htmlhttps://www.tcshealthcare.com/clinical-corner/best-practice-strategies-and-interventions-to-reduce-hospital-readmission-rates/
TUTORIALS FOLDER: How to create different types of charts (VIDEOS)
TUTORIALS FOLDER: How to create different types of charts (VIDEOS)Contains:1) “How to” short videos to illustrate how to do some of the charts discussed in the proposed analysis2) Short videos to show how to get the right Tableau file for submission (.twbx file) and how to export your visuals to PPT
Research on causes of readmissions
Research on causes of readmissionsThis folder contains research info on causes of readmissions and approaches to address them for one of the 5 conditions (COPD), on which many NoVA hospitals are underperforming. This is optional, you don’t have to go into this level of detail in your recommendations, but here it is if you’d like to see why
A4- Charts and PPT Submission
final submission for the Data Analysis project. By now you have explored the data in detail and have selected the best visuals to support your arguments for how to improve your hospital’s readmissions status.
Submit:1) Tableau file in .twbx format (Go to File/Export Packaged Workbook). If you do not save it in this format I cannot open the file and cannot grade, and you will get ZERO points for this component. Please follow the instructions. Submitting the right version of the file is worth 10% of your project grade.
Indicate the charts or dashboards to be considered for final grade by adding “Final” to their name in the tabs at the bottom; as with any analysis, your Tableau file may have hundreds of charts, because you should try different things to see what looks better and what you would like to focus on. However, you will have to select what your main points are, and then select the final 9 you would like to have considered for the grade.
Have at least one chart of each type and one dashboard, otherwise you can combine these charts in various ways (for a total of 9 visuals)
2) Add these 9 final visuals to a PPT presentation (see above info about what slides it should contain in addition to the charts exported from Tableau)
