All samples
Sample · SaaS & Technology · Executive Overview

SaaS Executive Revenue Overview

An executive Power BI report tracking ARR, Net Revenue Retention and Logo Churn against target, built on a Snowflake medallion warehouse fed by Salesforce and HubSpot. A monthly ARR snapshot fact drives retention and churn, while pipeline and marketing facts explain future growth.

Audience: CEO, CFO, CRO and board members. Generated by Blueprint BI on 2026-11-19 and shown exactly as generated.

What was entered

These are the only inputs. Everything below was generated from them.

Industry
SaaS & Technology
Report type
Executive Overview
BI tool
Power BI
Currency
USD ($)
Data sources
Salesforce, Snowflake, HubSpot
Columns
None given (Claude designed the model)
KPIs
ARR (target $12M), Net Revenue Retention (target 110%), Logo Churn % (target 1.5%)
Notes
None
Style and pages
Corporate Clean, 4 pages

Scope

Purpose, default period and where each input column lands in the model.

Purpose
Are we on track to $12M ARR, are we retaining and expanding customers, and is pipeline sufficient to close the gap?
Audience
CEO, CFO, CRO and board members
Default period
Current fiscal year to date by month, refreshed daily

Business rules

  • ARR. Sum of annualised recurring subscription value (MRR x 12) on active contracts at month end, excluding one-off services. Calculated in: Snowflake gold layer (dbt), monthly snapshot
  • Net Revenue Retention. ARR today from customers active 12 months ago divided by those customers' ARR 12 months ago, including expansion, contraction and churn. Calculated in: Power BI measure over FactArrSnapshot
  • Logo churn. A customer churns in the month their ARR falls from above zero to zero; churn % = churned logos / logos active at start of month. Calculated in: dbt flag ChurnFlag in gold; rate in Power BI measure
  • Active customer. A customer with ARR greater than zero at month end. Calculated in: Snowflake gold layer (dbt), monthly snapshot

1. Architecture

From source systems to the semantic model and the people who use it.

1Sources
Salesforce CRM
Salesforce Sales Cloud · Daily 01:00
HubSpot Marketing
HubSpot · Daily 01:00
Snowflake Billing Data
Snowflake · Daily 02:00
ARR Targets
Snowflake (finance planning upload) · Monthly
2Ingestion
Fivetran into Snowflake, transformed with dbt Cloud
Incremental sync on SystemModstamp / updatedAt watermarks
3Storage & transform
Bronze
Snowflake RAW database
Silver
Snowflake + dbt staging models
Gold
Snowflake + dbt marts
4Semantic model
Power BI semantic model
Import
5Consumers
Executives
Power BI App
Board pack
PDF subscription monthly
Finance
Analyze in Excel

Data flow detail

Ingestion
Fivetran lands raw SaaS objects; dbt builds silver and gold models daily.
Bronze
Raw Fivetran replicas of Salesforce and HubSpot objects, untransformed.
Silver
Cleaned, deduplicated, typed entities with conformed account IDs.
Gold
Kimball star: ARR snapshot, pipeline and lead facts with conformed dimensions.
Semantic model
Imported star schema from Snowflake gold views, refreshed after dbt completes.
Caveat: Data is only as fresh as the last scheduled refresh, not real time.
Caveat: Model size must stay within the Premium/Fabric capacity memory limit.
Caveat: Incremental refresh needs RangeStart/RangeEnd folding to Snowflake.

Governance & security

  • RLS by Region using UserRegionMap from Salesforce user territory, CEO/CFO unrestricted.
  • dbt tests: unique and not-null keys, ARR non-negative, snapshot month continuity.
  • ARR reconciled to billing monthly with tolerance 0.5%, alerting Finance.
  • Refresh failure alerts to the BI support Teams channel.
  • Certified dataset endorsement and Purview lineage.

Source detail

  • Salesforce CRM: Accounts, opportunities, contracts and subscription line items.
  • HubSpot Marketing: Marketing-sourced leads, MQLs and campaign attribution.
  • Snowflake Billing Data: Billing and subscription invoices already landed from the billing platform.
  • ARR Targets: Board-approved monthly ARR targets by segment.
