Test 4 Study Guide

Put the steps of the information processing cycle in the correct order, with the first step at the top.

1. Input 2. Process 3. Output 4. Store

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) ___.

2 dashes: "- -"

is the brains of the computer where most calculations take place.

A processor or central processing unit (CPU)

Select 3 sources of information that a CRM system uses to collect data about current customers.

Analytics Social Media Customer Surveys

Which three of the following regarding a computer application are true?

Applications can be located on smartphones, tablets, laptops, and even on servers accessible on the Internet. A computer application is a computer program. Most applications can be downloaded for free or for a fee.

The design of a CRM system that collects data on customer interaction should include which of the following elements?

Automation Treating customers as individuals Monitoring customer interactions

Used to display slices of information. Designed to plot numerical values in the form of bars. Often used to demonstrate the distribution of data points or to display values across different subgroups of data.

Bar Charts

Because its radio waves can pass through walls or desktops, ___-capable devices have become very popular.

Bluetooth

Which computer component found on the motherboard (magnified in the image) is often called the brains of the computer?

CPU

Is the selection and representation of data in a visualization that supports a desired conclusion or result.

Cherry-picking data

where customers are grouped into homogenous segments so behavior can be more easily analyz

Customer segmentation

includes the identification of which customers create the highest revenue

Customer value and profitability

Which of the following explain the importance of CRM to businesses? More than one answer can be selected.

Customers can be acquired using a number of approaches including social media, search, affiliate, referral, and email marketing. CRM software systems track prospective customers (and current customers) through the various stages of the funnel Organizations often track customer acquisition using a lead generation funnel

Duties for __________ include: •Working on data analytics teams to extract data from large data sets. •Creating reports that outline key findings. •Monitoring K P I's to identify success or failure. •Analyzing data to identify trends.

Data Analyst

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.

Data Ecosystems

What is based on the unique circumstances of each organization, a specialized ecosystem is created for every business entity.

Data Ecosystems

Improved customer service Improved patient experiences and internal procedures in healthcare Improved decision making These are the uses of

Data analytics

The process of investigating raw data of various types to: Uncover trends and correlations. To answer specifically crafted questions

Data analytics

___________ software assists managers by examining large quantities of data and parsing it into usable information.

Data analytics

Some of the responsibilities of a data analyst include which 3 of the following?

Data visualization Data structuring Data reporting

The use of facts, metrics, and data to guide strategic business decisions that align with organizational goals, objectives, and initiatives.

Data-Driven Decision Making (DDDM)

1.Ask - Determine what questions you need to ask and establish a clear definition of the problem 2.Prepare - Data should be collected, stored, and secured in preparation for data processing 3.Process - Data cleansing and checking should occur to ensure high-quality data is ready for analysis 4.Analysis - Data is analyzed to find patterns, trends, and relationships within the data set 5.Share - Data is shared with the appropriate audience. This can include visualization and presentations to key stakeholders 6.Act - Once data and results have been shared, decisions must be made These are the Six Steps of ________________

Data-Driven Decisions

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

There are several best practices that can be applied to ensure effective development and interpretation of data visualizations. Select 3 of these best practices.

Define the purpose Inclusion of data Use color

CRM analytics can provide insight into how customers and members of the organization interact with the CRM system. This can be used to encourage interaction and use.

Demonstrate the Value of CRM

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

Descriptive Analytics

Uncovers historical trends in data sets

Descriptive Analytics

What devise has 500 GB - 3 TB for space

Desktop

Designed for power users. Has a relatively large footprint. Not mobile, but allows for relatively easy upgrade and expansion.

Desktop computer

Click 3 characteristics of desktop computers.

Desktops use a full OS. Desktops allow for relatively easy upgrade and expansion. Desktops are often used in offices since they do not need to be mobile.

Common SQL terms include which 3 of the following?

FROM SELECT WHERE

Most tablets have solid-state drive (SSD) capacities measured in terabytes (TBs). True or False

False

The only major difference between MacBooks and the Dell laptops is their prices. True false question.

False

Built-in formulas included in a spreadsheet program

Function

Which of the following terms refers to the physical parts of a computer system?

Hardware

Characteristics of spreadsheets include which 3 of the following?

Information is organized into cells Data is structured in rows and columns Program is typically limited to one user at a time

Used to compare values over long and short periods. Can efficiently display changes over time in a single category of data or groups of data categories.

Line Charts (line plots or line graphs)

Which of the following are popular CRM options that are used to assist with sales prospecting?

LinkedIn Sales Navigator Zoominfo Clearbit Prospector

the process of dividing a market of both potential and existing customers into groups (i.e., segments) based on a variety of characteristics including both demographic and psychographic types of data.

Market segmentation

The devices shown in the image (iPod, Chromecast, Roku, etc.) are referred to as Personal ___ Players

Media

Characteristics of Mainframes

Not designed to calculate huge formulas, but able to manage thousands of transactions simultaneously. More powerful than a server, less powerful than a supercomputer. Often operated by businesses such as large banks or credit card companies.

Which three of the following are common spreadsheet application programs?

Numbers for Mac Microsoft Excel Google Docs (Sheets)

Analytical Thinking Includes characteristics and capabilities that allow for:

Observation. Research. interpretation of a problem.

Select the true statements about Customer Lifetime Value (CLV).

One of the key metrics used to determine the profitability of an organization's customers. Organizations use CLV to determine how much they should spend to acquire new customers versus how much they should spend to retain existing customers.

Which two of the following are true about system software?

One of the most important types of system software is the operating system. System software refers to programs that offer the structure and hardware control necessary to run the computer and its peripheral devices.

allows for customized marketing based on individual customer behavior

Personalization

Design elements that can lead to misleading data visualization include exaggerated or improper scaling.This can most often occur when presenting data in the form of a ___

