excerpt-

Include Page

CollaborationCollaborationnopaneltrue

	Data Nav_C
	Data Nav_C

Alert

title	CCSQ D&A

Portal is LIVE!
type	Info

CCSQ Data and Analytics training and resources are now available in the CCSQ D&A Portal. Contents of this Confluence space will be archived in the upcoming weeks.

CCSQ Data & Analytics Townhalls

Purpose: Townhalls are monthly

Excerpt IncludeRequesting & Getting AccessRequesting & Getting Accessnopaneltrue

Panel

borderWidth	0

Livesearch

spaceKey	DATA
placeholder	Search CCSQ Data & Analytics site
type	page

CCSQ Data & Analytics Communications Calls

Purpose: The Communications Calls are bi-weekly

informational calls held by the CCSQ Data & Analytics

Modernization

Team, designed to provide users with system updates, general announcements, and training demos. These calls will continue throughout

2021

2024. All

SAS Viya/CDR

users are welcome to attend and automatically receive the invitation to these calls.

The

Communication Calls

Townhalls are held on a

bi-weekly

monthly basis,

normally occurring every other Thursday beginning

occurring on Wednesdays at 1:00pm ET. Please note that the invitations to these calls are sent the week before the event, to ensure we include all new users on the invitation. Please look at the upcoming calls below and save the date in your calendar.

This page provides an archive of the meeting materials, recording, and Q&A from each

communications call

Townhall.

Panel

titleColor	black
titleBGColor	#359CCA
title	Upcoming Townhall Information

July 24th CCSQ D&A Townhall

Panel

titleColor	black
titleBGColor	#359CCA
title	2024 Townhall Dates

January 24, 2024

February 28, 2024

April 11, 2024

June 26, 2024

July 24, 2024

August 28, 2024

September 18, 2024

October 16, 2024

December 11, 2024

Panel

titleColor	black
titleBGColor	#359CCA
title	Previous Townhall Meetings

Expand

title	2024 Townhalls

01/24/24 -FileCloud Decommission and CCSQ D&A Environment Updates

02/28/24 - SAS Viya Transition Survey Reminders and Access Related Issues

04/11/24 - Portal Announcement and SAS Viya Transition Information

06/26/24 - SAS Viya Transition Office Hours Information and Databricks Assistant Pilot Demo

Expand

title	2023 Townhalls

01/26/23 -Notebook Alternative Updates, New QuickSight Macro, and Final Action Issue Update

03/23/23 -Databricks Update, Portal Introduction, and New Training

04/27/23 -Databricks Kickoff & Features Demo

06/28/23 - Databricks SQL Cluster

07/26/23 - Monthly Satisfaction Results Review and Databricks SQL Updates

08/30/23 - Upcoming Databricks Training and Ambari Decommission

09/27/23 - Ambari Decommission and Future Improvement Efforts

12/13/23 - Ambari Decommission and D&A Portal

Expand

title	2022 Townhalls

01/27/22 - MDM Data Changes & New User Collaboration Enhancements

02/10/22 - CCSQ Support Central Demo

02/24/22 - User Collaboration Wiki & Best Practice Review

03/10/22 - Subset Queries, Interactive Best Practices, Syntax Errors, and Restarting SAS Sessions

03/24/22 - Hive Tables Best Practices and Restoration Processes

04/07/22 - GitHub Overview

04/21/22 - The Role of HCD in the CAP/CDR Environment and End User Experience

05/05/22 - Confluence Usability Study - Results and Next Steps

05/19/22 - QuickSight Overview

06/23/22 - Best Practices Review and Notebook Alternative Pilot

09/01/22 - Persistent Storage Migration, Notebook Alternative, and QuickSight Updates

09/15/22 - Data Camp, Claims Data Issue, CSAT

10/27/22 - Data Camp Agenda, CSAT Updates, Persistent Storage Updates

HTML
<style>#title-text { display:none !important; } .aui-navgroup-primary { font-size: 1.25em; font-weight: bold; } .page-metadata-modification-info { display:none !important; } </style>

