Assignment:

$$ In this assignment, you will touch upon the first $2$ components of B$-$A$-$D$-$I$-$R$.$

$$ READ THE ACTIVITY#$2-$BADIR$-$SCENARIO provided to you in the Modules section of Canvas.

$$ You are to complete this Project Analysis Worksheet as part of your consulting work to help

Alex begin the process of making decisions on how to improve sales in his shoe store.

$$ In this worksheet you are establishing the basic research questions, positing related

hypotheses to test, suggesting possible sources of data and methodology to analyze to help

test the hypotheses and possibly answer the question. Be thoughtful and thorough in your

responses.

$$ Start with explaining the purpose of this data analytics project in the space provided.

$$ In the table, use the two provided examples as a starting point. Then provide five $(5)$

additional question$/$hypothesis$/$data line$-$items. Note that hypothesis statement should be

answerable by True $/$ False or Yes$/$ No; so that you can use data to prove or disprove the

hypothesis.

$$ Select from the $7$ possible methodologies covered in class to identify your next steps using the

data you will collect.

$$ When you are done with your examples, post your completed worksheet to the Activity #$2$

Assignment Folder in Canvas as an MS Word document.

Some sample examples of data sources but be creative and think of other data sources that would

be useful:

$$ Internal sales data

$$ Industry Reports on consumer trends & brand preferences

$$ Supplier data $($such as a Nike or Adidas sales report$)$

$$ Consumer sales data purchased from third party database marketers $($such as Google$)$

$$ Customer surveys

$$ Competitors$$ published reports $($Large chain stores$$ annual reports$)$

$$ Government data $($such as Consumer Spending reports$)$

$2$

Project Analysis Worksheet

Project Name: Alex Shoes

Purpose of Analysis: $[$Briefly explain what is the business need for this data analysis

project$]$

Data needed to research

the hypothesis$*$

Give $2-4$ possible data

sources for each

hypothesis. Be thoughtful

and as thorough as

possible. Do not be

repetitive.

Business$-$question Possible hypothesis that can be

researched with data

$($Statement should be answerable by

True$/$False$)$

Suggested Analysis

Methodology

$$ Internal sales data,

$$ Town census data

$$ Historical

Transactional data

$$ Marketing

strategy $$ target

customers

EXAMPLE

$(1)$ We need to define our

target demographics

better.

$$ Our target customers live

within $10$ mile radius

$$ Our target customers are $40$

years and under

$$ Our target customers are

majority female

Methodology:

$-$ Segmentation

EXAMPLE

$(2)$ We need to get a better

understanding of what

the younger shoe$-$buyers

care about e$.$g Style,

color, price, brand,

quality.

$1)$ Young buyers $(20$ and under$)$ are

brand and style conscious

$2)$ Young buyers $(20$ and under$)$

would like more color choices

$$ Internal sales

transaction data

$$ customer survey

to collect

birthdays $($to get

ages$)$

$$ Research data on

industry fashion

colors and styles

$3$

$$ Research data on

marketshare of

top selling brands

Methodology:

$-$Aggregate

analysis

$-$ Correlation

Analysis

$(3)[$complete$]$

$(4)[$complete$]$

$(5)[$complete$]$

$(6)[$complete$]$

$(7)[$complete$]$