This repository contains the projects required to complete Business Analyst Nanodegree program of Udacity academy.
- Program Descriptions
- Part 1: Problem Solving with Analytics
- Part 2: Data Wrangling
- Part 3: Data Visualization
- Part 4: Classification Models
- Part 5: A/B Testing
- Part 6: Time Series Forecasting
- Part 7: Segmentation and Clustering
- Tools and Techniques
This 3-months duration program provides foundational data skills that apply across functions and industries. It focuses on analyzing data and building models with Excel, query databases using SQL, and creating informative data visualizations with Tableau.
A jewelry company wants to put in a bid to purchase a set of 3,000 diamonds, but is unsure how much it should bid. So, I applied a linear regression model to predict the diamond prices and make a recommendation on how much the jewelry company should bid for the diamonds.
A home-goods manufacturer wants to predict expected profits from sending a catalog to 250 new customers. So, I applied a framework to work through the problem and built a linear regression model to provide results and a recommendation.
A pet store chain is selecting the location for its next store. So, I used data preparation techniques to build a robust analytic dataset, then build a predictive model to select the best location.
Create Reports from a Database Management wants some high level metrics about their organization. I wrote SQL queries to extract and analyze data from a transactions database and prepared a set of visualizations.
In this project, I explored a movies dataset and built Tableau dashboards to answer a set of questions, listed below, and tell a story with data.
- Question 1: How have movie genres changed over time?
- Question 2: How do the attributes differ between Universal Pictures and Paramount Pictures?
- Question 3: How have movies based on novels performed relative to movies not based on novels?
- Question 4: What is the most profitable runtime for a movie?
A bank recently received an influx of loan applications. So, I built and applied a classification model to provide a recommendation on which loan applicants the bank should lend to.
A chain of coffee shops is considering launching a new menu. So, I designed and analyzed an A/B test and wrote up a recommendation on whether the chain should introduce the new menu.
A video game producer is planning production levels. So, I used time series forecasting models to forecast monthly demand and provide a recommendation to help match supply to demand.
This capstone project has three main tasks,
- Task 1: Determining Store Format
- Task 2: Determining the Store Format for New Stores
- Task 3: Forecasting Produce Sales
A grocery store chain has 85 grocery stores and is planning to open 10 new stores at the beginning of the year. Currently, all stores use the same store format for selling their products, which leads to product surplus and shortages. So, I provided analytical support to make decisions about store formats and inventory planning. Also, the company wants to have an accurate monthly sales forecast. So, I prepared a monthly forecast for produce sales for the full year of 2016 for both existing and new stores.