Business Intelligence

Business Intelligence Architecture
 

Reference : http://www.crowsol.com/services/business-intelligence/

Jacob Memo : 

Exacting works  - Sophisticated System

 영업부 대략의 금액과 그래프 수준의 수치들을 제공하면 OK

 수입관리 자체시스템의 특성이 아닌

         Navitaire 시스템의 사상과 충돌나는 영업전략 (다양할 수 밖에 없는) 의 수용에 

         있어서의 어려움.

 --> 영업에서 발생하는 모든 금액을 각 그룹별로 쪼개어 회계측에 넘겨야 하는 업무

 --> 회계  1 원도 틀려서는 안된다.

OLTP  --> ODS --> DataMart  

--> DataWarehouse (Cubes)

--> OLAP (Star or multidimensional data model, complex analytical and ad-hoc queries)  

--> Business Intelligence --> Data Mining

Business intelligence (BI) refers to computer-based techniques used in identifying,extracting,[clarification needed] and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes.[1]

BI technologies provide historical, current and predictive views of business operations. Common functions of business intelligence technologies are reporting, online analytical processing, analytics,data mining, process mining, business performance management, benchmarking, text mining and predictive analytics.

Business intelligence aims to support better business decision-making. Thus a BI system can be called a decision support system (DSS).[2] Though the term business intelligence is sometimes used as a synonym for competitive intelligence, because they both support decision making, BI uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors. Business intelligence understood broadly can include the subset of competitive intelligence.[3] 

http://www.youtube.com/watch?v=gO5cuhp25HQ&feature=related

youtube BI  

Business Intelligence

Informed Decision-Making Based on Data

Business Intelligence (BI) enables better decision-making based on facts. It enables your organization to acquire a clear understanding of market behavior and commercial context. There are common questions that most companies have:

What are the best selling products?

How does this quarter's sales compare with last quarter?

Where are the top sales dollars generated?

Who are the bottom 5 employees based on profitability?

These types of questions can be answered by providing a way for business data to be structured in a way to enable the retrieval of related information. Crowell Solutions enables organizations to use Business Intelligence technology offerings as a means to provide this type of intelligence capability.

Source Systems

Most companies have distributed stores of data pertaining to the respective departments. Sales departments typically have metrics related to sales and performance. Inventory warehouses deal with their own set of metrics in relation to physical products or assets. These differing sources of data make up the business intelligence landscape for the company.

Data Staging Area

The different source data that comprise the company's business information need to eventually be stored in a data warehouse. There is a process called Extract Transform and Load (ETL) that facilitates means of formatting data from different sources so that they can be loaded into a data warehouse structure.

Data Warehouse

The varying forms of data get stored in a Data Warehouse. The Data Warehouse is the structure that facilitates the main work of business intelligence - reporting and analysis. Bits of data are structured in a way to facilitate flexible matrices that ultimately can be configured to display data in multiple dimensions by utilizing the concept of Online Analytical Processing (OLAP). This concept provides a configurable structure to analyze data.

User Interface

The business intelligence analysis can materialize in several different ways. Web-based applications can display information dashboards that display information. The data can also be accessed through reports generated by report writers. Custom applications can also display this data as well and any type of Ad-Hoc Query tools. 

Business intelligence is the process of extracting data from a database and then analyzing that data for information that you can use to make informed business decisions and take action[i].  The following diagram shows the overall framework for Business Intelligence[ii].

 

 

On the left side of the model are the various sources of data.  All of these sources of data are collected in the Data Warehouse, which we will discuss with the next question.  Out of the data warehouse comes several Data Marts that are specific to the companies departments.  The data from these data marts are then used in a Decision Support System (DSS) that is labeled as BI.  This system can be accessed by any permissible computers in the company to help make educated business decisions.

 

The model below shows us an example of a Delta Business Intelligence system that Steve Wong presented to our class[iii].

 

 

 

There are thousands of applications for decision making in various areas of a business.  Some examples of projects that I have worked on in my company include CRM, Pipeline Management, Internal Support Reports, and Knowledge Management ‘Best Practices’.  I have successfully managed a project where we implemented Siebel CRM OnDemand.  This system is allowing our company access to analytics and reports that we have never seen before.  Our sales management and executives can see customer information, salesperson reports, territory data, and even how well a particular product is selling.  It has completely changed how our company makes decisions.

 

            The next application can be seen with a project I created called a Sales Funnel.  This application allows our finance department and executives the ability to forecast our sales into the next quarter based on our existing sales opportunities, not industry data.  Each sales opportunity was given a percentage to close number based on the respective step in the sales life cycle.

 

            The internal support system that I created allowed the support manager to see and know what issues were open, who owned the issue, and details around receipt and promised times of closure.  This allowed the support manager to shift resources or priorities based on current demand.

 

            The knowledge Management ‘Best Practices’ project was created in response to our many siloed call centers that do not actively communicate with each other.  This knowledge management system allows service alerts, discontinues product information, product changes, facility changes, etc to be communicated to all call centers all while stored in one location.  This allows all the call centers access to customer and company data so that they can all be on the same page and be one face to the customer.

Reference : https://www.student.gsu.edu/~dsisco1/BI/BIMidterm/BI.htm

 

Reference : http://www.crowsol.com/services/business-intelligence/