Skip to content

My projects from Udacity's intensive Business Analytics NanoDegree program. Where I analyzed data; built financial forecast and dashboards with excel; intermediate-advanced level query using SQL; and data visualizations using Tableau.

Hishamdmacaraya/NanoDegree-Business-Analytics

Repository files navigation

NanoDegree in Business Analytics

[Winter 2022] Cohort of OneTen/BIT Scholarship Program

The Udacity's Business Analytics NanoDegree program is an intensive 4-month course where students learn business statistics; how to analyze data; how to uild financial forecast and dashboards with excel; intermediate-advanced level query using SQL; and data visualizations using Tableau.

Program Curriculum

For more details regarding the program, please check the Syllabus.

I. Introduction

Learn how people use data to answer questions, and find your own insights from a data dashboard.

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.

Project Description

A large part of working with data is being able to interpret data visualizations and explain your insights to others. To give you some practice with this, we’ve selected a few Tableau dashboards for you to explore. The link is in the data source bellow. Find three insights in the visualizations. For each insight, provide a static image that shares what you found. Write a short report explaining each observation and how you found the information to reach your conclusion from the dashboard. Altogether (including images), your report should be 1-2 pages. Click here for Rubic.

Project 1 Submission:

Project 1 Image

Data Interpretation of LinkedIn Top 10 Skills of 2016

Data Source

Project Reviwer's Comment:

"Congratulations, You did great work by creating a presentation that demonstrates three different insights from LinkedIn top skills 2016 dashboard, in addition to adding clear and concise conclusions based on your observations from the data. Gaining the knowledge to make conclusions from a data visualization is a very important skill, you need to obtain to build your data analytical skills."

II. Introduction to Data

Learn how to use statistics and visuals to find and communicate insights. Develop Excel skills to manipulate, analyze, and visualize data in a spreadsheet. Build Excel models to analyze possible business outcomes.

Project Description

Click here for Rubic.

Project 2: Interpret a Data Visualization

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.

Project 2 Submission:

Screenshot_20230127_083916

Restaurant-Industry-Insight-2015-2016

P&L Statement, Interactive Dashboard, and Financial-Model

Data Source

Project Reviwer's Comment:

"Excellent project, you have a good understanding of using the correct formulas and assumptions to create a great financial model where required and creating good slides supported by visualisations with clear descriptions to explain the analysis using the measures of centre and spread to support the claims."

III. SQL for Data Analysis

Learn to use Structured Query Language (SQL) to extract and analyze data stored in databases.

Project 3: Interpret a Data Visualization

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.

Project Description

Click here for Rubic.

Project 3 Submission:

Screenshot_20230127_083752

Data Source

Project Reviwer's Comment:

IV. Data Visualization

Learn to apply design and visualization principles to create impactful data visualizations, build data dashboards, and tell stories with data.

Project 4: Interpret a Data Visualization

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.Project 2 Instruction.

Project 4 Submission:

Tableau Public Profile Link:

Hisham D Macaraya at https://public.tableau.com/app/profile/hisham.d.macaraya

Project 4 Visualizations and Dasboards:

Insight's Explaination in Slide 2

Tableau 4

Tableau 2

Tableau 3

Tableau 1

Data Source

Project Reviwer's Comment:

About

My projects from Udacity's intensive Business Analytics NanoDegree program. Where I analyzed data; built financial forecast and dashboards with excel; intermediate-advanced level query using SQL; and data visualizations using Tableau.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published