/
Data Analytics Professional Certificate
/
Course 1
/
Module 2
Syllabus
Courses
Course Syllabus
Data Analytics Foundations
Module 1: Data and the data analyst role
Introduction
What is data analytics?
What is data?
The data analytics role in context
Large language models for data analytics
Graded Quiz
Graded Lab
Resources
Module 2: Using spreadsheets for data analytics
Introduction
How spreadsheets organize data
Spreadsheet fundamentals
Getting to know your data
Video
・
3m
Summary statistics - MAX, MIN, AVERAGE
Video
・
5m
Conditional formatting
Video
・
5m
Summary statistics – COUNTIF
Video
・
3m
Summary statistics– SUMIF, AVERAGEIF
Video
・
4m
Summary statistics – COUNTIFS, SUMIFS
Video
・
6m
Data processing – IF, IFS, RIGHT, LEFT
Video
・
5m
Where does data come from?
Video
・
4m
Cells and cell ranges
Reading
・
10m
Lesson 2 quiz
Practice Quiz
・
10m
Practice Lab: Exploring the Hotel Reservations dataset
Reading
・
30m
Data Exploration with LLMs
Time series data
Graded Quiz
Graded Lab
Module 2 Resources
Module 3: Data visualization in spreadsheets
Introduction
Data storytelling
Creating charts
Best practices in data visualization
Data visualization with LLMs
Graded Quiz
Graded Lab
Module 3 Resources
Module 4: The data analytics lifecycle
Introduction
The data analytics lifecycle
Working with stakeholders
LLMs for stakeholder analysis
Graded Quiz
Graded Lab
Module 4 Resources
Capstone Project
Course wrap up
Acknowledgments
close
Log In to continue learning
Data Analytics Professional Certificate
Join Now
Choose Your Plan
Planning for more users?
Team Plan
Learn More
Keep Current Plan
close
