Data Scientist: Analytics

Analytics data scientists use statistics and hypothesis testing to gather insights,
evaluate options, and spot trends. This path will teach you the technologies
and skills you need to do just that!

Data Science Foundations (Months 1 and 2)

Get started with the foundations. By the end of this section, you'll be able to conduct
an exploratory analysis of a dataset with both Python and SQL.

 Welcome to the Data Scientist: Analytics Specialist Career Path: Discover

what you will learn on your journey to becoming a Data Scientist: Analytics
Specialist!
o Welcome to the Data Scientist: Analytics Specialist Career Path:
Discover what you will learn on your journey to becoming an Analytics
Data Scientist!
 Principles of Data Literacy: Discover the world of data in this fully
conceptual course where you will learn how to think about, visualize, and
analyze data.
o Introduction to Data: Explore the world of data through case studies, and
learn about collection methods and data quality.
o Thinking about Data: Become wise in the ways of statistical thinking
with this approachable yet hearty introduction.
o Visualizing Data: Bring data and visualization together to tell
compelling data stories with eye-catching visuals.
o Analyzing Data: Cover your analysis bases by learning to make
informed data decisions and manage bias in its many forms.
 Learn SQL: Learn SQL — a popular language that’s used for communicating
with databases and working with data.
o Getting Started with SQL: Learn about what SQL is and how Data
Scientists & Analysts use it!
o Manipulation: Learn how to use SQL to access, create, and update data
stored in a database.
o Queries: Perform more complex queries by learning essential query
keywords and functionality
o Aggregate Functions: Learn powerful functions for performing complex
database operations with ease.
o Multiple Tables: Expand your SQL skills by creating and manipulating
databases with multiple related tables
o Review Fundamentals of SQL for Data Science: Review the SQL skills
you've built!
 Python Fundamentals for Data Science (Part I): Build a foundation in
programming with Python with a focus on Data Science!
o Introduction to Python Fundamentals for Data Science (Part I): Preview
what you'll cover in Python Fundamentals for Data Science Part I.
o Python Syntax and Variable Types: Learn about the syntax of the Python
language! Go over commands that store variables, print messages, and
perform mathematical operations.
o Python Functions: Functions are important tools for abstraction in your
code. Learn how to create and use them in Python!
o Python Control Flow: Learn how to build control flow into your python
code with if, else, and elif statements.
o Python Lists: Learn about lists, an essential data structure for storing,
manipulating, and working with data.
o Python Loops: Loops let you repeat Python code over and over. You'll
learn how to read and write loops and list comprehensions to solve data
problems.
o Getting Started Off Platform: Get Started off-platform with Jupyter
Notebook!
o Frida Kahlo Cumulative Project: Analyze data about Frida Kahlo's
works in this Off-Platform Project that you can add to your portfolio.
 Python Fundamentals for Data Science (Part II): Continue building your
Python Skills while applying them to real data science challenges including
finding and working with real data.
o Introduction to Python Fundamentals for Data Science (Part II): Preview
what you'll cover in Python Fundamentals for Data Science Part II.
o Data Acquisition: Where to begin in your search for data.
o Python Strings: Learn all about the Python strings and how to
automatically create, rearrange, disassemble, and reassemble blocks of
text!
o Python Dictionaries: Learn all about the Python dictionary structure and
how to create and use key-value pairs in your code.
o Python Files: Learn how to work with files in an automated way.
Investigate the properties of text, CSV, and JSON files by reading and
writing to them.
o Reggie's Linear Regression Cumulative Project: Review the data
collected by a local scientist to figure out how to maximize the fun in a
ball pit.
o Review: Python Fundamentals: Review everything you've learned in
Python Fundamentals.
 Portfolio Project: U.S. Medical Insurance: Use your understanding of Python
syntax to sort and analyze data about U.S. medical insurance costs!
o Portfolio Project: U.S. Medical Insurance: Use your understanding of
Python syntax to sort and analyze data about U.S. medical insurance
costs!

Data Science Foundations II (Month 3)

Build on your foundations with statistics, data visualization, and cleaning. By the end
of this section, you'll be able to work independently with a dataset of your choosing.

 Python Pandas for Data Science: Learn how to use the Python pandas library
