Tableau Assignment 10_23 Deliverable (1)

docx

School

Northern Illinois University *

*We aren’t endorsed by this school

Course

310

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by BarristerMinkMaster1031

Report
Tableau Assignment ACCY310 Question 1 Which customer charged the largest total dollar amount for credit purchases in 2022? Clover Grocery received the largest total dollar amount for credit purchases in 2022. The 2 visualizations below support this answer. The horizontal bar chart visualizes the answer a lot better because you can easily see how much more Clover Grocery sold than the other customers and it’s not even close with Clover Grocery coming in at $186,442 whereas the next customer, Urban Fresh Grocers, has only $127,694 worth of sales. Question 2 Which state had the largest total dollar amount of credit sales in 2022? New York had the largest total dollar amount of credit sales in 2022. The 2 visualizations below support this answer. The highlight table shows a much easier and more digestible graphic as opposed to the map. It looks nice but could be a bit more confusing or hard to interpret at first. Question 3 What was the balance for Accounts Receivable on December 31, 2022? The balance for Accounts Receivable on December 31, 2022 was none. The visualization below supports this answer. I could not find the answer with the
fields given. No matter what value you put it in keeps spitting out an error or the wrong information needed Question 4 What was the total dollar amount of invoices sent to customers in March 2022 and paid by customers in July 2022? The total dollar amount of invoices sent to customers in March 2022 and paid by customers in July 2022 was $17,259. The 2 visualizations below support this answer. The stacked bar chart represents this way better than the horizontal bar chart because it actually shows the total amount that was sent on the specific day added up rather than all of the amounts from the different customers side by side. Own Question What is the percentage of sales from a chain or single-store business in 2022? 42.97% of the sales are from a single-store business and 57.03% of the sales are from a chain business. The visualization below supports this answer.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help