Skip to content
Data & analytics

Get a reporting dashboard built in Power BI or Looker Studio

Someone spends a day each month copying numbers into a spreadsheet report, and by the time it's shared the questions have moved on. An analyst can build the report once in Power BI or Looker Studio, connected to your data and refreshed on its own.

TW-DRAFTDraft

Build a monthly sales report in Looker Studio

Budget
You set this
Timeline
2-3 weeks
Category
Data & analytics

Scope

Our monthly sales report is built by hand from HubSpot and Shopify exports. We want it rebuilt in Looker Studio with a daily refresh: revenue by channel and product, new versus returning customers, and pipeline by stage, shared with the leadership team.

Deliverables

  • Agreed metric definitions
  • Looker Studio report with four pages
  • Daily refresh from HubSpot and Shopify
  • Access set up for the leadership team
  • Handover call and notes

Skills

  • Looker Studio
  • Data modelling
  • HubSpot
  • Shopify
An example brief. Describe your task and the brief writer drafts one like it.

What the work involves

The scope a provider will expect to cover. Leave out what you don't need, and say so in the brief.

  • Agreeing the metrics and their definitions, so everyone reads the same number
  • Connecting the data sources and modelling the data
  • Designing pages around the decisions the report supports
  • Scheduled refresh, and access for the right people
  • A short handover so your team can change it

What to put in the brief

The facts a provider needs to give you a real price instead of a guess. Write it in your own words: the brief writer turns it into scope and deliverables, asks about anything missing, and you can edit every line before it goes out.

Start the brief
  1. 1The report you have today, or the questions you want answered
  2. 2The data sources, and how you can connect to them
  3. 3The tool you use, or want to use
  4. 4Who reads it, how often, and on what devices
  5. 5Any metrics whose definition you've already agreed internally

Ask each provider

Every proposal opens a conversation, so you can ask before you accept. The answers are often what separates two similar prices.

  • How will you agree metric definitions with us before building?
  • Which of our sources can you connect directly, and which need exports?
  • Can you show a dashboard you built for a similar business?

Questions companies ask

Power BI or Looker Studio?

Use what your company already has. Power BI fits companies on Microsoft 365; Looker Studio fits Google Workspace. If you haven't chosen, ask providers to recommend one for your sources and team.

Will my team be able to change the report later?

Ask for it in the deliverables: a handover session and short notes on how the data is connected. Reports that only their builder understands tend to stop being used.

Ready to hand it off?

Describe it in a sentence or two. The brief goes to every provider who lists Data & analytics, and you compare their proposals side by side. Posting is free, and you set the budget.

Post a task

More data & analytics guides

All guides