UNIT-3

Implementation of Business Intelligence:

Today, even small locally-dealing firm prefer to collect information on clients demographics
Along with their tastes and preferences as to the products or services the vendor offers.
For bigger organizations, collecting business data is a vital necessity that is highly
instrumental in analyzing historical activities and the current stand of their venture as
well as in divining market trends symptomatic of their niche for months and even years
to come.
The term “business intelligence” subsumes a whole range of procedures aimed at
collecting, hoarding, and analyzing business operations information. It can be
subsequently utilized to make knowledgeable data-driven decisions based on the
comprehensive picture this overview creates.
Activities of Business Intelligence Implementation:
 Data drilling. Specific AI and machine-learning techniques are employed to discover
and collect relevant data to trace trends in the obtained datasets.
 Data arrangement. By massing information from multiple data sources and aligning
measurements and dimensions used here, the information is prepared for further analysis.
 Bench marking. On customized dashboards, historical data is compared against the
current performance metrics to see how they fit together into the preliminary set goals.
 Querying. In the collected database, it seeks answers to very specific business-related
questions.
 Data representation. Charts, graphs, tables, and histograms can help visualize numbers to
get
Them more “digestible” for further consumption.
 Descriptive and statistical analysis. At first, you find out what happened, and then dig
into the process and causes of the development under scrutiny.
 Reporting. When the analysis is completed, all stake holders receive the results and plan
their actions correspondingly.

Benefits does successful BI implementation

 Real-time data tracking. In the modern volatile world, if we wait for reports to be
prepared for a week or two, the information they contain may well be outdated when it
reaches the decision- makers. BI implementation provides instant access to all critical data and
allows you to be proactive rather than reactive in your business choices.
 Data harmonization. Very often, fragmented pieces of data different departments
possess prevent them from correctly observing the entire picture. By business
intelligence implementation It will provide a single version of the truth, which is crucial
for the data-driven decision-making CEOs are engaged in on behalf of the whole
company.
 Enhanced visibility. Perusing hundreds of pages with statistics is tiresome and
bewildering. Successful business intelligence implementation enables us to get a clear
vision of all that happens in the organization (workflow-wise) and high light areas then
processes to focus on it.
 Boosted efficiency of your organization. Realization of problem areas is only the first
stage. It should make conclusions as to where the employees underperform, get rid of
redundant roles, and take other steps to optimize or even drastically improve the
operations. Moreover, it will be able to see the implications of the actions, realize
whether they have the desired effect, and fine-tune accordingly.
 Deeper customer in sights. Better understanding the clients’ behavior and purchasing
the form certain patterns is a key to improving both products and customer service.
 Consistent sales insights. Having real-time as well as historic sales and marketing data
at disposal, will be able to spot persistent trends in the ideal position, predict the success
of certain sectors, and thus detect ways to increase revenues riding the tide.
 A competitive edge. Business intelligence can be directed not only at the processes
inside your organization but outside as well. it can compare metrics with the
competitors’ indices and see where you lag behind and what they are doing better.
Key drivers of BI
There are many business drivers in play today that are motivating companies to establish
data warehouses. Current, consistent and accurate business information, they believe is
critical for strategic and tactical decision making.

Some of the business drivers are summarized below:

1. Single Version of the Truth

Fragmented, inconsistent and outdated data in multiple databases does not permit good
strategic and tactical decision making.

Companies require that business intelligence be consolidated and presented in a suitable

format for decision making. Inconsistent information from disparate information systems
is no longer acceptable.
Data Warehouse help the companies to achieve a single version of the truth by
consolidating the most accurate and current data from the most reliable systems.

2. Current and Accurate Information

In a highly competitive market place, businesses need to quickly identify problems and
opportunities in order to respond to events expeditiously and appropriately.

Up-to-date information on sales, profits, inventories and customers can help identify
problems early and leverage opportunities that could otherwise be missed.

Most application systems are too narrowly scoped and operate on cycles that don't
support real- time or near real-time information access.
 3. Rapidly Changing Information Needs

It is very difficult for businesses to anticipate future information needs. Application

systems often seem rigid and unable to adapt to evolving management information
needs.

Businesses need the flexibility to slice and dice data in many ways in order to identify
and analyze changes in the market place or in the business it.

Data Warehouses are designed for online, analytical purposes and provide great flexibility.

4. Customer Service Excellence

It is often said that 10% of a business's customers account for 90% of the business's
profits. Identifying the good customers and providing them with excellent service helps
retain good customers.

Data Warehousing can help identify a company's best customers using any number or
criterion.

5. New Service Delivery Channels

It is no longer sufficient to provide customers with just 9:00AM to 5:00PM in-store

service. Customers want to do business 7 days a week, 24 hours per day using alternate
service delivery channels such as via the Internet or telephone.
By examining all customer transactions, regardless of the channel used, businesses can
better understand their customers and serve them better.

Data Warehousing is critical for profiling customers and their transactions, regardless of
the channel used.
There are many technical drivers in play that are motivating companies to establish data
warehouses for online queries and analytics.

6. Multiple Internal Databases

Most medium and large businesses operate dozens, if not hundreds of un-integrated
application systems. Individual departments in companies often focus on their own
narrow system and information needs and don’t see the corporate value of integrating
data.

Companies have a need for database that reflects a "single version of truth". Data
Warehouses can help do that.

7. Purchased Packages

“Out of the Box “purchased applications sometimes use underlying concepts and
definitions that
Differ from those used by the business in existing custom built applications.

For example, a “customer” in one system could encompass all current and past
customers plus potential future customers. In another system, a customer might be
defined more narrowly as someone who has purchased a product and service during the
past 12 months.

Such inconsistencies create problems from an analytical perspective. A count of

customers done in the first database differs from a count done in the second.

Companies have a need to align concepts and terminology. Data Warehouses help do
this alignment.
 8. Increasing Complexity of Systems

The underlying data structures of application systems are often very complicated. To
create what would intuitively might appear to be a simple query often requires complex
programming logic that involves navigating multiple database tables and or applications
systems.

Writing reports or queries can consequently take time and money.

Companies have a need for a reporting environment that allows reports and queries to be
generated quickly, in expensively and without expensive IT skills. Data Warehouses can
simplify the reporting environment.

9. Application System Evolution

Businesses are highly dynamic and applications systems are constantly needing to be
enhanced to support new business requirements.

When systems are changed, reports and queries that access any changed tables must also
be updated. This maintenance work can be very costly.

Businesses have a need to trim their application support costs. Data Warehouses can help
shelter reports and queries from system changes that occur in "front end" operational
systems.
10. Computer Networks and External Databases

The rapid growth of computer networks has allowed companies to exchange data with
their suppliers, consumers, government bodies and other groups.
Businesses often have a need to integrate data from internal and external databases.
Data Warehouse can be designed to integrate corporate data with external data for
reporting purposes.