Skill focus
Data Modeling
Data modeling is how raw tables become understandable reporting structures with clear relationships and consistent metrics.
SQLPower BIDAXPower QueryExcel
How it helps in an office
In an office setting, good models help teams avoid conflicting numbers by defining shared entities, clean relationships, and reusable measures.
Practical examples
- Shape reporting tables around facts, dimensions, and business questions.
- Document metric definitions and edge cases.
- Reduce duplicated logic across dashboards.
- Make reports easier to audit, maintain, and explain.
What I focus on
star schemas
metric definitions
relationships
semantic layers