MIS Final Prep!
Data centralization means that data is centralized in ________ place(s)
1
The essential RDBMS functions; create, read, update, and delete data is collectively referred to as which acronym?
CRUD
The process of taking components from data sources and analytics platforms to create a more user-friendly experience that makes finding critical insights easier is called ______ data and analytics.
Composable
Forms are created using ________ software
DBMS
The acronym for Data Governance is ________
DG
The three-step data visualization process is comprised of which of the following? Ask the stakeholders. Explore data sets for patterns. Create your visuals. Planning for visuals.
Explore data sets for patterns. Create your visuals. Planning for visuals.
Common database field names for a Members table would include which fields? FirstName LastName CellPhone ShortText
FirstName LastName CellPhone
What is the benefit of designing data visualizations for the target audience?
It improves communication and understanding.
_____is software with processing capabilities outside of what the operating system of the consumer provides.
Middlewear
Most organizations do not develop their own DBMS; instead, they use DBMS created by which three of the following? Oracle Microsoft IBM Apple
Oracle Microsoft IBM
Microsoft's analytics software that allows for the processing, manipulation, and visualization of data is called Microsoft _____ BI.
Power
Which of the following is a popular Microsoft data analytics program that offers business intelligence as well as data visualization?
Power BI
Using the correct syntax allows the user to extract data from multiple fields found in data tables. In order to extract information from multiple tables, the ______ command is used to indicate multiple fields in conjunction with FROM and WHERE to narrow the search and get specific results.
SELECT
Common SQL terms include which three of the following? SELECT SPLIT FROM WHERE
SELECT FROM WHERE
Data-driven decision making (DDDM) can be facilitated through a six-step processes of Ask, Prepare, Process, Analysis, Share, and Act. Which of these steps refers to creating visualizations and presentations for key stakeholders?
Share
What does the abbreviation SQL stand for?
Structured Query Language
Popular applications used by today's organizations in web mining include Google Analytics, Data Miner, and ________.
Tableau
Commonly used techniques to gain information in web mining include, ________ , ________ , and ________. Web Content Mining (WCM) Web Structure Mining (WSM) Web Usage Mining (WUM) Web Techniques Mining (WTM)
Web Content Mining (WCM) Web Structure Mining (WSM) Web Usage Mining (WUM)
Questions that data analysts often ask include which three of the following? What overall outcomes and results that are needed? Who will receive the information and analysis? What are the time constraints for the project? How much is the company being paid for my analysis?
What overall outcomes and results that are needed? Who will receive the information and analysis? What are the time constraints for the project?
Using a Database Management System (DBMS) increases data security by using ________so that only authorized users can access data.
access rules
Data governance policies help to ensure an organization's data is valid, understandable, complete, and ________ .
accessible
Referential integrity is the ________ and ________ of data within a table relationship in a database accuracy consistency development relationship
accuracy consistency
Data integrity means the database is reliable, ________, and aligned to the goals of the organization.
accurate
There are many RDBMS query tools we can use. Those query tools include crosstab queries, ________queries, parameter queries, and queries specific to SQL.
action
Data marts assist with the _______ of what data a user needs rather than focusing on existing data.
analysis
Someone who possesses the knowledge of processing software, business strategy, and analytical skill to deliver data and reports that guide management and executives as they create well-informed decision making is known as a data
analyst
Curiosity, understanding context, having a technical mindset, data design, and data strategy are the five essential aspects of _____ thinking and skills.
analytical
Tasks of a database administrator (DBA) include database security, tuning, ________, and creation of queries and reports used to assist business decisions.
backup
Which type of chart is commonly used to create pictographs?
bar or line chart
The role of a DBA is to ________ and maintain tables in a relational database.
build
How can data visualizations establish trust and confidence when designed appropriately?
by telling a complex story quickly
A record is a ________ of related fields in a data file
collection
We use a ________field between the two database tables to create a relationship link.
common
What type of field is used in both tables to create a relationship?
common
What are potential disadvantages of data visualization? decrease trust and confidence in represented data data visualizations have no accessibility concerns convey biased or inaccurate information or inaccurate information display correlations that do not accurately reflect causation
convey biased or inaccurate information or inaccurate information display correlations that do not accurately reflect causation
Which three of the following are examples of data transformation? copying or replicating data converting a comma separated values (CSV) file into a PowerPoint file standardizing names and variables across data sets the deletion of database fields or records to ensure data integrity
copying or replicating data standardizing names and variables across data sets the deletion of database fields or records to ensure data integrity
What is a potential consequence of including cherry-picked data in a visualization?
creation of misleading and false conclusions
Online Analytical Processing (OLAP) is included in many Business Intelligence (BI) software applications. We use this OLAP for a range of ________ discovery activities, including report creation and analysis, analytical calculations, forecasting, budgeting, planning, and what-if predicative analysis.
data
The information technology (IT) architecture and infrastructure, software applications, programming languages, and storage technologies used for the collection, storage, analysis, and interpretation of meaningful data is referred to as the ____ ecosystem.
data
Because many business executives desire to create a data-driven decision making culture, which three of the following are competencies organizations invest in to support DDDM? English literature expertise data proficiency agility in analytics and data analysis building a data-driven community
data proficiency agility in analytics and data analysis building a data-driven community
Some of the responsibilities of a data analyst include which three of the following? data visualization data creation data structuring data reporting
data visualization data structuring data reporting
Reports offer a way to view, format, and summarize the information in a ________.
database
SQL is quite useful when working with large data sets and is widely used in today's business environment. It allows the user to query the data contained in a ______.
database
Data administration tasks include the development of information policies, data planning, ________ , security, and how internal-users and end-users use that data.
database design
A cloud database infrastructure integrates computer hardware and operating system in an internet-based ________.
datacenter
Using multiple lists and data sources can lead to a(n) ________ in data integrity.
decrease
What best practices should be applied when designing data visualizations? defining a specific purpose for the visualization designing visualizations for the target audience including all relevant data using as many colors as possible
defining a specific purpose for the visualization designing visualizations for the target audience including all relevant data
The process of data analytics includes which three of the following? descriptive analytics virtual analytics predictive analytics prescriptive analytics
descriptive analytics predictive analytics prescriptive analytics
Data redundancy is the ________ of data
duplication
Data scrubbing (data cleaning) involves identifying ________ in data sets then duplicating these errors to ensure the data is accurate for an organization.
errors
Characteristics of databases include which three of the following? fields records slides characters
fields records characters
Data transformation is the process of converting the _____ of data
format
Database Management Systems (DBMS) assign users different access rules to protect the data and users from ________, data leaks, and the misuse of data
identity theft
Uses of data analytics include which three of the following? improved decision making improved patient experiences and internal procedures in health care improved customer service increasing fonts
improved decision making improved patient experiences and internal procedures in health care improved customer service
A hybrid data mart ________data from a data warehouse as well as other data collection systems. It incorporates a top-down approach, end-user inputs, and enterprise-level integration.
integrates
Data centralization is critical for increasing data ________Blank.
integrity
Data marts are used to track ________, purchase transactions, and the supply chain.
inventories
Database reports are useful in many ways; one way a report is used is to provide details about individual records and to create ________.
labels
A database relationship is a(n) ________ between tables that define how the data are related.
link
A Database Management System (DBMS) has the ability for _____ and database ________ to manipulate, query, and store information in a database. managers administrators users files
managers administrators
A DBMS provides the ability to ________, query, and store information in a database for managers and database administrators.
monitor
Database administrators ________ and troubleshoot the database (if needed) to ensure it is stable and usable when needed.
monitor
Doing a data quality audit helps ensure the highest quality of data being used for business intelligence and other applications. The data analysis method involves quality assessment, design, transformation, and ________.
monitoring
When discussing personally identifiable information (PII), which three of the following are usually anonymized? names phone numbers social media activity Social Security numbers
names phone numbers Social Security numbers
What does the acronym NoSQL stand for?
non-relational databases
Databases maintain data and information about various types of data ________ .
objects
Traditional file systems use ________, files, and documents
paper
What type of relationships do pie charts primarily represent?
part-to-whole relationships
Databases are designed to keep data and information about different types of data objects, including objects, events, ________, and places
people
OLAP is used to support businesses in a wide range of areas including ________. performance management financial reporting simulation model software downloads
performance management financial reporting simulation model
When data is anonymized, the PII is eliminated or encrypted. PII includes names, Social Security numbers, addresses, and more and stands for ______ identifiable information.
personally
A ________ key must contain a unique value
primary
Parameter queries ________ the user for values to execute/run a query.
prompt
Areas covered in digital governance include data architecture, data ________ , data modeling, data warehousing, and data security.
quality
Areas covered in digital governance include data architecture, data ________, data modeling, data warehousing, and data security.
quality
SQL, usually pronounced "sequel," is quite useful when working with large data sets. The Q in SQL stands for
query
Collections of related fields in a database are referred to as
records
What do scatter plots primarily visualize?
relationships between numerical data pairs
Examples of data scrubbing include which of the following? removal of duplicate database records correcting misspelled words fixing syntax issues creating data tables
removal of duplicate database records correcting misspelled words fixing syntax issues
A major trend in data analytics is the use of artificial intelligence to focus on small data which is more precise, using small datasets that are capable of impacting decisions in the present. This is known as ______ AI.
scalable
What is another term used to describe scatter plots?
scatter diagrams
Database policies should be created and implemented by all organizations, regardless of the ________ of the organization.
size
The main tools used by data analysts include which three of the following? spreadsheets Punnett squares databases and query languages data visualization tools
spreadsheets databases and query languages data visualization tools
SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ______ query language.
structured
SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ______query language.
structured
Data governance involves the staff, procedures, and technologies needed to ________and protect the data and data properties of an entity.
supervise
In computer programming, a set of rules and guidelines that define a specific computer language is referred to as the language's
syntax
A database and a DBMS are different. A database is a collection of metadata, relationships, and ________
tables
Most databases are composed of multiple _____, which are groups of assigned records and fields organized in rows and columns.
tables
Key skills required of data analysts include which three of the following? technical writing skills experience with SQL and computer code in-depth understanding of sociology communication skills
technical writing skills experience with SQL and computer code communication skills
When selecting the right data, it is important to be aware of the source of the data. For example, data that is sold by an entity that didn't actually collect the data is considered ______data.
third-party
The process of converting the format of data from one form to another is called data ______.
transformation
In order to make understanding and interpretation of SQL queries easier, users have the ability to add comments. The symbol(s) that will tell SQL that an entry is a comment and should not be used in the query is(are)
two dashes: "- -."
Which of the following are standard SQL commands? update create drop add
update create drop
What is a pictograph used for in data representation?
using pictures to represent data
Parameter queries prompt the user for ________ to run a query.
values
The graphical and structured representation of data is known as data _____.
visualization
The common characteristics of big data include volume variety veracity velocity
volume variety veracity velocity
One of the ways web mining improves web experiences is through site visibility. Site visibility includes how and ________ the website appears when queries are executed in a search engine.
when
In a bar, line, or scatterplot graph, which axis is typically used to represent the values being compared?
y-axis
