Honglin Ran

I’m a Data Analyst with placement experience delivering end-to-end analytics solutions across Power BI, SQL, Excel, Power Query and DAX. I connect Power BI to MySQL databases, validate large datasets, and turn complex metrics into dashboards for non-technical stakeholders.

As a Data Analyst Intern at Be Data Solutions, I shaped and reconciled data using SQL, Excel and Power Query, including joins, aggregations, duplicate checks and missing-key checks. I designed fact and dimension models, built DAX measures for forecast accuracy and error metrics, and delivered stakeholder-focused finance, sales, product and supply chain dashboards. I also prepared a forecast table with 1,888,941 rows.

Previously, as an Associate Data Analyst at Chengdu ICT Information Technology Co., Ltd., I analyzed housing satisfaction survey data using SPSS, Excel and Python, improving data quality from 75% to 98%. I streamlined cleaning and reporting workflows, reducing manual effort by 40%, and produced management reports to support internal decision-making. I also build dashboards and apply classification/clustering in Python (Pandas, NumPy, scikit-learn) to support analytics and customer insights.