Data EnginesDANIEL DOGBEY / DATA & BI

THE PROJECT COLLECTION

Questions explored.
Work, explained.

Dashboards, models, pipelines, and reporting workflows. A collection of project work showing how I approach different data problems.

Screenshots and recorded previews · Dashboard controls are not live

22 projects

Data model

A look beneath the dashboard.

Before a dashboard can answer the right questions, the data behind it needs to be structured correctly. A well-designed data model connects business processes, keeps metrics consistent, and makes reporting easier to scale.

Reliable metrics

A consistent structure reduces conflicting numbers across reports and gives teams a dependable foundation for analysis.

Connected information

Sales, products, locations, supervisors, and dates can be analyzed together instead of living in disconnected reports.

Scalable reporting

A well-structured model makes it easier to add data and build new dashboards without rebuilding the reporting foundation.

Explore the model: click a table or field to see its relationships.

dim_dateDimension
dim_productDimension
fact_salesFact table
dim_locationDimension
dim_supervisorDimension
Selected relationship 1 → * one-to-many
Conceptual electronics-commerce star schema · Illustrative model

Why this matters: the model sits between the business question and the dashboard. It is the foundation that makes analysis consistent, explainable, and easier to extend.

Project image