Refresh and alertsReady by 06:00 ET daily; failures alert the BI support Teams channel and RevOps lead
Storage modeImport
History4 years of monthly snapshots, covering 12-month NRR lookback plus prior-year comparison
EnvironmentsDev, Test and Prod workspaces; dbt dev and prod targets
DeploymentPower BI deployment pipelines; dbt Cloud jobs
Source controlSemantic model and report as PBIP in Git, dbt project in the same repository

2. Data model

Star schema with grain, keys and relationships.

Star schema (galaxy with conformed dimensions)

3 fact · 5 dimension tables · 9 relationships · measures on _Measures

Key Business key Foreign key Degenerate Numeric Hidden Sort by
DimDateDate tabledimension
Grain: One row per calendar day
  • DateKeyINT
  • DateDATE
  • MonthNumberINT
  • MonthNameNVARCHAR(10)
    sort by MonthNumber
  • YearMonthNumberINT
  • YearMonthNVARCHAR(8)
    sort by YearMonthNumber
  • QuarterNumberINT
  • QuarterNVARCHAR(2)
    sort by QuarterNumber
  • YearINT
  • IsMonthEndBIT
DimSegmentSCD type 1dimension
Grain: One row per customer segment
  • SegmentKeyINT
  • SegmentCodeNVARCHAR(10)
    Business key
  • SegmentNVARCHAR(20)
    sort by SegmentOrder
  • SegmentOrderINT
DimOpportunityStageSCD type 1dimension
Grain: One row per opportunity stage
  • OpportunityStageKeyINT
  • StageNameNVARCHAR(40)
    Business key · sort by StageOrder
  • StageOrderINT
  • WinProbabilityDECIMAL(5,2)
FactArrSnapshotfact
Grain: One row per customer per month end
  • DateKeyINT
    → DimDate[DateKey]
  • CustomerKeyINT
    → DimCustomer[CustomerKey]
  • ProductKeyINT
    → DimProduct[ProductKey]
  • ARRDECIMAL(18,2)
  • NewARRDECIMAL(18,2)
  • ExpansionARRDECIMAL(18,2)
  • ContractionARRDECIMAL(18,2)
  • ChurnedARRDECIMAL(18,2)
  • ChurnFlagINT
  • ActiveFlagINT
FactPipelinefact
Grain: One row per open or closed opportunity per daily snapshot date
  • DateKeyINT
    → DimDate[DateKey]
  • CustomerKeyINT
    → DimCustomer[CustomerKey]
  • OpportunityStageKeyINT
    → DimOpportunityStage[OpportunityStageKey]
  • OpportunityIdNVARCHAR(18)
    Degenerate dimension
  • CloseDateDATE
  • PipelineARRDECIMAL(18,2)
  • IsOpenINT
FactArrTargetfact
Grain: One row per segment per month
  • DateKeyINT
    → DimDate[DateKey]
  • SegmentKeyINT
    → DimSegment[SegmentKey]
  • TargetARRDECIMAL(18,2)
DimCustomerSCD type 2dimension
Grain: One row per customer account version
  • CustomerKeyINT
  • AccountIdNVARCHAR(18)
    Business key
  • SegmentKeyINT
    → DimSegment[SegmentKey]
  • CustomerNameNVARCHAR(200)
  • RegionNVARCHAR(20)
  • IndustryNVARCHAR(50)
  • AcquisitionChannelNVARCHAR(30)
  • ValidFromDATE
  • ValidToDATE
DimProductSCD type 1dimension
Grain: One row per subscription product plan
  • ProductKeyINT
  • ProductCodeNVARCHAR(20)
    Business key
  • ProductFamilyNVARCHAR(50)
  • PlanTierNVARCHAR(20)
    sort by PlanTierOrder
  • PlanTierOrderINT

Grain note. FactArrSnapshot has no relationship to DimOpportunityStage, so its measures are only meaningful by the other dimensions.

Grain note. FactPipeline has no relationship to DimProduct, so its measures are only meaningful by the other dimensions.

Grain note. FactArrTarget has no relationship to DimCustomer, DimProduct, DimOpportunityStage, so its measures are only meaningful by the other dimensions.

