Welcome to Ling's Blog

Data visualization by PowerBI, Tableau, and Excel: 

- Design financial reports and metrics for business insight of B2B and B2B2C.

- Rebuild back-office report by python Dash.

- Ad-Hoc data support for stakeholders for key KPIs.

Report Optimization:

- Create process automation by python xlsxwriter and openpyxl, improving time efficiency from manual to automation.

- Report connecting database on PowerBI, saving time from 20 minutes to 5 minutes by rewriting SQL query.

-Redesign SQL schema for better data management in TB-size database. 

- B2B Product Innovation (BenQ ClassroomCare)

- Web crawling & NLP customer review from competitors

- Google Analytics analysis on BenQ website

Data Warehouse Building for Yageo :

- SAP BW/4HANA Migration 

Digital Marketing Business Case by NLP and Machine Learning :

- McDonald's New APP Comments

- 2021 Best Dessert Trends

- Establish business models through Amazon, Facebook for industrial report

- Analyze Martech trends and anticipate the digital marketing industry

- Web crawling to collect startup news by Python for Data Visualization

- Reported Amazon inventory data among 13 countries (Excel)

- Contacted forwarders and supported global logistics manager

- Maintained inventory data in the ERP system (SAP - B1)

- Msc of Digital Marketing and Data Science

- Thesis: NLP, Machine learning of Amazon Review

- BBA of Department of Business Administration

- GPA 3.55 / 4