Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
42 Cards in this Set
- Front
- Back
billy beane method
|
analyze existing data differently
better performance models yield better decisions: - play acquisition - utilization of existing players |
|
emergence of management
|
prior to 1900 no pro. mgt.
today: pro. mgt. important for social functions (healthcare, education, welfare, econ, etc.); survival depends on good mgt. |
|
mgt. 1.0 instinct
|
mgr. as gunslinger
- gut feel decisions - company performance depends on mgt. talent - strict org. hierarchy rules |
|
mgt. 2.0 decisions
|
fact-based decisions
data-driven decision support systems (DDS): database , decision models, interactive and analytical modeling process decision support evolution: better data, models, tech.; pushed lower into org. |
|
mgt. 2.0 implications
|
reduced reliance on "superstar" mgrs.
DDS enables ordinary people to perform at extraordinary levels what we think vs. what we know competing on analytics |
|
competing on analytics
|
sophisticated IS and rigorous analysis applied across all company functions
development and maitinence of analytics capability is a primary focus fact-based decisions hire many people with good analytical skills metrics for evaluating key business processes share data and analysis with customers and suppliers small experiments to create a culture of "test and learn" |
|
retail industry -- IT-enabled changes
|
power shift to large retailers: from push to pull; bulk buying, economies of scale; closer to consumer; control of shelves and extended store chains; store brand recognition and acceptance
product proliferation: excess demand for shelf space; slotting fees; excessive mfg. prod. promotions integration of supply chain partners |
|
old retail process
|
build buyer relationship -- persuasion tactics to influence decisions -- purchase decision -- ind./ad-hoc decisions (shelf layouts, promotions) -- analysis of results (long lag time and high level aggregation)
|
|
new retail process
|
collect and share scanner info. with mfg. -- category review analysis -- reccomend mkt. mix strat. -- data driven strategy decisions -- analysis of results -- mfg. modifies promotion and mkt. strategy
|
|
retail performance review process
|
retailer strategy and positioning
growth and mkt. share analysis prod. mix/variety analysis reccommendations |
|
DDS process
|
database
decision models decision-maker insights interactive analytical modeling process |
|
DDS design principles
|
reliability: output is correct and consistent
auditability: user able to trace steps to generate output modifiability: easy to modify elegant simplicity: approp. degree of automation; approp. calc./processing method; NOT clever complexity |
|
DDS effectiveness test
|
purpose: goals, qualifications answered
data: type and qty./source calculations: parts calcuatlated, formulas used changes: easy to modify or change data |
|
structured process vs. ad hoc approach
|
ad hoc: good for simple model with few deliverables; small data set; BUILDER = USER
structured process (SDLC): good for complex model and system; may deliverables; large data set; BUILDER NOT USER |
|
DDS development process
|
design
build and test document |
|
DDS design - 4 step process
|
1. output - metrics, tables and graphs
2. processing logic - models to generate output metrics; excel tools and methods to populate output forms 3. data model - sources, structures, links 4. excel multisheet layout - what goes where in spreadsheets |
|
DDS design practices
|
goal - elegant simplicity
approach - art, NOT science process - iterate among 4 steps until design goal is met |
|
DDS design tips
|
work back from end product
catch and fix problems before the spiral out of control acid test: stranger must be able to replicate the analysis with new set of data without help from developer |
|
growth market share output forms
|
how to measure growth
how to measure market share how to compute for each group how to display results |
|
growth rate metrics
|
% growth rate for market - (sm05-sm04)/sm04
|
|
market share metric
|
market share = sp05/sm05
|
|
growth/mkt. share quadrant chart
|
mkt. share vs. growth rate %
|
|
variety product mix output form
|
how to measure variety
how to calculate variety for each group how to determine if prime has right mix how to display results |
|
variety index ratio
|
= # prime SKUs/# market SKUs
top 10 bottom 10 comparison - 10 SKUs with lowest sales - 10 SKUs wit highest sales |
|
uses for spreadsheets
|
small simple databases
grid for drawing/flow charts financial models stat. analysis project management |
|
alt. methods for deliverable processes
|
brute force: sort, subtotals, averaged by groupings, copy and paste to output tables; output tables = data source
conditional calculation: sumif/averageif function pivot table: report, chart |
|
data model
|
how data is organized, represented, accessed
efficient and effective org. of data: principles tempered by requirements of excel based DSS |
|
database
|
collection of tables that organize and store related information
|
|
table
|
lists of rows and columns containing info. on a subject
|
|
columns
|
field or attributes on subjects
|
|
rows
|
instances for each attribute
|
|
data design principles
|
minimize redundancy -- duplicate info. wastes space, increases likelihood of errors
efficient use of storage space and processing capability ensure correct and complete info. -- analysis based on incorrect data leads to bad decisions |
|
good database design
|
info. divided into subject based tables to reduce redundancy
tables can be linked together to retrieve data accuracy and integrity of info. data model of ind. analysis and processing requirements |
|
DBMS design process
|
purpose: range of expected uses
sources: identify and collect required data divide info. into tables: each major entity becomes a seperate table define columns/fields for each table: info. attributes assoc. with each entity/subject set-up table relationships: common fields link records across tables |
|
DBMS vs. excel DSS
|
DBMS: linked tables consolidated through queries; field structure based on subject attribute relationships apparent in the data
excel DSS: fewer tables; info. compared in single table; field structure based on analysis reqs. for grouping and filtering; excel influence data model design |
|
growth issues
|
tend to either grow or decline
steady state declining relative to competitors that are growing investors reward growth growth masks mistakes |
|
mkt. share issues
|
econ. of scale advantage
brand recognition - go with best leverage with suppliers correlated with LT profitability |
|
calculation method -- pivot table
|
convert growth/mkt. share data to excel table
select field by groups, categories, brands select data fields - growth rate, mkt. share, sales change fields and views for what if analysis refresh tables to look at updated data |
|
quadrant charts
|
plot growth-mkt. share results as quadrant bubble charts
purpose: facilitate interpretation through visualization; 4 quads. = benchmarks to eval. results |
|
quad. chart midpoint selection criteria
|
choose midpts. for x and y axis that yield most meaningful comparison of the bubble positions in the chart based on overall goal of analysis
look for benchmarks for x and y vars. that provide best context for comparison of data plotted choose measure broader than the data plotted - overall competitors - stores in chain as benchmark for store performance |
|
product mix
|
important factor in shopping choice
important in space constrained environment source of differentiation and competitive advantage |
|
marketing mix elements
|
price
promotion dist. product |