Data Foundations v1.0.0

Nanodegree key: nd100

Version: 1.0.0

Locale: en-us

Master data fundamentals applicable to any industry, and learn to make data-driven decisions. Learn Excel and SQL, and gain data visualization skills with Tableau.

Content

Part 01 : Welcome to the Program

Welcome to the program! In this part, you’ll get an orientation into using our classroom and
services. You’ll also get advice for making the best use of your time while enrolled in this
program.

Module 01: Welcome to the Nanodegree
- Lesson 01: Welcome to Data Foundations
  In the welcome, you will learn about the instructors, curriculum, and how this program is set up moving forward.
- Lesson 02: Nanodegree Orientation
  Here, you will learn more about the student services that are available for this Nanodegree program, as well as how to be successful in completing the program.
Module 02: Working with data
- Lesson 01: Working with data
  To get a glimpse at the tools you will be learning during this program and some areas where they are applied, this first project will tell you a few stories and give you a quick intro to each.
  
  Project Description - Interpret a Data Visualization
  
  Project Rubric - Interpret a Data Visualization

Part 02 : Introduction to Data

Module 01: Descriptive Statistics
- Lesson 01: Descriptive Statistics I
  In this lesson, you will learn about data types, measures of center, and the basics of statistical notation.
- Lesson 02: Descriptive Statistics II
  In this lesson, you will learn about measures of spread, shape, and outliers as associated with quantitative data. You will also get a first look at inferential statistics.
- Lesson 03: Spreadsheets 1: Getting Started
  In this lesson you'll learn to get started with spreadsheets: creating and saving a spreadsheet, basic operations, fill, and addressing.
- Lesson 04: Spreadsheets 2: Manipulate Data
  In this lesson, you'll learn to manipulate data in a spreadsheet: formulas, functions, removing duplicate rows, splitting columns, filtering, and sorting.
- Lesson 05: Spreadsheets 3: Analyze Data
  In this lesson, you'll learn to analyze data in a spreadsheet: answer questions about the data using aggregation functions, logical functions, pivot tables, and lookup tables.
- Lesson 06: Spreadsheets 4: Visualize Data
  In this lesson, you'll learn to present data professionally using spreadsheets: charts, histograms, box-plots, and formatting.
- Lesson 07: Analyze Survey Data
  Welcome to the second project! In this project you will use your knowledge of statistics and spreadsheets to analyze data about the students across Udacity programs.
  
  Project Description - Analyze Survey Data
  
  Project Rubric - Analyze Survey Data

Part 03 : SQL for Data Analysis

Module 01: SQL Things
- Lesson 01: Basic SQL
  In this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.
- Lesson 02: SQL Joins
  In this lesson, you will learn how to combine data from multiple tables together.
- Lesson 03: SQL Aggregations
  In this lesson, you will learn how to aggregate data using SQL functions like SUM, AVG, and COUNT. Additionally, CASE, HAVING, and DATE functions provide you an incredible problem solving toolkit.
- Lesson 04: [Optional] SQL Subqueries & Temporary Tables (Advanced)
  In this lesson, you will learn how to use temporary tables and subqueries to take your querying to a whole new level!
- Lesson 05: [Optional] SQL Data Cleaning (Advanced)
  Data cleaning is a necessary evil of working with data. In this lesson, you will learn how to clean data using SQL. These skills are so important with working with data that aren't exactly perfect.
Module 02: Query a Digital Music Store Database
- Lesson 01: Query a Digital Music Store Database
  The Chinook database is an iTunes library representing a digital music store. You will be querying this database as a part of this project to assist the store in learning about their customers.
  
  Project Description - SQL Project
  
  Project Rubric - SQL Project

Part 04 : Data Visualization

Sharing your analysis results is integral to working with data. Here, you'll learn how to properly design data visualizations and create interactive dashboards with Tableau.

Module 01: Data viz lessons

Part 05 : Congratulations and Next Steps

Once you have completed all four of the projects, you might be wondering 'what next?'

Module 01: Now What
- Lesson 01: Congratulations and Next Steps
  In this lesson, I want to take the time to congratulate you on your accomplishment, and talk about potential next steps in using data in your career and beyond.

**Part 06 (Elective):** Advanced SQL [Extra Materials]

Module 01: Advanced SQL
- Lesson 01: [Optional] SQL Subqueries & Temporary Tables (Advanced)
  In this lesson, you will learn how to use temporary tables and subqueries to take your querying to a whole new level!
- Lesson 02: [Optional] SQL Data Cleaning (Advanced)
  Data cleaning is a necessary evil of working with data. In this lesson, you will learn how to clean data using SQL. These skills are so important with working with data that aren't exactly perfect.