The creation of a dashboard requires the healthcare administrator to be knowledgeable on what data should be pulled directly depending on the type of key performance indicator (KPI). When looking at the financial status of a healthcare organization the healthcare administrator will develop KPIs for the type of insurance, account receivable pending, paid visits, and the length of the visit. This assignment requirement is to build visuals in an excel document that shows the number of pending insurance claims vs. paid, percent of visits based on length of the visit, and insurance mix. Once the visuals are created then show a correlation between the length of visits and paid/pending visits and the length of visit vs. insurance mix. Based on the data develop a KPI to use that will show trends in the data.
Before you begin, be sure you review the following resources:
GMSISuccess. (2020, Feb 6). Progression of data, from data to information to knowledge to insight to action. https://gmsisuccess.com/progression-of-data-from-data-to-information-to-knowledge-to-insight-to-action/
For this assignment, prepare a PowerPoint slide presentation that highlights the visuals from the enclosed excel sheet. Data Analytics and Intelligence Tools Unit 1 Assignment Application.csv Download Data Analytics and Intelligence Tools Unit 1 Assignment Application.csv
Prepare a PowerPoint presentation with speaker notes 7-10 slides, not including title and reference slides. This assignment requirement is to build visuals in an excel document that shows the number of pending insurance claims v. paid, percent of visits based on length of the visit, and insurance mix. Once the visuals are created then show a correlation between the length of visits and paid/pending visits and the length of visit v. insurance mix. Based on the data develop a KPI to use that will show trends in the data.
The slide presentation will address the following areas:
Overview of the presentation and data assimilated for visualization.
Graphics and Charts to display the data
Analysis and Synthesis of how the data supports healthcare operations
Development of KPI to identify trends and changes in the process.
Explain what type of indicator is being developed to measure the data.
This case assignment reinforces information in your textbook and the concepts presented in this unit. Your responses should be thorough, well-conceived graduate college-level responses that are grammatically correct. When you answer these questions, you must support your responses and justify your responses with facts and details from the readings and with your opinions, conclusions, and interpretations. Please write in complete sentences.
Requirements:
(7-10) PowerPoint slides plus title slide and (1) reference slide
Include Speaker notes in your slide presentation
Format paper using APA style
Include (3) scholarly references used as in-text citations to support your concepts (these should be under 5 years old)
Week 1 Application Assignment: Financial Data Visualization Utilizing Excel
Week 1 Application Assignment: Financial Data Visualization Utilizing Excel
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeOverview
Overview of the presentation and data assimilated for visualization.
25 pts
Full Marks
0 pts
No Marks
25 pts
This criterion is linked to a Learning OutcomeAnalysis of the Graphs and Charts Utilized to Present Data
Graphics and Charts to display the data
Analysis and Synthesis of how the data supports healthcare operations
25 pts
Full Marks
0 pts
No Marks
25 pts
This criterion is linked to a Learning OutcomeKPI Development
Development of KPI to identify trends and changes in the process.
25 pts
Full Marks
0 pts
No Marks
25 pts
This criterion is linked to a Learning OutcomeExplain Indicators to Measure Data
Explain what type of indicator is being developed to measure the data.
15 pts
Full Marks
0 pts
No Marks
15 pts
This criterion is linked to a Learning OutcomeMechanics
PowerPoint Slide presentation is organized and professional. Slides are free of spelling and grammar errors. Follows APA guidelines set forth in the instructions.
10 pts
Full Marks
0 pts
No Marks
10 pts
Total Points: 100
