No team overhead
No project manager, BI specialist, or junior handoffs to pay for. You work directly with the engineer building your platform.
Data engineering on Microsoft Fabric
Big-firm data engineering, without the big-firm invoice.
Most firms staff a data project with several engineers, a project manager, and a BI specialist, and you pay for every one of them. Lode Analytics is one senior engineer who handles it end to end, from standing up your Microsoft Fabric workspace to the Power BI dashboards your team uses every day. One client at a time, fixed prices, and a system you own.
Why one engineer
One client at a time
Your project gets full focus, not a slice of a busy consultancy's bench.
Infrastructure to dashboard
A systems administration background means I can set up Fabric capacity, workspaces, gateways, identity, and security, not just the reports.
How it works
From scattered sources to dashboards your team relies on.
Source systems
ERP, CRM, SaaS, SQL, files
Ingestion
Scheduled, incremental loads
Lakehouse
OneLake, open Delta tables
Medallion
Raw, clean, and business-ready layers
Warehouse
Modeled tables, SQL access
Reporting
Power BI dashboards
Services
Fixed-price phases, scoped to what you need next.
Discovery & Assessment
- Map your systems and reporting needs
- Data readiness and licensing review
- Fabric capacity sizing
- Written roadmap and fixed-price quote
Platform Build + First Pipeline
- No Fabric yet? Full setup: capacity, gateway, workspaces, security, Git
- First source through bronze, silver, and gold
- First Power BI dashboard on a schedule
- Documentation and handoff
Reporting Expansion
- Add sources: ERP, CRM, SaaS APIs, SQL, Excel
- New subject areas: sales, margin, inventory, production, finance
- Shared KPI definitions
- Row-level security
Health Check & Optimization
- Diagnose capacity overruns and failed refreshes
- Move full reloads to incremental
- Right-size capacity and reduce cost
- Monitoring and failure alerts
Experience
Built in production, not on slides.
2+ years
Leading data and IT for a food manufacturer
1.5 years
Delivering pipelines alongside a data analytics consultancy
50+
Pipelines running in production, API to report
Sources delivered end to end: REST and OData APIs, ERP connectors, SQL databases, SaaS platforms, on-premises systems via gateway, and Excel/CSV files.
Case study
A food manufacturer replaces hand-built reports with one source of truth.
Finance, MRP and demand planning, and OEE reporting from the same checked data, on a schedule.
~100
Source tables and API feeds automated across ERP, SQL, and production systems
2–3 weeks
From kickoff to first live report
How engagements work
Clear scope, clear price, and nothing locked away.
The engagement
- Fixed price per phase in a written SOW
- Start small with one source and one report
- You own everything (code, tables, reports, documentation) in your tenant
- Optional support retainer
Good fit if you…
- Run Microsoft 365 with an ERP such as Business Central
- Don't have Fabric yet or need it set up properly
- Rebuild the same reports by hand every week
- Have departments whose numbers don't match
Start with a discovery call.
Bring a list of your systems and the questions you can't answer today.
Book a discovery call andrew@lodeanalytics.com