CCSQ Data & Analytics Data Camp

The CCSQ Data & Analytics Data Camps are multi-session, multi-day events focused on educating the CCSQ Data & Analytics user community. During these special events, technical experts and special guests present during multiple one-hour sessions, each ending with a question and answer session. These events will be following an Open House format, allowing users to be able to jump in and out of the event to attend certain sessions. The Data Camps are an opportunity for the user community to come and learn more about SAS Viya, CDR, and the future of CAP. 

Please explore this page through the tabs above to discover more information and details about past and upcoming Data Camp events.

November 17th 

12:30- 1:00pm EST  |  Welcome from CMS Leadership (iQIES/QBIC SAS Viya users welcome)

Presenter: Mr. Brent Weaver and Mr. Ken Howard

Presentation: Are you wondering about the SAS Viya environment and how all of the components interact? During this session, we will provide an overview of the technical details of SAS Viya, Hive, and AWS and how they work together. 

Presentation Recording: Click here to listen to the recording. Password: ZG@56s@T

Meeting Materials: November 2020 Data Camp Introduction

1:00 - 1:55pm EST  |  CCSQ Data & Analytics Environment Overview (iQIES/QBIC SAS Viya users welcome)

Presenter: Pete Grivas

Presentation: Are you wondering about the SAS Viya environment and how all of the components interact? During this session, we will provide an overview of the technical details of SAS Viya, Hive, and AWS and how they work together. 

Presentation Recording: Click here to listen to the recording. Password: ZG@56s@T

Meeting Materials: CCSQ Data & Analytics Environment Overview PowerPoint

2:00 - 2:55pm EST   |  CDR Data Overview 

Presenters: Curtis Smith and Manpreet Khural

Presentation: This session will cover the relationships between the key data sources in the CDR. We will discuss how data works in the CDR, touch on claims, provider, and beneficiary data, and how these sources relate to other CCSQ data sources like iQIES, HQR, and EQRS. 

Presentation Recording: Click here to listen to the recording. Password: ZG@56s@T

Meeting Materials: CDR Data Overview PowerPoint

3:00 - 3:55pm EST  |  Visual Analytics Overview  (iQIES/QBIC SAS Viya users welcome)

Presenters: Mr. Lee Herman

Presentation: SAS Visual Analytics provides a complete platform for analytics visualization. Interactive, self-service BI and reporting capabilities are combined with out-of-the-box advanced analytics so everyone can discover insights from any size and type of data, including text.

Presentation Recording: Click here to listen to the recording. Password: ZG@56s@T

Meeting Materials: Visual Analytics Overview PowerPoint

4:00 - 4:55 |  Hive SQL In-Depth

Presenters: Mr. Pete Grivas

Presentation: Take a deeper dive into execution plans, how Hive works behind the scenes with partitions, and why explicit SQL is recommended over implicit SQL.

Presentation Recording: Click here to listen to the recording. Password: ZG@56s@T

Meeting Materials: Hive_SQL In-Depth PowerPoint

November 18th 

12:00- 1:00pm EST  |  Special One-Hour Q&A (iQIES/QBIC SAS Viya users welcome)

Panelists: Mr. Brent Weaver, Mr. Ken Howard, and Ms. Indre Goble

Presentation: Do you have questions related to the modernization efforts at ISG? Attend this open forum to have your questions answered!  

Presentation Recording: Click here to listen to the recording. Password: nJk4u#cg

1:00 - 1:55pm EST  |  SAS Troubleshooting Tips & Tricks

Presenter: Mr. Brendon Salatino

Presentation: Learn how to troubleshoot common issues in SAS Viya. SAS logging options and importing data will be covered as well as how to break your code into manageable components for testing.

Presentation Recording: Click here to listen to the recording. Password: nJk4u#cg

Meeting Materials: Troubleshooting in SAS PowerPoint

2:00 - 2:55pm EST   |  SQL Optimization Techniques

Presenters: Mr. Pete Grivas

Presentation: During this presentation, we’ll cover user-submitted code before and after optimization, and the approach we took to improving its performance; all with the goal of sharing how other users of CDR can do the same.

Presentation Recording: Click here to listen to the recording. Password: nJk4u#cg

Meeting Materials: SQL Optimization Techniques PowerPoint

3:00 - 3:55pm EST  |  Hive & CAS Working Together

Presenters: Mr. Chris Coley

Presentation: CAS provides an in-memory solution to running SAS Programs while Hive provides a distributed approach to accessing large quantities of data. This session will cover the best way to integrate Hive and CAS, using each in a way that plays to their respective strengths.

Presentation Recording: Click here to listen to the recording. Password: nJk4u#cg

Meeting Materials: Hive and CAS Working Together PowerPoint

4:00 - 4:55pm EST |  The Future of CAP

Presenters: Pete Grivas

Presentation: The CAP architecture is designed to abstract compute services from data. This extensible architecture allows multiple tools to access the data and allows end users to leverage the tools they are most comfortable with to perform their analyses. We will cover the future of CAP with a focus on future data science tools.

Presentation Recording: Click here to listen to the recording. Password: nJk4u#cg

Meeting Materials: Future of CAP PowerPoint