Downtown Office Supply

/in /by

Downtown Office Supply

Downtown Office supply is a small family owned store in a small suburb.  In order to maintain and grow the business the owners want to do some analysis to see how their sales are doing.  Management wants to see how the company did last year and make some decisions about what products to keep along with staffing for busy times of the year.

Instructions:  Use the excle spreadheet provided and import the data to Tableau.  Complete the tasks below.  Upon completion you will submit this word document with your screen shots attached along with your Tableau file  (.tbw).

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

  1. Open Tableau.
  2. Import the excel file – Final_Orders_Clean.xlsx.
  3. Create an innerjoin between market_fact table and the rest of the tables as shown below[ Hint: Drag and Drop the tables in the Data Source space]

  1. Double check your join statements to make sure the correct primary key and foreign keys are in place. [HINT:  order_id and ord_id]

  1. Click on “Goto Worksheet” at the bottom to insert a blank worksheet for your questions  For each question, take a screen shot of your visualization.  Be sure to save your Tableau file and upload the Tableau file along with a document including your screen shots.

10 points each

  1. Management wants to see how much is spent in Shipping Costs across the different Product Categories and Sub Categories for each Ship Mode. Add a new sheet titled Q1. Required Components: 1) A table with the Product Categories and Sub Categories listed. 2) Shipping Costs for each Ship Mode. 3) Color the Shipping Costs based on the Product Subcategory.  Using the same data, create a circle views chart.  Do you see any outliers  What are they?
 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"