lbadmin

About lbadmin

This author has not yet filled in any details.
So far lbadmin has created 5 blog entries.

Hospital Compare

Hospital Compare has information about the quality of care over 4500Medicare- certified hospitals across the country. We have used this information to do the analysis that which hospitals are good for particular condition. Either way the information is useful for the hospital to make a sound decision for quality of the care they provide. When you have a life-threatening emergency, always go to the nearest hospital. However, if you’re planning to have surgery, or if you have a condition like heart disease and know you may need hospital care in the future. Research shows that some hospitals do a better job taking care of patients with certain conditions than other hospitals.

For the interaction with this tableau report, please go to:

https://public.tableau.com/views/HOSPITALDATAforSLstage2scales/TopMeasureID?:embed=y&:display_count=yes&:showTabs=y

[wptabs mode=”horizontal”] [wptabtitle] Challenges[/wptabtitle] [wptabcontent]

 

  • The difficulty lies in aligning all the measure of different categories and units and produce a universal total score which can meaningfully represent the performance of a […]
2019-01-19T13:34:48+00:00Uncategorized|

Facility Compare Dashboard

Facility Compare Dashboard provides Snapshot of Five Star Rating for dialysis facility Clinics.

  • Design the complete data visualization which combine the inverse normal distribution calculation and rank average into a custom geocoding dashboard. It need to be user friendly.
  • Related ratio of error-prone approach with key calculation facts by using dashboard action filters.
  • We had developed a parameter filter combine with calculations field in tableau to show the accuracy of the calculation against each key facts.
  • Designed a KPI score chart to show the comparison between automated process and manual process along with time frame.
  • Enabled end user to see significant improvement on business visibility using the dynamic interactive actions in the dashboards.
  • VizQL
  • PL/SQL
  • Java Script
  • CSV/MS Excel[/wptabcontent][/wptabs]
2019-01-20T14:12:03+00:00Projects|

CrownWeb Dashboard

CROWN Web is a Web-based data collection system that allows authorized users to securely submit patient-based data to CMS’s CROWN application via electronic data interchange. CROWN Web is an abbreviation of Consolidated Renal Operations in a Web-Enabled Network. Need to represent the relationship between key factors (e.g. XSD validation, CMS accepted ratio, CMS rejected ration, resubmission rejected rate etc).

They expect us to design simple solution for end user so they can understand the relationship with a single click on key factors. We have created a dashboard using Tableau with three highlighted cross tab tables. Those tables are within the hierarchical relationship for drawing down analysis so the end user can check exact reason of rejection by clicking on each highlighted fact numbers. We have created incremental updating dashboard with a various filters and calculations to end users in order to help them to improve the process performance.

2019-01-20T14:17:33+00:00Projects|

Dialysis Facility Compare Data Store

Facility Compare data store that provides one to five-star rating based on information about the quality of care and services that a dialysis facility provides. It will store data published on government website, and other in-house data stores, and perform calculations to derive performance measures and final FIVE STAR to identify the performance of business and other third-party facilities.

  • Complex statistics calculations being used in conjunctions, e.g. inverse normal distribution, rank average, distance calculation based on longitude and latitude etc.
  • Error-prone approach in the data collection from government as well as data processing.
  • Implemented tiered calculations using Informatica and PL/SQL to accurately calculate all measures and produce the result as expected.
  • Centralized design and automated process to reduce manual effort as well as maintain all history data.

All measures are timely and accurately calculated, resulting in significant improve on business visibility of facility performance.

  • Informatica
  • PL/SQL
  • Tableau

[…]

2019-01-20T14:21:08+00:00Projects|

CROWN Web Data Store

CROWN Web is a Web-based data collection system that allows authorized users to securely submit patient-based data to CMS’s CROWN application via electronic data interchange. CROWN Web is an abbreviation of Consolidated Renal Operations in a Web-Enabled Network. The CROWN WEB DATA STORE (CWDS) is a database repository that will store data from 5 xml feeds which client sends to CMS (Government) on a scheduled basis. CWDS stores the data from KC which is the actual source of the xml feeds. Feeds include Patient, Clinical, New Patient ESRD 2728, Date of Death ESRD 2746 and Attestation. CMS (Government) submissions vs CMS (Government) Feedback matching is highly impossible due to CMS do not send the whole key data along with their Accept/Reject comments.

  • To structure the Feedback comments/Errors, Identify the Errors causing by Facility to take appropriate action to reduce the %age of CMS Rejections to ZERO.[/wptabcontent]

Provided a Data Store […]

2019-01-20T14:14:50+00:00Projects|