Business Analytics

Welcome to Business Analytics

Welcome to the Business Analytics Nanodegree program! In this lesson, you will learn more about the structure of the program and meet the team.

Nanodegree Orientation

In this lesson, you will learn more about the structure of the program and how to navigate yourself through the learning experience.

Getting Help

You are starting a challenging but rewarding journey! Take 5 minutes to read how to get help with projects and content.

Get Help with Your Account

What to do if you have questions about your account or general questions about the program.

Working with data

In this project, you’ll explore an interactive data dashboard to uncover insights, and write a short report explaining each insight.

Descriptive Statistics - Part I

In this lesson, you will learn about data types, measures of center, and the basics of statistical notation.

Descriptive Statistics - Part 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.

Spreadsheets 1: Getting Started

In this lesson, you will learn about the basic functionality for spreadsheet software, use cell referencing and menu shortcuts.

Spreadsheets 2: Manipulate Data

In this lesson, you will learn basic spreadsheet function: sort and filter data, use text and math functions, split columns and remove duplicates.

Spreadsheets 3: Analyze Data

In this lesson, you will learn how to summarize data with aggregation and conditional functions. You will learn how to use pivot tables and lookup functions.

Spreadsheets 4: Visualize Data

In this lesson you will build data visualizations for quantitative and categorical data; create pie, bar, line, scatter, histogram, and boxplot charts, and build professional presentations.

Business Metrics

This lesson will cover how to calculate business metrics used by business analysts across a range of business functions. You will also learn how to calculate and interpret key performance metrics.

Excel Modeling

This lesson will cover the fundamentals of sales and financial forecasting models. You will learn how to create forecast models using advanced lookup and data validation tools in Excel and Sheets.

Project: Analyze NYSE Data

In this project, you will use a data set containing financial performance data from companies listed in NYSE S&P to create an income statement and forecast financial metrics.

Intro to Using SQL for Data Analysis

This is a quick summary of what is covered in this course.

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.

SQL Joins

In this lesson, you will learn how to combine data from multiple tables together.

SQL Aggregations

In this lesson, you will learn how to aggregate data using SQL functions

SQL Subqueries & Temporary Tables

In this lesson, you will learn about subqueries, a fundamental advanced SQL topic. This lesson will walk you through the appropriate applications of subqueries, the different types of subqueries, and review subquery syntax and examples.

SQL Window Functions

Window functions allow users to compare one row to another without doing any joins using one of the most powerful concepts in SQL data analysis.

SQL Data Cleaning

Cleaning data is an important part of the data analysis process. You will be learning how to perform data cleaning using SQL in this lesson.

Query a Digital Music Store Database

In this project, you will use a digital music store database to help the company see how they might optimize their business practices.

Data Visualization Fundamentals

In this lesson you learn to evaluate the quality of data visualizations and build high quality visualizations, starting with the fundamentals of data dashboards.

Design Principles

In this lesson you learn to implement the best design practices, and to use the most appropriate chart for a particular situation.

Creating Visualizations in Tableau

This lesson teaches you how to build data visualizations in Tableau using data hierarchies, filters, groups, sets, and calculated fields, as well as create map-based data visualizations in Tableau.

Telling Stories with Tableau

In this lesson you learn how to build interactive Tableau dashboards and tell impactful stories using data.

Build a Data Visualization project

In this project, you’ll build interactive dashboards with Tableau and use them to discover and communicate insights from data.

Congratulations and Next Steps

Congratulations on completing all the projects for the Business Analyst Nanodegree!

Industry Research

You're building your online presence. Now learn how to share your story, understand the tech landscape better, and meet industry professionals.

Take 30 Min to Improve your LinkedIn

Find your next job or connect with industry peers on LinkedIn. Ensure your profile attracts relevant leads that will grow your professional network.

Resume Review

Improve your resume by getting personalized feedback on how you communicate your qualifications for a job.