based off the spreadsheet given to us please answer step by step and meet all the requirements such as the PDF to make a DETAILED AND THROUGH DASHBOARD SO THAT WE CAN PRESENT TO STAKEHOLDERS. What are the demographics of patients?
• What are the Hospital patterns of patients and total charges and how do they compare to previous years? • What is the diagnostics category/groups of patients and what are the total charges of diagnostics?
• Which Ethnicity has the most diagnostics? • Which Age group has the highest hospitalization? THE DASHBOARD MUST SEE:[below are the ‘must see’ features your report should have]
[order_button_a]
• Interactivity – your dashboard views should interact with one another.
• Parameters: use at least 1 parameter in your view.
• Calculated fields: use at least 3 calculated fields in your view. • Use at least 2 sets and 1 combined set in your view. • Use at least 1 context filter, 2 dimension filters, 2 measure filters. • Use at least one image on your dashboard. • Use at least 1 navigation button on your dashboard. • Add refresh date to your dashboard.