and lambda functions for Data Science.
o Introduction to Data Manipulation with Pandas: Prepare to meet the
pandas Python library, an essential tool for Data Scientists.
o Lambda Functions for Pandas: Amplify the power of pandas with
lambda functions!
o Hands-On with Pandas: Learn how to create, load, select, and modify
data with pandas DataFrames.
o Aggregates in Pandas: Learn how to use aggregate functions in pandas to
calculate tables of summary statistics.
o Multiple Tables in Pandas: Learn how to combine information from
multiple DataFrames.
o Data Manipulation Challenge Project: Put your new data manipulation
skills to the test with a Jeopardy project!
 Exploratory Data Analysis in Python: Learn about exploratory data analysis
(EDA) techniques for Data Science
o Introduction to EDA: Explore exploratory data analysis and learn about
what it is used for.
o Variable Types for Data Science: Learn about different variable types
and their role in Exploratory Data Analysis.
o Inspect, Clean, and Validate a Dataset: Learn how to use exploratory
data analysis (EDA) to inform data inspection, cleaning, and validation.
o Summarizing a Single Feature: Learn how to explore a single feature in a
dataset using summary statistics and simple data visualizations.
o Summarizing the Relationship between Two Features: Learn how to
investigate whether there is an association between two variables.
 Statistics Fundamentals for Data Science: Learn how and when to use the
essential statistical tools Data Scientists use to analyze data.
o Probability for Data Science: You'll certainly use probability in your
Data Science journey -- learn about the rules of probability, set theory,
and distributions.
o Sampling for Data Science: Sample the world of sampling by learning
about distributions and the Central Limit Theorem.
o Inferential Statistics Basics: Preview what inferential statistics is all
about and learn why correlation is not necessarily causation.
o Hypothesis Testing for Data Science: We have a hypothesis that you will
be fluent with hypothesis testing with t-tests and p-values by the end of
this unit!
o Simple Linear Regression for Data Science: Discover the world of
Linear Regression - one of the most versatile and foundational statistical
tools Data Scientists use.
 Data Visualization Fundamentals with Python: If a picture is worth a
thousand words, then a visualization is worth more than a thousand data points.
Learn how to make them here!
o Line Charts in Python: Learn how to create line charts in Python to
visualize your data trends.
o Charts Beyond the Line Chart in Python: Learn how to create a
multitude of charts to visualize almost every type of data.
o Visualizing Categorical Data: Learn how to visualize categorical data
with bar charts and pie charts.
o Visualization for Exploratory Data Analysis: Discover ways to use
visualization to explore a dataset!
o Data Visualization Fundamentals Review : Review best practices for
creating data visualizations.
 Portfolio Project: Data Visualization: Use your understanding of data
visualization to analyze and plot data about GDP and life expectancy.
o Data Visualization Portfolio Project: Use your understanding of data
visualization to analyze and plot data about GDP and life expectancy.
 Data Wrangling, Cleaning, and Tidying: Clean, well-structured data is
essential to data science but cleaning data requires both a keen eye and
technical skills. Develop both here!
o Introduction: Data Wrangling and Tidying: Discover what you’ll learn in
Data Wrangling and Tidying.
o Introduction to Regular Expressions: Get a taste of regular expressions
(regex), a powerful search pattern language, to quickly find and select
the data you’re looking for.
o How to Clean Data with Python: Some say data scientists spend 80% of
their time cleaning data and 20% of their time doing analysis. Learn how
to do this 80% in Python!
o Handling Missing Data: Learn how and when to tackle missing data with
deletion, single imputation, linear interpolation, and multiple imputation
techniques.
 Communicating Data Science Findings: Communication is an important part
of your work as a data scientist. Learn best practices for effectively explaining
your analysis.
o Introduction: Communicating Data Science Findings: Get ready to
communicate your data analysis findings a lot better.
o Communicating Data Science Findings: Communication is an important
part of your work as a data scientist.
o Review: Communicating Data Science Findings: Now to communicate
all you've learned about communication...
 Data Science Foundations Portfolio Project: Use your knowledge of data
analysis to interpret data about endangered animals for the National Park
Service.
o Biodiversity in National Parks: Use your knowledge of data analysis to
interpret data about endangered animals for the National Park Service.

Statistics for Data Scientists (Month 4)

