This repository contains my projects for Udacity's Business Analytics Nanodegree Program. This Udacity program aims to develop foundational data skills that apply across functions and industries. To Analyze data using Excel
, query a database using SQL
and build interactive dashboards and visualizations in Tableau
. The main objectives for this nanodegree are to gain foundational data skills that are applicable to any industry. Collect and analyze data, model business scenarios, and communicate your findings with SQL, Excel, and Tableau.
In this project, I explored an interactive data dashboard about LinkedIn Top Skills 2016 to uncover insights. Then I wrote a short report explaining each insight, and how I found the information to reach my conclusion from the dashboard.
In this project, I've used statistics and spreadsheet programs (Excel) to analyze data from over 500 companies on the New York Stock Exchange. In particular, I created a Profit & Loss statement with an S&P 500 company selector widget in Excel. I also used Excel to create a dynamic income statement, where I forecasted financial metrics based on three possible scenarios for a company of choice from the NYSE dataset. Lastly, I analyzed the change in terms of Cost-of-good-sold between Year 1 and Year 3 for Materials Sector.
In this project, I queried a digital music store database which holds information regarding the store’s media, employees, and customers. I used 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.
In this project, I built interactive dashboards with Tableau and use them to discover and communicate insights from data. I used a dataset of Youtube to visualize the highest views, likes for videos, and more.
- Database Querying using
SQL
- Data Analysis using
Excel
- Data Visualization using
Tableau