/Udacity-Business-Analytics

Data projects where I analyze data and build models with Excel, query databases using SQL, and create data visualizations with Tableau.

Primary LanguageTSQL

Udacity Business Analytics Nanodegree

[Spring 2020] Projects for my Udacity Business Analytics (Data Foundations) Nanodegree. Technologies used: SQL, Excel, Tableau

Program Curriculum:

Welcome to the Program - Project 1: Interpret a Data Visualization

In this project, you’ll explore an interactive data dashboard to uncover insights. You’ll write a short report explaining each insight, and how you found the information to reach your conclusion from the dashboard.

Link to report

Data used

Introducton to Data - Project 2: Analyze NYSE Data

In this project, you'll use statistics and spreadsheet programs like Excel to analyze data from over 500 companies on the New York Stock Exchange. You'll also forecast financial metrics based on three possible scenarios for a company of your choice from the NYSE dataset.

Link to report

Data used

SQL for Data Analysis - Project 3: Query Digital Music Store Database

In this project, you will query a digital music store database which holds information regarding the store’s media, employees, and customers. You will use the database to help the store gain an understanding of the types of music that are purchased, where customers live, and how the company might optimize their business practices.

Link to report

Database used

Queries used

Data Visualization - Project 4: Build Data Dashboards

In this project, you’ll build interactive dashboards with Tableau and use them to discover and communicate insights from data. You’ll use a dataset of flight delays in the US to visualize the quality of airlines and airports, find the best times to fly, and more.

Link to report

Database used