This course can be taken by selecting a specific software or working with all available options for comprehensive training. We encourage you to become familiar with various software programs and understand their advantages and disadvantages.
​
Learning Objectives
​
Upon completing the course, you will be able to:
-
Develop mastery in data analysis, visualization, preparation, and database management/querying
-
Utilize financial, market, quality, operational, and utilization data in decision making
-
Define data requirements for a problem then deploy appropriate analytical tools and methods
-
Incorporate health equity and Social Determinants of Health in generating insights
-
Communicate effectively with technical (IT and Data) and non-technical teams (Clinical and Business)
​
Course Outline
​
Course Introduction
Session 1: Basics of Data Analytics
Session 2: Financial Data in Healthcare
Session 3: Utilization and Operations Data
Session 4: Quality Data in Healthcare
Session 5: Project Management & Data Visualization
Session 6: Market Data in Healthcare
Session 7: Integration and Course Summary
​
👉 Course Syllabus
​
​
​
Microsoft Excel
​
The most popular spreadsheet program in the world. Great for data analysis.
​
Advantages
Easy to learn and use
Low cost
Installed everywhere
Disadvantages
Limit on data size
Slow Speed
Weak data visualization
Microsoft Access
​
User-friendly database querying program that doesn't require coding. Great for small-scale database management and querying.
Advantages
Easy to learn and use
Low cost
No IT help needed
Disadvantages
Slow Speed
No data visualization
Basic SQL features
Tableau
​
Top-ranked data visualization program. Great for rapid fire data analysis and visualization.
​
Advantages
Easy to learn and use
No IT help needed
Superb data visualization
Fast Speed
Disadvantages
Cost
Basic data preparation
​
​
​
Alteryx​
​
Top-ranked data preparation program to connect, transform, and output data for visualization and analysis. Great for large-scale data processing and automation.
Advantages
Easy to learn and use
No IT help needed
Easy to build and edit data pipelines
Fast Speed
Disadvantages
Cost
Basic data visualization
​
​
​