Sales & Marketing Reporting Layer

The Problem

Sales and marketing teams were pulling data manually from multiple sources, leading to inconsistent reporting and slow decision-making. They needed a single source of truth with self-serve dashboarding.

My Approach

I designed a dimensional data model covering sales funnel stages, marketing attribution, and operational KPIs. Built on Redshift with dbt for transformations. Created Tableau dashboards serving 50+ concurrent users.

What I Built

• Dimensional fact and dimension tables aligned with business processes
• dbt models for repeatable, tested transformations
• Tableau dashboards tracking campaign performance and revenue forecasts
• Data lineage documentation for stakeholder transparency
• Role-based access controls for different user personas

Impact & Results