4.4 Data Structure & Standards Flashcards
Data Process Chain
Summarizes the different phases of the data-to-insight cycles, and indicates where accountants can create value;
How data is transformed into insights
Data Process Phases
- Data Discovery:
understand what is available and relevant - Data Collection:
extract, clean, integrate data - Information Model Building:
prepare for analysis - Analytics:
create powerful interactive dashboards (identify insights) - Problem Solving:
make decisions
Data Structure
Refers to how data is organized
Unstructured Data
Text, audio, video, images
Lack of underlying data model = processing + analysis is challenging
Important for other applications like fraud detection; easy to integrate (data can be lumped together)
Structured Data
Has been organized and has an underlying data model; easy to process and analyze
Integration is challenging
Semi-structured: spreadsheets
Semantically enhanced data descriptions
Meaning / semantics of data that can be explicitly recorded using machine-readable “tags”
Extensible Markup Language (XML)
Set of tags / vocabulary the computer can understand; international standard; can be personalized
Makes integrating and processing data easy
XML: a tool to STORE data
HTML: used to FORMAT
Extensible Business Reporting Language (XBRL)
an XML-based computer language that uses tags to define all financial statement items
A requirement of the SEC (for public companies) when reporting financial information
Taxonomy
Set of rules that defines XBRL tags; establishes commonalities between data
ie. GAAP and IFRS
Data Life Cycle
Presents a model of the different states data can be in and what steps to apply; used for data discovery; a framework explaining data, how it’s connected/managed/issues