Lesson Reviewer in Bia
Lesson Reviewer in Bia
Lesson 1: Business Intelligence in the Era of Big Data the variety of data that collectively constitute big
and Cognitive Business data.
The business benefits being touted were couched in That “out of the box” potential means nothing without
high-level business terms like agile business and intelligent use of the potential to create incremental
customer intimacy, but what was being sold was a revenues and/or reduce or optimize expenses. Vendors
package of canned reports with little connection to the are sophisticated at convincing business executives and
business benefits being claimed. managers that their “solution” reduces risk, speeds up
time to value, and creates competitive advantage—out of
3) It might be hype if. . . you’re being sold a race car and the box and without any customization. In other words,
your company is just learning to ride a bike. When it their product is a silver bullet for solving all manner of
comes to BI, big data, analytics, and cognitive business, complicated business challenges.
even the most successful companies in many industries
are just starting to move up the maturity curve. 6) It might be hype if. . . a technology vendor conveys
the idea that all one needs to do is buy their product and
4) It might be hype if. . . the topic is big data, big data the company will obtain benefits like improved profits.
analytics, or cognitive business. The “next big thing” in BI, analytics, big data, and cognitive business need to be
BI comes along every couple of years and then fizzles. business-driven initiatives, not technology-driven.
Pushed by big consulting firms, big vendors, and
prominent analyst firms, these latest concepts are all the If a company can develop a clear vision and concrete
rage at a given point in time. strategy for leveraging business information and
business analyses, the technology piece can be figured
In real world practices: out and is generally low-risk if one uses tools that have
been around for a long time.
● Many successful big companies haven’t even There is no substitute for aligning BI, analytics, big data,
leveraged regular data yet, let alone big data or and/or cognitive business applications with core business
cognitive computing; process, managing process and cultural change, and
● The most valuable data for BI and analytics are driving adoption of the applications by business users.
generally the common, mundane transactional
data, customer data, and financial data that A BUSINESS VIEW OF BIG DATA
companies have had for years—data that is the
key to understanding the economic performance Data volume.
of the company and what drives it; ➢ There is no argument that the Internet and the
social media revolution have spawned vast
In real world practices: amounts of new kinds of data. And new
technical approaches to storing and managing
● Big data in the form of unstructured digital these vast volumes of new data have evolved to
content such as pictures, video clips, text make the cost of keeping that data much less
messages, and document images is of unproven expensive. So, we can store big data cheaply, but
value in many traditional (non-Internet based) the “garbage in, garbage out” maxim still
companies; applies. From a business perspective, what is
● Many traditional companies do not generate important is determining the utility of that data
unstructured digital content in the normal course for creating
of their business, though marketers are starting business value.
to leverage web and social media data. Data velocity.
➢ More broadly, the explosion of social media
5) It might be hype if. . . you hear the term “out of the activity and Internet commerce means that there
box” in relation to any BI, analytics, big data, or are hundreds of millions of pieces of data
cognitive business software product or service. Software created every second.
vendors design standard products that they hope to ➢ From a business perspective, what is important
license to millions of users. is determining whether and
how high data velocities are relevant and useful
for creating business value.
that content will be used to increase revenues,
Data variety. reduce costs, or both.
➢ What is supposedly new with big data is the
capture and storage of unstructured data or semi
structured data—all of it digital but much of it
not really “data” in the traditional sense of the LESSON 2: BUSINESS DATA THAT PROVIDES
word. The pictures, video clips, text messages, ANALYTICAL PERSPECTIVE
document images, and web logs stored today
could arguably be called “content” or “digital
content” rather than data. In fact, in the Reports
document management and workflow worlds,
many of these types of unstructured data are It is an account or statement describing in detail an
considered content. event, situation, or the like, usually as the result of
observation, inquiry, etc.
From a business perspective, what is important is
determining how these various forms of “big data Types of Reports That Business Analysts Need to Learn:
content” can be used to create business value.
General Reports;
As to the business importance of big data, we might Aggregate Reports
reasonably point out that:
Dashboard Reports.
● New varieties of digital content will be
important if they can be used to increase
revenues, reduce costs, or both—and this will General Reports
depend on industry-specific and company-
specific factors; These are the most commonly used type of reports. They
● Increased volumes of digital content will use an Excel-like design pattern that supports unlimited
be important if the content can be used expansion of rows and columns, multiple sheets, and
to increase revenues, reduce costs, or cross-sheet calculations and so on. Users can use general
both—otherwise one could be spending reports for parameter query, data entry, chart design, etc.
money to store ever-increasing volumes
And general reports can be divided into detail report,
of
grouped report, crosstab report, column report, query
trash.
● Increased velocities of digital content report, data entry report, etc.
will be important if the content can be
used to increase revenues, reduce costs,
or both and its utility for doing so is Business Scenarios
time-dependent—otherwise one could
be spending money to accumulate trash The general reports can replace all kinds of traditional
more quickly. reports made by Excel in the enterprise, greatly reducing
production time. And the reports can be viewed on the
web thanks to B/S (browser/server) structure.
Business Scenarios
Business Scenarios
In the traditional report design interface, it is
cumbersome to freely match different forms, graphics,
controls, etc. on one page. Dashboard reports provide a other expenses without having to give up quality and
simple and efficient way to design and quickly build a efficiency.
business dashboard.
Cementos Argos is a cement company with operations in Solution: Sabre developed an enterprise travel data
the U.S., Central and South America and the Caribbean. warehouse (ETDW) to hold its enormous amounts of
data. Sabre executive dashboards provide near real-time
Challenge: The company looked for an overall insights in user-friendly environments with a 360-degree
competitive advantage and a way to support better overview of business health, reservations, operational
decision-making. performance and ticketing.
Solution: Cementos Argos created a dedicated business Results: The scalable infrastructure, graphic user
analytics center. The company invested in experienced interface, data aggregation and ability to work
business analysts and data science teams and used BI to collaboratively have led to more revenue and increased
leverage data. client satisfaction.
Results: The company standardized the finance process Real-World Examples of Business Intelligence at Work:
and applied big data to gain more in-depth insight into
customer behavior which yielded a higher profitability 5) Spear Education: BI Streamlines Internal Processes
level. and Workflow
Real-World Examples of Business Intelligence at Work: Spear Education is a leader in continuing education for
dentists.
3) Baylis & Harding: BI Provides Decision Making
Process Support Challenges: Spear's phone system was lacking
functionality that could make its customer service reps
Baylis & Harding is a wholesale distributor specializing work more efficiently and provide better customer
in world-class toiletries and gift sets found in major and service. For example, their phone system didn’t record
independent resellers. calls and wasn’t connected to a customer relationship
management (CRM) tool.
Challenge: The company needed to give managers and
executives greater visibility into financial, customer and Solution: After some research, Spear connected its call
sales data to make better decisions and expand the center software with its BI solution to maintain more
business.
thorough customer interaction records and provide a metrics to find ways to optimize processes.
complete view of customer interactions. Business intelligence can also ensure that
service level agreements are met and help
Results: After implementing a new solution for their improve distribution routes.
contact center, Spear increased agent efficiency and
saved the company 35 hours of rep time per week.
Human Resources:
Spear's agents now reinvest that time by placing 4,000
more outbound calls every week. Today, human resources are one of the most
principal functions of an organization. The
number of applications, workforce management,
INDUSTRY VIEW OF BUSINESS INTELLIGENCE. recruitment processes, and the analysis of staff
has risen to the point where manual screening
Data scientists and analysts:
and optimizing processes is no longer possible.
Analysts are BI power users, and they Keeping the ‘human’ aspect of a company
use centralized company data paired healthy and productive while welcoming the
with powerful analytics tools to best candidates for the advertised position are
understand where opportunities for crucial elements of success. Business
improvement exist and what strategic intelligence can upscale all of these processes
recommendations to propose to with advanced analytics and visualizations that
company leadership. will enable each member of the team to see a
clear overview of the state of human resources.
Finance:
By blending financial data with
operations, marketing and sales data,
FACTORS THAT INFLUENCE THE IMPORTANCE
users can pull insights from which
decisions can be acted upon and OF BUSINESS INTELLIGENCE.
understand factors that impact profit and
loss.
Marketing: 1. The number of individual customers a company
Business intelligence tools help serves.
marketers track campaign metrics from 2. The number of products or services a company
a central digital space. BI systems can offers.
provide real-time campaign tracking,
measure each effort’s performance and 3. The number of suppliers from whom a company
plan for future campaigns. This data obtains products or services.
gives marketing teams more visibility
into overall performance and provides 4. The number of geographies in which a company
contextual visuals for sharing with the operates.
company.
5. The number of business units a company has.
Sales:
6. The variability of the demand for a company’s
Sales data analysts and operation
products or services.
managers often use BI dashboards and
key performance indicators (KPIs) for 7. The number of industries in which a company
quick access to complex information operates.
like discount analysis, customer
profitability and customer lifetime 8. The position of the company in the supply chain.
value. Sales managers monitor revenue
targets, sales rep performance along 9. How competitors are using BI to an advantage.
with the status of the sales pipeline
LESSON 4: BUSINESS INTELLIGENCE
using dashboards with reports and data
OPPORTUNITY ANALYSIS
visualizations.
Operations: Some things to remember:
To save time and resources, managers can
access and analyze data like supply chain
To create value, investments must increase net after-tax The goal of BI Opportunity Analysis is to align
cash flows into the business. business strategies, functional strategies, business
processes, and potential investments in BI—which we
Companies spend millions to provide information and
call BI Opportunities, or BIOs for short.
analyses (BI) for running the business and improving
results.
A business strategy is an outline of the actions and
decisions a company plans to take to reach its goals and
Business Intelligence Opportunity Analysis provides
objectives.
the economic rationale and business case for investing in
Business Intelligence. The primary assumption is that ➢ A business strategy defines what the company needs
strategies and financial results are realized through to do to reach its goals, which can help guide the
business processes, and Business Intelligence can be decision-making process for hiring as well as resource
leveraged to improve business processes. allocation.
investment?
BI Opportunity Analysis differs from a “data subject”
➢ How much time must our business and IT approach because it identifies specific BI applications
that aim to impact specific business processes in defined
people invest over what timeframe? ways that generate targeted economic results.
➢ How much risk does the proposed
➢ What are the critical success factors and how well are BI Opportunity Analysis is to develop answers to the
we prepared to meet them?
following questions:
➢ What business information do we need? ➢ What reveals what business processes are important to
business analyses do we want to be able to do using the measure, manage, and improve.
business information?
➢ What business decisions do we want to support using A strategy map is a means of aligning business
the business information and analyses? strategies, goals and objectives with:
➢ Which core/key business processes would be (1) The company’s value propositions for its customers;
improved by leveraging better information and more
robust analyses? (2) The internal business processes through which
➢ What would be the potential business/economic customer value propositions are achieved;
impact of improving those business processes? (3) The internal processes by which the company
➢ How much change to people, process, and technology develops itself and its people.
would be involved?