Relationships
From (many)To (one)CardinalityFilter directionActive
FactArrSnapshot.DateKeyDimDate.DateKeymany-to-oneSingleYes
FactArrSnapshot.CustomerKeyDimCustomer.CustomerKeymany-to-oneSingleYes
FactArrSnapshot.ProductKeyDimProduct.ProductKeymany-to-oneSingleYes
DimCustomer.SegmentKeyDimSegment.SegmentKeymany-to-oneSingleYes
FactPipeline.DateKeyDimDate.DateKeymany-to-oneSingleYes
FactPipeline.CustomerKeyDimCustomer.CustomerKeymany-to-oneSingleYes
FactPipeline.OpportunityStageKeyDimOpportunityStage.OpportunityStageKeymany-to-oneSingleYes
FactArrTarget.DateKeyDimDate.DateKeymany-to-oneSingleYes
FactArrTarget.SegmentKeyDimSegment.SegmentKeymany-to-oneSingleYes

3. DAX measures

An excerpt: the first 6 of 28 measures. Download the .dax file for all of them.

Validated: 28 measures, 0 errors, 3 warnings
ARR
ARR at the last snapshot date in context.
ARR
ARR =
VAR _LastDate = LASTNONBLANK ( DimDate[Date], CALCULATE ( COUNTROWS ( FactArrSnapshot ) ) )
RETURN CALCULATE ( SUM ( FactArrSnapshot[ARR] ), _LastDate )
ARR PY
ARR at same point last year.
Time Intelligence
ARR PY =
CALCULATE ( [ARR], SAMEPERIODLASTYEAR ( DimDate[Date] ) )
ARR YoY %
ARR growth versus prior year.
Time Intelligence
ARR YoY % =
VAR _PY = [ARR PY]
RETURN IF ( _PY > 0, DIVIDE ( [ARR] - _PY, _PY ) )
ARR Target
Planned ARR at last target month in context.
Targets
ARR Target =
VAR _LastDate = LASTNONBLANK ( DimDate[Date], CALCULATE ( COUNTROWS ( FactArrTarget ) ) )
RETURN CALCULATE ( SUM ( FactArrTarget[TargetARR] ), _LastDate )
ARR vs Target
ARR gap to target in dollars.
Targets
ARR vs Target =
VAR _T = [ARR Target]
RETURN IF ( NOT ISBLANK ( _T ), [ARR] - _T )
ARR vs Target %
ARR attainment against target.
Targets
ARR vs Target % =
VAR _T = [ARR Target]
RETURN IF ( _T > 0, DIVIDE ( [ARR], _T ) )
Download all 28 measures

4. KPIs and RAG rules

KPITargetDirectionGreen (1)Amber (2)Red (3)Example
ARR
Annualised recurring subscription value of active contracts at period end.
[ARR]
RAG: [ARR RAG]
$12M Higher≥ $12,000,000≥ $11,000,000< $11,000,000$11.4M +31.2%
Amber
Net Revenue Retention
Current ARR of year-ago customers / their ARR 12 months ago.
[Net Revenue Retention]
RAG: [Net Revenue Retention RAG]
110% Higher≥ 110.0%≥ 100.0%< 100.0%112.4% +2.1 pts
Green
Logo Churn %
Churned logos per month / customers active at start of month.
[Logo Churn %]
RAG: [Logo Churn RAG]
1.5% Lower≤ 1.50%≤ 2.00%> 2.00%2.30% +0.6 pts
Red

How RAG is shown

1 Green#0478572 Amber#B453093 Red#B91C1C

Each KPI has a RAG measure returning 1, 2 or 3 (BLANK when there is no value), so the thresholds live in one place. In Power BI, use conditional formatting with Format style "Rules" based on the RAG measure: 1 green, 2 amber, 3 red, and an icon set on the same rule. Status is never shown by colour alone: every colour is paired with its icon shape or word.

5. Report pages

Page layouts with the theme applied. Charts show placeholder shapes; the KPI cards use Claude's sample values.

Page 1: Executive Summary

Purpose
Show ARR, NRR and churn against target at a glance.
Audience
CEO, CFO, board
Default filter
Current fiscal year to date
Slicers
DimDate[Year] (dropdown) · DimSegment[Segment] (buttons) · DimCustomer[Region] (dropdown): Limited to permitted regions for RLS-restricted users
Title label
[Selected Period Label]
SaaS Executive Revenue Overview
Executive Summary
Current fiscal year to date
ARR Amber
$11.4M
+31.2%Target $12M
Net Revenue Retention Green
112.4%
+2.1 ptsTarget 110%
Logo Churn % Red
2.30%
+0.6 ptsTarget 1.5%
ARR vs Target by Month
Jan 2025Mar 2025May 2025
ARR by Segment
14%
  • SMB
  • Mid-Market
  • Enterprise
  • Strategic