Pictogram

Used to represent part-to-whole relationships in a data set.

Pie Charts

The 3-step data visualization process is comprised of which of the following?

Planning for visuals Explore data sets for patterns Create your visuals

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

Power

uses prior information to assist in the determination of the success or failure of future endeavors

Predictive modeling

These are examples of ___________________ •Tracking fuel prices by airlines to determine possible increases and decreases. •Monitoring flu strains and activity to determine possible outbreak areas. •Analysis of cyberthreats and activity to identify possible threats and breaches.

Prescriptive Analytics

Used to help determine best courses of action. Considered to be the most advanced form of data analytics. Seek to predict what, when, and why a given scenario might occur.

Prescriptive Analytics

CRM analytics often give insights that foster innovation. This information can be used by decision-makers to identify strong areas and potential growth areas.

Product Development

is the method of searching and finding potential customers for a product or service.

Prospecting

__________ a potential customer occurs when an organization determines whether or not an individual or business makes sense to pursue as a potential customer.

Qualifying

SQL, usually pronounced "sequel", is quite useful when working with large data sets. The Q in Structured ____ Language stands for ___.

Query

Characteristics of databases include which 3 of the following?

Records Fields Characters

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

Are designed to diagram pairs of numerical data with one variable placed on each axis. If there is a correlation between the variables, the data points will fall on a line or curve.

Scatterplots (scatter diagram or X‑Y graph.)

Which three of the following devices are also computers?

Smartphone Gaming console Laptop Desktop

The __ tool is used to capture a screen shot, or snip, of any image on the screen of a laptop or desktop computer,

Snipping

CRM analytics can provide information about where data erosion occurs and how processes can be improved to minimize it.

Standardized Data Collection Processes

Many of these are owned by research universities and government agencies such as the NSA. NASA uses them to determine gravitational fluctuations that might indicate additional planets in the solar system

Supercomputer

Programs that offer the structure and hardware control necessary to run the computer and its peripheral devices are called __ software.

Systems

Analytics software that offers business intelligence and data visualization across many areas as well as for organizational processes.

Tableau

CRM systems can be designed to capture data about why users are buying a product or service and how they are using it.

User Experience

CRM analytics can be used to test the ______ of products or services. This ______ check results from the analysis of consumption trends and usage behaviors.

Viability

The graphical and structured representation of data is known as data _____

Visualization

A stationary (non-mobile) computer that combines the power of a desktop with a neat, clean, look is a(n):

all-in-one

If you want a non-mobile computer without the relatively large footprint of a desktop, consider purchasing a(n) ___ computer.

all-in-one

Smartphones owe much of their popularity and computing flexibility to ___ .

apps (applications)

Users can identify patterns in data as well as create data visualization tools with ________

charts and graphs

A well-developed CRM strategy can assist organizations to identify the needs, wants, preferences, and expectations of ______

current customers

A SQL statement is used to ask a question or communicate a request of the ______ management system.

database

A personal computer with a separate system unit (chassis or tower) and a relatively large footprint is called a ___ .

desktop

Memory, such as RAM or cache, is __ and has no moving parts.

electronic (solid state)

Analysts use _______ and other tools to depict the workflow, the sequence of operations, and the decision points.

flow-charts

Most new laptops come with 128-1,000 _____ of storage.

gigabytes

The physical parts of a computer, such as the monitor, keyboard, mouse, and system unit are called computer ___ .

hardware

Memory, such as a computer's RAM ___

holds data and programs being used by the processor.

Which operating system is found on Apple smartphones and tablets?

iOS

CRM software assists organizations in identifying marketing qualified ________ (MQLs).

leads

While not designed to solve complex technical formulas, a computer that is more powerful than a server computer, and used by organizations to process large numbers of transactions simultaneously is called a

mainframe

When a computer is shut down, the information in the memory (the RAM, the caches, the registers) is ___.

not saved

Because they tend to use relatively large amounts of battery life and because their inclusion tends to make a laptop somewhat larger (thicker), many new laptops do not come with _______ drives such as blu-ray or DVD players.

optical

Media players allow you to listen to audio files such as music, podcasts, listen to audio books, and watch videos. Media players are often referred to as _____ Media Players due to their transportability and customization.

personal

Most new smartphones come with between 2 and 6 GB of __ .

random access memory (RAM)

Data from the hard drive reaches the CPU ___ than data from the RAM.

slower

Because of their compact size and extreme efficiency, smartphones, tablets, and some laptops use ______ - state storage (hard drives)

solid

A hardware component that keeps data and information when the device is not powered is called a ____ device.

storage

The most powerful computers, _______ , can evaluate complex data very quickly. Many of these computers in the United States are owned by the government or major research institutions and can cost $1 million dollars or more.

supercomputers

Desktop computers usually come with at least 8-16 GB of __. One nice thing about a desktop is that most allow this to be easily expanded to up to 32 to 64 GB.

system memory (RAM)

Most databases are composed of multiple ______ , which are groups of assigned records and fields organized in rows and columns.

tables

A highly mobile, touch-screen enabled device that is larger than a smartphone and popular with those who use a computer while walking around is a _____ computer.

tablet

is the group of existing and potential customers that an organization believes they can sell their products or services to.

target market

Analytic Analysis

the process of analyzing data to discover patterns, correlations, and trends

If you buy a new computer game that emphasizes graphics, or new photo/video editing software for your desktop computer, you may want to purchase a new ___.

video/graphics card

There are three main tools data analysts and other members of an organization use to analyze data. They are spreadsheets, databases and query languages, and data ______ tools.

visualization

What are the types of Computer Hardware

•system unit (called the tower or the chassis) •printer •monitor •keyboard •mouse router