Data Analyst
Xi'An,Shaanxi
• Used excel to organize and integrate 474 government investment projects. provided to Vertiv to better utilize government resources and expand markets in Northwest China • Analyzed on industry segments, markets, and competition, which including Government, Education, Medical, Taxation, Public Security, export business models, and data analysis support• Constructed a logical prediction model to fill in missing values for classification, adjust each variable, and screen different… Show more • Used excel to organize and integrate 474 government investment projects. provided to Vertiv to better utilize government resources and expand markets in Northwest China • Analyzed on industry segments, markets, and competition, which including Government, Education, Medical, Taxation, Public Security, export business models, and data analysis support• Constructed a logical prediction model to fill in missing values for classification, adjust each variable, and screen different provinces and projects• Generated trend charts for each category to observe governments’ investing preference with different provinces in excel• Led the conceptualization, creation and implementation of interactive database using Excel to provide support for data query and classification result search, leading to time saving of 10% in team’s daily operations• Conducted regression analysis and forecast the government's key investment directions for the next three months, assisted the business team to quickly locate optimization goals, and provided decision support for the company's investment,which increased the company's quarterly earnings Show less