Integrated Data Repository (IDR) Training

• IDR Overview & Data Analytics (Live Webinar)
• SAS EBI Business Analyst (Live Webinar)
• IDR T-MSIS / Medicaid Virtual Data Mart Training
• SAS EBI Town Hall
• IDR-BI User Group
• Snowflake

IDR Overview & Data Analytics (IODA) (Live Webinar)

This lecture-style class is a combination of Medicare business training and an introduction to the Integrated Data Repository, known as the IDR. ​It provides an overview of the Medicare data in the IDR, including these topics:

• What is the IDR? What is its mission & history?
• Available data and how to access/use it
• FFS Medicare vs Medicaid vs Medicare Advantage
• Journey of a claim from time of service to arrival in IDR
• Claims (Type codes, families, joining tables, partitioning)
• As-Is / As-Was
• Transaction tracking
• Real life application for business use cases
• Tools and resources available

Duration: 12 hours of training spread over 4 days.

Access Note: We recommend that you obtain access to Confluence via the ENT_AGILE_TOOLS job code.

SAS EBI for Business Analysts (Live Webinar)

Introduction to how the SAS Enterprise Business Intelligence (EBI) system works in conjunction with the Integrated Data Repository (IDRC - Snowflake) at CMS, including these topics.

• Introduction to SAS client and web apps
• Setup accounts and SAS/Snowflake connections
• Enterprise Guide basics
• Querying IDRC data from SAS
• Best practices
• Self-service utilities
• Overview of SAS Studio and the SAS Add-in for Microsoft Office
• SAS stored processes

Duration: 12 hours of training spread over 4 days

Access Note: We recommend that you obtain access to Confluence via the ENT_AGILE_TOOLS job code.

IDR T-MSIS / Medicaid Virtual Data Mart Training

An introduction to the Medicaid Virtual Data Mart in the Integrated Data Repository including these topics:

• Available T-MSIS data and how to access/use it
• EUA Access and Data Use Agreement (DUA)
• Medicaid Virtual Data Mart (MDCD VDM)
• T-MSIS data vs Medicare claims data
• IDR Medicaid Virtual Data Model
• Query best practices
• Real life application for business use cases
• Tools and resources available

Duration: One 3-hour session

Access Note: We recommend that you obtain access to Confluence via the ENT_AGILE_TOOLS job code.

SAS EBI Town Hall

The SAS EBI Town Hall is a bi-monthly, unscripted, open-forum, Q&A session where all SAS-related questions are welcome. Previous questions have included (but aren't limited to):

• How to import and export data?
• What are the best practices for querying the IDR from SAS?
• How to cancel a query?
• What is the relationship between Enterprise Guide and SAS Studio?

IDR-BI User Group

The IDR-BI User Group, commonly referred to as the “IBUG,” is a monthly gathering of the CMS IDR team and the end-users of the IDR data and Business Intelligence tools. Foundational goals of the IBUG are to:

• Provide a forum for IDR and BI users to share analytical ideas with each other
• Bring the IDR and BI application maintainers closer to their end-user community to share information and to better understand user needs

Past topics covered in the IBUG have included:

• IDR Encounter Data
• Finder File Process
• ICD-10 Data
• SAS Views
• T-MSIS Data
• Life of Part A and Part B Medicare Claims

Snowflake 1-Day Training

For current users of the Integrated Data Repository (IDR), this custom training will provide an overview to Snowflake features, functionality, and how to access it from the Snowflake UIs using the Snowflake Web Interface Snowsight (demonstrating similar use cases for those using Teradata SQL Assistant/Studio today to access Teradata).

• Overview and Architecture
• Snowflake Object Model
• Snowsight
• Client Interfaces
• SQL Support in Snowflake
• Visualizing Query Execution with Query Profile
• Visualizing Data With BI Tools
• Data Visualization Best Practices
• Time Travel and Zero-Copy Cloning
• Working with Complex Queries
• Data Sharing

Duration: 8 hours

Access Note: We recommend that you obtain access to Confluence via the ENT_AGILE_TOOLS job code.

 

To request additional information on any of the IDR trainings listed above, please visit the following Confluence Link here.