COURSE PACKET 4 Flashcards
____ is a set of theories, methodologies, processes,
architectures, and technologies that transform raw data into meaningful and
useful information for business purposes
Business intelligence (BI)
is about getting the right information, to the
right decision makers, at the right time.
Business Intelligence (BI)
enterprise-wide platform that supports reporting, analysis and
decision making that leads to fact-based decision making “single version of the
truth”
BI
committed ______ from the top is a vitally important
element. Repeated studies have shown that a lack of commitment at the
top is a major reason BI projects fail.
LEADERSHIP
another important factor. You have to have a clear
vision of what you’re trying to accomplish and how you intend to get
there. Further, this vision has to be aligned with your business goals.
STRATEGY
Dedicated ______ are also central to making BI succeed.
This includes not just the people who use BI, but also the
supporting players. Quality staff becomes more important as BI works to
wring value out of the operation.
PEOPLE
This one comes far down the list for a reason. While ______ is an important enabler for BI, it is not the dominant factor
TECHNOLOGY
have to be in place to make
BI central to your business’ efforts. This means change in your business
processes and the organization has to accept change. This is another place
where top level support is vital.
Organizational Dynamics
Which customers should I target?
What has caused the change in my pipeline? Which are my most profitable campaigns per region?
Did store sales spike when we advertised in the local paper or launched
an email campaign?
What is the most profitable source of sales leads and how has that changed
over time?
SALES AND MARKETING
Which vendors are best at delivering on time and on budget? – How many
additional personnel do we need to add per store during the holidays?
Which order processing processes are most inefficient?
OPERATIONAL
What is the fully loaded cost of new products?
What is the expected annual profit/loss based on current marketing and
sales forecasts?
How are forecasts trending against the annual plan?
What are the current trends in cash flow, accounts payable and accounts
receivable and how do they compare with plan?
FINANCIAL
improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions
Business Intelligence VIsion
lives and breathes data. A
statistician by nature, they will drill deep down into data, looking for fresh
insights that will be used to underscore business strategy. The role includes
documenting all your business data, identifying patterns and creating reports
and dashboards that will support the decision-making process.
The Data Analyst
The CEO, of course, is at the helm of the business, driving the
company’s success by improving operational analytics efficiency and
constantly looking for ways to reduce costs.
The Executive
has the capability
of working with complex data sets
power user
____ will make use of
dashboards to analyze predefined sets of data.
casual user
is another key player in the BI process. The ___ user still plays a central
role – maintaining the infrastructure and giving departments the tools that
allow them to fulfill their own data requests
the IT Team
defining which data will be loaded into the system and
analyzed.
Stage 1. The Data
extracts data from
multiple sources, transforms it into a format satisfying the operational and analytical requirements of the business, and loads it to a target destination, such
as a database or data warehouse..
Stage 2. The ETL (Extract, Transform, and Load) Engine
Connects electronic data from different operational systems so
that the data can be queried and analyzed over time for business
decision making.
Stage 3. Data Warehousing
Analyzes multidimensional data sets found in a data warehouse to
identify trends, outliers, and patterns.
Stage 4. Analytic Engine
The dashboards, reports and alerts that present findings from the analysis.
Typically, Technology Agnostic
Stage 5. Presentation Layer
The main focus of _____
system is to record the
current Update, Insertion
and Deletion while
transaction. ____ administers day to day
transaction of an
organization.
Online Transaction processing (OLTP)
____ database stores
historical data that has
been inputted by OLTP. It
allows a user to view
different summaries of
multi-dimensional data.
Using ____, you can
extract information from a
large database and
analyze it for decision
making.
Online Analytical Processing (OLAP)
is a
relational database
management system
(RDBMS) developed by
Microsoft.
MS SQL Server
______ Service is a fully managed
database service to
deploy cloud-native
applications using the
world’s most popular open
source database.
MySQL Database
A ____ is a
request for data from a
database. Usually the
request is to retrieve data;
however, data can also be
manipulated using
queries.
database query
A software system used to
maintain relational
databases is a _____
relational
database management
system (RDBMS)
_____ is an analytically oriented, integrated, time-
variant, and nonvolatile collection of data that supports decision
making processes
Data warehouse
is a data store for implementation of decision-making activities.
It stores historical data which is used by enterprises for making strategies in their
business processes.
data warehouse
It is the process of extracting patterns from data.
can be used to uncover patterns in data but is often
carried out only on samples of data
Data Mining
____ is a term that we use in the business
that simply means, we are unbiased towards the use of different
technology tools to solve different problems.
Technology agnostic
a set of high-level reports on key metrics, typically
for managers.
Dashboard
