Analytics Basics
The fourth V in the 4V’s of Big data (hint: the other threes are volume, velocity, variety)
What is veracity
The E in ETL stands for
What is Extract
The rule that states in many naturally occurring collections of numbers, the leading significant digit is likely to be small
What is Benford’s law
The type of chart that is best described as useful for identifying the correlation between two variables
What is Scatter plots
A particular type of report that is made up of strategic objectives and metrics to help the organization reach its target measures in line with strategic goals
What is balanced scorecard
The T in the IMPACT model stands for:
What is track outcome
A programming tool to retrieve data -- SQL stands for
What is Structured Query Language
The type of data analytics that attempts to estimate or predict, for each unit, the numerical value of some variable using some type of statistical model
What is regression
The type of chart that is preferred for when quartiles, median, and outliers are required for analysis and insights
What is Box and whisker plots
The category of KPI that net promoter score belongs to
What is customers
The computer-based standard used to define and exchange financial information from financial statements preparers to financial statement users
What is XBRL
The data field which creates the relationship between two tables
What is foreign key
The type of data analytics that attempts to assign each unit in a population into a small set of categories
What is classification
The best color theme for a color blind audience (Hint: a combination of two colors)
What is orange/blue scale
The category of KPI that 360-degree feedback score belongs to
What is employee performance
A table of data which includes every transaction that occurs via a cash register at a retailer.
What is Point-of-sale (POS) transaction data
The SQL clause or keyword which identifies the columns that you would like to extract
What is SELECT
The type of data analytics that attempts to characterize the typical behavior of an individual, group or population
What is profiling
The kind of data visualization that is used for gaining insights and generating ideas while interacting with your data
What is exploratory visualization
The creator of the 75 measures (KPIs) every manager needs to know
What is Bernard Marr
An interactive report showing the most important metrics to help users understand how a company or an organization is performing
What is digital dashboard
The document which is referred as data about the data; it communicates which tables are in the relational database, which fields are in the table, and how each table is related
What is data dictionary
The type of data analytics that attempts to divide individuals into groups in a useful or meaningful way
What is clustering
The kind of data visualizations that present findings to an audience
What is declarative visualization
A rule which says when a measure become a target it ceases to be a good measure
What is Goodhart’s law