Syllabus
Healthcare Analytics Certificate
The Healthcare Analytics Certificate equips you with analytics skills needed to bring data-driven insights and operational efficiency to the healthcare sector. The program will teach you how to use spreadsheets, SQL, and data visualization tools to manipulate, visualize, and pull insights from datasets. You’ll learn to use data to inform decisions that can impact patient care, hospital systems, and other healthcare settings. This certificate is designed for people with some prior experience in the healthcare industry.
Why Healthcare Analytics?
Healthcare jobs increasingly require analytical skills to make sense of data generated by health systems and patient care
Health data analysts perform critical work creating predictive models, automating reports, and performing other functions to drive new efficiencies in healthcare
Health data analysts are employed across hospital, diagnostic centers, healthcare consulting companies, healthcare IT vendors and more
4 Courses | Hands-On Learning and Career Exploration
Course 1:
Healthcare Analytics Fundamentals
Course 2:
SQL for Analytics
Course 3:
Data Visualization with Tableau
Course 4:
Healthcare Analytics Capstone
Course 1: Healthcare Analytics Fundamentals
In this course, you’ll learn foundational concepts in analytics that you can apply to healthcare settings. You will practice skills for data wrangling, data visualizations, descriptive statistics, exploratory data analysis, and data storytelling. The course culminates with a hands-on project in which you will perform an end-to-end exploratory data analysis (EDA).
Learning Outcomes:
- Construct business framing applications for analytics problem-solving processes.
- Apply spreadsheet software to manipulate and prepare data for analysis.
- Communicate analysis insights to intended audiences, such as business stakeholders.
Course 2: SQL for Analytics
In this course, you will learn the fundamentals of SQL through a guided case study project, where you will act as a data analyst supporting the growth of the new company. You will build DDL (data definition language) and DML (data manipulation language) queries using MySQL workbench. You will assess the existing data infrastructure, apply appropriate changes to a database, and present insights to business stakeholders.
Learning Outcomes:
- Explain the role and structure of relational databases as they apply to data analytics.
- Extract meaningful insights from relational databases using Data Manipulation Language (DML).
- Design industry-standard relational database schemas using Data Definition Language (DDL).
- Revise database schema to meet criteria of normal forms (1NF, 2NF, & 3NF).
Course 3: Data Visualization with Tableau
In this course, you will learn the fundamentals of data visualization, including how to communicate insights from data. You will be learning in an online lab environment using real industry data sets and building directly in Tableau software embedded in the learning experience (no downloads required). You will create and design both static and dynamic tables, data visualizations, dashboards, and stories while incorporating visual design best practices. You will also connect multiple external data sources and optimize large data to efficiently wrangle and analyze industry data.
Learning Outcomes:
- Learn to use Tableau Software to visualize data.
- Build interactive tables by connecting, preparing, and customizing data in Tableau.
- Create data visualizations, dashboards, and Tableau Stories, to communicate insights to business stakeholders.
- Apply Tableau performance optimization to improve speed when working with large datasets.
Course 4: Healthcare Analytics Capstone
You will complete a capstone project to apply everything you have learned in this program to a real challenge in the healthcare industry.
Learning Outcomes:
- Apply your data analytics skills to a real challenge in the healthcare industry.
- Complete a healthcare analytics project to add to your portfolio.
4 Courses | Hands-On Learning and Career Exploration
Course 1:
Healthcare Analytics Fundamentals
In this course, you’ll learn foundational concepts in analytics that you can apply to healthcare settings. You will practice skills for data wrangling, data visualizations, descriptive statistics, exploratory data analysis, and data storytelling. The course culminates with a hands-on project in which you will perform an end-to-end exploratory data analysis (EDA).Â
Learning Outcomes:
- Construct business framing applications for analytics problem-solving processes.
- Apply spreadsheet software to manipulate and prepare data for analysis.
- Communicate analysis insights to intended audiences, such as business stakeholders.
Course 2:
SQL for Analytics
In this course, you will learn the fundamentals of SQL through a guided case study project, where you will act as a data analyst supporting the growth of the new company. You will build DDL (data definition language) and DML (data manipulation language) queries using MySQL workbench. You will assess the existing data infrastructure, apply appropriate changes to a database, and present insights to business stakeholders.
Learning Outcomes:
- Explain the role and structure of relational databases as they apply to data analytics.
- Extract meaningful insights from relational databases using Data Manipulation Language (DML).
- Design industry-standard relational database schemas using Data Definition Language (DDL).
- Revise database schema to meet criteria of normal forms (1NF, 2NF, & 3NF).
Course 3:
Data Visualization with Tableau
In this course, you will learn the fundamentals of data visualization, including how to communicate insights from data. You will be learning in an online lab environment using real industry data sets and building directly in Tableau software embedded in the learning experience (no downloads required). You will create and design both static and dynamic tables, data visualizations, dashboards, and stories while incorporating visual design best practices. You will also connect multiple external data sources and optimize large data to efficiently wrangle and analyze industry data.
Learning Outcomes:
- Learn to use Tableau Software to visualize data.
- Build interactive tables by connecting, preparing, and customizing data in Tableau.
- Create data visualizations, dashboards, and Tableau Stories, to communicate insights to business stakeholders.
- Apply Tableau performance optimization to improve speed when working with large datasets.
Course 4:
Healthcare Analytics Capstone
You will complete a capstone project to apply everything you have learned in this program to a real challenge in the healthcare industry.
Learning Outcomes:
- Apply your data analytics skills to a real challenge in the healthcare industry.
- Complete a healthcare analytics project to add to your portfolio.
What You’ll Learn:
After completing this program, you’ll be ready to:
- Develop business reports and analyze data using pivot tables and spreadsheet software.
- Use SQL to extract insights from data.
- Create data visualizations, dashboards, and Tableau Stories.
- Communicate analysis insights to business stakeholders.
Learning Experience
- No required times to log in. Complete lessons at times during the week that work for you. Keep up with deadlines to stay on track and complete in 9 months.
- Complete real business projects in an online platform and get individualized support and feedback from instructors.
- Practice using software directly in the learning platform. No separate downloads.
- Explore the real work that healthcare analysts do on the job and apply those skills to your own career.
FAQs
What is the schedule?
There are three required courses which will be open for 8 weeks with a 1-week grading period after each. These will be followed by a capstone project which can be completer in 1 week. You should expect to spend 10-12 hours per week completing your coursework. The program is flexibly-paced, meaning you can move as quickly or slowly as you’d like through each course, as long as you complete all sections and projects during the 8-week course period. We provide a suggested course schedule to help pace yourself through each course. Students who follow this schedule are more likely to earn the certificate and get more out of the course by spreading out their workload, and our instructors provide weekly nudges to keep you on track. As long as you submit all projects by the course end date, you can progress through the course at whatever pace works best for you! For example, you might do all your work over the weekend or space it out throughout the week.
Can I work full-time while enrolled in this program?
Yes, the entire course experience is online and can be completed on your own schedule as long as you work towards the deadlines set in each course. There are no set times or classes when you need to log in. Our courses are designed for working professionals, students, and parents!
What prerequisites do I need?
Students must have a high school degree prior to taking this program. No prior experience is required.
What is Pathstream?
Pathstream is a provider of digital skills training based in Silicon Valley. We partner with leading tech companies and universities to develop programs that prepare people for in-demand jobs.