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.

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

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

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

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

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

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.

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

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

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.

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.

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.

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.

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.

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

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.

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

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

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.

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.

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.

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

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

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

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.

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

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