Project | Accounting homework help

Project Sara.lolaHelp me with this question, is due by December 9th 11:59 PM CDT

• a year ago
• 150

Final Case Project – Big Superstores Student Case Handout – Preparing the Excel File

Overview

This case illustrates how an interactive dashboard can be built in Excel to analyze data. As you analyze this case you will gain a deeper understanding of the company’s sales and how this information can be used for decision-making. You will be using the interactive dashboard to answer several questions about a company’s sales. Read all the instructions in this document before starting the case. The terms “case” and “project” are used interchangeably throughout this document. Background This data set is based on retail sales transactions for Big Superstores. The data set contains more than 1,000 sales transaction records from 2023 (prior year) through 2024 (current year). Each sales record contains information on product, region, division, and more. All data and names are fictitious. You can assume each transaction listed is an individual sale. All customers have Net30 payment terms, and all transactions are sold on account regardless of distribution channel. All sales are taxable. Data dictionary In your data set, the following field names are used along with their description.