Chapter 17: Business Intelligence
Transform
"Normalize" data
In ____________'s organizations started using and processing data to support strategic decisions they make
1950
___% of all data is ____________
80% of all data is UNSTRUCTURED
CRM
A component of an EMP system, A source of a lot of information
Example of DSS
Anything that helps you make decisions
Old name of business analytics
BANA
- Refers to an assortment of software applications used to analyze an organization's raw data.
BI
What refers to an assortment of software applications to analyze an organization's raw data?
BI
______ change data into significant, meaningful information that helps organizations make better decisions
BI
Large collected datasets are called what?
Big Data
XBRL is
Business taging language
system that holds information about sales, marketing, customer service records, and much more
CRM
Where could you extract your info from
CRM or ERP
CAO
Chief Analitics Officer
Instead of centralized files (your oceans) in one place like a Data Warehouses or Datamarts, Hadoop uses a _________ that allows files to be stored on multiple servers
Cluster Systems
Map Reduce is like little ______ _______ that search out and query data where it resides, and process the query instead of dragging it back to a large centralized server
Computer minions
CRM stands for
Costumer Relationship Management
Computer-based systems that support an organization's decision-making activities
DSS
What is a graphical interface that characterizes specific data analysis through visualization?
Dashboard
What software helps BI become more usable through visualization?
Dashboard
BI can be described as computer applications that change ________ into significant, meaningful information that helps organizations make better decisions.
Data
What is another term for Data Mining?
Data Discovery
Collection of data from a variety of sources used to support DSS and generate BI
Data Warehouse
What consolidates disparate data?
Data Warehouse
Netflix does a lot of ___________when they suggest things you might watch
Data mining
Semistructured data
Data that can be turned into structured data
Instead of Warehouses, smaller business would use...
Datamart
What is a smaller Data Warehouse?
Datamart
DSS stands for
Decision Support System
Mining
Drilling down the data to get to the usefull infor
ETL means
Extract Transform Load
T/F If you are not a BI expert you can not use BI
FALSE, there are many easy to use softwares that have been developed
What allows a cluster system that allows data to be stored on multiple servers?
Hadoop
Where did the name "Hadoop" come from?
Hadoop was the toy elephant for his son
Business Intelligence
Historical, current and predictive data to help decision makers
Velocity
How fast you can collect data?
What held up the emergence of the Cloud?
Internet speed
Veracity
Is the data your organization collected any good?
Problem with Hadoop
It is too advanced, only good for big companies
Why is keeping enormous amounts of inventory a bad thing?
It's too expensive
Load
Load the normalized data into the data warehouses
The processing arm, or engine, of Hadoop
Map Reduce
allows data to be queried and processed directly on the server where it lives, instead of moving the data across the network to be analyzed on the computer
Map Reduce
What provides a standard format to organize data?
Normalization
Who owns Siebel
Oracle
Predictive Analytics
Predict what might happen
Reactive strategy
Reactive strategy
ROI means
Return on Investment
How does FINANCIAL SERVICES benefit from big data?
Risk analysis & fraud detection
How does HEALTHCARE benefit from big data?
Risk factors and Genome research
Biggest EMP in the world
SAP
How does GOVERNMENT benefit from big data?
Security (counter terrorism activities)
Ex of CRM
Siebel
refers to a strategy for segmenting, viewing and understanding data in a database
Slice and Dice
How does ENERGY benefit from big data?
Smart Grid
A survey would be an example of _______ data
Structured Data
_________ is data that resides in fixed formats
Structured Data
3 ways that data can be categorized...
Structured, Semi-structured, Unstructured
Example of a user friendly dashboard
Tableau
Semistructured data is NOT organized, but has _____
Tags
What is another term for Text Analytics?
Text-minning
Volume
The amount of data collected by an organization
How does ADVERTISING benefit from big data?
They can target their adds
if a customer said, "the barista was friendly", that would be categorized under the topic "Employee Friendliness." EXAMPLE OF _____
Topic Analytics
What data is disorganized and not easily read?
Unstructured
Collecting massive amounts of facebook comments and twitter post would be an example of ______ Data
Unstructured Data
Is my data structured? (4 V's)
Variety
What refers to different kinds of data?
Variety
How fast can we process the data? (4 V's)
Velocity
Is the data your organization collected any good? (4 V's)
Veracity
What refers to quality of data?
Veracity
How much data does your business need, and further, where do you keep it once you've collected it? (4 V's)
Volume
What refers to the amount of data?
Volume
4 V's of Big Data
Volume Velocity Variety Veracity
Mountain Analogy
We have mountains of data and we have to mine to get te data we want
One good way to know how much data is by knowing....
What questions you need to ask, just like jepardy
How does RETAIL benefit from big data?
Where to place stores? Where do you put your stuff?
Variety
You may have identified what data you wish to collect, but is it Structured, Semi-structured, or Unstructured?
Data Analytics
applying statistics and logic techniques to define, illustrate, and evaluate data
Data Warehouse
are used to consolidate disparate data in a central location, and lots of it!
Business Analytics
attempts to make connections between data so organization's can try to predict future trends that may give them a competitive advantage.
Descriptive Analysis
attempts to make connections between data so organization's can try to predict future trends that may give them a competitive advantage.
Dashboards
easy-to-use graphical interfaces that characterize specific data analysis through visualization
Hadoop
infrastructure for storing and processing large sets of data across multiple servers.
Apache Hadoop
is an open-source software framework written in Java for distributed storage and distributed processing of very large data sets on computer clusters built from commodity hardware.
Unstructured Data
is disorganized data that cannot be easily read or processed by a computer because it is not stored in rows and columns like traditional data tables.
Data Visualisation
is the graphic display of the results of data mining, analytics and BI in general
Decision/Prescriptive Analysis
looks at an organization's internal data and then analyzes external conditions like supply abundance and then endorse a best course of action.
ETL must happen in ______
order
Data is no good to you unless it's _________.
organized
Datamart
smaller, more focused data warehouse
Data Mining
sometimes called Data Discovery is the examination of huge sets of data to find patterns and connections, and identify outliers.
Text Analytics
sometimes called Text-mining hunts through unstructured text data to look for useful patterns, like whether their customers on Facebook.com or Instagram.com are unsatisfied with the organization's products or service.
Normalizing data
that your data is typically organized into the fields and records of a relational database.
Scrubbing and cleaning data
they got read of stuff that was not any good
Topic Analytics
tries to catalog phrases of an organization's customer feedback into relevant topics.
Data analytics makes sense of organization's data an turns it into ______ to validate future decisions
useful information
Extract
where you collect the data
