Power BI templates by department

Start running your business by the numbers.

Deploy your first report today with templates drawn from over 100 client projects.

  • Deployed in a few minutes
  • Yours to customize
  • Save 2 months of development
The Simplified P&L on a laptop screen: revenue, gross profit, EBITDA, net income, debt, and cash against the prior year and budget, with anonymized data

« I've worked on over 100 client projects in the last 10 years. I know the whole data cycle, from the source system to the dashboard. That's what lets me hand you a report that's already structured, ready for you to customize however you like. »

Emilien Granger, founder of BI Template and CTO of Datapilot

Save 2 months of development

An agency starts from scratch. You start from a report that's already built and proven with our clients.

With an agency

A project built from scratch

Timeline
With an agency : 2 months of development
Price
With an agency : From €3,000 excl. VAT

With a template

A standard proven on client projects

Timeline
Ready to use today
Price
From €69 excl. VAT

Timeline and price observed at other agencies for a simple report, custom-built.

Your numbers, finally where they belong

Before: a report thrown together in a rush, where you hunt for every number. After: our Revenue Analysis, where the essentials read at a glance.

After: the Overview page of the Revenue Analysis, with revenue, gross profit, gross margin, and average order value against the prior year, monthly and cumulative revenue, and revenue by channel and by warehouse
After
Before: a cluttered sales report, with filters everywhere and charts with no hierarchy
Before

Get this report free

A template ready for your data

Start from a report that's already built, plug in your data, and let it grow with you.

Our template. A complete report, already built and tested on client projects, delivered with an anonymized dataset.

Your data. An Excel export from your software is all it takes.

Help along the way. A step-by-step guide and a reply within 48 business hours. Or choose consulting services, and I'll connect your report with you.

Wherever you take it. The file is yours. Add your own pages, metrics, and colors.

Don't see your software? Email me at emilien@datapilot.fr before you buy, and I'll tell you whether the report can use it.

Not ready to buy a template yet?

Try our Starter Kit for free and adapt it to your needs. It includes a calendar table, 7 ready-made visuals, and a guide, all reusable in your own reports.

The Starter Kit dashboard: sales, units sold, average price, and % of target against the prior year, sales by month, the breakdown by category, and sales by category against the prior year and target

No credit card needed. We use your email to send you the free kit, then to write to you about our templates. Reply "stop" at any time and you won't hear from us again. Details in our privacy policy.

Find the template for your team

  • Finance & Accounting

    P&L, revenue, and multi-entity reporting. For CFOs, finance managers, and controllers.

  • Human Resources

    Headcount, turnover, pay, and the gender pay gap. For HR directors and HR managers.

  • Sales

    Deals by stage, weighted pipeline, and each rep's activity. For sales leaders and business owners.

  • Marketing

    Social media, ad campaigns, and website traffic. For marketing managers.

Three templates to start with

  • Simplified P&L

    Your financial reporting against last year and budget, ready to present to your leadership team.

    €109 excl. VAT

  • Sales Pipeline Analysis

    Your deals stage by stage, and each rep's activity.

    €69 excl. VAT

  • HR Analysis

    Your headcount, turnover, and pay gaps, all in one report.

    €109 excl. VAT

All templates

Emilien Granger

I built these reports on real client projects

For the past 5 years, I've been building Power BI reports at Datapilot, our data consulting firm. Together, our team has delivered over 100 client projects, mostly in hospitality, sales, finance, and marketing. From one client to the next, the same requests kept coming back: a P&L, a sales tracker, an HR dashboard.

BI Template offers those same reports to everyone. Building them once is what keeps the price low. The file is yours, and if you get stuck, you email me.

Emilien GrangerFounder and CTO of Datapilot

And when a template isn't enough, there's Datapilot: our experts start from one of our reports to build yours. Talk to Datapilot

Questions before you buy

You don't need to know how to code. You need to know how to open Power BI Desktop, which is free, and follow a step-by-step guide: the deployment guide that comes with every report. If you've ever loaded an Excel file into Power BI, you have the skills you need.

You start by testing the report with the anonymized dataset that comes with it. Then you connect your own numbers, at your own pace.

The report is flexible. At the bottom of each template's page, the "Technical details" section shows how it's built today. If your columns have different names, the deployment guide lists the expected headers, column by column, and where to find each one in your software. You rename the headers of your export in Excel.

Is your export very different? Before you buy, send an anonymized extract to emilien@datapilot.fr. I'll tell you honestly, within 48 business hours, whether the report can use it.

Email me before you buy

Not to use the report on your own computer: Power BI Desktop is free. A Power BI Pro license lets you publish the report online and share it with colleagues. In the US, it costs $14 per user per month.

Usually, the person who publishes the report and each colleague who views it online need this license. If your company already uses Power BI, you may have these licenses already. Ask your IT team.

Start with the deployment guide that comes with every report. It takes you step by step from opening the report to publishing it.

Still stuck? Email me at emilien@datapilot.fr. I'll reply within 48 business hours.

Want personal help while you set up your template? With consulting services, you get one hour with me for €200 excl. VAT, or a half day for €500 excl. VAT. Add it to your purchase or book it later.

Get the free kit

Consulting services

By email, right after payment: one download link per report, to a .zip file with its 3 files. Inside, you'll find the Power BI report (.pbix), the deployment guide (PDF), and the anonymized dataset (.xlsx).

Payment goes through Stripe, on a secure checkout page. We never store your card details.

All questions

Stop starting from scratch

Pick the template for your role, try its demo, then connect your data.

Still deciding? The free kit gives you a guide, a calendar table, and visuals, real files you can reuse. Get the free kit

This site uses cookies to analyze traffic. Read our privacy policy.