EXAM 3 Flashcards
(253 cards)
7.1 What is Data Exploration?
Define Data Exploration
Also called 1) ex___y data analysis, it is the 2) di____y process of 3) lo___g for something 4) n___ and previously 5) u___n in the data
This is accomplished by looking for 6) p___ns, ou___s, or, more generally, for 7) ins____.
1) exploratory
2) discovery
3) looking
4) new
5) unknown
6) patterns, outliers
7) insights
Define Insights
an 1) obse_____ that might 2) sig____ af___t a business’ 3) de___-m___g.
1) observation
2) significantly affect
3) decision-making.
Remember, decisions are 1) n___ based on 2) d___.
Rather, decisions are informed by the 3) in___s generated from 4) d___
1) not
2) data
3) insights
4) data
This process of generating insights is what 1) dis___ data analysis from the simple act of reporting 2) nu____.
While they might share some tools, it is essential to differentiate between data 3) e___on, int____ion, and rep___:
Exploration: 4) Di__ng in___s.
Interpretation: 5) Con____g and unde____ in___s.
Reporting: 6) Com___ ins___s
1) distinguishes
2) numbers
3) exploration, interpretation, and reporting
4) Discovering insights
5) Contextualizing and understanding insights
6) Communicating insights
The Process of Data Exploration
What’s the 4 step process of Data Exploration?
- Ide___g Q____s
- Id____g D___ Rel___s
- Exp___ D___a Rel____s
- Gen___g In____s
- Identifying Questions
- Identifying Data Relationships
- Exploring Data Relationships
- Generating Insights
The Process of Data Exploration
1. Identifying Questions
Data exploration helps answer accounting 1) que__s such as whether sales and profits are 2) im___g, which products deserve 3) inv____, if 4) b__d d___s are appropriately managed, and more.
An 5) an___ database should provide 6) an___s to both 7) an____d and un____d (un___ed) qu____s.
Once the question is 8) det___, such as the question about whether unit sales are improving in Illustration 7.1, then the underlying data 9) rela___s can be 10) id___
1) questions
2) improving
3) investment
4) bad debts
5) analytical
6) answers
7) anticipated and unanticipated (unplanned) questions
8) determined
9) relationships
10) identified
The Process of Data Exploration
2. Identifying Data Relationships
Define Data Relationships
describes 1) h__ d__ el___s (or v__s) 2) rel___ to each 3) ot___
-But before aspects of data relationships can be analyzed, they have to be 4) id__
1) how data elements (or values)
2) relate
3) other
4) identified
The Process of Data Exploration
2. Identifying Data Relationships
Stephen Few, an expert in data visualizations, differentiates eight foundational data relationships
- No____ co___son
- Di____n
- Dev___
- Ra___g
- Pa__-to-wh___e
- Cor____
- T___e se___s
- Geo___
The data relationship identified in Illustration 7.1 is a time series, which describes 1) ho__ something 2) cha__ o___r ti__ and helps to 3) ide___ pa___s of ch___.
A relationship that has been 4) ide___, whether it is a time series relationship or one of the relationships examined later in this chapter, is ready for 5) ex____n
- Nominal comparison
- Distribution
- Deviation
- Ranking
- Part-to-whole
- Correlation
- Time series
- Geospatial
1) how
2) changes over time
3) identify patterns of change
4) identified
5) exploration
The Process of Data Exploration
3. Explore Data Relationships
While there are different approaches to exploring data relationships, 1) vis____ and s___s are the most common.
Exploration involves 2) sel___ the 3) vis__n or vis___s 4) b___t su__d for 5) ex___g the data 6) rel___s. In Illustration 7.1 a line chart visualizes the time series
1) visualization and statistics
2) selecting
3) visualization or visualizations
4) best suited
5) exploring
6) relationships
The Process of Data Exploration
3. Explore Data Relationships
Keep in mind that 1) t___l-sp___c kno___ is required to create 2) vis___s.
For example, a time series analysis requires knowing how to create line charts.
Business intelligence software such as Excel, Power BI, and Tableau all have powerful tools that visualize data relationships for exploration
1) tool-specific knowledge
2) visualizations
The Process of Data Exploration
4. Generate Insights
The line chart in Illustration 7.1 shows an upward trend of unit sales starting in 2023.
Exploring this insight further would include discovering the 1) s___e of that growth and if the upward trend can be explained by other 2) fa___.
In fact, data exploration is a 3) con___s p___s.
4) Ins___ generate n__w que___, which then generate even 5) m___e ins____. These observations are then 6) int____ and co____ed to stakeholders during the 7) l___t st__ of the data 8) a___s p___ss
1) source
2) factors
3) continuous process.
4) Insights generate new
5) more insights.
6) interpreted and communicated
7) last stage
8) analysis process
Exploring Data with PivotTables
Data exploration 1) inv____s data from 2) di___t an___s to collect 3) in__s.
A widely-used tool for this is the 4) Ex__ Pi___T___e
1) investigates
2) different angles
3) insights
4) Excel PivotTable
The five components used for data exploration with PivotTables are 1) fi___s, v___s, r___s, col___s, and fil___
1) fields, values, rows, columns, and filters
Fields
The Fields area 1) li__ all the data 2) el___s available for 3) exp___n p___es. They can be dragged and dropped to other areas to build data 4) rel____ and fi__r the data.
In Illustration 7.3, the Model and UnitsSold fields are used for exploration.
1) lists
2) elements available
3) exploration purposes
4) relationships and filter
Values
The Values area in Illustration 7.3 (B) represents the 1) n__r or nu__rs to be 2) an__d.
It can be used to 3) e___e data in different ways:
-Drag and drop any field into the Values area and apply mathematical operations such as average, count, or sum to it.
-Create calculated fields.
Examples of accounting-related values that could be analyzed include gross revenue, net revenue, taxes, cost, profit, and more. For HNA, the values in the UnitsSold field are summed, generating the total number of units sold during the 2021–2025 period.
1) number or numbers
2) analyzed
3) exploree
Filters
Using filters further enhances data exploration with Excel PivotTables.
Filters let us determine 1) w___t d__a should be 2) con____ for analysis, and they can be 3) cr___d for any field
1) what data
2) considered
3) created
7.2 How are Data Relationships Visualized for Exploration?
There are two types of data exploration patterns.
Some patterns explore a 1) fou___ data re___p with a 2) s___le vis____n, while others explore data by 3) inte___ da__ re___ps
1) foundational data relationship
2) single visualization
3) integrating data relationships
Data Exploration Pattern 1: Nominal Comparison
Define Nominal Comparison Data Relationship
A data 1) rel___p that 2) com___s the 3) va___s of a 4) cat___l va___le based on a 5) s___d, nu___ variable
1) relationship
2) compares
3) values
4) categorical variable
5) second, numeric
Data Exploration Pattern 1: Nominal Comparison
Define Exploration Structure
A 1) vi___l that 2) d___es the 3) dif___t data 4) e__ts 5) u___d in data 6) exp___ and 7) h__w they are 8) r__d
1) visual
2) describes
3) different
4) elements
5) used
6) exploration
7) how
8) related
Data Exploration Pattern 1: Nominal Comparison
For nominal comparisons, the exploration structure is a 1) n___al variable, which is 2) w___ is being 3) com___, and a 4) nu____ variable, 5) w___ is 6) h__w the values of the 7) n__l variable are 8) co__d
1) nominal
2) what
3) compared
4) numeric
5) which
6) how
7) nominal
8) compared
Data Exploration Pattern 1: Nominal Comparison
Visualizations
Visualizations for nominal comparisons include 1) b___r charts, c___n charts, d___ plots, and loll___p charts.
1) bar charts, column charts, dot plots, and lollipop charts
Data Exploration Pattern 1: Nominal Comparison
Exploration and Insights
A nominal comparison can 1) qu___y ev___e data and collect 2) in___ in__t, which is especially 3) u___l when 4) w____g with a 5) n___ data set.
It allows us to compare the 6) si___s of each category–which is the 7) bi___t, which is the 8) sm___t, if one category is 9) tw__e as big as another, and more
1) quickly evaluate
2) initial insights
3) useful
4) working
5) new
6) sizes
7) biggest
8) smallest
9) twice