Module 11: Databases & Analytics

Describe the "Act" step in the DDDM process.

Once data and results have been shared, decisions must be made

Data that offers free access, distribution, and usage is known as

Open Data

Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered ___ data.

Ordinal

Forms structure data input to help ensure data ________ meaning the information entered is accurate, timely, and useful.

accuracy

Measurable and counted data that can have almost any numeric value is called __data.

continuous

In a database, data is organized in complex and meaningful collections specified by the database administrator. These collections are referred to as

fields

Data that has been collected internally by the organization is known as

first party data

When you need to link two tables in a database that do not have a field in common, one solution is to create a ___.

foreign key

When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ________ subsystem.

manipulation

A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a(n) ________ database.

multi-dimensional

To search a database for information, create a ___.

query

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a

record.

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 ________.

structured query language.

Uses of data analytics include which 3 of the following? 1. Improved decision making 2. Improved patient experiences and internal procedures in healthcare 3. Improved customer service 4. Improved data security

1. Improved decision making 2. Improved patient experiences and internal procedures in healthcare 3. Improved customer service Improved customer service

What element of a database field specifies the data in a field such as text, numeric, or date/time? element of a database field specifies the data in a field such as text, numeric, or date/time?

Data Type

Trends in data analytics include which 3 of the following? Data analytics as a core business function Composable data Scalable AI Virtual Analytics

Data analytics as a core business function Composable data Scalable AI

Describe the "Analysis" step in the DDDM process.

Data are analyzed to find patterns, trends, and relationships within the data set.

Describe the "Share" step in the DDDM process.

Data are shared with the appropriate audience. This can include visualization and presentations to key shareholders.

Describe the "Prepare" step in the DDDM process.

Data should be collected, stored, and secured in preparation for data processing.

What is sensing?

Involves the identification of meaningful data that should be collected by an organization; organizational data sources (internal databases, spreadsheets, etc.)

What is a relational database?

Is made up of one or more flat files, or tables, or data

Microsoft's analytics software that allows for the processing, manipulation, and visualization of data is called

Microsoft Power BI

When working in Microsoft Power BI, which 3 tiers are available?

Power BI Desktop Power BI Premium Power BI Pro

What type of key are the examples below? - Driver's license Number- - Social Security Number - Voter registration Number

Primary

What are the Key Data Analyst Tools?

Spreadsheets Databases and Query Languages Data Visualization Tools.

What is analysis?

The examination of data. Examples: statistical models

What is storage?

The final phase of the data project lifecycle. Involves hardware, software, and procedures for securing, maintaining, and accessing data.

Trying to answer questions such as, "what happened?" or, "what is occurring?" or "what was the ROI?", is the role of ___.

descriptive analytics

To create a relationship between two tables, it is necessary to create a listField 1Field 1 list , Incorrect Unavailable key in one table that is the primary key of the other table.

foriegn

To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.

forms

A link between tables in a relational database that defines how the data are related is called a _____.

relationship

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

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 are examples of data transformation?

- Standardizing names and variables across data sets - Copying or replicating data - The deletion of database fields or records to ensure data integrity

What is data transformation?

Data transformation is the process of converting the format of data.

What 3 are major varieties of data formats?

Discrete data Structured data Unstructured data

The DBMS engine provides an interface for the end user of the database. This interface is called the ________ view.

logical

In the six-step process analysts use to create data-driven decisions, the step during which data cleansing occurs to ensure that high-quality data is ready for processing is the

process step.

The type of database that uses common fields to create links between tables is called a(n) ________ database.

relational

What are the 6 step process for DDDM?

1. Ask 2. Prepare 3. Process 4. Analysis 5. Share 6. Act

What does DDDM mean?

Data Driven Decision Making

Some of the responsibilities of a data analyst include which 3 of the following? Data visualization Data structuring Data reporting Data creation

Data visualization Data structuring Data reporting

Describe the "Ask" step in the DDDM process.

Determine what questions you need to ask and establish a clear definition of the problem.

What are the 3 steps for the visualization process?

Exploring the Data Sets for Pattern Planning for Visuals Creating Your Visuals

What type of key are the examples below? - Street Address - City - Last Name - Party Affiliation

Ordinary Field

In the datasheet view of a relational database (such as Microsoft Access), a row of information is called a ___ .

Record

What are the 5 steps of the Data Project Lifecycle?

Sensing Collection Wrangling Analysis Storage

What is an example of the primary key?

Student ID # in a database because a person's last name, first name, and address can be the same can be changed

z An integral part of a database management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ________.

dictionary

A database that stores data in different physical locations and that users access through client/server networks is called a ________ database.

distributed

Describe the "Process" step in the DDDM process.

Data cleansing and checking should occur to ensure high-quality data are ready for analysis.

Which of the following is a popular data analytics program that offers business intelligence as well as data visualization?

Tableau

What is wrangling?

The conversation of raw data into a user-friendly format includes the development of algorithms.

What is collection?

The gathering of data from determined and validated data sources. It can be collected manually or programs can automatically capture it.

The process of investigating raw data of various types to uncover trends and correlations, and to answer specifically crafted questions is the role of data

analytics

When you make an online purchase and enter your shipping or billing information, you're actually filling out a form that was generated by a database management system. The DBMS subsystem that allows for form creation is the ________ generation subsystem.

application

In the ClassList table, the primary key is likely the __ field.

classnumber

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 _______

composable data and analytics

The process of converting the format of data from one form to another is called

data transformation

Because he wanted to be able to sort gifts according to continent and time zone, in 1984 Santa switched from using long lists to using ________.

spreadsheets

The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ________ subsystem.

data administration

Protecting private or sensitive information by eliminating or encrypting information is the goal of

data anonymization

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 a primary key?

It is a key with one or more fields that uniquely identifies each record.

What is a table of data?

It is made of records with each entry for the record placed into a field

A common SQL term used in queries is FROM. FROM allows the user to choose the _____ of the database in which the query is located.

table