• Use SQL to retrieve data such as user consumption, mobile plan, and business subscriptions, and regularly sort out commonly used sentences and send them to other departments.• Use R language for data analysis, track and analyze the scale of high-value customers above 80 yuan, inflow and outflow, etc., track and analyze the participation volume of each marketing activity, target customer participation rate, and marketing activity effect every quarter..• Complete the data analysis summary report, analyze the communication share, the number of broadband net additions, and the number of 4G customers net additions.• Organize the "On campus orientation Card" activity, understand student needs through data analysis and interviews of previous years of orientation activities, extract 3 student needed points, optimize the 25 yuan student discount plan, and achieve a 43% market share.

•Complete the assessment of the customer's risk tolerance, make a reasonable property investment plan, and obtain 100% customer satisfaction.• Responsible for a six-person team to compare and analyze the two case companies through Porter's five forces model and SMART model.• Analyze the future expectations of the two companies, make investment plans, and write research reports.