Exam 2 MIS

Hash

A digitial fingerpring or unique identifier that helps create secure transactions

Computer Networks

A network is a group of two or more devices/computers connected together

Step 4 of the IaaS

Add the IP address to the packet

Step 1 of the IaaS

Assemble the data packet

one of the first computer aided design programs ever devleoped

AutoCAD

What is the requirement for referential integrity in a table relationship?

Data on both sides of the relationship must be present.

Open Data

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

Data administration responsibility: Location data collection

Deciding that the organization will begin collecting and storing users' locations upon the release of the next generation software for its mobile app

Data administration responsibility: Sharing data policy

Defining policies stating that employees may not share data with people who are not employees of the organization

What are dependent data marts?

Dependent data marts extract data from a data warehouse when it is needed.

Data administration responsibility: Two-factor authentication

Determining that two-factor identification must be used to access data that the company has determined confidential

What does the Internet of Things refer to?

Everything connected to the internet

What are hybrid data marts?

Hybrid data marts combine data from a data warehouse and other collecting systems.

Step 2 of the IaaS

Identify the correct domain name

Step 5 of the IaaS

Implement Transmission Control Protocol

What are independent data marts?

Independent data marts are separate from a data warehouse and are created to collect data relating only to particular business functions.

Is an instant computing infrastructure composed of processing, data storage, and a variety of other computing resources provided by a cloud vendor

Infrastructure as a service

helps organizations avoid the cost of acquiring and managing their own physcial servers and datacenter architecture

Infrastrucutre as a servic

What does IoT stand for?

Internet of Things

What is referential integrity?

It applies to data quality within the structure of a relational database.

Step 3 of the IaaS

Look up the IP address using the Domain Name System

Computer networks

Networks range in size from small home networks to the internet whihc is the worlds largest network

Better Communication

People from across the organization, regardless of their physical location, can share content in real-time including documents, spreadsheets, videos, and messages.

hosting of hardware and software

Platform as a service

3 common SQL language

SELECT, WHERE, FROM

Database management system

SQL statement is used to ask a question or communicate a request of ____.

Step 6 of the IaaS

Send the message

What are examples of devices in the Internet of Things?

Sensors, wearable tech, smartphones

Tableau

The ability to explore and anayze data in seconds using a drag and drop interface as well as natural language processing which allows for the presentation of questions are major attributes of ____.

Line Chart

Used to compare values over time

Pie Chart

Used to represent part to whole relationships in a data set

Scalable

a major trend in data analytics is the use of AI to focus on small data which is more precise, using small datasets that are capable of impacting decesions in the present

record

a row of information

Transmission control protocol

a suite of communicatio protocols used as a private network communications protocol for private networks including intranets and extranets covers how software applications communicate across networks and how data packets are assembled and reassembled

Web usage mining

also called log mining, includes analysis of web access logs or the when how and r=frequency of website access

Purpose of SQL statement

answer questions about the database

referential integrity

be consisten: a foreign key field that references a primary key field must agree with that primary key

Platform as a service

cloud-based computing software model where cloud service providers offer hardware and software tools need for application/software development via the interned

project life cycle according to harvard phases

collection, wrangling, sensing

trends in analytics

composable data, scalable AI, data analytics a a core business function

Computer networks

computer networks support many different software applications

5 essential aspects of analytical thinking and skills

curiosity, understanding context, having a technical mindset, data design, data strategy

3 trends is analytics include

data analytics as a core business function , composable data, scalable AI

Fields

data is organized in complex and meaningful collections specified by the data base administrator

3 competencies organizations invest in to support DDDM

data proficiency, building a data driven community, agility in analytics and data analysis

3 responsibilities of data analyst

data reporting, data visualization, data structuring

open data

data that offers free access, distribution, and usage is known as...

Data integrity to an organization

databases and database management system with a high level of data integrity enable more efficient data maintenance in support of organizational goals

3 step viualization process is comprised of which of the following

explore data sets for patterns, planning for visuals, create your visual

Data warehouses primary use

facilitate the analysis of data from multiple sources

Tableau uses 3 things to help DDDM

facts, metrics, data

How are data marts different from data warehouse

focus on an individual department or business function and manage less data than a warehouse

Data quality Audits

gain an overall assessment of the strengths and weaknesses of their data

web structure mining

includes analysis of hyperlinks, nodes, and related web pages

Web Content mining

includes extraction of information from web pages/documents, including text, images, videos and interactives

site visibility

includes how/when the site surfaces when queries are executed in search engines

Accessibility

includes the structure of websites and pages to ensure device/platform access and scalability ensuring information is available to users and acces for those with physical an congnitiive limitations for users

NIC(network inferface card)

inorder to connect to internet and other computers on a network each device must have this

truncating

is to shorten the y-axis to make differences appear larger than they actually are

continuous data ollection

measureable and counted data that can have almost any numeric value

Microsoft power BI

microsofts analytics software that allows for the processing, manipulation, and visualization of data is called _____.

data normalization

organized approach to simplify tables to eliminate redundancy

3 step data visualization process

planning visuals, create visuals, explore data sets for patterns

6-step process analyts use to create data-driven decision making includes?

prepare, analysis, ask

data anonymization

protecting private or sensitive information by eliminating or encrypting information is the goal

Advantage of performing a data quality audit

recommends ways the organization can improve its data quality and reduce costs through increasing data consistency

usability

refers to how easily website user/visitors can interact with the site

SQL task

retrieve data

streamlined workflow

scheduling activities can easily be added and updated in the software. remote team members are actively engaged in workflow, duties and processes due to the real time nature of the software

Main charcteristic of a relationol database

stores and allows acces to data objects that are reltaaed to one another

XML(Extensible Markup Language)

tech that are able to exchange information with each other using standardized web communication protocols and languages

2 dashes"- -"

tells the SQL that whatever comes after is a comment and should be ignored in the query

data ecosystem

the IT architecture and infrastrucutre, software applications, programming languages, and storage technologies used for the collection, storage, analysis, and interpretation of meaningful data is referred to as the

data transformation

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

composable data and analytics

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

Scatterplot

used to disgram pairs of numerical data. Help to determine if there is a correlation between variables

Bar Chart

used to display slices of information.Allow for comparing one group of data to other groups