/Business-Analytics

Business Analytics Nanodegree - Learn Excel, SQL and Tableau skills. Four reviewed projects to complete. See the projects website below.

Primary LanguageHTML

Business Analytics Nanodegree

This Udacity program aims to develop foundational data skills. Analyze data using Excel, query a database using SQL and build interactive dashboards and visualizations in Tableau.

To successfully complete this course, four mentor reviewed projects are required and one must satisfy the project's rubric.

Here are some of the reviews I received from Udacity:

"Congrats on passing this project from the very first attempt! This is something I don’t see often, so you should be really proud of yourself :)". Full review 👉

"Good knowledge of statistics and great analytical skills shown in this work. Please keep up doing this good job!". Full review 👉

"Well done coming up with your insights, they are simple yet very informative". Full review 👉

Course Syllabus

Welcome to the Program

Introduction to the program about where and how data applies to a variety of industries. First project is to interpret a data visualization.

🎯 PROJECT - Interpret a Data Visualization

Project Link

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 Rubric

Introduction to Data

Using descriptive statistics and visualizations in Excel this section aims to develop and communicate insights discovered from the data. This section also teaches more advanced excel functions, builds excel models and statistical analysis. The project at the end of the lesson is to analyze data from NYSE.

🎯 PROJECT - Analyze NYSE Data

Project Link

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 Rubric

SQL for Data Analysis

Extract and analyze a data set using SQL. Use data gathered from a query result to find answers to business questions and visualize it to make it easier to understand. The project in this section is to analyze a digital music store in how data gathered from their database may help the company.

🎯 PROJECT - Query a Digital Music Store Database

Project Link

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 Rubric

Data Visualization

This section takes data visualizations to another level. Use Tableau to analyze and visualize large data sets, and create informative and dynamic data dashboards. This section makes it easier to visualize large data sets in a more readable form in order to present insights to all business areas.

🎯 PROJECT- Build Data Dashboards

Project Link

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 Rubric


Certificate of Completion

image


Acknowledgement

Thanks to 🙌 Udacity 🙌 for providing this scholarship 🎉 course.