Info
Please note that the Communications Calls will continue shortly in early 2022.

Horizontal Navigation Bar

id	Communications Calls

Horizontal Navigation Bar Page

title	Search by Topic

Column

width	48%

General Topics

Expand

title	Claims Data

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "claims_data_part_a_b_d_data"

Expand

title	CSAT Overview

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "csat_overview"

Expand

title	Drug Data

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "drug_data"

Expand

title	DUA Mapping

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "dua_mapping"

Expand

title	MDM Data

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "mdm_pmi_sipp"

Expand

title	Part A, B, & D Data Sources

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "claims_data_part_a_b_d_data"

Expand

title	Partition Pruning

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "partition_pruning"

Expand

title	QMARS Data

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "qmars_ng_overview"

Expand

title	SAS Viya Visual Analytics Series

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "sas_viya_visual_analytics_series"

Expand

title	Special Speakers

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "damod_special_speakers"

Expand

title	SQL Demos

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "sql_info"

Expand

title	System Usage Notifications

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "system_usage_notifications"

Expand

title	Zeppelin

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "zeppelin"

Column

width	10%

Column

width	48%

Macro Demos

Expand

title	Batch Processing Logging Macros

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "batch_processing_macros"

Expand

title	Email Notification Macros

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "email_notification_macros"

Expand

title	Gzip & Gunzip Macros

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "gzip_gunzip_compression_macros"

Expand

title	Help and Support Macros

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "help_and_support_macros"

Expand

title	Hive Exec SQL Macro

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "hive_exec_sql_macro"

Expand

title	Hive Explain Macro

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "execution_plans"

Expand

title	List Macros

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "list_macros"

Expand

title	Log Level Macro

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "logging_macro"

Expand

title	Process Management Macros

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "process_management_macro"

Expand

title	Queue Status Macro

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "queue_status_macro"

Expand

title	Search CDR Macro

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "search_cdr_macro"

Expand

title	Show Rowcount Macro

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "show_rowcount_macro"

Expand

title	Usage Hive Macro

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "usage_hive_macro"

Expand

title	Usage Workbench Macro

Content by Label

showLabels	false
showSpace	false
sort	creation
reverse	true
cql	label = "usage_workbench_macro"

Horizontal Navigation Bar Page

title	Search by Date

Tabs Container

direction	vertical

Tabs Page

title	2022

01/27/22 - MDM Data Changes & New User Collaboration Enhancements

02/10/22

02/24/22

03/10/22

03/24/22

04/07/22

04/21/22

05/05/22

05/19/22

06/09/22

09/01/22

09/15/22

09/29/22

10/13/21

10/27/22

11/10/21

Tabs Page

title	2021

01/21/21 – Best Practices Review with Hive

02/04/21 – Comprehensive Training Plan & New Macros

02/18/21 – Best Practices and New Macros

03/04/21 – S AS Viya & CDR Architecture Best Practices

03/18/21 – BIC Data - DVA's Perspective

04/01/21 – Best Practices and New Macros

04/15/21 – Best Practices and New Macros

04/29/21 – New QualityNet Analytics Tool Zeppelin

05/13/21 – Underutilized Important Macros

06/10/21 – Zeppelin Environment Demo - Part One

06/24/21 – Claims Data Review & Demonstration

07/08/21 – Hive Best Practices

07/22/21 – Zeppelin Python Interpreter Demo

09/16/21 – MDM PMI/SPP & NPI Profile Overview

09/30/21 – 2021 Data Camp Prep Best Practices Review

10/14/21 – QMARS NG Overview

11/18/21 – HDFS Incident Recovery Summary and New Slack Channel

Tabs Page

title	2020

01/09/20 – Accessing SAS Viya and Connecting to Datasets

01/23/20 – Data Roadmap and SAS Viya Demo

01/30/20 – SAS Viya Query Builder Demo

02/06/20 – SAS Viya Scheduling Jobs & Finding, Uploading, and Saving Data in 5.2

02/20/20 – Answering Your Questions

03/05/20 – How to Use Claims Data by Using a Claims Extract and Visual Analytics

