Developed dashboards/reports to meet internal/external business/customers’ needs that require the transformation of data into insights and solutions in a user-friendly format. Developed a user activities dashboard by utilizing MySQL, Azure Data Studio, and advanced Power BI features to analyze CAPS website user activities. Used SQL queries and Power BI data modeling to gather/transform over 500+ companies’ information which contains over 10,000 rows of data across 5+ different relative tables to solve many internal tracking issues.Built/developed an interactive dashboard using advanced Power BI skills (DAX, Charticulator, Power Query... ,etc.) to assess over 400+ suppliers’ information and survey results to help identify actionable insights.Pulls from data, insights, and content to tell SM / benchmarking story using advanced PowerPoint design skills to build visually professional reports, building professional grade infographics for every report.Use SQL queries (JOINS, GROUP BY, ORDER, WHERE and CASE, etc.) to retrieve data stored in a SQL database for reports.Decreased 30% of project time by implanting a better ETL (extract, transform, and load) data process, and automatic reporting process using Power BI.Working with the IT manager to improve the end-to-end data collection process and initiate the development of CAPS maturity model assessment.Working across different business functions (sales, marketing and financial, etc.) to develop different Power BI dashboards for internal and external needs.Training the team on Power BI / SQL / Data management skills.

Utilized Power BI to build interactive reports using advanced functionality of DAX, Azure, and Data Modeling.Used intermediate SQL queries (INNER JOINS, GROUP BY, ORDER BY) to retrieve data for reports stored in a SQL database.Pulls from insights, content expert to tell SM / benchmarking story.Receives misc. requests from project managers, works with experts to pull and provide information to export.Translation of insights, data into relevant output, custom reports. Work with marketing to create report templates for different report types.Using advanced PowerPoint design skills to build visually professional reports, building professional grade infographics for every report.Manage online visual charts with IT Manager.

Prepare and organize data gathered from surveys for use in analysisUse common statistical and data analysis to prepare survey results for reportingCreate reports for CAPS business customers that summarize the collected dataCreate charts, graphs, and other visualizations in reports as neededAssist with data collection and verification; assist with survey creation and survey programmingRespond to business customers’ requests in a timely mannerAssist CAPS team members in creating PowerPoint slides for business presentationsAssist with process improvement, problem-solving, and support of special projectsMay represent CAPS by participating in meetings and phone calls with business customersPerform other duties as assigned

o Used Excel and SPSS to handle and convert data into actionable insight and increase customer satisfaction by 15%.o Once managed 5 projects at the same time. Mapping out a timeline. Communicating among all stakeholders. Troubleshooting any issues.o Maintain and track research metrics in order to identify and drive continuous improvement and effectiveness of design thinking research efforts.o Prepare reports that interpret consumer behavior, market opportunities and conditions. Translate report from Chinese to English.

o Design fun and useful class content to ensure students enjoy learning a different language

o Retrieve data from 5+ platforms including Nielsen, Comscore and Google Analytics for analyzing purposes.o Use Excel or other data tools to analyze data and generate weekly and monthly media market trend report.

o Publications: 1 paper in Behaviour & Information Technology. (NSC 95-2627-E-004-002-) and 2 posters.o In charge of design, set up, management and analysis of research projects with both quantitative and qualitative research method.o Data monitoring / analyzing, using Excel, SPSS and Matlab to monitor data and analyze data, find and observe the trend of data and summarize into a meaningful result to present.