Business Intelligence Decision-making System Solution

1. Objectives of the Business Intelligence System

The business intelligence system processes the raw data based on the data collected by the Business Process Management System, and provides results conducive to decision making, helping people make business decisions correctly.

The business intelligence system should be able to thoroughly analyze the situation of suppliers, customers and the enterprise in multiple time periods, perspectives, and methods, understand the behavior of suppliers and customers, and understand the problems existing in the enterprise, this will help customers improve their business operations and services.

The business intelligence system not only reflects the situation of raw data, but also uses the modern data model method to process the original data, so as to further reveal the internal relationship between the data, to achieve business intelligence.

Based on the internationally renowned basic business intelligence platforms brio and business object, Beijing Changyi completed the development of business intelligence systems, you can extract data from an enterprise's bi server, generate OLAP reports, generate various analysis graphs, and drill up and down according to any path, this greatly facilitates the operation and management personnel of the mall to conduct in-depth analysis and decision-making on data. The system provides a variety of analysis models to analyze and extract data involving business operations, reaching the advanced level in China.

　　2. Implementation of Decision Analysis

Decision Analysis is a process of extracting, processing, and transforming data. As a business intelligence system with basic functions, it should have multiple analysis methods and methods:

(1) Arbitrary Data Extraction

After selecting certain conditions based on the queried object, you can obtain the required query content and select the queried items as you like. You can drill up or down to implement the required query as you like.

(2) sorting any data

Data such as suppliers, customers, buyers, departments, and salespersons can be sorted in a forward or reverse order. any item in the query results can be sorted.

(3) rate analysis

For each analysis object, calculate the ratio parameter that reflects its inherent characteristics, and analyze the ratio of each object between different time ranges.

(4) Trend Analysis

Analyze the development trend of a benchmark, calculate the year-on-year comparison and period-over-period comparison of the indicator, calculate the trend information such as the seasonal index, moving average, and smoothing index, and forecast the Indicator Based on the relevant model.

(5) graphic analysis

The relationships between indicators at the same time or at different times can be expressed using histograms, pie charts, line charts, scatter charts, and other graphs, allowing people to intuitively master the internal relationships between data.

(6) Correlation Analysis

Use the correlation coefficient method in statistics to calculate the correlation coefficient between two indicators, so as to know the correlation degree between the two indicators.

(7) regression analysis and Model Analysis

By calculating the regression coefficient of time series, we can obtain the variation law of a certain indicator, establish a mathematical model, and describe its prediction method to provide support for people's decision-making.

3. Decision Analysis objects

Enterprise decision-making analysis should be based on accurate understanding of analysis objects for certain objects, and certain indicators should be set for analysis objects to digitize analysis objects. Based on the actual situation of retail business, there are three direct analysis objects:

(1) Suppliers

Supplier comparison and analysis are the main means for commercial enterprises to optimize the supplier structure and improve economic efficiency.

(2) Customers

This module analyzes customer behaviors and customer status indicators to help people understand customer composition and requirements and improve customer relationships.

(3) The Enterprise

This enterprise includes the following objects:

Analysis of product composition and inventory status

The purchaser assesses the purchaser's performance.

The salesperson assesses the salesperson's performance

The Department assesses the performance of the Department.

The product category analyzes the overall situation of the product category

　　4. basic functions of the Business Intelligence System

The functions of the business intelligence system include general functions and data selection functions. Common functions can be used for public processing. You can use tool bar methods to select analysis objects.

The functions of the business information system are as follows:

(1) General Functions

Indicator selection

Data Extraction

Title Modification

RePort Printing

Display pie chart, line chart, and Histogram

Forward and reverse sorting

Calculate Correlation Coefficient

Maximum value, minimum value, average value, and variance

Moving Average processing

Moving Average Prediction

Exponential smoothing prediction

(2) Data Object Selection Function

Supplier Analysis

☆Supplier supply capability

● Number of varieties

● Average daily supply

● Average monthly supply

● Maximum daily supply

● Supply Period

☆Supplier's business structure

● Import and sale of supply Varieties

☆Supplier operation status

● Sales

● Sales ranking

● Gross profit

● Cost income

● Number of promotions

● Promotion and profit sharing

● Gift amount

● Number of items returned to the factory

● Factory return amount

● Turnover days

☆Supplier Settlement Conditions

Business Method

● Interest on borrowed funds

● Interest consumed by unit sales

☆Comprehensive evaluation of suppliers

Customer Behavior Analysis

☆Member Structure Analysis

● Age

● Gender

● Income

● Distance from a mall

● Monthly purchases

● Average unit price of each purchase

☆Member Purchase Behavior Analysis

● Average unit price of each purchase

● Proportion of various commodities

● Purchase time

● Return times

● Return amount

● Purchase amount affected by promotion activities

☆Purchase Behavior Analysis

● The purchase volume of each product category is based on age

● Gender

● Income

● Distribution of distance from a mall

☆Customer loyalty Analysis

● Percentage of unpurchased customers in total for 30 consecutive days

Enterprise Status Analysis

☆Buyer Assessment

● Purchase

● Sales

● Gross profit

● New Product Development

● Number of promotions

● Fee

● Excess stock amount

● Cost

● Capital interest

☆Salesperson Assessment

● Sales

● Return

● Transaction count

● Average customer unit price

☆Contract and Price Assessment

● Number of new product records

● Number of contracts

● Number of suppliers

● Pricing

● Price Adjustment

☆Department Performance Assessment