1 / 13

IPPS INPATIENT CHARGES VISUALIZATION

IPPS INPATIENT CHARGES VISUALIZATION. PRESENTED BY -PETER CHOU, TIM KANG, RYAN ZHU, SHWETA SHWETA. Agenda. DataSet Used What is the DataSet about? Purpose of the Application Who will use it and what are their goals Design Patterns and Graphs Used Tools Used Demo. DATASET USED.

palos
Download Presentation

IPPS INPATIENT CHARGES VISUALIZATION

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. IPPS INPATIENT CHARGES VISUALIZATION PRESENTED BY -PETER CHOU, TIM KANG, RYAN ZHU, SHWETA SHWETA

  2. Agenda DataSet Used What is the DataSet about? Purpose of the Application Who will use it and what are their goals Design Patterns and Graphs Used Tools Used Demo

  3. DATASET USED • DATASET NAME - INPATIENT PROSPECTIVE PAYMENT SYSTEM (IPPS) PROVIDER SUMMARY FOR THE TOP 100 DIAGNOSIS RELATED GROUPS(DRG)-FY2011 • DATA PROVIDER - DATA.CMS.GOV • LINK - HTTPS://DATA.CMS.GOV/MEDICARE/INPATIENT-PROSPECTIVE-PAYMENT-SYSTEM-IPPS-PROVIDER/97K6-ZZX3

  4. WHAT IS THE DATASET ABOUT? • COVERS TOP 100 FREQUENTLY BILLED PROCEDURE BY MORE THAN 3,000 U.S. HOSPITALS • HOSPITALS RECEIVE MEDICARE INPATIENT PROSPECTIVE PAYMENT SYSTEM (IPPS) PAYMENTS FOR THE DRUGS • PAYMENT IS DONE BY MEDICARE BASED ON A RATE PER DISCHARGE FOR FISCAL YEAR (FY) 2011. • THESE DRGS REPRESENT MORE THAN 7 MILLION DISCHARGES OR 60 PERCENT OF TOTAL MEDICARE IPPS DISCHARGES.

  5. ATTRIBUTES • DRG DEFINITION • PROVIDER ID • PROVIDER NAME • PROVIDER STREET ADDRESS • PROVIDER CITY • PROVIDER STATE • PROVIDER ZIP CODE • HOSPITAL REFERRAL REGION DESCRIPTION • TOTAL DISCHARGES • AVERAGE COVERED CHARGES • AVERAGE TOTAL PAYMENTS • AVERAGE MEDICARE PAYMENTS

  6. SAMPLE DATASET

  7. PURPOSE OF APPLICATION • ACT AS A MEDICAL CONSULTANT • PROVIDE ANSWER TO A USER QUESTIONS LIKE • WHAT’S THE AVERAGE COST FOR A CERTAIN DISEASE NATIONWIDE? • WHAT’S THE AVERAGE COST FOR A CERTAIN DISEASE IN MY STATE? • WHAT’S THE AVERAGE COST FOR A CERTAIN DISEASE IN MY CITY? • WHAT’S THE AVERAGE COST FOR A CERTAIN DISEASE FOR A SPECIFIC HOSPITAL? • THE NUMBER OF PATIENTS THAT WERE DISCHARGED PER HOSPITAL

  8. PURPOSE OF THE APPLICATION CONT.. • FOR A CERTAIN DISEASE, HOW THE CHARGES VARY AMONG HOSPITALS, CITIES, STATES? • WHAT ARE THE MOST/LEASE PREVALENT DISEASES? • WHAT ARE THE MOST/LEASE COSTLY DISEASES?

  9. WHO WILL USE IT AND WHAT ARE THEIR GOALS? • USERS WHO ARE FAMILIAR WITH THE DATASET • USERS WHO KNOW ABOUT THE DISEASE THEY HAVE AND WOULD LIKE FURTHER INFORMATION ABOUT THE DISEASE. • THEY HAVE A CLEAR GOAL IN MIND FOR EXAMPLE – FOR SO AND SO DISEASE WHAT IS THE MOST EXPENSIVE HOSPITAL IN MY STATE. • USERS WHO WANT TO COMPARE VARIOUS ATTRIBUTES OF THE DATASET. • USERS WHO POSSESS KNOWLEDGE ABOUT VARIOUS STATES IN UNITED STATES AND KNOWS THE ACRONYMS USED TO REPRESENT THEM, FOR EXAMPLE CA REPRESENTS CALIFORNIA; OR HAS INTERNET AVAILABLE TO SEARCH FOR THEM.

  10. DESIGN PATTERNS, GRAPHS USED AND WHY DYNAMIC QUERIES - HELPS IN FILTERING OUT UNNECESSARY DETAILS IN THE GRAPH DATA TIPS - POPS OUT INFORMATION ON MOUSE OVER MULTI-Y GRAPHS - HELPS IN LETTING THE USERS KNOW THAT THE GRAPHS ARE RELATED. ENCOURAGES COMPARISONS AMONG THE GRAPHS. BOX PLOT - HELPS IN VISUALIZING SUMMARY OF THE DATA BAR CHART -  SHOW COMPARISONS AMONG CATEGORIES DASHBOARDS - USER CAN LOOK AT THE MONITOR AND ANALYZE THE INFORMATION PRESENTED IN DASHBOARD AT A GLANCE WORD CLOUDS -THEY ARE A FUN WAY TO SHOW WORDS, WHERE THE MOST IMPORTANT ONES ARE BIGGER THAN THE OTHERS.

  11. TOOLS USED • BOOTSTRAP LOADER - IT AUTOMATICALLY ADJUSTS THE WEBSITE ACCORDING TO MONITOR SIZE. • JAVASCRIPT, CSS • R PROGRAMMING LANGUAGE - FOR CREATING BOXPLOTS USING SHINY PACKAGE • TABLEAU - FOR ANALYZING AND CREATING DASHBOARDS. • HEROKU - FOR HOSTING APPLICATION ONLINE

  12. ADDITIONAL THINGS IN WEBSITE EXCEPT VISUALIZATION • HELP TABS EXPLAINING GRAPHS AND DATA • FORM, SO THAT USER CAN SUBMIT A QUESTION REGARDING THE DATA OR ANY OTHER TOPIC • CAROUSELS AND THUMBNAILS

  13. QUESTIONS??

More Related