1. You should provide THREE (3) insightsbased on your data sets. You will be looking for...

 

Transcribed Image Text:

1. You should provide THREE (3) insightsbased on your data sets. You will be looking for relationships between attributes in the data set that can help you understand the company's products, customers, sales and or any other aspects. 2. You are expected to demonstrate your ability to use the following functions appropriately: Sorting, Filtering, Subtotals, IF, Countl F, Averagel F, Pivot Tables and others. 3. Your analysis may not support using all the listed functions. However, your team will be marked on the sophistication of the analysis and the appropriateness of the tools being used. 4. You and your team are expected to create some professional chart(s) for each insight to communicate the results of your analysis. The charts should help to interpret our results and conclusions. 5. For each insight, the report of your data analysis will include: a. A statement about what you are trying to discover. b. Tables summarizing the results from your analysis. c. Charts/diagrams/plots you are using to visualise the data with appropriate headings and formatting. d. Screen shots from the Excel will be acceptable if it is clearly labelled and concise. e. A brief description of what you have discovered and how the decision making people can use this information to add value to their business 1. You should provide THREE (3) insightsbased on your data sets. You will be looking for relationships between attributes in the data set that can help you understand the company's products, customers, sales and or any other aspects. 2. You are expected to demonstrate your ability to use the following functions appropriately: Sorting, Filtering, Subtotals, IF, Countl F, Averagel F, Pivot Tables and others. 3. Your analysis may not support using all the listed functions. However, your team will be marked on the sophistication of the analysis and the appropriateness of the tools being used. 4. You and your team are expected to create some professional chart(s) for each insight to communicate the results of your analysis. The charts should help to interpret our results and conclusions. 5. For each insight, the report of your data analysis will include: a. A statement about what you are trying to discover. b. Tables summarizing the results from your analysis. c. Charts/diagrams/plots you are using to visualise the data with appropriate headings and formatting. d. Screen shots from the Excel will be acceptable if it is clearly labelled and concise. e. A brief description of what you have discovered and how the decision making people can use this information to add value to their business

Answer rating: 100% (QA)

Insights from Rosetta Stone Data Insight 1 Identifying HighGrowth Markets a Objective To identify markets with the highest potential for future growth based on historical sales performance b Analysis ... View the full answer