Pal Mak

Background

About Pal Mak

I am a Data & Business Analyst with a proven track record in retail data, specialising in Power Automate, Power BI, Power Query and a suite of Microsoft Office Applications. I focus on transforming data into actionable insights to drive business performance.Throughout my career, I have developed and implemented automation solutions that have significantly streamlined reporting and business processes, saving hundreds of work hours annually. These ongoing time savings contribute to overall efficiency within the organisation.I also created an automated, live Price Tracker tool that tracks competitor pricing across major retailers. This initiative has driven millions in revenue through the Price Match program, providing the business with true visibility, business intelligence and helping it stay competitive in the Jewellery and Watches industry.With strong expertise in data analysis, I efficiently handle large datasets using ETL processes, and employ data modeling and visualisation techniques to create compelling data stories that inform decision-making. I am experienced in using various reporting tools to deliver clear insights and drive action.Additionally, I provide deep understanding of key business drivers in both volume and high-end sectors. I have developed statistical models to identify “Keystone” products that drive customer acquisition and maximise lifetime value.I proactively identify business opportunities and mitigate risks affecting sales, margin, and inventory across products, promotions, and stores. I provide region-specific recommendations to capitalise on sales opportunities and enhance profitability.Other key achievements include- Designing and implementing tools, dashboards, and automated reports to enhance data-driven decision-making- Creating advanced scraping tools for competitor data analysis, contributing to competitive intelligence- Streamlining processes and automating repetitive tasks for operational efficiency- Leading data cleansing efforts to ensure reliable, accurate data for strategic decisions- Providing A/B testing frameworks and statistical analysis to optimise business strategies.Fluent in Cantonese and a good understanding of Mandarin, I bring a diverse set of skills to help organisations unlock value from their data and stay ahead of the competition.