Dive deeper into statistics and data analysis. By the end of this section, you will know
how to conduct exploratory analysis to drive insights, and use visualizations
effectively to see your data in a new way.

 Next Steps: The Analytics Specialty: Get ready for your data science
specialization by reviewing how each role works to make meaning from data.
o Next Step: Becoming a Data Science Specialist: Review the Data
Scientist Career Path Specialties and explore the types of roles that each
one fills.
o Welcome to the Analytics Specialty: Let's get started in the Analytics
Speciality!
 Advanced Exploratory Data Analysis: Deepen your statistics knowledge and
get ready to prove a case with data!
o Introduction to Advanced EDA: Explore what you will learn in
Advanced Exploratory Data Analysis!
o Variance and Standard Deviation: Learn how to calculate and interpret
variance and standard deviation!
o Distributions: Learn how to create, interpret, and describe a histogram!
o Quartiles, Quantiles, and Interquartile Range: Learn to calculate
quartiles, quantiles, and the inter-quartile range (IQR) for a variable and
visualize them with a boxplot!
o Summary Statistics for Categorical Data: Learn how to summarize
categorical variables in Python using numerical summary statistics.
o Data Transformation: Learn how to transform your data to get it ready
for efficient analysis, and practice on real-world business data!
 Visualization for Data Science Applications: Put your Matplotlib data
visualization skills to the test with these challenge projects!
o Matplotlib Challenge Projects: Put your Matplotlib data visualization
skills to the test with these challenge projects!

Advanced Databases (Month 5)

In this section, you'll get hands on practice using SQL to calculate user churn, usage
funnels, and marketing attribution. Level up your SQL with Window Functions and
database protection.

 Advanced SQL for Data Science: Keep building your SQL skills with
advanced techniques and hands-on practice.
o Introduction to Advanced SQL for Data Science: See what you will learn
in Advanced SQL for Data Science!
o Window Functions: Use a window function to perform a calculation
across a set of table rows that are somehow related to the current row!
o Introduction: Analyze Real Data with SQL: See what you will learn in
Analyze Real Data with SQL!
o Usage Funnels: Analyze Warby Parker’s marketing funnel from Quiz →
Home Try-On → Purchase in order to calculate conversion rates.
o User Churn: Analyze churn for two groups of Codeflix users and
recommend which segment represents a better long-term user base.
o Marketing Attribution: Help CoolTShirts, an innovative apparel shop,
improve their marketing campaigns.
o Gaming Trends: Analyze Twitch data with SQL and Matplotlib.

BI Tools for Data Scientists (Month 6)

Flesh out your skillset by building fluency in two of the most popular BI Tools: Excel
and Tableau. By the end of this section, you'll be able to build dashboards, pivot data,
and work across a variety of tools and platforms. Show off your knowledge of data
analytics by developing your final portfolio project. In this section, we will guide you
through all of the steps you need to create a protfolio-worthy project.

 Learn Tableau for Data Visualization: Learn the basics of data setup and
visualization in Tableau.
o Data Setup: Learn the basics of setting up data in Tableau.
o Making Visualizations: Learn the basics of data visualization in Tableau.
o More on Storytelling: Learn techniques and tricks for telling compelling
data stories in Tableau.
o Final Project: Make a portfolio-worthy project in Tableau!
 Learn Microsoft Excel for Data Analysis: Learn how to analyze and visualize
data in Microsoft Excel!
o Welcome to Learn Microsoft Excel for Data Analysis: Get started with
Excel for Data Analysis!
o Exploring Data: Learn how to leverage Excel to explore data.
o Visualizing Data: Learn to visualize data in Excel!
o Handling Data: Get a handle on handling data in Excel!
o Capstone Project: Bitcoin Prices in Excel: Use Excel to analyze Bitcoin
price behavior.
 Data Scientist: Analytics Specialist Final Portfolio Project: Show off your
knowledge of data analytics by developing your final portfolio project on a
topic of your choice.
o Data Analytics Final Portfolio Project: Show off your knowledge of data
analytics by developing your final portfolio project on a topic of your
choice.
 Data Scientist: Analytics Specialist Final Review: Review what you learned
in the Data Scientist: Analytics Specialist Career Path and explore ways to
deepen your knowledge!
o Data Scientist: Analytics Specialist Final Review: Review what you
learned in the Data Scientist: Analytics Specialist Career Path and
explore ways to deepen your knowledge!