Data Vizualization (1) (1)
.docx
keyboard_arrow_up
School
University Canada West *
*We aren’t endorsed by this school
Course
601
Subject
Business
Date
May 14, 2024
Type
docx
Pages
12
Uploaded by SuperHumanWasp4238
1
Data Visualization and story telling-Teamwork
BISTA, Mamta
Dua, Saloni
Narvaez Fraga, Jennifer Liliana
Velasquez Orjuela, Annie Carolina
University of Canada West
BUSI 650
Razi Bayati
09-03-2024
2
Abstract
The report that we present below contains the analysis of the behavior of data provided on the sale of office supplements in 2 years in some cities in the United States, we proceeded to evaluate all the variables that can influence the good performance of this business, as well as the behavior of sales, profits and other data relevant to the commercial activity of this company.
3
Data exploration
The exploration of the data set was carried out from the shared Excel that refers to the behavior of a data set from an office supply store. During the explain phase, we look at the data to understand its structure, identify some potential problems, and get a sense of the patterns and trends that are already present.
We examined the structure of the data to understand the information we had available, we
checked the data types in each column.
We define the main variables in the data set to be: order ID, order date, product category, sales, and profit.
Let's visualize distributions: to visualize the distribution of numerical variables and identify possible outliers and important patterns.
Figure 1
Exploring Data to Tableau
Data Cleaning
4
We treat missing values: We find and treat any missing values in the data set, either by removing corresponding rows such as years of purchase and some characters from zip codes.
Fixed formatting errors: To ensure that columns containing dates, currencies, and other formatted data types are in the correct format
We remove duplicates: To avoid counting the same observation twice in our analyses, we
search for and remove any duplicate rows in the data set.
We standardize values: To ensure consistency, we standardize values if there are values that represent the same thing, but are expressed differently.
Figure 2
Data Exploration in Excel
Data modeling
5
To ensure that the data was complete and accurate, we focused on establishing clear connections between the various tables during the data modeling process.
Variables and relationships analyzed
Sales trends by region : We can analyze how sales vary in different areas and if there is any area that has a higher number of sales.
Product Performance: We can examine which products have the highest sales and profits, as well as which products have the lowest performance.
Analysis of the profit margin of the products. We can divide customers into groups based on how they shop and determine how they differ in terms of sales and profits.
Primary and foreign keys:
Primary Key: In the Super Store data set, the primary key could be " Order ID". Each order has a unique ID associated with it that identifies it.
Foreign Keys :
" Order ID" could be a foreign key in other tables in additional information such as: shipping details or payment details.
" Product ID" could be a foreign key if there is detailed information about the products in
another table.
Data Visualization Analysis
Next, we will review the relationship analyzes in graphical form Using Tableu
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
3 Issues in Business Analytics that has concerns to Ethics
arrow_forward
explain how alternative method of sampling used in the process of gathering data to support decision making
arrow_forward
Please provide 3 research problems for this question
An investigation on parental involvement in their children's education and its influences on their academic performance at charlton Primary in Jamaica.
arrow_forward
Summarize the differencesbetween secondary data andprimary data.
arrow_forward
Construct a questionnaire comprising 6 questions regarding demographic aspect of respondents, 5 questions on dimension of any business issue you want to study and 5 questions of 5-point scaling pattern on the influencing factors of chosen business issue that you are studying through questionnaire.
arrow_forward
* Hame
Gradebook
Week 1 actice Asignmet-x
O ttps//appmyeducator.com/counelactivity.t/1844/270721506109441/
Which of the following is A curent trend in consumer behavior
Decreased customer need for accessing information prior to a purchase
OIncreased consumer reluctance to share data with businesses they interact with
O Availablity of premium options for devoted and loyal customers of a business
The need to create a seamless user experience on an easy to-use company website
Which of the folloving describes the form of data Kantar may present to marketers?
Ut providesa qualitative and quantitative segmentation opproach that oncovers the functional, sociall and emotional drivers of consumer behvior within a
given market.
Ditves companies a major presence on social networking sites as this alows them to interact with their current and potensal consumers in new ways
On stresses the subjective meaning of the consume's individual expertience and the idea that any behavior is subject to mutple…
arrow_forward
list 5 types of quantitative data analysis methods, pros and cons of each method
arrow_forward
1. Give a specific example and scenario in Hospitality Industry that we can apply the
Data Analysis Cycle.
Identify the
Problem
Identify
Available Data
Sources
Identify if
Additional Data
Sources are
needed
Statistical
Analysis
Implementation
and
Development
Communicate
Results
Maintenance
arrow_forward
Examples of Purposive Sampling1. A diaper company intercepts any shopper buying diapersin a supermarket to determine their preference in buyingdiapers.
Are the results of these surveys reliable and unbiased?Can we generalize the results for the entire population?
2. PCSO conducts customer satisfaction surveys andinterviews the people lining up to apply for financialassistance.
Are the results of these surveys reliable and unbiased?Can we generalize the results for the entire population?
arrow_forward
Om2.
What is meant by participant observation? What are the Types of data generated by the participant observation and their advantages and disadvantages?
arrow_forward
What is producivity analysis? What is prescriptive data analytic model? How are the two related or how are they different? Give example of each.
arrow_forward
Contrast the planning approach when dealing with data certainty verses uncertainty
arrow_forward
In Traditional Survey Reseach, elaborate what are;
1. Nonresponse Bias
2. Refusal rate
3. Response Bias
arrow_forward
Explain the following terms as used in research
i) Dependent variables
ii) Independent variables
iii) Moderating variables
iv) Mediating variables
v) Extraneous variables
arrow_forward
Make a scatter plot of the data and determine which type of model best fits the data.
linear
quadratic
exponential
square root
arrow_forward
Explain the folllowing:
coding the data,
identifying themes,
interpreting the data
arrow_forward
Define business analytics (BA)
arrow_forward
“Psychological effects of Covid-19 and Older Persons of District Islamabad: An Anthropological Perspective”
a) Select one sampling technique and justify your selection.
b) Choose one data collection method for your research Topic. And explain how will it be appropriate for authentic/accurate data?
arrow_forward
List two (2) advantages and Two (2) disadvantages of the Observation Method of datacollection.
arrow_forward
Do Porter's published recommendations include any specific sorts of gathered data?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Related Questions
- 3 Issues in Business Analytics that has concerns to Ethicsarrow_forwardexplain how alternative method of sampling used in the process of gathering data to support decision makingarrow_forwardPlease provide 3 research problems for this question An investigation on parental involvement in their children's education and its influences on their academic performance at charlton Primary in Jamaica.arrow_forward
- Summarize the differencesbetween secondary data andprimary data.arrow_forwardConstruct a questionnaire comprising 6 questions regarding demographic aspect of respondents, 5 questions on dimension of any business issue you want to study and 5 questions of 5-point scaling pattern on the influencing factors of chosen business issue that you are studying through questionnaire.arrow_forward* Hame Gradebook Week 1 actice Asignmet-x O ttps//appmyeducator.com/counelactivity.t/1844/270721506109441/ Which of the following is A curent trend in consumer behavior Decreased customer need for accessing information prior to a purchase OIncreased consumer reluctance to share data with businesses they interact with O Availablity of premium options for devoted and loyal customers of a business The need to create a seamless user experience on an easy to-use company website Which of the folloving describes the form of data Kantar may present to marketers? Ut providesa qualitative and quantitative segmentation opproach that oncovers the functional, sociall and emotional drivers of consumer behvior within a given market. Ditves companies a major presence on social networking sites as this alows them to interact with their current and potensal consumers in new ways On stresses the subjective meaning of the consume's individual expertience and the idea that any behavior is subject to mutple…arrow_forward
- list 5 types of quantitative data analysis methods, pros and cons of each methodarrow_forward1. Give a specific example and scenario in Hospitality Industry that we can apply the Data Analysis Cycle. Identify the Problem Identify Available Data Sources Identify if Additional Data Sources are needed Statistical Analysis Implementation and Development Communicate Results Maintenancearrow_forwardExamples of Purposive Sampling1. A diaper company intercepts any shopper buying diapersin a supermarket to determine their preference in buyingdiapers. Are the results of these surveys reliable and unbiased?Can we generalize the results for the entire population? 2. PCSO conducts customer satisfaction surveys andinterviews the people lining up to apply for financialassistance. Are the results of these surveys reliable and unbiased?Can we generalize the results for the entire population?arrow_forward
- Om2. What is meant by participant observation? What are the Types of data generated by the participant observation and their advantages and disadvantages?arrow_forwardWhat is producivity analysis? What is prescriptive data analytic model? How are the two related or how are they different? Give example of each.arrow_forwardContrast the planning approach when dealing with data certainty verses uncertaintyarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios