In this mention from a book Using Open Source Platforms for Business Intelligence:
Avoid Pitfalls and Maximize ROI, author Lyndsay Wise, boss and owner of Toronto-based
consultancy WiseAnalytics, digs into a subject of BI adoption. Wise examines since organizations
might cruise implementing business comprehension program in ubiquitous and open source BI collection in
particular. She looks during how businesses can advantage from a BI plan yet discusses a importance
of assessing business goals and existent IT infrastructure before starting a deployment.
The initial of 3 segments from Chapter 8 of Wise’s book, this territory introduces key
factors that companies contingency cruise in weighing a choice between open source business intelligence
software and compulsory BI technology. In addition, readers will learn about some of the
advantages that outcome from adopting BI tools, including information consolidation, increased
organizational prominence and softened risk mitigation.
Table of Contents
Open source BI tools: Do they accommodate your business goals?
Reasons for selecting open
source business comprehension software
source tools aren’t a best BI program for an organization
The plan behind BI adoption
Understanding a universe of open source business comprehension (OSBI), some of a differences
within a marketplace, and since vendors position themselves as they do are a initial step towards
identifying either this form of BI deployment matches a mandate of your organization. If
you are looking for an OSBI charity or perplexing to confirm a form of deployment we should select,
the subsequent set of questions we and your colleagues should be seeking are “what do we do with this
information?” And “how do we confirm what will work best for a organization?” After all, software
selection is not as easy as shutting your eyes and indicating to a vendor’s trademark on your computer
screen. It requires being means to sell a value of BI to government and defining what isn’t
working in a stream system, how BI can make it better, and what options competence work best within
your IT environment.
This mention is from a book Using Open Source Platforms for Business Intelligence: Avoid
Pitfalls and Maximize ROI, by Lyndsay Wise. Published by Morgan Kaufmann Publishers,
Burlington, Mass. ISBN 978-0124158115. Copyright 2012, Elsevier BV. For some-more info, greatfully revisit the
Elsevier store website.
This section has a lofty idea of addressing these questions. After all, in sequence to identify
is right for you, it is critical to initial cruise how BI will support a organization’s
strategic goals. Once we make this decision, it becomes probable to brand either OS fits
within a company’s business strategy. Obviously, some organizations bypass in-depth evaluations
and name program formed on prior use or recommendations from friends. Although this can also
work, a incomparable a bargain of what exists internally, a some-more expected that a overall
project will be successful.
One of a problems with a BI marketplace currently is that unless an organization is good versed
in all of a solutions available, many solutions demeanour comparison and can yield identical things during face
value. Yes, vendors have their pivotal differentiations, yet a existence is that many solutions can be
customized to yield like facilities and functionality. Being means to optimize a solution,
however, is one of a pivotal differences when going a stretch and holding a time to compare vendor
requirements with business goals and a existent IT infrastructure.
Let’s take this one step serve by looking during a purpose of developers and a routine they need
to go by to exercise an finish user confronting BI solution. Generally, IT developers take a lot of
time putting a pieces of a information nonplus together. This means they demeanour during any list within each
data source and brand if and how information is associated and that fields are required. For
instance, what product information exists and where it is stored, how it relates in one list to
various other tables, what information is required, and what calculations are compulsory to make sure
that business users can get a insights they need to make a best decisions possible.
Doing all of this effectively is no easy task. Some tables competence residence Product Number, while
others use a apart Product ID descriptor, with others still providing a Name and Description. To
create a unaccompanied viewpoint of data, all of this information needs to be combined and, in many
cases, product numbers do not follow a specific structure. So, fixing conventions competence not be
standardized and like names or descriptions competence be used that meant opposite things to different
employees. And even within information room infrastructures that lift in all of a information though all
of these information joins and additional preparation, these tasks are still compulsory to rise strategic
The bottom line is that to get a many out of your information from a business perspective, we need
- An bargain of what we wish to grasp and since BI is critical as a pivotal support to you
and your organization’s goals.
- Collaboration between business units and IT to assistance optimize information access.
- Insights into what we competence need in a prolonged run, either from a business or data
- A extended bargain of your corporate culture, as opposite cultures will flower using
different forms of BI applications.
- Visibility into your information resources and what we wish to reap from them.
All of these aspects request to both OSBI and BI implementations. Understanding a value
proposition of BI and a pivotal advantages of OS (which will be discussed in a arriving chapters)
can assistance we confirm either it creates clarity to take a plunge, or name a some-more traditional
approach to BI adoption. Let’s demeanour during all of this in some-more fact by violation down a strategic
side of BI deployments — from a business perspective.
One of a reasons we cruise it is so critical to take a step divided from open source BI and look
strategy and a ubiquitous value of BI is since we pronounce with a lot of organizations about BI,
whether conducting attention research, providing advisory services, or putting together case
studies. One of a issues that constantly come adult is a fact that a attention is formidable to
navigate. we am mostly asked, “Which product should we select?” Or, “I review an essay about businessman X,
should we exercise their solution?” And in many situations, these questions need a lot more
knowledge about a stream IT infrastructure that exists, business needs, etc.
In addition, some of these same companies are new to BI. In these cases, they have been using
Excel and it isn’t operative for them anymore — some even call it their “Excel Hell.” According to
these companies, being means to remove information, put it in a spreadsheet, and manipulate it to
your heart’s calm ends adult being a discord to building a clever information infrastructure, or
ensuring information validity, privacy, security, and accuracy. Consequently, where spreadsheets have been
beneficial for a individual, a house is starting to humour due to a miss of consistency
across a organization.
This leads to a broader bargain of since many companies demeanour during BI, that is fundamentally to
address a uncertainties that arise due to a miss of trust in a information that is available. However,
there are also many other reasons. Let’s try some of a reasons behind BI’s increasing
importance within organizations and how a use is apropos essential to ensuring strategic
Goals of consolidating information opposite manifold information sources
The Excel instance usually discussed is a good segue into a contention of a need for data
consolidation. There is a common instance used by BI practitioners and resolution providers to
illustrate since Excel on a incomparable scale does not work and since it is critical to rise a secure
and centralized entrance indicate to business information. Basically, it goes something like this. A
planning assembly is called to assistance brand either or not a pronounced association is on lane mid-year
and to brand either it will accommodate a altogether sales goals. Each dialect sends a nominee with
a prepared display to brand sales, accounts receivable, accounts payable, supply chain,
partner networks, etc. And any deputy has taken a time to ready a pivotal metrics
related to his or her business duty by exporting information into Excel, adding calculations
based on departmental business rules, and utilizing it to fit individualized purposes.
When all of these preference makers come together and benefaction their information, they find that
their numbers don’t compare up. Basically, it becomes unfit to brand opening when the
validity of a information is questionable. Questions arise, such as, that dialect is right? How can
we trust a information? What calculations were applied? And where do we go from here? These are
all current questions that need to be addressed if organizations wish to rise a unchanging approach of
managing their data.
There is a consistent discuss over either formulating a “single
view of a truth” is indeed possible, that a ubiquitous Internet hunt will uncover we based
on a series of results. Although it falls outward a range of this book, it is still important
to know that even yet information is consolidated and needs to be accurate and valid, that one
version of a law does not exist. Each department does have a possess viewpoint of information and business
entities. What does exist is a intensity to emanate an accurate, centralized repository that is
monitored for effect in a secure way. In this sense, combined information provides a improved viewpoint of
performance opposite a organization, that is not singular to a dialect or business function.
Better business visibility
All of this leads to improved altogether visibility. Once information can be devoted and accessed
across a organization, it can be used to yield improved visibility. Organizations used to silos
can now benefit a broader bargain of what is function within their companies. On a high level
this sounds simple, yet when we demeanour some-more deeply we see that this is indeed a pivotal reason that
many organizations cruise building a information warehouse. Some companies indeed start their BI projects
with a idea of building a clever information room infrastructure, and a reason is to achieve
exactly what we have been deliberating — a centralized entrance indicate to information to yield better
customer service, product allocation and prominence into broader business operations.
Traditionally, many businesses rise operational systems separately, with information stored
separately as well. Therefore, a usually approach to know what is occurring over HR, financial or
supply sequence is to emanate a executive information store. Once companies wish to know how financial and
accounting intersects with sales and distribution, or how patron compensation can be used to
up-sell and enhance sales, a ability to viewpoint information opposite a classification in a centralized
repository becomes essential.
Another reason organizations demeanour during BI is to assistance lessen risk. In a past, most risk
management within BI remained within a area of finance, insurance, and banking, yet most
organizations need to cruise intensity risk and assistance lessen a effects on a organization.
Within BI, this goes over information prominence and means regulating predictive displaying and other
advanced statistical models to safeguard that business with accounts past due are not authorised to
submit new orders unless it is famous beforehand, or that word claims aren’t being submitted
The National Health Care Anti-Fraud Association (NHCAA) estimates that in 2010, 3% of all health
care spending — or $68 billion — was mislaid to health caring rascal in a United States.This makes
fraud showing in health caring intensely important, generally when we cruise that if we are
paying for word in a United States, partial of your word premiums are substantially being paid
to cover a instances of rascal that occur, creation this applicable over health caring insurance
providers. Although risk competence not be as apparent within all industries or organizations, many
businesses still wish to make certain they do not deposit their resources in unprofitable products or
projects. In these cases, a specific hurdles of risk comment competence not be as good yet still
require a strategic growth and use of BI and analytics.
- Continue to a subsequent section: Reasons for choosing
open source business comprehension software.
- Read a QA
with author Lyndsay Wise.
This was initial published in Feb 2013