Page History

The Townhall slides will be uploaded after the event. 

June Townhall Presentation Slides

Monthly Satisfaction Survey Review & Poll

• Go to 1:30 in the recording to review.

SAS Viya Transition Topics Office Hours Information

• SAS Viya Transition Topics Office Hours

  • Topic 1: Introductory to DBX (Workspace, Notebooks, Compute Clusters, Catalog Explorer, Workflows) (Held – 06/05)
  • Topic 2: File Management: Importing files from S3 workbench and Extracting CDR tables (SQL/Python)  (Held – 06/12)
  • Topic 3: Exploring DataFrames vs Database Tables (Held – 06/20)
  • Topic 4: Reporting: Exporting files to S3 workbench and Writing to CDR tables (SQL/Python) (Coming Soon – 06/26)
• SAS Viya Transition Office Hours – Upcoming
  • Repeat of Topic 1: Introductory to DBX (Workspace, Notebooks, Compute Clusters, Catalog Explorer, Workflows) (Coming Soon – 07/03)
  • Topic 5: Working with DataFrames Using Python (Coming Soon – 07/10)
  • Repeat of Topic 2: File Management: Importing files from S3 workbench and Extracting CDR tables (SQL/Python) (Coming Soon – 07/17)
  • Office Hours will resume in August
• SAS Office Hour Material & Resources
  • Office hour material will become available in the CCSQ D&A Portal
    • Topic 1 & 2 materials are now available with Topic 3 coming soon
  • Additionally, regular SAS resources will be published every 2 weeks
    • Former D&A Portal page SAS Viya Transition FAQs page has been removed
      • New page: SAS Viya Transition Resources; easy navigation to categories and office hour material
  • Q&As are divided into categories to make information easier to find
  • Where are Q&As coming from?
    • Help Desk, the #ccsq_data_analytics Slack channel, and SAS Use Case meeting questions are collected & SAS programmers draft answers

Portal Updates & Demo

• CCSQ D&A Portal

  • Recently performed user interviews to hear what enhancements you want to see
    • We want to ensure that the Portal is a valuable tool that you can add to your toolbox
  • Beginning monthly audits to evaluate the following:
    • Identifying out of date content to remove
    • Update existing content with any new information
    • Provide consistent formatting and easy to read KBs
  • New announcements will be available under the Latest News & Event section
    • Announcements will still be sent via email
• CCSQ D&A Portal Updates
  • Updates:
    • Calendar View for Upcoming Events
    • Coming Soon:
      • Past Events page to include Data Camp and Townhall materials currently available in Confluence
      • Data Contributor page
  • Feedback received from user interviews have identified areas of improvement that will be coming soon to the Portal
    • We always welcome feedback, please feel free to provide suggestions in the #ccsq_data_analytics slack channel

Coming Soon: New Datasets in the CDR

• PRS 2.0

  • Program Resource System (PRS) 1.0 will be replaced by version 2.0
    • PRS assists Quality Improvement Organizations (QIOs) and Program Support Contractors in maintaining CMS programs. This is a repository of demographic information for hospital providers in CMS, CASPER, QIES, and PECOS.
  • Timing: this data is planned to be available for use by the end of July
    • Note: PRS 1.0 will be sunset later this year and at that time PRS 2.0 will be considered the single source of data.
• HQR: Exemptions
  • The Waivers module functionality from PRS 1.0 will be re-established in HQR as the Exceptions module.
  • Timing: you will need to switch to using Exemptions in mid-August. We’ll communicate details and an exact date once it’s established.

Databricks Assistant Pilot- Demo

• Databricks Assistant Pilot

  • Databricks Assistant Pilot is now available!
  • Training:
    • Databricks Assistant Pilot Announcement Article
    • Databricks Assistant Training Video
    • Databricks Assistant Training Guide
  • Reminder: Do not include any sensitive data in Databricks Assistant such as PHI/PII, Passwords, etc.

Accessing the CDR with R

• Databricks R Cluster Now Available!

  • Databricks R clusters are now able to query CDR and project data directly from databases.
  • Data Catalog usage with R Notebook: https://da-cdr-prod.cloud.databricks.com/?o=8943086681571732#notebook/3560544239816412/