Module 6 (Principles)
Big Data
Big Data
Five key characteristics associated with big data
What is: Volume, Velocity (speed), Value, Variety, Veracity (quality)?
Gets the most value out of information and presents the results of analysis in an easy-to-understand manner.
What is business intelligence (BI)?
Tiled. Horizontal. Vertical. Cascade.
What are window layout options to view workbooks?
Tab used to add subtotals to a data range
What is the data tab?
Searches in any direction, defaults to exact matches, and has built-in error handling.
What is XLOOKUP?
A large database that collects business information from many sources in the enterprise in support of management decision making
What is a data warehouse?
A Word Cloud and a Conversion Funnel is an example of this.
What is visual analytics?
Any workbook can be turned into this by just deleting all its current data, leaving only the formulas and design elements.
What is a template?
Process that hides records that do not match specified criteria
What is filtering
The formula includes the table name as well as the name of the row or column you want to calculate.
Example: =Sum(C2:C7) =SUM(Dept Sales[Sales Amount]).
What is a structured reference?
Key-value, column, document, and graph
What are four main categories of NoSQL?
Encourages nontechnical users to make decisions based on facts and analyses rather than intuition
What is self-service analytics?
References to cells in other workbooks establish a link, or a connection, between a source workbook containing the data and the destination workbook receiving the data.
What is an external reference?
Often used in dashboards because they provide a quick way to filter data.
What are slicers?
Another way of retrieving data from a two-way table is with the INDEX and XMATCH functions.
What is INDEX and XMATCH functions?
Uses several types of nodes
What is Hadoop?
This is an example of how it can be used - Monitor credit card transactions to identify likely fraudulent requests for authorization
What is data mining?
You can edit several worksheets simultaneously by doing this.
What is grouping the worksheets?
Provides a way of writing more complicated filter criteria that involve expressions that combine fields using the AND and OR logical operators.
What is an advanced filter?
Where criteria is an expression that is either true or false, and values are returned accordingly.
What is the IF function?
This process is essential in ensuring the quality of the data
What is ETL?
An organization needs these three things to get real value from its BI
What is data management program, creative data scientists that understand the company, and management team commitment?
A reference that includes the row address, the column address, and the worksheet address, expressed within a single reference as: Sheet! Range (Summary!B10)
What is a 3-D reference?
Can locate duplicate records when the duplicates occur in a single field.
What is conditional formatting?
A pivot table automatically uses the sum function if the value is this
What is a number?