1/21
Looks like no tags are added yet.
Slice and Dice Data definition
slice - to focus on one value or category
dice - to apply multiple filters or dimensions
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
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
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
data profiling definition
the three-part process of investigating data quality, investigating data structure, and then deciding the next steps for the analysis
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
measure hierarchies - definiton
an information modeling pattern that is especially useful for creating financial ratios
measure hierarchies - examples in accounting
- gross profit percentage
- Canadian/US revenue ratio
integrated star schema - definition
an information modeling pattern that analyzes how inflows and outflows affect resources
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
integrated star schema - accounting application examples
- cash receipts to cash to cash disbursements
- fixed asset acquisitions to fixed asset to depreciation
who-what-when star schema - definition
an information modeling pattern that intergrates analysis of the who, what, and when transactions
who component of who-what-when star schema
internal agent and external agent
what component of who-what-when star schema
resource
when component of who-what-when star schema
calendar
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)
what table - defintion
a dimension table that describes the resources involved in a business transaction
who table - definition
a dimension table that describes agents involved in a business transaction data
when table - definition
a dimension table that describes when the data from the business transaction occurred
what table - example
product, merchandise
who table - examples
employee
when table - examples
calendar