1) Understand the Goal
Clarify the business decision and success metrics. Align on the audience, cadence, and the top KPIs.
About Me
I’m Tan — a data analyst who turns messy datasets into clear, decision-ready dashboards and reports. I help small businesses and teams automate reporting, uncover opportunities, and communicate insights with confidence.
Power BIExcelSQL
PythonRDAXPower QueryData Modeling
How I Work
2) Clean & Model
Power Query/SQL pipelines, star schema, and DAX measures that make analysis fast and reliable.
3) Build & Iterate
Prototype, review, iterate—prioritizing clarity, speed, and trust in the numbers.
4) Ship & Support
Docs, refresh schedules, and quick fixes as you scale usage.
Toolstack
Business Intelligence
Power BI (DAX, measures, visuals), Excel (Pivot, Power Query), custom visuals and theming.
Power BIExcelDAX
Data Engineering
Clean ingestion with Power Query/SQL, standardized models for self-serve analytics.
Power QuerySQLModeling
Analysis & Scripting
Python/R for EDA, feature engineering, and small automations that speed up workflows.
PythonREDA
Delivery & Ops
Versioned files, refresh scheduling, and documentation to keep dashboards reliable.
DocsVersioningRefresh
Experience
Freelance Data Analyst
2022 — Present • Built Power BI and Excel dashboards for retail and ops; automated reporting; designed KPI views that improved visibility and planning.
Power BIExcelSQL
Academic & Personal Projects
Projects in churn analysis, inventory health, and financial tracking. Emphasis on clean modeling, readable visuals, and clear storytelling.
PythonRData Viz
Working Principles
Clarity over Flash
Simple, useful visuals > noisy dashboards. If a number matters, it should be obvious.
Trust the Data
Document assumptions, sources, and refresh logic. Make it easy to verify how numbers are built.
Small Iterations
Ship quickly, gather feedback, refine. Stakeholders see value faster and dashboards stay relevant.