NCHIMA/LHIMA Data Analytics Webinar Series
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 webinars 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 the NCHIMA and LHIMA membership hands-on experience analyzing healthcare data with readily available software.
Part 1: Basic data analytics with MS Excel
Recorded: September 7, 2016
CE – 1.0 Technology
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
Recorded: September 14, 2016
CE – 1.0 Technology
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 R
Recorded: September 21, 2016
CE – 1.0 Technology
R is one of the world’s fastest growing analytical platforms. It can be used to carry out basic to very advanced analytics including statistics and data mining. This webinar will offer participants a first glance at the R platform and introduce them to the R language, how to create basic data summaries and graphs, and how to manipulate imported data.
- Introduction to writing R scripts
- Import data into R
- Create data summaries
- Create graphical summaries
David Marc is an assistant professor and the health informatics graduate program director at the College of St. Scholastica. Currently, Dr. Marc teaches courses on the foundations of health informatics, human factors and usability assessment, data analytics, and research design. Dr. Marc has a master’s degree in biological sciences from the University of Minnesota and a PhD in health informatics also from the University of Minnesota. Dr. Marc also holds a certification as a health data analyst (CHDA). Currently, Dr. Marc serves as the chair of the AHIMA foundation research network, a current presenter for the AHIMA faculty development regional meetings, and an instructor for the CHDA exam prep workshops. Dr. Marc also serves on the Minnesota HIMSS board as the chair of student affairs and is the chair for the AMIA education taskforce. Dr. Marc has extensive experience working with large healthcare datasets and analytic procedures. Recently, Dr. Marc co-editing 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 to the recording will be provided within 2 business days following receipt of payment.
3-Part Series ONLY
No refunds as all webinars are recorded and playback is available for at least 90 days.
When you register online, you will have the option to pay by mail with a check or pay online with a credit card (AMEX, MasterCard, or Visa). If you are paying by check, select “offline/mail” under payment options in the shopping cart. You will later see instructions to print the invoice page and mail your payment to KnowledgeConnex. The mailing address will be on the invoice. Make your check payable to KnowledgeConnex.
You can determine if your registration fee has been received by clicking here.
Click here if you are unable to view the registration form.