Bloom's Taxonomy-Accountants skills - Answers create
evaluate
analyze
apply
understand
remember
where accountants must play - Answers create
evaluate
analyze
where machines excel - Answers apply
understand
remember
create - Answers combining parts to make a new whole
evaluate - Answers judging the value of the information
analyze - Answers breakings down information into component parts
apply - Answers applying the facts, rules, concepts, and ideas
understanding - Answers understanding what the facts mean
remember - Answers recognizing and recalling facts
AMPS Model - Answers Ask the question
Master the data
Perform the analysis
Share the story
(back to beginning)
Data vs information - Answers Data is processed into information
, Data - Answers consists of facts and statistics about a person or object that are collected for
reference or analysis.
Structured data - Answers Excel spreadsheets
Relational databases
OLAP cube
Unstructured - Answers No specific schema
Schema typically set at query
Tends to be text heavy
Big date - Answers refers to extremely large and complex data sets
Small data - Answers is accessible, concise and workable or
is contained in a small device
Types of analytics - Answers descriptive, diagnostic, predictive, prescriptive
descriptive analytics - Answers what has happened
diagnostic analytics - Answers why did it happen
predictive analytics - Answers what is likely to happen
prescriptive analytics - Answers how should we act
Descriptive ex - Answers Use various functions in Excel to determine the age of accounts
receivable
Diagnostics ex - Answers Use variance analysis identifying expense accounts fluctuating +/-
10% from budget
Predictive - Answers Current trend in sales indicates next years sales will be $2 billion
Prescriptive - Answers Use machine learning to evaluate a new lease and appropriate
classification under GAAP
Characteristics of Useful Information - Answers Relevance
Faithful Representation (i.e., reliable/accurate)
Complete
Timeliness