This 2-part webinar series will offer a hands-on experience to analyze and visualize healthcare data. The sessions will explore the utility of MS Excel and Tableau Public to prepare data for analysis, create data summaries, and apply data visualization to create meaningful insights. Instructions on how to download and install the software will be provided. The data files will also be included ahead of time. Each webinar will be one hour in length.
The first webinar will explore the use of MS Excel and offer the following:
• Preparing data using MS Excel
• Develop data summaries using functions
• Develop data summaries using PivotTables
• Create visual displays of data using PivotCharts
The second webinar will explore data visualization in the Tableau Public environment and offer the following:
• Preparing data using Tableau Public
• Develop tabular data summaries using Tableau
• Develop graphical data summaries using Tableau
• Create interactive dashboards
February 18, 2020
CEU: 2.0 – Informatics, Analytics, and Data Use
David Marc, PhD, CHDA
David Marc, PhD, CHDA is an associate 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 a member of the AHIMA Council for Excellence in Education (CEE) where he co-chaired 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
Dr. Ryan Sandefer is the Associate Vice President for Academic Affairs at the College of St. Scholastica. He is also an associate professor in the HIIM Department where he teaches research methods and data analytics. He is responsible for coordinating and integrating planning efforts around new and expanding non-traditional programs. Through the use of data analytics and metrics, Dr. Sandefer deepens the college’s culture of evidence and the use of data for 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 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. Dr. Sandefer served as the chair of the AHIMA Council for Excellence in Education, a presenter for the AHIMA data analytics workshops, and an instructor for the Certified Health Data Analytics exam prep workshops. Dr. Sandefer has extensive experience working with large healthcare datasets and analytic procedures. 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.