Compare various descriptive analysis methods

Assignment Help Other Subject

Reference no: EM133777545

You are working as a business analyst for XYZ, a regional restaurant chain. Recently, your organization was acquired by ABC, another restaurant chain. The joint leadership team of the newly formed business needs to create a profitable three-year plan. They will look to your analysis to inform this plan, given that neither company has any analysis of its own. You will be the first analyst to look at the data of the newly formed business.
Both restaurant chains operate out of multiple locations, sell direct to consumers, and are fast-casual restaurants. However, they offer distinct products that cater to different customer bases. You need to provide a descriptive analysis of what the new joint customer base looks like and how that compares in terms of the demographics of the geographic regions they are now selling in, now that they are a single entity with locations in different geographical regions than their home base.

Your final product will be a suite of visualizations that explain to the joint leadership team the current state of this newly formed business, the customer profiles of the new organization, and the products that have historically sold best and worst and are the most and least profitable. Finally, you have been asked to compare the customer profiles to the regional demographics where the newly formed restaurant chain has locations. Using your analysis, the joint leadership team will craft a three-year plan to make the company profitable within the fast-casual industry segment, which is notorious for being competitive.

You may use the following information about the organization:

ABC-XYZ Data Sets: These data sets were given in Milestone One. One sheet contained customer and sales/product data from the ABC restaurant chain prior to the merger. The second sheet contained customer and sales/product data from the XYZ restaurant chain prior to the merger.

Stakeholder Requirements: This is a Word document with requirements from various stakeholders.

In Milestone One, you cleaned and merged the data sets. In this milestone, you will analyze and identify stakeholder requirements. You will also compare various descriptive analysis methods, conduct a k-means cluster analysis, produce summary statistics, and present the findings on the merged data set. You will complete these activities using Tableau in the VDI.
Prompt

In Milestone One, you cleaned and transformed the data sets. You will now, use your cleaned, transformed and merged data set in this milestone activity. Please ensure that you have made the necessary updates to get an error-free data set before you start using this in this milestone activity.

Using the cleaned and transformed dataset from Milestone One, you will run the data through descriptive analysis models in Tableau and suggest ways to address the stated business problems.

Specifically, you must address the following rubric criteria:
Using the Stakeholder Requirements Document, identify stakeholder requirements.

How will these requirements shape your analysis? Explain.

Compare various descriptive analysis methods.

Compare and contrast a k-means cluster analysis method to at least two of the following models:

Regression

Decision tree

Reference no: EM133777545

Questions Cloud

Write an essay that includes an introduction paragraph : Write an essay that includes an introduction paragraph, the essay's body, and a conclusion paragraph to address the assignment's guide questions.

Describe functions and management of electronic : Describe functions and management of electronic patient records, reporting, and business processes.

What did you learn about yourself and your process : What did you learn about your topic? What did you learn about yourself and your process? What questions did you want to explore but didn't

Why studying the development of rock music is important : In the text box below, explain the reasons why studying the Development of Rock Music is important to your overall WMU undergraduate education.

Compare various descriptive analysis methods : How will these requirements shape your analysis and Compare various descriptive analysis methods.

How will these requirements shape your analysis : Using the Stakeholder Requirements Document, identify stakeholder requirements. How will these requirements shape your analysis? Explain

Describe the safeguards that were put in place to prevent : Describe the safeguards that were put in place to prevent abuses in state-funded facilities - Do you think enough was done to prevent abuse in the name

Explain three company benefits of collecting customer data : Explain three or more company benefits of collecting customer data. Explain what type of customer data the 3-D printing company should collect and why.

How would you conduct a target audience analysis : You are launching a new e-learning platform. How would you conduct a target audience analysis to identify the most promising market segments?

User Account

All Pages