That's how I use the data: Get in the bowl.

One of the basic prerequisites of data analysis is that you have to have data to analyze

So there are some so-called data mining experts toe Gao said: Data mining the vast number of work is to clean the data!

Are some people do not eat the cargo, where the ready-made data to let them clean, the actual work I always found again and again: access to data is the hardest part

In fact, there are only two ways to get data

1, from what other systems to obtain ready-made historical data

2, from their own system to allow users to input data

Today I'd like to share my little experience on the 2nd.

First of all, the user is the most TMD annoying so-and-so system, need them to put in a lot of cooperation, the last credit or the people who do the system, they do not have the benefit of not to say, but also in order to get used to the new system, changed their habits, and even additional workload, for some reasons (such as Ann All) must also retain the original data registration method unchanged, so that users are willing to input data to your system is strange.

In fact, do not ignore this problem, because users are not actually willing to input data, your work can not continue to expand, especially we found that valuable data analysis is in the actual hands after the data are combined to explore, and not in the data has not yet yy out, so, no rice, how to cook, no rice, How can you get enough money to buy rice?

Shang, we in the long-term is neglected, slowly realize: a system to want to use good, will be in the first second to produce benefits, don't pull bastard said what long-term interests, otherwise users will be ruthless perfunctory you, you also get the long-term interests.

Take data entry for example, how the first second to produce benefits?

1, play the value of the relevant data, if the user fill out some strong correlation data, fill out a item, in fact, b we already know, then do not let users continue to input, but by associating a B, save this crucial few seconds

For example, when I register a certain terminal information, each terminal has: Cell phone card number, terminal number, installed in the car license plate number, these three are one by one corresponding, in the user input car brand, the system automatically put the phone card, terminal number filled in, the user before a bright, holding their hands of the information, check, it is true, So the goodwill, more directly is: Save the user very concerned about a few seconds

2, play the value of multiple systems integration, if the user registers a form, need a lot of system coordination, many times to complete, try to help them through, save this crucial few seconds

For example, when I'm registering a customer call business, customer's call number will be recorded in the traffic system, customer information in the CRM system has records, customer sales records in the XXXX system has records, customers xxxx in XXXXX have records, well, the original registration method must be turned over, Find all this information, and then solve the user's problem, now, I play, I first in the user to open my system, to detect whether the user is talking, if yes, then access to the telephone system, using identity information to obtain the number of the call, according to the number to access the CRM system, access to customer information, according to XXX visit XXX get xxxx .... Within a flash, all kinds of potential value information gathered together, everyone easily answered the customer's questions, improved customer satisfaction

3, play the historical data value, if the user will enter the form and certain historical data correlation is very strong, then the sufficient call historical data, tries to help them to discover the problem in time, saves this crucial few seconds

For example, when I register information for a device, I understand that these devices will only be registered once, but lax management, often repeated registration come in, I started from this problem, every time the user registration equipment, I will real-time call the historical data to determine whether the equipment has been registered in the register, and to give eye-catching tips, User A look, hey, registered, check, give up input, save a few seconds time

For example, when I register the price of a part, I will call the historical data, there is a so-called the concept of the same parts, you say this A and this b basically similar, and this 10 yuan, that 1000 yuan, this is appropriate? Obviously the input may be wrong, I give eye-catching tips to help users find early, save a few seconds of time

For example, I found that a certain customer calls every time to check a fixed information, then I identified the customer came to the phone, the background automatically prepared the information, and the recommended way to give users a reminder, the user only a little bit, everything is coming, most of them are exactly what this person wants, save a few seconds of time

4, the use of multi-purpose value, if the user can not give up the original data holding mode, we will do our best to reduce his holdings in the cost of data.

For example, users should send this batch of data into Excel anyway so I'm going to spend some of my time in the system, the usual way to input data, one-time, fast export into a specific format of Excel, which brings a lot of work, but it is worthwhile, because users will more trust you, they do not lose the fish and paws, And your system will be good and serious to use, in the long run, it would be better than the bargain.

I have mentioned "save a few seconds" in this article many times! It's a lot of people's shit, but I value it, I often measure myself, whether I really help others save time, from the beginning to save time, I deliberately do not look after things, this gives me unlimited impetus, I give myself a goal--"Lifelong Achievement Award", that is, I strive to help users save Every second of 24 hours, if I do, then I even sleep at home, it is equivalent to 24 hours of labor.

And a lot of other people do the system, tell the truth value is also very large, but the user is very painful, very trouble, time is negative, perhaps the leadership of the cool, but the first line of the user, care, I am also a part-time job, I do not see this.

I used the data to get the data into the bowl, what about you?

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Programming/project/