ACC 638 short answer questions ch5/6

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/21

encourage image

There's no tags or description

Looks like no tags are added yet.

22 Terms

1
New cards

Slice and Dice Data definition

slice - to focus on one value or category

dice - to apply multiple filters or dimensions

2
New cards

Slice and Dice Data - analytical perspective - how to

Select one primary variable to isolate a subset of your data and then add a second, third, or fourth variable to narrow your view further and cross-examine interactions

3
New cards

Flat vs Crosstab Tables - Structural difference

flat tables have column headers that do not contain data values useful for analysis purposes, while crosstab tables have column headers that do

4
New cards

advantage of flat table over crosstab table

since flat tables have column headers that do not contain data values useful for analysis purposes, the data can be used for filter and group-by operations

5
New cards

data profiling definition

the three-part process of investigating data quality, investigating data structure, and then deciding the next steps for the analysis

6
New cards

data profiling - purpose and importance in data analysis

helps identify missing values, duplicates, inconsistent formats, invalid values, unusual outliers, and relationships between fields. it helps decide whether data is reliable and what cleaning or transformation is needed

7
New cards

measure hierarchies - definiton

an information modeling pattern that is especially useful for creating financial ratios

8
New cards

measure hierarchies - examples in accounting

- gross profit percentage

- Canadian/US revenue ratio

9
New cards

integrated star schema - definition

an information modeling pattern that analyzes how inflows and outflows affect resources

10
New cards

integrated star schema - when to use

when you need to analyze and cross-reference data across multiple distinct business processes or fact tables using a single, unified set of definitions

11
New cards

integrated star schema - accounting application examples

- cash receipts to cash to cash disbursements

- fixed asset acquisitions to fixed asset to depreciation

12
New cards

who-what-when star schema - definition

an information modeling pattern that intergrates analysis of the who, what, and when transactions

13
New cards

who component of who-what-when star schema

internal agent and external agent

14
New cards

what component of who-what-when star schema

resource

15
New cards

when component of who-what-when star schema

calendar

16
New cards

who-what-when star schema - example analytical question

What is the total quantity sold (measure) per category (what dimension) during weekends (weekday)(when dimension) to male (gender) customers living in the Mid-Atlantic region (who dimension)

17
New cards

what table - defintion

a dimension table that describes the resources involved in a business transaction

18
New cards

who table - definition

a dimension table that describes agents involved in a business transaction data

19
New cards

when table - definition

a dimension table that describes when the data from the business transaction occurred

20
New cards

what table - example

product, merchandise

21
New cards

who table - examples

employee

22
New cards

when table - examples

calendar