Spreadsheets are useful for many other things besides financial tasks, such as progress reports and for keeping track of descriptive data. For your final project and presentation in this course, you will create at least two tables and an accompanying graphic that will help you write functions and learn simple programming techniques using advanced Excel features. This assignment gives you the opportunity to demonstrate the knowledge you have gained by using real-world data and applying at least five features of Excel to your dataset.

Similar to the work you completed for your weekly assignments, you will need to locate real-world data. For this assignment, you will need to locate and utilize large datasets. Please find attachment of dataset I choose.  it shows The growth of supermarkets in most populated cities are increasing and market competitions are also high. The dataset is one of the historical sales of supermarket company which has recorded in 3 different branches for 3 months data. Predictive data analytics methods are easy to apply with this dataset

In an 8-10 page report:

  • Provide an introduction to your      overall project
  • Give a rationale and      explanation for the datasets you have chosen
  • Include at least two tables      demonstrating your data and analysis
  • Create at least one graphic to      visualize the data and your analysis
  • Explain how you have analyzed      the data using at least 5 Excel functions
  • Give a thorough analysis of the      data and it’s implications not only for the organization but also the      industry in which the organization operates.
  • Offer any closing thoughts      about the data and the overall project

Your report should be 8-10 pages, not including cover and reference pages. Provide at least 5 outside references and use APA format.

Data Analytics