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 BI Excel SQL Python R DAX Power Query Data Modeling

How I Work

My approach to data analysis projects

1) Understand the Goal

Clarify the business decision and success metrics. Align on the audience, cadence, and the top KPIs.

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

Technologies I use to deliver results

Business Intelligence

Power BI (DAX, measures, visuals), Excel (Pivot, Power Query), custom visuals and theming.

Power BI Excel DAX

Data Engineering

Clean ingestion with Power Query/SQL, standardized models for self-serve analytics.

Power Query SQL Modeling

Analysis & Scripting

Python/R for EDA, feature engineering, and small automations that speed up workflows.

Python R EDA

Delivery & Ops

Versioned files, refresh scheduling, and documentation to keep dashboards reliable.

Docs Versioning Refresh

Experience

My journey in data analytics

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 BI Excel SQL

Academic & Personal Projects

Projects in churn analysis, inventory health, and financial tracking. Emphasis on clean modeling, readable visuals, and clear storytelling.

Python R Data Viz

Working Principles

The values that guide my work

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.

Have a dataset you'd like to make useful?