Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how can i share the excel file pls. CEO of the Company Sample-Super store has assigned you the task to analyze the dataset Sample_superstore.xls and

image text in transcribed
how can i share the excel file pls.
CEO of the Company Sample-Super store has assigned you the task to analyze the dataset "Sample_superstore.xls" and present a report answering the following question using SAP Lumira Discovery 1. What are the Net Sales by Region? 2. What is the Net Sale by City? 3. What are the Gross Sales by Product? 4. What is the Total Profit so far? 5. What are the Profits by region? 6. What are the Profits by City? 7. What is the Profit by ATLANTA City for each year? 8. What is the Highest Sale by each Region? 9. What are the Number of customers in each region? 10. How many distinct categories and sub categories? 11. How many Shipments modes are used? 12. Find the Number of orders shipped using each shipment mode? 13. Find the No of orders shipped using each shipment mode each year? 14. Find Top 3 selling product? 15. Find the date highest sale was made? 16. Find the date lowest sale was made? Note: In addition to these questions each student should come up with 4 advanced meaningful analytics from the given database (The marks will be based the complexity of the graph)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The AICPA Audit Committee Toolkit Private Companies

Authors: AICPA

2nd Edition

1940235464, 978-1940235462

More Books

Students also viewed these Accounting questions

Question

What are two reasons for developing LANs?

Answered: 1 week ago