Analytics Engineering & BI: Power BI, Tableau and Looker
When three dashboards show three different revenue numbers, the problem is rarely the chart. We build the models, metric definitions and semantic layer underneath and then the dashboards on top, so every number has one definition and an owner.

Sound familiar?
- Every team calculates revenue, churn or margin differently, and meetings start with an argument about the numbers.
- Power BI or Tableau reports query raw tables directly and get slower every month.
- Power BI Premium P SKUs are being retired at the end of each agreement term, and the move to Fabric capacity needs a plan.
- Sales and support tools need warehouse data, and someone exports spreadsheets by hand to get it there.
What you receive
- Metric catalogue with owners
- dbt models and semantic layer in your repository
- Production dashboards with row-level security
- Capacity and refresh plan
- Hand-over sessions for your analysts
What we deliver
Scope is confirmed in writing in the assessment, with anything out of scope listed too.
- 01
Metric definitions
Key business metrics written down once, with owners, grain and filters agreed with the business.
- 02
Dimensional models
Star schemas and marts in dbt on Snowflake, Databricks, BigQuery or Fabric, tested and documented.
- 03
Semantic layer
Power BI semantic models, LookML or the dbt Semantic Layer, so every tool reads the same definitions.
- 04
Dashboards people use
Power BI, Tableau or Looker dashboards designed with their users, with performance and row-level security tested.
- 05
Capacity and licensing
Power BI Premium to Fabric F SKU moves, capacity sizing and refresh scheduling.
- 06
Reverse ETL
Modelled data synced back into CRM, marketing and support tools with Hightouch or native connectors.
Fixed scope and a fixed fee, agreed in writing.
Every engagement is scoped after a free 30-minute review. The scope and fee are confirmed in writing before work starts, and the assessment fee is credited toward the project.
Step 01
Semantic layer & BI review
Fixed fee, scoped after the free review
Metric conflicts, model and report hot spots, capacity findings and a fixed quote. Credited toward delivery.
Step 02
Analytics build
Fixed fee, scoped after the free review
Models, semantic layer and dashboards delivered domain by domain, scoped from the review.
Samples and an example engagement
Templates with fictional systems and an illustrative scope, so you can judge the depth before the first call.
Warehouse to lakehouse migration readiness checklist
Checks before moving Teradata, Hadoop, Netezza, Oracle, SQL Server, Redshift or Synapse to Snowflake, Databricks or Fabric. Printable.Sample deliverableSample assessment report: database upgrade readiness
The structure and depth of the written plan you receive at the end of a paid assessment, shown with fictional systems.Sample deliverableSample cut-over runbook: PostgreSQL major upgrade with blue/green
A step-by-step runbook excerpt with timings, owners, checks and the rollback path.From first call to delivery
You can stop after any step and keep everything we have written.
- 01
Free
Free 30-minute review
We look at what you run, what is urgent and whether a fixed-fee engagement fits. You get a short written summary.
- 02
1–2 weeks · credited
Semantic layer & BI review
Metric conflicts, model and report hot spots, and a fixed quote.
- 03
Typically 4–8 weeks
Analytics build
Models, semantic layer and dashboards delivered domain by domain.
Technologies
Names are trademarks of their owners. Listing does not imply partnership.
Questions about this service
Straight answers on scope, fees and how we work. Anything else, ask us.
Which BI tool do you recommend?
Usually the one you already own. Power BI fits Microsoft estates, Tableau suits visual exploration and Looker suits a modelled, governed approach. We fix the model underneath before suggesting a tool change.
What is a semantic layer, and do we need one?
It is one place where metrics are defined, so every dashboard and tool calculates them the same way. If different teams report different numbers, you need one.
Can you move us from Power BI Premium to Fabric?
Yes. The move from P SKUs to F SKUs is mostly a capacity reassignment, but sizing, regions, gateways and refresh schedules need checking. We plan and test it.
Will our analysts be able to maintain it?
Yes. Models are SQL in dbt, documented, and we run hand-over sessions with your analysts.
Start with a free 30-minute review.
Databases, cloud or AI: talk to a senior engineer about what you run and what is coming. We reply within one business day and sign your NDA on request.
