Foundation
What you will learn:
Real-life roles and responsibilities of a junior data analyst
How businesses transform data into actionable insights
Spreadsheet basics
Database and query basics
Data visualization basics
Skill sets you will build:
Using data in everyday life
Thinking analytically
Applying tools from the data analytics toolkit
Showing trends and patterns with data visualizations
Ensuring your data analysis is fair
Ask
What you will learn:
How data analysts solve problems with data
The use of analytics for making data-driven decisions
Spreadsheet formulas and functions
Dashboard basics, including an introduction to Tableau
Data reporting basics
Skill sets you will build:
Asking SMART and effective questions
Structuring how you think
Summarizing data
Putting things into context
Managing team and stakeholder expectations
Problem-solving and conflict-resolution
Prepare
What you will learn:
How data is generated
Features of different data types, fields, and values
Database structures
The function of metadata in data analytics
Structured Query Language (SQL) functions
Skill sets you will build:
Ensuring ethical data analysis practices
Addressing issues of bias and credibility
Accessing databases and importing data
Writing simple queries
Organizing and protecting data
Connecting with the data community (optional)
Process
What you will learn:
Data integrity and the importance of clean data
The tools and processes used by data analysts to clean data
Data-cleaning verification and reports
Statistics, hypothesis testing, and margin of error
Resume building and interpretation of job postings (optional)
Skill sets you will build:
Connecting business objectives to data analysis
Identifying clean and dirty data
Cleaning small datasets using spreadsheet tools
Cleaning large datasets by writing SQL queries
Documenting data-cleaning processes
Analyze
What you will learn:
Steps data analysts take to organize data
How to combine data from multiple sources
Spreadsheet calculations and pivot tables
SQL calculations
Temporary tables
Data validation
Skill sets you will build:
Sorting data in spreadsheets and by writing SQL queries
Filtering data in spreadsheets and by writing SQL queries
Converting data
Formatting data
Substantiating data analysis processes
Seeking feedback and support from others during data analysis
Share
What you will learn:
Design thinking
How data analysts use visualizations to communicate about data
The benefits of Tableau for presenting data analysis findings
Data-driven storytelling
Dashboards and dashboard filters
Strategies for creating an effective data presentation
Skill sets you will build:
Creating visualizations and dashboards in Tableau
Addressing accessibility issues when communicating about data
Understanding the purpose of different business communication tools
Telling a data-driven story
Presenting to others about data
Answering questions about data
Act
What you will learn:
Programming languages and environments
R packages
R functions, variables, data types, pipes, and vectors
R data frames
Bias and credibility in R
R visualization tools
R Markdown for documentation, creating structure, and emphasis
Skill sets you will build:
Coding in R
Writing functions in R
Accessing data in R
Cleaning data in R
Generating data visualizations in R
Reporting on data analysis to stakeholders
Capstone
What you will learn:
How a data analytics portfolio distinguishes you from other candidates
Practical, real-world problem-solving
Strategies for extracting insights from data
Clear presentation of data findings
Motivation and ability to take initiative
Skill sets you will build:
Building a portfolio
Increasing your employability
Showcasing your data analytics knowledge, skill, and technical expertise
Sharing your work during an interview
Communicating your unique value proposition to a potential employer
Optional: Your diagnostic quiz score and what it means
Use your score to help you determine whether you should take the speed track. The speed track
allows you to skip over the lesson material and go straight to the weekly challenges and the course
challenge, which lead to your final course score. In order to earn your certificate, you will need an
overall score of 80% or higher on all graded materials in this program. Read on to figure out your
next steps based on your quiz score:
If you scored 100% on the diagnostic quiz:
You’re probably very familiar with the fundamental concepts involved in data analytics and
can take the speed track to move on to Course 2.
You must take each of the weekly challenges and the course challenge, which will count
toward the 80% overall score needed to earn the certificate. To help you find these items
more quickly, we’ve identified them with asterisks in the course materials (for example:
*course challenge*).
After you complete the weekly challenges and course challenge, proceed to Course 2.
You’re welcome to review videos, readings, and activities throughout the course based on
your interests.
If you scored between 90% and 99% on the diagnostic quiz:
You’re probably familiar with the fundamental concepts involved in data analytics and might
consider taking the speed track to move on to Course 2.
However, we still recommend that you go through the Course 1 lesson materials to review
areas where you might have some gaps before proceeding to Course 2.
You must take each of the weekly challenges and the course challenge, which will count
toward the 80% overall score needed to earn the certificate. To help you find these items
more quickly, we’ve identified them with asterisks in the course materials (for example:
*course challenge*).
After you complete the weekly challenges and course challenge, proceed to Course 2.
You’re welcome to review videos, readings, and activities throughout the course based on
your interests.
If you scored between 80% and 89% on the diagnostic quiz:
You likely have some background knowledge on fundamental concepts involved in data
analytics.
However, we recommend that you go through the Course 1 lesson materials to review areas
where you might have some gaps before proceeding to Course 2.
You must take the weekly challenges and the course challenge, which will count toward the
80% overall score needed to earn the certificate. To help you find these items more quickly,
we’ve identified them with asterisks in the course materials (for example: *course
challenge*).
If you scored less than 80% on the diagnostic quiz:
No problem — this course was made for you!
We strongly recommend that you go through all of the Course 1 videos, readings, and
activities, as the concepts taught are building blocks that will set you up for success on your
learning path.
You must take the weekly challenges and the course challenge, which will count toward the
80% overall score needed to earn the certificate.
Regardless of your score, the course material can help you supplement or fill gaps in your
knowledge. Whether you take the speed track or complete the certificate at the provided pace, good
luck on your data endeavors
