Create a report that presents the data using visualization

Assignment Help Computer Engineering

Reference no: EM133801414

Assignment: Data visualization

Overview

You are a business analyst for an organization that distributes pizza ingredients to various restaurants. These ingredients include dough, sauces, and toppings. Your organization wants to expand its customer base but does not know what kind of restaurant or which U.S. region to target. You have been given a Clean Customer Sales Data Set that is a representative sample of the sales at your customers' restaurants for 2015 and 2016. This also contains household income data for the restaurant zip codes.

You must analyze this data to help inform marketing decisions. To begin, you must analyze and visualize the given data. You will use Power BI to complete these tasks and understand the relationships and patterns within the data set.

In Module One, you identified some stakeholder requirements and performed data wrangling to clean, transform, and merge the two data sets. In this assignment, you will begin your data analysis by employing visualization techniques on the given data. The resulting visual representations of the data will illustrate the trends and patterns within the data and help organizations forecast and plan better.

Prompt

Create a report that presents the data using visualization techniques best suited for the types of data included in your data set. Include the relevant screenshots of your data visualizations in the report.

Specifically, you must address the following rubric criteria:

A. Visualize and Identify Outliers: Visualize and identify any outliers in the data set using an appropriate graph.

a. If appropriate, identify the twenty-fifth and seventy-fifth percentiles and the median.

b. Investigate any cases that show up as outliers and validate that the outliers are not mistakes in the data; make a note of them and describe what influence they may have on the analysis.

B. Data Visualization: Use appropriate visualization techniques to generate graphs for using various variables (column attributes). Describe the trends and patterns these graphs depict about the data.

a. Generate a graph to visualize the trend in the number of orders placed in a day.
b. Generate a graph to visualize the trend in the number of orders placed according to the order time.
c. Generate graphs to show the number of orders placed according to times of day, restaurant categories, cities, zip codes, and states.
d. Generate graphs that show the times during which there are more and fewer orders.
e. Generate graphs that show the amount spent on pizza.

C. Rationale: Justify your choice of visualization technique for each of the above graphs.

a. Are there any additional variables that you think will help uncover more patterns and trends in the data set? Explain.

i. Which visualization techniques will you choose for these variables?

Reference no: EM133801414

Questions Cloud

Design the analogue butterworth filter prototype : ENG3049-N Digital Control and Instrumentation, Teesside University - Design the analogue Butterworth filter prototype for the high-pass filter and convert

Who originally came up with the term gilded age : Explain why the period between 1870 and 1900 is known as the Gilded Age. Who originally came up with the term, Gilded Age?

Endangering the welfare of child charge : Consider a defense argument against an endangering the welfare of a child charge in a case where police seized a dog based upon the living conditions

Which zip codes appear to more or less likely to profitable : Does the data indicate particular day of the week or month of the year that sees more orders? Which zip codes appear to be more or less likely to be profitable?

Create a report that presents the data using visualization : QSO 560- Create a report that presents the data using visualization techniques best suited for the types of data included in your data set.

Describe the options in sentencing process : Describe the options in the sentencing process. Describe how a judge determines an appropriate sentence.

What financial figure do you believe was the determinant : What financial figure do you believe was determinant to your decision and why? How you be able to apply this particular financial information to other situation

What are provisions the attorney must prove : What are the provisions the attorney must prove? Please discuss the strengths/weaknesses of the above facts as they relate to the Violation requirements?

Define the parties involved directly and indirectly : Define the parties involved directly and indirectly in the supply chain and their role in the smooth running of the business.

User Account

All Pages