Jul 16, 2017

Analysis of the Data

This paper concentrates on the primary theme of Analysis of the Data in which you have to explain and evaluate its intricate aspects in detail. In addition to this, this paper has been reviewed and purchased by most of the students hence; it has been rated 4.8 points on the scale of 5 points. Besides, the price of this paper starts from £ 40. For more details and full access to the paper, please refer to the site.

Analysis of the Data


You are working as a data analyst for the Excellent Consulting Group. Your client, Buddy’s Floor Barn, wants to analyze how they are doing in their 18 locations in four regions across their 10 product lines over the last 3 quarters. Each Regional Manager has compiled the data for his/her region showing the sales revenue for each of the five product lines (premium flooring) for each of the first three quarters.

Case Assignment

Assemble the data from each Store Manager into a data table in list format. And then generate Pivot Table Report. Use this report to analyze the data to answer Buddy’s questions. Write a business report to Buddy’s Floor Barn that provides the answers and discusses the issues.

Data: Download Case 1-Data.xlsx with the data from the four regional managers for the first three quarters showing sales of their five premium flooring products.

Assignment Expectations


  • Accurate and complete analysis in Excel using the MADM model and theory.

Written report:

  • Accurate and complete review of the situation.
  • Accurate and complete discussion of the analysis.
  • Accurate and complete Recommendation
  • Accurate and complete explanation of the rationale and logic.

STEW-MOD1-CASE-520 Student: Institution: Analysis of the data The MADM model and theory is used to analyze on the given data. The abbreviation refers to Multiple Attribute Decision Making. It is a theory used by organization in order to analyze on the sales of products and hence evaluate on the performance over a certain period of time. Through this analyses that are carried out an organization can be able to asses itself as it can be able to make out on its strengths, weakness, opportunities and threats. The following is an analysis of the four managers in the different regions of the organization. Table Q1Q2Q3TotalEast940, 349770,806889, 1072,620,256South1,019,4371,066,1111,074,3133,159,861Mid states956,056870,157874,1432,700,356West 1,081,945


100% Plagiarism Free & Custom Written,
Tailored to your instructions

International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120

100% Pass Guarantee

Order Now


We've produced some samples of what you can expect from our Academic Writing Service - these are created by our writers to show you the kind of high-quality work you'll receive. Take a look for yourself!

View Our Samples

FLAT 25% OFF ON EVERY ORDER.Use "FLAT25" as your promo code during checkout