Supporting technical capability
Improve slow Power BI reports and document the calculations.
A short fixed-fee engagement that improves the agreed parts of a slow Power BI model with documented measures and a performance log, so the reports load quickly and the numbers hold up.
Illustrative sample · supporting capability
Is a slow visual caused by its measure, model or source?
- SOURCEMonthly transactions · model relationships
- DEFINITIONMonthly total measure over the intended relationship
- DECISIONAmbiguous relationship: confirm totals before changing the model.
REFRESH CONDITIONCompare the same query and totals in controlled runs; record the dataset refresh used.
- Observation
- The same total is calculated over a wide table and crosses an ambiguous relationship.
- Decision
- Inspect the model and query before claiming a speed improvement.
- Next action
- Capture the query plan, isolate the measure, check totals and compare controlled runs. No performance gain is assumed.
This capability can inform the next service. Its inclusion, price and calendar must be agreed in that service’s scope; following the link does not make it included.
Explore the relevant next serviceTechnical context
When this work applies
- Reports are slow and refreshes take too long.
- Measures are inconsistent and nobody trusts the data model.
- The model grew organically and nobody documented how it works.
Possible outputs
Outputs to agree in scope
Fix log for the data model
A before and after of refresh time, model size, and slow queries, with every fix recorded.
Documented measures
Each DAX measure named, explained, and verified so the numbers are trusted again.
Performance recommendations
What to change next to keep the model fast as it grows.
Commercial & delivery basis
The scope and conditions of the work.
Delivery window
This supporting capability has no separate confirmed delivery window. The proposal names its scope and calendar.
Capability scope to confirm
- Model review
- DAX cleanup log
- Documented measures
- Performance recommendations
Scope assumptions
- One existing Power BI model or PBIX file
Exclusions
- A full rebuild or a new report suite
- A data warehouse build
Required access
- The existing PBIX file or workspace access
- Read access to the underlying data sources
- A 30-minute kickoff with the report owner
Acceptance
The agreed completion standard.
The engagement is complete when the fix log, the documented measures, and the speed recommendations are delivered and walked through.
Discuss the work
Tell us what you need to change.
Share the systems involved, why the change is needed and your deadline. We clarify the work, responsibilities and information needed for a proposal.
Discuss this project