Fitting BI With Other

Download as pdf or txt
Download as pdf or txt
You are on page 1of 13

Fitting BI with Other

Technology Disciplines
Aman Shakya
Overview of BI Software
Overview of BI Products and Vendors
• BI market as an aspect of everything in the technology stack — from
the operational data to the user-facing tools that spit out those
valuable insights:
• The BI software market is notoriously dynamic.
• niche players vs. large software vendors
• There is no such thing as a one-size-fits-all solution in BI software.
The dimensional model
• Feature set
• Compatibility
• Packaging
• Performance
• Ease of use
The BI Software Marketplace
BI and Datawarehousing
• BI must be connected with an organization’s data to be effective
• The challenge is to put all the necessary data in one place
• Data warehouses are the perfect architecture to meet that challenge
• A data warehouse is a single logical (but not necessarily physical)
repository for a company’s transactional or operational data.
• Data warehouses resolve differences
• Business intelligence and data warehousing are closely related
because it is the single data store (the aggregation of disparate data
sources) that allows BI processes to take place.
BI and Datawarehousing
ERP and BI
• ERP (Enterprise Resource Planning) applications could run and have
everyone in a company looking at the same data
• SAP was first on the scene, but others quickly followed. PeopleSoft,
Baan, Oracle, Lawson, and JD Edwards were all pioneers in
client/server ERP.
• ERP companies offered a complete solution to the Y2K problem
• replacing legacy systems with a unified set of ERP applications
ERP and BI
• ERP lead to the foundations of BI
• Forward-thinking ERP vendors started adding powerful reporting and
analytic packages to their application suites to add further value for
their customers.
• SAP was a trendsetter, introducing SAP BW (Business Warehouse) in
1997
CRM
• CRM stands for Customer Relationship Management.
• It refers to software that handles all aspects of an organization’s
interactions with its customers.
• That may include the entire sales cycle, from winning new customers, to
servicing and tracking existing customers, to providing post-sales services.
• CRM applications can touch lots of pieces of a business.
• ERP vendors began including CRM applications in their enterprise suites
• CRM systems would become more involved in decision-support processes
• Support marketing practices/ Campaign management like customer loyalty
management, churn management, and customer reacquisition
E-Commerce Takes BI Online
• When the Internet first began popping up in homes, CRM software
displayed little more than the same content you might find in sales
brochures.
• Amazon founder Jeffrey Bezos and his apparent fascination with
analytics were largely responsible for pushing BI into the e-commerce
realm
• He tracked every move customers made — and had the Web
application respond to those moves
• When you add books to your shopping cart, the system performs
real-time analysis to recommend other books to you.
Real-time business intelligence
• As you shop, sophisticated analytics are running in the background —
comparing your habits and online activities with those of millions of
customers who came before you.
• This customer-facing system can then react to you in real time and
present you with options that make you more likely to spend more,
return again and again, and be happy with the experience.
• BI capabilities shaping a Web site’s behavior on the fly — represents a
level of complexity and utility that isn’t commonly seen in the other
technology disciplines like ERP and CRM.
The Finance Function and BI
• The budgeting and planning process for organizations had always
been intensely manual
• Business intelligence found fertile soil in the global finance functions.
• Business intelligence technology allows planners to perform what-if
analyses, run budgets through predictive and profitability analyses,
and create scorecards and dashboards to aid in corporate
performance management practices.
• BI not only speeds up these processes, it also gives the finance
department far more confidence in the numbers themselves.

You might also like