Private Health Fund Ancilliary Benefits - March 2023

Overview

Power BI visualuation of the APRA March 2023 Private Health Ancilliary Benefits by :

• Proportion Spend By Category
• Quaterly Benifits Paid
• Forecast of Benifit Payments
• Quaterly Growth Rates
• GAP Shortfall
• Gap By Service Type

Design

• Visuals : Bookmark Navigator, Text Box, Default Slicer, TimeLline Slier, Line Chart, Column Chart, Bar Chart, Pie Chart, Trend Line
• DAX : Semi-addative measures, Year-on-Year Time intelligence
• Tips and Tricks :Conditional Formatting of bar chart colours

References

Dashboard available at : http://bit.ly/37tdts1

APRA statistics avaliable at : https://www.apra.gov.au/quarterly-private-health-insurance-statistics