Product Assistant This position everyone has their own different style, some biased design, some biased operation, but also some biased technology, there are people to brag, no one good or bad, can make good products is the key.
After all, the product is basically do not need to job, but master a little technology, will improve you and research and development efficiency.
1. Basic SQL
Sometimes in fact, some backstage does not meet the needs of the data we need to see, this time need to write their own SQL query, the total can not see a pv,uv have to trouble research and development it? Trouble them one or two times, the SQL they write to take a look at, their own change can meet most of the needs, after all, we are the Internet porters, not involved in the advanced algorithm level is not too difficult, only hand-cooked er.
2.excel
With the data is not enough, need to do a chart to be more intuitive, PivotTable Dafa Good ah, here omitted a lot of words. In addition, Excel formula is best to learn a little, the process of product design is best to have data as a basis, and some partial bragging products PK when the data can make them shut up.
3.f12& Mobile phone Grab Bag
If you do a PC page, learn to use the developer tool to look at the page elements, do technical research, check bugs, pull out the text are very convenient, now the developer tools with the mobile side of the simulation, so the PC to view mobile WAP site is very convenient. Mobile end of the bag need to do through the PC agent, and then use fiddle or Charles, such as grab tools, if you see a number on the app is not correct, you can grasp the package simply to determine whether this is the result of the server return problem, or the previous section to show the problem, Do not have every time out of the bug did not know to throw to the front or backstage.
4. Miscellaneous
Change host, scientific Internet and so on are some very easy to learn, and often encounter things. In the face of problems (such as not on the web), first learn to analyze the cause of the problem, rather than pat the head and help research and development is the most basic ability. In addition, the product should be the Internet product enthusiasts, the use of good tools to improve efficiency is a kind of technology.
5. Work Skills
I have seen some colleagues in order to organize the project on the Jira, the update log written in the wiki, after the copy, each entry has a "circle" to delete, and then need to add "*", they really one delete ... One more time for a day to do this .... In fact, find a word, such as CTRL + F, find the "circle", replaced by "star", and then tick replaceall on it.