All work
SQL · Power BI
Data Preparation Using SQL
This project models data staged in a relational database into conformed dimensions and two fact streams (Milestones, Subscriptions), exposed as SQL views for Power BI. It supports ASC 606-compliant revenue recognition, contract-level drilldowns, segment slicing, cost attribution, and payment timing analysis.
- 5 SQL views
- 4 conformed dims
- 2 fact streams
What it demonstrates
- vw_orders_details
- Order, project, and product grain enriched with customer and product segments, aggregating milestone revenue and cost.
- vw_milestone_tracking
- Milestone line-level fact with part catalog and product enrichment; exposes cost, revenue, milestone date, and cost line item for performance-obligation analysis.
- vw_pmts_milestones
- Normalized invoicing and payment events — terms, due amounts, received amounts — joined to customer segments for payment-behavior metrics.
- vw_product_details
- Product dimension enriched with cost line-item mapping to support cost attribution.
- vw_subscription_tracking
- Monthly subscription stream with date normalization, product and part enrichment, and order linkage.
Live
The data preparation
Loading