hala-otb / future-seekers---business-analytics-nanodegree-program Goto Github PK

#Business-Analytics-Nanodegree-Program

This project is aimed at analysis using data visualization in Tableau and ind 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.

In this project i analyzed real life data from the New York Stock Exchange. I made a subset of a large dataset provided by Kaggle that contains historical financial data from S&P 500 companies. I have created a smaller subset of the data that i will be using for the project.

-interpret the measures of central tendency and spread (mean, median, standard deviation, range) -use a combination of Excel functions (e.g., IF statements, INDEX and MATCH, calculating descriptive statistics with the IF statement, drop downs, data validation, VLOOKUP). -analyze and forecast financial business metrics using Excel . -create visualizations of a business metric and use Excel to create a financial forecast model.

A jewelry company wants to put in a bid to purchase a large set of diamonds, but is unsure how much it should bid. In this project, you will use the results from a predictive model to make a recommendation on how much the jewelry company should bid for the diamonds.

In this project, i build interactive dashboards with Tableau and use them to discover and communicate insights from data.