1 / 32

ProClarity: Practical Applications

ProClarity: Practical Applications. Thomas R. Emmendorfer, PharmD Assistant Chief Consultant Pharmacy Benefits Management (PBM) Services. Learning Objectives. At the end of the presentation, the participant will understand: T he principles of how data cubes are organized

eamon
Download Presentation

ProClarity: Practical Applications

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. ProClarity: Practical Applications Thomas R. Emmendorfer, PharmD Assistant Chief Consultant Pharmacy Benefits Management (PBM) Services

  2. Learning Objectives • At the end of the presentation, the participant will understand: • The principles of how data cubes are organized • The principles of conducting analyses of data cubes using ProClarity • How to setup a ProClarity Briefing Book • How to export results of analyses to PowerPoint and Excel • How to establish a connection to the data cube using Excel

  3. Overview • Data Cube • Collection of data that is organized for rapid query response and designed for analysis • Derived from relational tables or a data warehouse • Online Analytic Processing (OLAP) Client • Application that enables browsing and analysis of data cubes (e.g. ProClarity®)

  4. Example of Relational Tables VA National Patient Care Databases VA National Health Surveys Mortality Data Pharmacy Databases DEpiC Diabetes Epidemiology Cohort Potential Data VA Rehab VA Dz Registries CMS Medicare

  5. PBM Services ProClarity® Cubes • IV • Unit Dose • Outpatient

  6. Measures = numeric Dimensions = descriptive categories

  7. Example of Dimension Hierarchy

  8. Measures: Outpatient Prescriptions

  9. Briefing Books • “Pages” or individual reports saved in one main “Book” or file • Interactive and updates automatically • View and modify pages within book

  10. PBM ProClarity® Access • VISN Formulary Leader Approval • VISN and National access • Requests sent to Alan.Celestino@va.gov • Signed Data Use Agreement must be scanned and emailed back and/or mailed back

  11. Question 1: What were the top 10 drugs at the generic level for VISN 24 by cost in FY2008?

  12. Review • Dimension – Select specific level • Filter • Rows vs. Columns

  13. Question 2: How many unique patients were dispensed VENLAFAXINE in VISN 24 by QTR (FY08 – FY09)?

  14. Review • Dimension • Select specific level (Time) • “Search” feature (Drug) • Rows vs. Columns • Graphical display selection

  15. Question 3: How many unique patients were dispensed VENLAFAXINE in VISN 24 facilities by QTR (FY08 – FY09)?

  16. Review • Dimension • Select specific level (Time, VISN) • “Search” feature (Drug) • Rows vs. Columns • Graphical display selection

  17. Question 4: How many unique patients were dispensed VENLAFAXINE IR and SA in VISN 24 Station 100 by QTR (FY06 – FY07)?

  18. Review • Dimension • Select specific level (Time) • “Search” feature (Drug) • Create “Member” (Drug) • Rows vs. Columns • Graphical display selection

  19. Question 5: How many unique patients were dispensed VENLAFAXINE IR and SA by VISN 24 facilities (FY06 – FY07)? (Only Display ONE facility at a time)

  20. Copy Results of Question 5 Excel PowerPoint

  21. How to Connect the Cube to An Excel Workbook

  22. ProClarity® Conclusions • Provides a graphical user interface • Create and save customized “Briefing Books” • Trend internal and external prescribing trends to a VA facility/VISN

  23. Questions?

More Related