TCH traffic Business Intelligent Analysis

I have been working on BI for two years. Many times, the customer feels that you have made reports. If you are not afraid of the customer's needs, you are afraid that the customer has no requirements!

It is very painful for you to use BI without knowing what to do.

I went to the UNICOM headquarters of a province some time ago and saw a data table. The table structure is as follows.

Name Type Nullable Default Comments
--------------------------------------------------
DATE_TIME VARCHAR2 (20)
CITY_NAME VARCHAR2 (30)
BTS_ID VARCHAR2 (20)
Ci number (38)
CHINA_NAME VARCHAR2 (80) Y
AREA VARCHAR2 (30) Y
TOWN VARCHAR2 (20) Y
ATTENTION_LEVER VARCHAR2 (20) Y
ENGINEER VARCHAR2 (30) Y
TYPE1 VARCHAR2 (30) Y
TYPE VARCHAR2 (30) Y
OBJECT VARCHAR2 (50) Y
T_TRAFFIC FLOAT Y

This data source table is currently used by the customer to check the TCH traffic every day. But I don't think so. First, I think this table is good!

After a period of consideration, I raised the following questions,

 

1. What is the basic distribution of residential areas in various cities?

2 is the classification of the residential area (VIP, level 1, level 2, level 3) scientific and reasonable? What problems exist?

3. How can we use scientific methods to evaluate the value of a community based on TCH traffic?

4 is the value of a residential area associated with the residential area level and category? What kind of association?

5 does the daily traffic change of TCH have a certain rule? What are the laws of the province? Are there similar laws in different cities?

6 What are the internal influencing factors and rules of TCH traffic? Can I perform in-depth analysis using data mining methods?

 

The analysis of these problems can reflect the value of BI only by using BI. I will share with you the definition of the output ratio of the residential traffic units proposed by my friends.

Significance of this algorithm:

• The unit output ratio of traffic volume reflects the relationship between residential investment and traffic output. • The higher the unit output ratio of traffic volumes, the higher the traffic volume generated by the residential area, and vice versa. • When the unit output ratio is equal to 1, it indicates that the cell output is equal to the provincial average. When the unit output ratio is greater than 1, it indicates that the cell traffic output is higher than the provincial average. When the unit output ratio is less than 1, this indicates that the output of residential traffic is lower than the provincial average.