ARR Bridge YTD
PriorOpeningNewExpansiContracChurnClosingCurrent
Visual specification: Executive Summary
VisualTypeFieldsFormatting and interactionAnswers
Headline KPIskpi strip
values: [ARR], [Net Revenue Retention], [Logo Churn %]
tooltip: [ARR vs Target %], [ARR YoY %]
  • Status icon and word from each KPI's RAG measure
  • Variance vs target shown below value
Are we on track for ARR, NRR and churn targets?
ARR vs Target by Monthline
axis: DimDate[YearMonth]
values: [ARR], [ARR Target]
tooltip: [ARR vs Target]
  • Target as dashed grey line
  • Data labels on last point in $M
Is ARR tracking toward the $12M plan?
ARR by Segmentdonut
legend: DimSegment[Segment]
values: [ARR]
  • Labels show percent and $M
Which segments make up the ARR base?
ARR Bridge YTDwaterfall
axis: [New ARR]
values: [Expansion ARR], [Contraction ARR], [Churned ARR]
  • Increases in brand indigo, decreases in red with labels
  • Data labels in $K
What drove ARR change this year?

Page 2: ARR Growth

Purpose
Explain ARR growth by product, segment and region.
Audience
CFO, CRO
Default filter
Current fiscal year to date
Slicers
DimProduct[ProductFamily] (dropdown) · DimCustomer[Region] (dropdown): Limited to permitted regions for RLS-restricted users
Title label
[Selected Period Label]
SaaS Executive Revenue Overview
ARR Growth
Current fiscal year to date
ARR Movement by Month
JanFebMarAprMayJun
ARR by Product Family
Core Platform
106%
Analytics
103%
Security
103%
Integrations
87%
Add-ons
84%
ARR vs Target by Segment and Region
NameActualvs Target
SMB£1479K108.0%
Mid-Market£1263K92.2%
Enterprise£1304K95.2%
Strategic£1153K84.1%
Visual specification: ARR Growth
VisualTypeFieldsFormatting and interactionAnswers
ARR Movement by Monthstacked column
axis: DimDate[YearMonth]
values: [New ARR], [Expansion ARR], [Contraction ARR], [Churned ARR]
  • Net New ARR shown as line overlay
How do new, expansion and churn trend monthly?
ARR by Product Familybar
axis: DimProduct[ProductFamily]
values: [ARR]
tooltip: [ARR YoY %]
  • Sorted descending
  • Data labels in $M
Which product families drive ARR?
ARR vs Target by Segment and Regionmatrix
rows: DimSegment[Segment]
values: [ARR], [ARR Target], [ARR vs Target %]
  • Icon and colour from [ARR RAG]
  • Region not used: targets are by segment only
Where is attainment behind plan?

Page 3: Retention & Churn

Purpose
Track NRR and logo churn, and find at-risk segments.
Audience
CEO, VP Customer Success
Default filter
Trailing 12 months
Slicers
DimSegment[Segment] (buttons) · DimCustomer[Region] (dropdown): Limited to permitted regions for RLS-restricted users
Title label
[Selected Period Label]
SaaS Executive Revenue Overview
Retention & Churn
Trailing 12 months
NRR Trend
JanMarMay
Logo Churn % Trend
JanMarMay
Churn by Segment
SMB
108%
Mid-Market
101%
Enterprise
85%
Strategic
82%
Top Churned Accounts
NameActualvs Target
Northwind Logistics£1139K83.1%
Contoso Health£1203K87.8%
Fabrikam Retail£1390K101.5%
Tailspin Media£1532K111.9%
Adatum Finance£1530K111.7%
Visual specification: Retention & Churn
VisualTypeFieldsFormatting and interactionAnswers
NRR Trendline
axis: DimDate[YearMonth]
values: [Net Revenue Retention], [Net Revenue Retention PY]
  • Constant line at 110% target
