Exam 1 Flashcards
1
Q
What is Bloom’s taxonomy
A
a hierarchical view of critical thinking skills
2
Q
Where do accountants play a role in blooms taxonomy
A
Create, Evaluate, Analyze
3
Q
Where do machines excel in blooms taxonomy
A
Apply, Understand, Remember
4
Q
What is the order of Blooms Taxonomy
A
Top to bottom
Create
Evaluate
Analyze
Apply
Understand
Remember
5
Q
What is the definition of create
A
combining parts to make a new whole
6
Q
what is the def. of evaluate
A
judging the value of info or ideas
7
Q
what is the def. of analyze
A
breaking down info into component parts
8
Q
what is the def. of apply
A
applying the facts, rule, concepts and ideas
9
Q
what is the def. of understand
A
understanding what the facts mean
10
Q
what is the def of remember
A
recognizing and recalling the facts
11
Q
What part of blooms taxonomy does the basic accounting curriculum address
A
remember, understand and apply
12
Q
what part of blooms taxonomy does data analytics cover
A
the higher-order thinking skills (analyze, evaluate and create)
13
Q
True or false… Accountants simply cannot analyze, evaluate and create if they do not already have the basic accounting knowledge and understanding required by the lower- level skills of remembering, understanding, and applying levels of critical thinking mastered.
A
True
14
Q
What is the AMPS model
A
Ask the question
Master the Data
Perform the Analysis
Share the Story
15
Q
What happened? What is happening?
is what type of analytics
A
Descriptive Analytics
16
Q
Why did it happen? What are the root causes of past results?
is what type of analytics
A
Diagnostic Analytics
17
Q
Will it happen in the future? What is the probability something will happen?
Is what type of analytics
A
Predictive Analytics
18
Q
What should we do, based on what we expect will happen?
A
Prescriptive Analytics
19
Q
Your Data wont speak unless you ask it the right questions relates to what part of the AMPS
A
ask the right question
20
Q
what issues exist in data we want to analyze
A
- Can the data answer/address the question
- Does the data exhibit data integrity
- Does the data have errors
- Is data missing
- Is data biased
- What type of data is it
- What type of analysis does the data allow us to do
- Cost of acquiring vs. the benefit of using data
- Who owns the data
- Is the data hard to access
21
Q
When is a PivotTable good to use
A
summarize the A/R aging or post- J.E to trial balance
22
Q
When should a cash flow analysis be used
A
evaluate capital investments made by the firm or equity investments made by a potential investor
23
Q
when should a data visualization be used?
A
histograms and scatterplots might be used to help evaluate J.E that are excessively big or excessively small with the testing of internal controls
24
Q
When should a regression analysis be used
A
evaluate cost behavior by segregating total costs into fixed and variable cost components
25
What-If/Goal Seek Analysis
used to perform an analysis of how changing costs and other factors affect breakeven level for a new product
26
What is Benford's Law
might be used to find and evaluate unusual and potentially fraudulent transactions
27
What is the best way to report what we've found in our data analytics
Static/Dynamic Visualizations
28
What are examples of static visualization and what are they created for
one-off analyses...
- reports
- graphs
- tables
29
What are examples of dynamic visualization and what are they created for
updates on a continuous basis
- Dashboards
30
T/F 91% of people prefer visual content over written content
True
31
What are data Acquisition and Preparation Tools and what part of AMPS is it for
Master the Data
Excel (basic)
Alteryx
SQL (structured query language)
Tableau Prep
Power Query (PowerBI)
32
What are data analysis Tools and what part of AMPS is it for
Perform the analysis
- Excel, SAS, SPSS, Strat, R and Python
33
What are data visualization Tools and what part of AMPS is it for
Share the Story but can also be apart of perform the analysis
- Excel, Tableau, Power BI, word and powerpoint
34
What is SQL
a tool to prepare data for analysis and is used to access specific data from very large datasets
35
What tools analyze data interactively
Excel (basic analysis)
- Pivot Tables
-Data Analysis Toolpak
36
What do pivot tables do?
An Excel function that analyzes data interactively
good for summarizations, and also organizes data. Allows reorganization and summarization of data using crosstabulations without changing the underlying spreadsheet.
37
What do data analysis toolpaks do?
An Excel function that analyzes data interactively
- access to specific analysis techniques, including descriptive statics, histograms, correlation, and regression
38
What tools analyze data programmitcally
SAS, SPSS, Strata - software analysis tools that emphasize statistics
R and Python - programming software tool used to perform advanced data analysis
39
What is accounting data analytics
encapsulated as the technologies, systems, practices, methods encapsulated as the technologies, systems, practices, methodologies, databases, statistics, and applications used to analyze diverse accounting and nonaccounting data to give organizations the information they need to make sound and timely business decisions.
40
What data sources do we consider for analysis
- F.S
- Macroeconomic statistics
- Supply chain data
- Financial analyst reports
41
Finding what data is available to answer the question is part of what AMPS
master the data
42
What are the four V's
Volume
Velocity
Variety
Veracity
43
What are examples of volume? Four V's
Click stream, Log, Event, Speech, Social Media, Traditional
44
What are examples of velocity? Four V's
speed of generation, rate of analysis
45
What are examples of variety? Four V's
unstructured, semi-structured, structured
46
What are examples of veracity?
untrusted vs. uncleansed data
47
How would you rate a balance sheet that is reported for G M four times a year based on the four Vs of Big Data (Volume, Variety, Velocity, and Veracity)?
Variety
*Structured
Veracity
* Data quality
* Belter quality,(trusted)
* better conclusions
48
Where do we find accounting data
- Financial Statements
- General Journal/Ledger
- Financial Accounting-Related Data
- Managerial Accounting Data
- Tax Data
49
Financial Statements Include:
- B/S
-I/S
- Statement of Cash flows
- Statement of S.E
50
What details do General Journal/Ledger show?
- journal entries
- general ledger
- Fixed asset subledger
- Receivables subledger
- Inventory subledger
51
What are the various locations where financial accounting-related data could be found
- conference call transcripts
-press releases
- XBRL
- filing with securities and excuange comissions
- 10K - anual filings
- 10Q - quarterly filings
- 8K - report of material events or changes
52
what are conference call transcripts
a place where financial accounting related data is found
- CEO, CFO hold a chat to discuss quarterly results
53
what is XBRL?
a place where financial accounting-related data is found
standards-based way of exchanging business information between business systems
54
Standard cost data
allows variance analysis, comparing budget to actual
55
POS transaction data
all information from the sale
56
Potential cost drivers
all evaluation of best way to allocate overhead
57
Supply Chain Data
system which tracks products from vendor to final customer
58
Customer Relationship Management System Data
tracks everything about the customer
59
HR Management System Data
System which tracks all information regarding employees
60
What does tax data combine?
Internal and external data
61
In a company where does tax data come from?
Financial reporting system
62
where is tax information applicable to the tax function kep?
data warehouse or data mart
63
Does managerial accounting data comprise enterprise data from various sources
yes
64
can other non-accounting sources inform analyses
yes
65
what are examples of other non-accounting sources that can inform analyses
Economic data, current and historical stock prices, social media, and analyst research reports
66
Gross domestic product
a measure of economy-wide performances
67
unemployment numbers
a measure of labor availability
68
consumer price index
a measure of inflation
69
housing market starts and price levels
generally regarded as a key measure of economic status
70
What is economic data that can help identify trends in the market?
- gross domestic product
- unemployment #'s
- consumer price index
- housing market starts and price levels
71
what do social media and chat boards help us understand
sentitment
72
what do product reviews help determine
satisfaction and demand
73
What do analyst reports and earnings forecasts such as value line do
show trends
74
how are reading product reviews useful for predicting earnings
help predict financial information
75
What is categorical data
data represented by words and categorizes groups
75
What do pivot tables do
summarize data and is a tool that allows the reorganization and summarization of certain data without changing the underlying spreadsheet
76
what is numerical data
meaningful numbers
77
what is nominal data
type of categorical data that cannot be ranked
78
what are examples of nominal data
gender, transaction type, depreciation method
79
what is nominal data summarized by
counting and grouping
80
what is ordinal data
type of categorical data that can be ranked
81
what are examples of ordinal data
- gold bronze
- survey answers
- transaction dates
-
82
What is interval data
a type of numerical data where there is an equal interval between each observation
83
which type of data is able to be multiplied, summed and other complex numerical equations
interval data
84
what are examples of interval data
SAT scores
Farenheit Temperature
85
what is ratio data
type of numerical data, with equal and definitive ratio between each data point and absolute zerow
86
what are examples of ratio data
height, weight, accounting FS figures, kelvin temp scale
87
where would transaction type be summarized on a pivot table
Row feild
88
what would amount range be summarized on a pivot table
value feild
89
Is current depreciation a static number or a calc. field based on the passage of time
calc feild
90
is net book value a static or calc. field
calc field
91
How is time remaining to order calculated?
92
what is a data dictionary
a centralized repository of information about data containing a seperate record for each feild/variable in the table/database
93
what could be done with the coupon - should it be in product or sales database
both
94
what goes with the quote..."its data about data"
data dictionary
95
what is excels relative advantage
best at data analysis, has tools that create PT, graphs and performing stat. analysis
96
what is tableaus relative advantage
best for visualization, does not allow for orignal data entry
97
what is the relative advantage of databases
most secure way of storing data
98
what is the difference between a relational data base and data dictionary
relational database has multiple tables
99
what are the three components to a relational database
tables
feilds
records
100
tables definiton
data organized into sets of columns (fields) and rows (records)
101
fields defintion
descriptive columns that contain information about the observation in the table
102
records definiton
these are rows in a table, each record or row, corresponds to a unique instance of what is being described in the table
103
do feilds or records contain the foreign and primary key
fields
104
what is the primary key
unique identifier in each table
105
in the transaction table what is the primary key
transaction_ID
106
what is foreign key
exists to create a relationship or link between two tables
107
How do entity relationship diagrams represent database tables
graphically
108
what is an ER diagram
graphical representation of an information system and its relationship with events within the system
109
What are the internal controls that relational databases enable
-preventative controls
- security around data entry
- reduce redundancy and cut down error
- reduces the possibility of having more than one truth
110
How do relational databases enhance data integrity
- free from error
-complete
-neutral
111
what does ETL stand for
- EXTRACT data from sources
- TRANSFORM data into different data types
- LOAD data into other tools for further analysis
112
T/F excel allows analysts to query data from sources
T
113
T/F is is important to understand the frequency of refreshing data
T
114
T/F Tableau does not require access to another data source
F
115
Does Structured Query Language (SQL) enable filtered transaction
YEs
116
When do we want to use SQL
want to extract price columns and rows needed to answer the data analysis problems
117
SQL filters are...
SELECT feilds
FROM tables
WHERE filter (usually dates)
118
Can Excel pull data from the internet?
YES
119
