Downloads

Report recipes

The standard sales, finance and operations report layouts and the measures behind them.

Last updated

View as Markdown For AI agents All guides as text

On this page

You'll be able to

  • Plan the standard sales, finance and operations report pages.
  • Choose the measures that each report page needs.
  • Build Excel-first versions of the same reports.
  • Write prompts that get useful analysis from an AI assistant.

Step plan for "analyze X in Power BI"

  1. State the question (what decision, which measure, which breakdown, which period).
  2. Model: fact grain, dimensions, a Calendar, relationships, base measures.
  3. Build measures, then visuals; validate each visual against the SQL answer.
  4. Format, add tooltips and drill, test slicers, then publish or share.

Sales analysis report (the standard four-page layout)

Finance reports

Operations and HR

Headcount (semi-additive: closing count per month), turnover % = leavers / average headcount, utilization = billable hours / available hours, backlog, cycle time with DATEDIFF, SLA % within target.

Excel-first versions

Prompts that work well with an AI assistant connected through MCP

Want to see it run?

Open a finished Power BI project or Excel workbook built on the same data, or ask an AI assistant that has read these guides.