Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started