This course is the most important part of our program. You will solve problems based on real scenarios using the software tools listed below. We encourage you to become familiar with as many tools as possible 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.
​
Microsoft Access
​
User-friendly database querying program that doesn't require coding. Great for small-scale database management and querying.
Tableau
​
Top-ranked data visualization program. Great for rapid fire data analysis and visualization.
​
Alteryx​
​
Top-ranked data preparation program to connect, transform, and output data for visualization and analysis. Great for large-scale data processing and automation.
Microsoft SQL (coming soon)
​
Top-ranked database management and querying program from Microsoft.
Microsoft Power BI (coming soon)
​
Top-ranked data visualization program from Microsoft.
Qlikview (coming soon)
​
Top-ranked data visualization program.
R (coming soon)
​
Free software used widely for statistical analysis and graphics.
Python (coming soon)
​
Free software used widely for software development including data analysis and visualization. A preferred program language for machine learning.
​
PostgreSQL (coming soon)
​
Free software used widely for database management and querying data. One of the most popular tools in the market.​