Managing Your Revenue Cycle Using Microsoft Excel Pivot Tables Webinar Series

SCHIMA/SCMGMA/GHIMA
Webinar Series:
Managing Your Revenue Cycle Using
Microsoft Excel Pivot Tables

Please join us for this webinar series to develop your MS Excel skillset.

The webinar series will provide attendees with knowledge to:

  • Produce Pivot Tables and Pivot Charts to analyze medical practice data
  • Use formulas to assist in data analysis
  • Discover how MS Excel can be leveraged for creating meaningful operational and financial insights

Webinar 1: February 19, 2020 1 CEU Technology

Webinar 2: February 26, 2020 1 CEU Technology

Webinar 3: March 4, 2020 1 CEU Technology

Please follow the links below to learn more about the series, registration rates and our presenter.

Healthcare Data Analytics Webinar Series

Monday, January 7, 2019
9-11 AM ET

Wednesday, January 9, 2019
9-11 AM ET

Thursday, January 10, 2019
2-4 PM ET

Friday, January 11, 2019
2-4 PM ET

This workshop will offer a hands-on experience analyzing healthcare data. Attendees will use MS Excel, the R statistical software package, and Tableau to prepare, describe, and visualize large healthcare datasets. Data will be analyzed in MS Excel using intermediate and advanced functionalities that will help improve the efficiency and accuracy of an analysis. The R statistical software package is an open source platform that utilizes a scripting language to analyze and visualize data. Tableau is data visualization software and attendees will learn how to create interactive summaries and dashboards. Ultimately, attendees will learn how to leverage cost-effective tools for preparing and visualizing data. At the conclusion of the workshop attendees will have greater confidence analyzing healthcare data with cost-effective tools to transition data into information for key stakeholders.

Speakers:

David Marc, PhD, CHD
Ryan Sandefer, PhD

 

Data Analytics Webinar Series

A three-part webinar series will offer members an opportunity to learn how to analyze healthcare data using MS Excel, RStudio, anopen-source data analytics software platform and Tableau for data visualization. The webinar will include tutorials on how to carry out basic and advanced analytical techniques including data acquisition, data summaries, data preparation, and data visualization. Each webinar is live and will run 1-hr in length and will be recorded for playback up to 60 days after the live event.

Offer webinar participants hands-on experience analyzing healthcare data with readily available software.

Part 1: Data Analytics with MS Excel- Intermediate/Advanced
August 8, 2018 at 12 PM ET

Objectives:

  • Create meaningful data summaries using pivot tables and pivot charts
  • Utilize intermediate and advanced Excel functions
  • Develop visual displays to assist in the interpretation of data
  • Part 2: Data Analytics with R and RStudio

Part 2: Data Analytics with R and RStudio
August 15, 2018 at 12 PM ET

Objectives:

  • Understand the utility of applications for big data analytics
  • Utilize basic R functions for data summaries
  • Develop graphs for interpreting data
  • Part 3: Data Visualization with Tableau

Part 3: Data Visualization with Tableau
August 22, 2018 at 12 PM ET

Objectives:

  • Upload data and perform data preparation
  • Develop graphs including geospatial representations
  • Create interactive dashboards.

Speaker: David Marc

Data Analytics Webinar Series

Summary

A three-part webinar series will offer members an opportunity to learn how to analyze healthcare data using MS Excel and the open-source data analytics software platform, R. The webinar will include tutorials on how to carry out basic and advanced analytical techniques including data acquisition, data summaries, data preparation, and data visualization. Each webinar is live and will run 1-hr in length and will be recorded for playback up to 90 days after the live event.

Purpose

Offer the webinar participants hands-on experience analyzing healthcare data with readily available software.

Outline

Part 1: Exploring Basic R Programming

August 17, 2017 at 12 PM ET
CEU – 1.0 Technology

Objectives:

  • An introduction to the R programming language
  • Creating R objects
  • Preparing imported data for analysis
  • Creating data summaries

Part 2: Exploring Data Visualization in the R Programming Environment

August 24, 2017 at 12 PM ET
CEU – 1.0 Technology

Objectives:

  • Creating common data plots such as histograms, bar plots, line plots, box plots, and dot plots, among others
  • Creating an interactive display
  • Publishing graphs for dashboards

Part 3: Exploring Data Mining Approaches in the R Programming Environment

August 31, 2017 at 12 PM ET
CE – 1.0 Technology

Objectives:

  • Data mining concepts and principles
  • Preparing data for data mining
  • Creating predictive data models
  • Testing and deploying data models

Speaker: David Marc

Learn More and Register