Is retention improving toward 110%?
Logo Churn % Trendline
axis: DimDate[YearMonth]
values: [Logo Churn %], [Logo Churn % PY]
  • Constant line at 1.5% target
Is monthly churn below 1.5%?
Churn by Segmentbar
axis: DimSegment[Segment]
values: [Logo Churn %]
tooltip: [Churned Logos]
  • Bar colour from [Logo Churn RAG] with labels showing status
Which segments churn most?
Top Churned Accountstable
values: DimCustomer[CustomerName], DimSegment[Segment], DimCustomer[Region], [Churned ARR]
  • Sorted by Churned ARR ascending
  • Filter: Top 10 by largest [Churned ARR] loss
Which lost accounts hurt ARR most?

Page 4: Pipeline & Outlook

Purpose
Assess whether pipeline covers the remaining ARR gap.
Audience
CRO, CFO
Default filter
Latest snapshot, closing this fiscal year
Slicers
DimSegment[Segment] (buttons) · DimCustomer[Region] (dropdown): Limited to permitted regions for RLS-restricted users
Title label
[Selected Period Label]
SaaS Executive Revenue Overview
Pipeline & Outlook
Latest snapshot, closing this fiscal year
Open Pipeline by Stage
Visits · 100%
Leads · 73%
Qualified · 47%
Proposal · 33%
Won · 17%
Pipeline Coverage by Segment
SMB
114%
Mid-Market
112%
Enterprise
99%
Strategic
91%
Largest Open Opportunities
NameActualvs Target
Woodgrove Bank£1114K81.3%
Litware Software£1356K99.0%
Proseware Inc£1413K103.2%
Wide World Importers£1424K103.9%
Lucerne Publishing£1493K109.0%
Visual specification: Pipeline & Outlook
VisualTypeFieldsFormatting and interactionAnswers
Open Pipeline by Stagefunnel
axis: DimOpportunityStage[StageName]
values: [Open Pipeline ARR]
tooltip: [Open Opportunities]
  • Data labels in $K
Where does open pipeline sit in the funnel?
Pipeline Coverage by Segmentbar
axis: DimSegment[Segment]
values: [Pipeline Coverage]
tooltip: [Open Pipeline ARR]
  • Constant line at 3.0x
  • Blank shown as 'Target met'
Is coverage at least 3x the remaining gap?
Largest Open Opportunitiestable
values: DimCustomer[CustomerName], DimOpportunityStage[StageName], FactPipeline[CloseDate], [Open Pipeline ARR]
  • Sorted by Open Pipeline ARR descending
  • Filter: Top 15 by [Open Pipeline ARR]
Which deals matter most to close the gap?

6. AI-designed page

Page 1 as drawn by the AI Design Studio (a Pro feature), unedited.

Assumptions and open questions

Confirm these with the business before build. Each one changes the model or measures if the answer differs.
#Assumption or questionImpact if different
1Reporting uses the calendar year; prior-year comparisons use calendar months.Add fiscal columns to DimDate and rebase YoY measures on fiscal periods.
2ARR excludes one-off services, usage overages and is net of discounts.Change ARR logic in dbt and restate snapshot history.
3Logo churn is counted at account level; a reduction to zero followed by return within 30 days is not churn.Adjust ChurnFlag rule and churn counts in gold.
4ARR targets are set by segment and month only, so target measures are not sliced by region or product.Add RegionKey or ProductKey to FactArrTarget and relate it to those dimensions.
5RLS region mapping comes from Salesforce user territory assignments.Source a separate security table from HR or Entra ID groups.
6Customer segment changes are tracked as SCD2 and NRR uses current segment.Use historical segment on snapshot rows if cohorts must keep original segment.

Recommendations

  • Configure incremental refresh on FactPipeline by snapshot date, keeping 2 years and refreshing the last 7 days.
  • Build NRR cohort logic in dbt as a monthly table if DAX performance degrades beyond 2 seconds.
  • Document every measure description and publish a KPI glossary page in the Power BI app.
  • Use a field parameter later to let executives switch between ARR, NRR and churn on one trend chart.
  • Schedule a monthly ARR reconciliation review with Finance before the board pack subscription sends.
  • Track app usage metrics and retire visuals unused after 90 days.

Make one for your own report

Start free