Question: Part 1(70%) Using the software Public Tableau, and the attached Excel sheet, visualize data by creating the following sheets: Sheet 1: Sales by Category and

Part 1(70%) Using the software Public Tableau, and the attached Excel

Part 1(70%) Using the software Public Tableau, and the attached Excel sheet, visualize data by creating the following sheets: Sheet 1: Sales by Category and Sales by Segment (15\%) Sheet 2: Profit Ratio by City (15\%) Sheet 3: Profit Ratio by Geography (15\%) Sheet 4: Build a Dashboard (25\%) Part 2(30%) Based on the Dashboard built, answer the following questions (in BBL): Question 1: Analyze the sales by segment and recommend the best strategy to increase the sales (10%) Question 2: Analyze the profit ratio by city and predict the profit ratio for the 2023 and 2024(10%) Question 3: Analyze the impact of sales by segment on profit Ratio by geography (10\%) Part 1(70%) Using the software Public Tableau, and the attached Excel sheet, visualize data by creating the following sheets: Sheet 1: Sales by Category and Sales by Segment (15\%) Sheet 2: Profit Ratio by City (15\%) Sheet 3: Profit Ratio by Geography (15\%) Sheet 4: Build a Dashboard (25\%) Part 2(30%) Based on the Dashboard built, answer the following questions (in BBL): Question 1: Analyze the sales by segment and recommend the best strategy to increase the sales (10%) Question 2: Analyze the profit ratio by city and predict the profit ratio for the 2023 and 2024(10%) Question 3: Analyze the impact of sales by segment on profit Ratio by geography (10\%)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Create a cost-volume-profit (CVP) graph based on the company's existing commission-based compensation scheme for its sales representatives: - Double click on "new sheet" at the bottom of the workbook...

Need ONLY an answer to Part C, step 1, questions 1 and 3. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company Assigned to you Find the most...

September 24, 2016 $ Apple Inc. CONSOLIDATED BALANCE SHEETS (In millions, except number of shares which are reflected in thousands and par value) September 30, 2017 ASSETS Current assets Cash and...

Aldorado Aldorado Company is a wholesale whominum distributer which has alusi in carload lots and wills to several thousandumises. The nature of the aluminum business requires that the company...

Myob software required Note: background information at the bottom (starting form page 10) PART 1: Self-Reection 10 Marks do this rt last This reflection asks students to attend to the following two...

How do you get $5145 cash balance? How do you do the bank reconciliation? Which journal entries must be adjusted? I have attached the assignment part B and my excel general journal (no need to use...

NOTE: USE $2,500 AS ENDING INTRA-COMPANY INVENTORY IN THE BOOK IN CHAPTER 5, THERE IS A COMPREHENSIVE EXAMPLE FOR A CONSOLIDATED FINANCIAL STATEMENTS FOR A DOWNSTREAM SALE LESSON 5-2/5-3 Part 1 :...

pls help solve it all Pre-Assessment Checklist: Task 3 - Project The purpose of this checklist The pre-assessment checklist helps students determine if they are ready for assessment. The...

My chosen company is Adobe ! I have to create a training strategy to address the company needs. I am having trouble figuring out how to actually create the Training or Intervention Strategy. I have...

Need the answer to Part C question only questions regarding the Step 2 - 7th question. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company...

As a supervisor, you notice that one of your employees is consistently clocking out late resulting in overtime. The hospital has a strict policy that all overtime must be approved in advance. The...

While hiking after school one day, you came across several plants that you werent familiar with. You took a leaf sample from each, and went back to the lab and did a stomata density count. Using a...

You purchase Firm A July 1 2 0 call contract ( equaling 1 0 0 shares ) for a premium of $ 5 from a market maker. You hold the option until the expiration date, when Firm A stock sells for $ 1 2 3 per...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".