03/17/20 – Replacements of Proc Sort and Best Practices

04/02/20 – Best Practices for Using the System

04/16/20 – Best Practices Review & Hive Preview

04/30/20 – SAS 9.4 vs. Viya (CAS)

05/14/20 – Global Macros and Efficient Use of Claims Data

05/28/20 – Best Practices for Using the System

06/18/20 – Viya Best Practices and Tips

07/02/20 – Changes to Claims Data Part A, B, & D

07/16/20 – CSAT Overview

07/30/20 – Best Practices Review

08/13/20 – Overview of BIC Data

08/27/20 – Best Practices Review

09/10/20 – QIES HelpDesk and Best Practices Review

09/24/20 – HCQAR R&A Transition Experience

10/08/20 – Recommended SAS E-Learning and Best Practices

10/22/20 – SAS Visual Analytics Series Part One & Troubleshooting SAS Viya

11/05/20 – HQR Interim Data Access & SAS Visual Analytics Series Part Two

11/19/20 – DUA Mapping

12/03/20 – SAS Visual Analytics Series Part Three

12/17/20 – SAS Visual Analytics Series Part Four

Tabs Page

title	2019

11/07/19 – Centralized Data Repository & Transitioning to SAS Viya

11/20/19 – SAS Viya Go-Live

12/05/19 – SAS Viya Demonstration

12/12/19 – SAS Viya Visual Analytics

12/19/19 – SAS Viya Tips & Confluence Walkthrough

Tabs Page

title	Archive

Expand

title	10/03/19 - Life of a Claim

Topic: Life of a Claim

Date & Time: Thursday, October 3, 2019, 1-2pm

Presenters: Todd Schaefer and Kathleen Berg

Location: CMS C-115

Materials: To retrieve a copy of the meeting materials, contact us.

Expand

title	09/05/19 - Robotic Process Automation & CCSQ Claims Data Requirements Gathering

Topic: Robotic Process Automation & CCSQ Claims Data Requirements Gathering

Date & Time: Thursday, September 5, 2019, 1-2pm

Presenters: CMS & Guidehouse LLC

Location: CMS S2-20-01

Materials: To retrieve a copy of the meeting materials, contact us.

Expand

title	08/06/19 - CCSQ Quality Data - What It Is

Topic: CCSQ Quality Data - What It Is

Date & Time: Tuesday, August 6, 2019, 1-2pm

Presenters: Indre Goble, ISG & Ryan Webb, Index Analytics

Location: CMS C-111

Materials: To retrieve a copy of the meeting materials, contact us.

Expand

title	07/02/19 - CCSQ Data & Analytics Modernization Efforts

Topic: HCQIS Data & Analytics Modernization Efforts

Date & Time: Tuesday, July 2, 2019, 1-2pm

Presenters: Indre Goble, ISG

Location: CMS C-111

Materials: To retrieve a copy of the meeting materials, contact us.

Expand

title	06/04/19 - Welcome & Introduction to the COP

Topic: Welcome & Introduction to the COP

Date & Time: Tuesday, June 4, 2019, 1-2pm

Presenters: ISG, Cupic Chan, Tom Wolfe

Location: CMS C-111

Materials: To retrieve a copy of the meeting materials, contact us.

Excerpt IncludeCCSQ Data & AnalyticsCCSQ Data & Analyticsnopaneltrue Panel

borderColor	#349BC8
borderWidth	1
titleBGColor	#349BC8
borderStyle	solid
title	Submit a Topic

Please take a few minutes to share your topic suggestions for a future CCSQ Data & Analytics Communications Call.

Button HyperlinktitleSubmit Topictypestandardurlhttps://www.surveymonkey.com/r/LPSXBLTtargettrue

Versions Compared

Old Version 135

New Version Current

Key

CCSQ Data & Analytics Townhalls

CCSQ Data & Analytics Communications Calls

General Topics

Macro Demos

Page History

Versions Compared

Old Version 135

New Version Current

Key

CCSQ Data & Analytics Townhalls

CCSQ Data & Analytics Communications Calls

General Topics

Macro Demos