Sales Performance Dashboard Sample dataset
Interactive Excel dashboard on RM16.2M of revenue across 1,500 transactions, with slicers for product, region, salesperson and month, and KPIs that update automatically.
Excel, pivot tables, Power Query
I check data against its source and find what doesn't match.
Data operations and quality audit, Kuala Lumpur. I reviewed 10,000+ insurance records at 99% accuracy for an Australian workers' compensation insurer, and now reconcile multi-outlet financial data.
I'm a data and audit professional in Kuala Lumpur with more than 2 years of experience across data analysis, quality auditing and operations. At AS White Global Malaysia I followed client-specific rules to review and verify insurance records. At The Olive Tree Group I reconcile credit card data, run variance analysis and consolidate financials across several entities.
I've also worked on AI training data, uploading and verifying structured data in a cloud system. I hold a BBA from City University Malaysia and the Google Data Analytics Certificate. My main tool is Excel, where I build reconciliation workbooks and dashboards. The portfolio projects below also use SQL and Python on sample datasets.
I do this every day for 17 outlets: compare the sales report with the card machine and find what doesn't match. You get 3 shifts and 3 lives. Click the rows that don't match before time runs out. Wrong clicks cost a life, and streaks multiply your score. (Invented sample numbers, not real data.)
At the Changkat outlets, one card machine often processes payments for other outlets, so I have to match each slip to the outlet it belongs to. Each outlet's report says how much card sales it should have. Pick an outlet, then tap the slips that add up to that total. (Invented sample numbers, not real data.)
Outlet reports
Slips from the machine
Unlock these by playing the two games above. . Saved on this device only.
The Olive Tree Group, Malaysia
Mowinton Consulting, remote
AS White Global Malaysia, Kuala Lumpur
CSN Solutions Sdn Bhd, Puchong
GENO Hotel, Selangor
These use sample datasets, not client or employer data.
Interactive Excel dashboard on RM16.2M of revenue across 1,500 transactions, with slicers for product, region, salesperson and month, and KPIs that update automatically.
Excel, pivot tables, Power Query
Cleaned and structured a sample claims dataset (200 claims, RM552,848) and built approval and processing analysis with KPI reporting.
Excel, Power Query
Python script that automates cleaning, aggregation and reporting on 1,500+ sample transaction records.
Python, Pandas, SQLite
View on GitHubVerified 500+ sample transaction records with SQL JOINs, aggregations and filters to find inconsistencies across tables.
SQL
View on GitHubOpen to data operations, quality audit and data analyst roles in Kuala Lumpur.