The Documentary Channels Dashboard in Power BI reports on a 500-title, 1,955-episode catalog across 5 interactive report pages, 15 charts and scorecards, and 22 DAX measures, with 5 slicers available on every page. The sample model covers January to December 2025 and lands on 116,572,000 views, 65,044,584 watch hours, $63.80M revenue and a 49.3% net margin, all comparing month over month against November 2025.
Factual and documentary programming is judged on two numbers that rarely sit in the same report: how far into a title people actually get, and what the slate returned against what it cost to make and market. Most channel groups keep viewership in one spreadsheet, revenue in the finance system and production spend in a third place, then reconcile them once a quarter. This dashboard puts completion rate, watch hours per title, cost per 1K watch hours and return on spend on the same set of filters, so the conversation happens weekly instead of quarterly.
Key Features of the Documentary Channels Dashboard in Power BI
- Five themed report pages with five KPI tiles each. Overview, Audience Trends, Genre and Format Mix, Production and Spend, and Channels and Platforms. Every tile carries the current value, a month-over-month delta chip and a twelve-point lollipop sparkline, so one glance gives you a number and its direction.
- 22 DAX measures. Total Viewership, Total Watch Hours, Completed Views, Completion Rate %, New Subscribers, Subscriber Conversion %, Avg. Watch Hours per Title, Total Revenue, Ad Revenue, Sponsorship Revenue, Revenue per 1K Watch Hours, Net Margin, Net Margin %, Production Budget, Marketing Spend, Total Spend, Return on Spend %, Cost per 1K Watch Hours, Total Titles, Total Episodes, Avg. Runtime Minutes and Avg. Audience Rating.
- Five slicers per page. Date Range, Region, Genre and Platform are constant; the fifth changes with the page and is Channel, Format, Language, Production House or Status.
- Month-over-month logic that does not break on a single-month filter. The comparison uses ALL(‘Date’) on both sides, so picking one month still resolves the previous month instead of blanking every delta chip.
- A hidden Details drillthrough page plus Metric Detail and Trend Detail tooltip pages. Right-click a bar to see the rows behind it; hover a KPI for its own card.
- A dark theme measured for accessibility. Body text sits at 13.5:1 against the card background, muted labels at 6.35:1 and the accent at 9.39:1, and the two lowest ramp colours were dropped from every series for failing 4.5:1.
Dashboard Pages Explanation
Page 1: Overview
The landing page answers “how did the catalog do this month”. KPI tiles read Total Views 116,572,000 (up 10.7%), Watch Hours 65,044,584 (up 5.0%), Total Revenue $63.80M (up 6.6%), Net Margin 49.3% (down 4.9%) and Audience Rating 3.7. Visuals are Watch Hours and Completion Rate by Month, the Channel Scorecard ranking six channels by watch hours, share, revenue and net margin, and Revenue by Genre, led by True Crime at $16.42M and Nature and Wildlife at $13.70M.
Page 2: Audience Trends
This page separates reach from retention. Completed Views 70,642,240 (up 12.8%), Completion Rate 60.6%, New Subscribers 1,666,576 and Watch Hours per Title 130,089. Views and Subscriber Conversion by Month runs the monthly bars against a conversion line that moves between 1.0% and 1.7%; Views and Completed Views by Quarter shows Q3 peaking at 38.36M views against 23.39M completions; and the Platform Audience Scorecard breaks Streaming App, YouTube, Linear TV and Partner OTT out by viewership, completion rate and new subscribers.
Page 3: Genre and Format Mix
The catalog composition page. Total Titles 500, Total Episodes 1,955 (up 31.5%) and Avg. Runtime 58.5 minutes. Watch Hours and Audience Rating by Genre covers seven genres from True Crime at 16.82M watch hours down to Travel at 3.99M, with ratings sitting in a narrow 3.6 to 3.8 band. The Genre Scorecard adds title counts and star ratings, and Titles by Format splits the catalog into Feature Documentary 157, Limited Series 131, Episodic Series 124 and Short Doc 88.
Page 4: Production and Spend
Where the money went and what came back. Production Budget $25.94M, Marketing Spend $6.39M, Total Spend $32.33M, Cost per 1K Watch Hours $497 and Return on Spend 97.4%. Spend and Return on Spend by Month tracks monthly outlay against a return line that peaks at 115.4% in October. The Region Spend Scorecard covers North America, Europe, Asia Pacific, Latin America and the Middle East, and Spend against Net Margin by Production House plots eight houses as labelled bubbles so an outlier is visible instantly.
Page 5: Channels and Platforms
The commercial page. Total Revenue $63.80M, Ad Revenue $43.79M, Sponsorship Revenue $20.01M, Revenue per 1K Watch Hours $981 and Subscriber Conversion 1.4%. Revenue and Net Margin by Channel ranks Frontier Docs at $13.28M through Chronicle One at $8.84M with the margin line on the secondary axis. The Language Reach Scorecard compares English, Spanish, French, Hindi, Japanese and German on viewership, revenue and revenue per 1K watch hours, and Revenue by Platform shows Streaming App at 56.5% of revenue against Linear TV 19.9%, YouTube 12.6% and Partner OTT 10.9%.
Page 6: Get More Dashboards
A closing page describing what is inside the file and how to request a custom build. It holds no data and can be deleted before you circulate the report internally.
Documentary Channels Dashboard in Power BI vs. Tableau or Qlik vs. Paid Media Analytics SaaS
| Feature | Documentary Channels Dashboard in Power BI | Tableau / Qlik build | Paid media analytics SaaS |
|---|---|---|---|
| Cost | ✅ $17.99 one-time | $70+ per creator / month, plus build time | $25–150 per user / month |
| Platform | Power BI Desktop (free) | Tableau Desktop or Qlik Sense licence | Vendor-hosted web app |
| Setup time | ✅ Under 10 minutes | 2–5 days to model and lay out | 1–3 weeks including data onboarding |
| Report pages included | ✅ 5 built, plus drillthrough and 2 tooltip pages | Blank canvas | Fixed vendor pages |
| Customizable measures | ✅ Full — edit any DAX measure | Full | Limited to vendor fields |
| Share with a link | Publish to your own Power BI Service workspace | Tableau Server or Cloud | ✅ Built in |
| Works offline | ✅ Yes, the .pbix runs locally | Yes | No |
| Documentary-specific metrics | ✅ Completion rate, watch hours per title, cost per 1K watch hours | You build them | Generic media KPIs |
| Year-1 cost at 5 users | ✅ $17.99 total | $4,200+ | $1,500–9,000 |
For a channel group that wants completion rate and return on spend in one report without paying per seat every month, this dashboard sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Programming and content leads at documentary channels, factual networks and streaming catalogs of roughly 50 to 2,000 titles
- Independent production houses that report watch hours, completion rate and return on spend to a distributor
- Distribution and licensing teams comparing revenue by platform, language and region
- Analysts who already export the catalog to Excel or SQL and want a finished model rather than a blank canvas
Not a fit if:
- You need live API feeds from YouTube, Netflix or an OTT partner. This model refreshes from a file or database connection you point it at and ships no connectors.
- You do not run Power BI Desktop on Windows. The Excel edition of this dashboard is the better fit.
- You need rights and royalty accounting. There is no contract, window or residual logic here; that belongs in a content rights reporting model.
- You are budgeting a single production. The model is built around a catalog, not one title.
Real-World Use Cases
Ana is head of programming at a six-channel factual network. Every Monday she opens the Overview page, filters to one channel and reads watch hours against completion rate. When views rise while completion rate falls, she knows a title is being sampled and abandoned, and she moves it out of the prime slot before the quarter closes rather than after it.
Marcus runs a documentary production house with eight titles in delivery. He uses the Production and Spend page to show his distributor cost per 1K watch hours and return on spend by month, then uses the bubble plot of spend against net margin by production house to argue that his slate returns more margin per dollar than the two larger houses charted beside him.
Priya handles international distribution. She works from the Channels and Platforms page, comparing revenue per 1K watch hours across English, Spanish, French, Hindi, Japanese and German, and uses the Revenue by Platform donut to decide whether the next window goes to a streaming app or a partner OTT.
Advantages of This Power BI Dashboard
- One-time cost instead of a seat licence. Five people using a $25-per-seat platform for a year costs $1,500; this file costs $17.99 once and there is no per-user fee.
- Hours saved on the monthly pack. The five pages export straight to PDF, so the monthly programming review does not need a slide deck rebuilt by hand.
- Metrics that match the trade. Completion rate, watch hours per title and cost per 1K watch hours are the numbers factual commissioners actually argue about, and they are already written as DAX.
- Nothing is locked. You own the .pbix, so a measure you disagree with can be rewritten, and a page you do not need can be deleted.
- It reads on a projector. Every colour in the theme was checked against a 4.5:1 contrast floor before release.
Opportunities for Improvement
Two honest limitations are worth stating before you buy. First, there are no live data connectors. The model refreshes from the bundled Data.xlsx or from a source you repoint it at in Power Query; it will not pull from a YouTube, OTT or ad-server API on its own, and wiring that up is your work.Documentary Channels Dashboard in Power BI
Second, the sample data is synthetic and deliberately tidy. Real catalogs carry titles with missing runtimes, co-productions split across two houses and revenue booked in several currencies. The model is single-currency and formats to USD, so a multi-currency group needs a conversion step upstream. Neither issue affects the report logic, but both cost an afternoon on first load, and it is better to know that now.Documentary Channels Dashboard in Power BI
Best Practices
- Load your catalog into the exact column layout that Data.xlsx shows before you repoint the source; a matching schema means the visuals never need touching.
- Keep the Date table as the only date source and let the relationships do the filtering, rather than adding date columns to the fact table.
- Set the Date Range slicer to a rolling 12 months so the sparklines always show a full year.
- Read completion rate next to views, never alone. Rising views with falling completion is the signal this report exists to surface.
- Use the Production House bubble plot before the next commissioning round, not after the season has aired.
- Publish to a Power BI Service workspace if more than two people need it, and schedule the refresh rather than mailing the file around.
- Read the Microsoft Learn guide to Power BI measures before you edit the DAX, and check the data sources documentation when repointing the model.
Explore Relevant Templates
- Documentary Channels Dashboard in Excel — the same catalog metrics for teams that live in a workbook rather than in Power BI.
- Content Rights Agencies Dashboard in Power BI — licensing, windows and rights revenue, the reporting layer that sits next to this one.
- Podcast Monetization Startups Dashboard in Power BI — audience and revenue reporting for audio-first catalogs.
- Esports Team KPI Dashboard in Power BI — another audience-and-revenue model built on the same page architecture.
- Movie Watchlist Data Entry System in Excel — a lightweight companion for logging titles before they reach the catalog.
Frequently Asked Questions
What metrics does the Documentary Channels Dashboard in Power BI track?
It tracks 22 measures including total viewership, watch hours, completed views, completion rate, new subscribers, subscriber conversion, revenue, ad and sponsorship revenue, net margin, production budget, marketing spend, cost per 1K watch hours and return on spend.Documentary Channels Dashboard in Power BI
How long does setup take?
Under 10 minutes if your catalog already sits in a spreadsheet. Open the .pbix, check the bundled Data.xlsx for the expected columns, repoint the source through Transform data, then Close and Apply. All five report pages redraw from your rows as soon as the refresh finishes.Documentary Channels Dashboard in Power BI
Do I need a paid Power BI licence to use it?
No. The dashboard opens and runs in Power BI Desktop, which Microsoft gives away free. A Pro or Premium licence is only required if you want to publish the report into a shared Power BI Service workspace for colleagues.Documentary Channels Dashboard in Power BI
How does this compare to a paid media analytics platform?
A vendor platform runs $25 to $150 per user per month for generic media KPIs. This template is a one-time $17.99 purchase, runs locally on your own machine, and every measure is editable because the .pbix file belongs to you.Documentary Channels Dashboard in Power BI
Can I add my own genres, channels and languages?
Yes. Genres, formats, channels, platforms, languages, regions and production houses are all read from your data, so adding one is a data change and not a report rebuild. The slicers and every scorecard pick the new value up on the next refresh.Documentary Channels Dashboard in Power BI
Does it connect to YouTube or an OTT platform automatically?
No, and that is a deliberate limitation. The model refreshes from a file or database connection you configure in Power Query. If you need an automated API pull, build that feed first and point the model at its output.Documentary Channels Dashboard in Power BI
What is in the download?
A ZIP containing the .pbix report, a Data.xlsx sample source that shows the exact expected column layout, and a Power BI Dashboard user manual PDF. Nothing else is needed to open and edit the report on a Windows machine with Power BI Desktop installed.Documentary Channels Dashboard in Power BI
About the Author
Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.Documentary Channels Dashboard in Power BI
Conclusion
If your programming reviews currently reconcile viewership, revenue and production spend from three separate files, the Documentary Channels Dashboard in Power BI collapses that into five filtered pages you can open on a Monday morning. It is honest about what it does not do: no live connectors, single currency, synthetic sample data. Everything else is already built.Documentary Channels Dashboard in Power BI
👉 Click here to Purchase the Documentary Channels Dashboard in Power BI
Instant download · One-time payment · No subscription
For step-by-step video tutorials, visit Youtube.com/@PK-AnExcelExpert.
Last updated: September 2026Documentary Channels Dashboard in Power BI
