PREPARATION
-
Please download the course files and follow the steps for the installation before the class starts.
In this course, you will gain a solid foundation in basic statistical concepts such as mean, median, mode, skewness, and kurtosis, and learn how to apply them effectively in real-world business scenarios. You will explore how to perform regression and clustering analyses to uncover patterns and relationships in data. The training will guide you through building forecasting models using techniques like linear regression, simple moving averages, and weighted averages.
You will also learn how to develop semantic models and use DAX in Power BI to calculate key statistical measures and build interactive visual reports. Through hands-on exercises, you’ll conduct exploratory data analysis (EDA) using slicers, filters, histograms, and scatterplots. Additionally, you’ll apply advanced DAX functions to create KPIs, implement ranking logic, and extract market basket and cohort insights.
The course will also teach you how to segment customer data using RFM and decile models, detect statistical signals using thresholds and confidence intervals, and automate insights through alert mechanisms. Finally, you will develop the ability to craft compelling data stories and design executive dashboards that align with business goals and drive strategic decision-making.
Your Instructor
Alex Ooi
Alex Ooi is a data analytics expert with over seven years of specialized experience transforming complex business requirements into actionable technical solutions. With his unique blend of accounting background and technical expertise, Alex empowers organizations to make data-driven decisions with confidence.
As a Microsoft Power BI Data Analyst Associate and Associate Chartered Management Accountant (ACMA), Alex combines financial acumen with technical proficiency to deliver exceptional results. His track record includes developing Python-based automation tools that significantly reduced operational time and implementing robust data infrastructures that strengthened marketing effectiveness.
Throughout his career at industry leaders like Heineken Malaysia, Coca-Cola, and EY Analytics, Alex has consistently delivered measurable results—including a proprietary profitability analysis adopted across Heineken's APAC region and automation processes that saved 60+ man-hours monthly at Coca-Cola.
Alex excels in creating sustainable data ecosystems that minimize technical debt while maximizing business value. His consultancy focuses on three key pillars: enabling clients to control their data narratives, shifting organizational perspectives, and facilitating entry into new data horizons through hands-on workshops and training.
For organizations seeking to enhance visibility, efficiency, and profitability through data, Alex delivers purpose-driven solutions that transform complex information into strategic assets for meaningful business growth.