Data Analytics Webinar Series


A joint webinar between Minnesota Health Information Management Association and Wisconsin Health Information Management Association



Recorded on: January 29, 2019, February 5, 2019, and February 12, 2019

Continuing Education Credits

This program has been approved for three (3) Continuing Education Units for use in fulfilling the CE requirements of the American Health Information Management Association (AHIMA). Each webinar is one (1) CEU.

Domain – Clinical Data Management OR Performance Improvement 

To receive CE hours for this webinar series, one must register and pay for the webinar series. 

AHIMA Certification-Recertification Information

Audits:  Each year a percentage of recertification report forms are randomly selected for audit.  Individuals selected for audits will be notified in writing and required to submit verifiable documentation (for example, certificates of attendance or similar materials) for each activity listed on the CEU Report Form by the due date specified on the audit notification material…Individuals who fail to respond to the audit request by the specified due date or are found to have submitted false information on their recertification form may be denied recertification.

For more information regarding AHIMA Recertification click here.

The three-part Data Analytics Webinar Series has been reviewed and approved for 2.5 HIMSS CE’s by the UW-Extended Campus and the HIMT program’s Approved Education Partnership with HIMSS.


A three-part webinar series will offer members an opportunity to learn how to analyze healthcare data using MS Excel and Tableau. 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 will run 1-hr in length and will be recorded for later use and dispersal.


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


Part 1: Basic data analytics with MS Excel


Participants will learn how to create basic data summaries (e.g., counts, sum, averages) using MS Excel. The seminar will cover functions such as the SUM, AVG, COUNTIF, COUNTIFS, and PivotTables. Additionally, methods for creating effective graphs will be explored including PivotCharts.


  • Create summaries for data exploration
  • Create graphs to identify trends in data
Part 2: Advanced data analytics with MS Excel


Participants will learn how to carry out advanced function in MS Excel for the purposes of data preparation and data validation. The seminar will cover VLOOKUP to combine two datasets. The IF, IF(AND), and IF(OR) functions will be explored to examine ways of recoding or transforming data. Additionally, data validation will be explored to control the type of data or the values that users enter into a cell.


  • Combine two datasets
  • Validate data to limit user entry
  • Create conditional statements to recode data
Part 3: Data analytics with Tableau


Tableau is one of the world’s fastest growing analytical platforms. It can be used to carry out basic to very advanced data visualization methods including geospatial analyses. This webinar will offer participants a first glance at the Tableau platform and introduce them to the navigation of the software and how to create data summaries and graphs


  • Introduction to Tableau
  • Import data into Tableau
  • Create data summaries
  • Create graphical summaries


David Marc, PhD, CHDA

David Marc, PhD, CHDA

Department Chair & Health Informatics Graduate Program Director
Assistant Professor
Department of Health Informatics and Information Management
The College of St. Scholastica

David Marc, PhD, CHDA is an assistant professor, the health informatics and information management department chair, and the health informatics graduate program director at the College of St. Scholastica in Duluth, MN. Dr. Marc has a master’s degree in biological sciences and a PhD in health informatics from the University of Minnesota and is a certified health data analyst (CHDA). He served as the former chair of the AHIMA foundation research network and currently serves as an elected member of the AHIMA Council for Excellence in Education (CEE) where he co-chairs the Educational Programming Workgroup. Dr. Marc also serves on the HIMSS Scholars Workgroup and the HIMSS Student and Early Careerists Committee. Dr. Marc is a frequent speaker at state and national meetings and workshops where he speaks on topics related to healthcare data analytics. He is an accomplished researcher and author on topics related to health informatics and information management workforce trends.

Ryan Sandefer, PhD

Ryan Sandefer, PhD

Assistant Vice President for Academic Affairs
Associate Professor
The College of St. Scholastica
Department of Health Informatics and Information Management

Ryan Sandefer, PhD is the Assistant Vice President for Academic Affairs at the College of St. Scholastica. Through the use of data analytics and metrics, Dr. Sandefer deepens the college’s culture of evidence and the use of data in strategic decision making. He ensures the alignment of initiatives with the College’s mission and values, especially the challenge of creating community among online and extended site learners. Dr. Sandefer is also an associate professor and former chair of the Department of Health informatics and Information Management at the College of St. Scholastica.  Currently, Dr. Sandefer teaches courses in consumer informatics, data analytics, and research design. Dr. Sandefer has a master’s degree in political science from the University of Wyoming and completed his PhD in health informatics from the University of Minnesota. Currently, Dr. Sandefer serves as the past-chair of the AHIMA Council for Excellence in Education, a current presenter for the AHIMA faculty development regional meetings, and an instructor for the CHDA exam prep workshops. Dr. Sandefer has extensive experience working with large healthcare datasets and analytic procedures.  Recently, Dr. Sandefer co-edited the textbook Data Analytics in Healthcare Research: Tools and Strategies through AHIMA press, which offers a unique opportunity to experience big data from a hands-on perspective using open source tools and data.

Access Instructions

Access instructions to the recording will be provided within 2 business days following receipt of payment.


AHIMA Member – $50 for all three sessions

Non Member – $63 for all three sessions

This webinar series will be available on-demand. This means that each webinar will be recorded and sent out to all paid registrants, even if they register after the live webinar has occurred, or if they cannot make the time and date set for the live webinar.


Refunds will not be available. 


Registration for this on demand registration has now closed.