1 / 120

Developing a Practice Dashboard MGMA Anesthesia Administration Assembly May 2008 Joe Laden

Developing a Practice Dashboard MGMA Anesthesia Administration Assembly May 2008 Joe Laden MGMA member since 1981 AAA Member since inception Business Manager Anesthesia Associates of Louisville, PSC joeladen@aalouisville.com. What is a Dashboard?. Merriam-Webster Dashboard

gin
Download Presentation

Developing a Practice Dashboard MGMA Anesthesia Administration Assembly May 2008 Joe Laden

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Developing a Practice Dashboard MGMA Anesthesia Administration Assembly May 2008 Joe Laden MGMA member since 1981 AAA Member since inception Business Manager Anesthesia Associates of Louisville, PSC joeladen@aalouisville.com

  2. What is a Dashboard?

  3. Merriam-Webster • Dashboard • a screen on the front of a usually horse-drawn vehicle to intercept water, mud, or snow • a panel extending across the interior of a vehicle (as an automobile) below the windshield and usually containing instruments (as a speedometer) and controls

  4. What is a Business Intelligence Dashboard? aka Digital Dashboard Electronic Dashboard Information Dashboard Scorecard

  5. The Ultimate Anesthesia Dashboard

  6. What is a not a dashboard, But might look like a dashboard?

  7. Click above to activate calculator, click here to go to next slide

  8. Click above to activate calculator, click here to go to next slide

  9. Click above to activate calculator, click here to go to next slide

  10. Click above to activate calculator, click here to go to next slide

  11. Dashboard definition and characteristics of good dashboard design. Stephen Few . . . .

  12. “Visual display Of the most important information needed to achieve one or more objectives Which Fits entirely on a single computer screen So it can be Monitored at a glance” Stephen Few www.perceptualedge.com

  13. Visual Display • Text • Units 12,000 12,300 11,700 13,024 12,670 • Hours 1,200 1,230 1,195 1,200 1,140 • Graphics

  14. Achieve Objectives • Monitor Anesthesiologist/ACT Work Output: • Units • Minutes • Cases • Monitor Reimbursement for Work Performed • Monitor Collection Efficiency • Monitor Hospital Efficiency (O.R. Utilization) • Make decisions about staffing • Determine need for hospital subsidies

  15. Monitor Single Screen at A Glance • Static • Text • Graphics • Mixed • Dynamic • Selectors • Drilldown • Portal to Reporting System • May be OK to have multiple screens/pages

  16. Mini G/L

  17. Additional Characteristics of Good Dashboards Small, clear, concise and intuitive display mechanisms Customized to each person, group or function Replace hunt and peck data gathering from many reports Fine tuned to deliver insight in a powerful way

  18. Problems with “Dashboard” Model for Business Intelligence • Vehicle dashboard is real time • Provides no trending & historical data • Provides no comparisons • Monitors relatively few indicators

  19. Audience for Your Practice Dashboard • Board of Directors • Shareholders • Practice Manager • Billing Manager • Dashboard contents should be targeted to its readers

  20. Where are anesthesia dashboards available today? • Anesthesia Billing Software Vendors • Anesthesia Billing Companies • Anesthesia Practice Management Companies • Report Hosting Companies • DIY for Small – Medium Size Groups

  21. Tools to Produce You Own Dashboard • Excel / Word Text Dashboard Cheap and Easy • Excel Charts (graphs) • Cheap, but more difficult • Excel Pivot Tables • Powerful but need transaction data • Xcelsius/Engage • Expensive & Complicated • but more powerful • Custom Programming • IT expertise and expense, specialized software

  22. Steps to Prepare You Dashboard • Determine Your Audience • Review Current One Page Reports • Decide Which Key Performance Indicators to Display • Determine How to Gather Data • Decide on Dashboard Construction Tool

  23. KPI • Anesthesia Key Performance Indicator Categories • Anesthesiologist/ACT Production • Billing & Collection • Practice Operations • ExpensesPersonnel

  24. Anesthesiologist/ACT Production KPI • Cases • Units • Base • Time • Flat Fee Procedures • Minutes/Hours • Gross Billing

  25. Billing & Collection KPI • Payments • Gross and Net Collection Ratio • A/R Aging • Days in A/R

  26. Practice Operations KPI • Personnel & Cost • MD • CRNA • Overhead • Corporate • Billing Costs

  27. KPI Coupled with Timing Per Month Day Year Quarter Week

  28. KPI Coupled with Comparative Timing • Year vs year • Year to Date vs. Last Year to date • Quarter vs Same Quarter last year • Trailing 12 months vs. Trailing 12 months prior year

  29. KPI vs. Comparative Benchmarks • Facility vs. Facility • MD vs. MD • Payer vs. Payer • MGMA Physician Compensation and Production Survey • MGMA Single Specialty Practice Cost Survey

  30. KPI Top and Bottom • Top 10 and Bottom 10: • Surgeons (collected per hour) • Anesthesiologists (units per year) • CRNA’s (hours billed/ hours paid) • Payers (collected per unit) • ASA Codes (units per case)

More Related