A
______ are vertical lines of cells, typically labeled with letters (In Spreadsheet)
Columns
______ is an extremely large and complex datasets that cannot be easily managed using traditional data processing techniques
Big Data
_______ is often referred to as the language, or mathematics, of business.
Accounting
______ is applying statistics and logic to evaluate data.
Data Analysis
The intersection of a row and a column forms a _____, where data is entered.
cell
"Uses graphs and dashboards to summarize data and visually display information in a concise and clear manner” is called _______
Data Visualization
Examination of vast datasets to discover patterns and connections is _______
Data Mining
Business departments need to communicate with one another through the process of data and information sharing called _______.
collaboration
A database is made up of files called _____ that are related to each other.
tables
_______ is a software application that allows users to organize, analyze, and manipulate numerical data in a tabular format
Spreadsheet
What feature allows spreadsheets to perform powerful calculations?
Formulas
What are the three types of data?
Structured, Unstructured, Semi-structured
What does ETL stand for?
Extract, Transform, Load
A collaborative thought process to generate ideas and directions is called ________
Brainstorming
Numbers, Text, Dates, Formulas, and Boolean (TRUE/FALSE) are examples of _______
data types
What type of analytics does BI usually deal with?
Descriptive analytics
_____ is widely used by small to medium-sized businesses for accounting
QuickBooks Online
What is GAAP?
Generally Accepted Accounting Principles
A _____ defines all the relationships between the data, tables, and keys.
schema
What are the 'Four V's' of Big Data?
Volume, Velocity, Variety, Veracity
Database designers construct databases by using __________ which is a database-modeling method to construct a theoretical and conceptual representation of data.
entity relationship diagrams (ERM)
Hadoop is an _________ software framework for storing and processing _________ ranging in size from gigabytes to petabytes of data across multiple servers or server clusters.
open-source; large datasets
_______ is a Long-term planning designed to achieve a specific goal. In contrast, ________ is a short-term decisions based on current and future analysis.
Strategic decisions; Tactical decisions
What are the five core functions that businesses must fulfill?
Accounting, production, R&D, human resources, marketing
Using historical sales data to predict future trends and sales figures for different products or regions is an example of _______
sales forecasting