Development of a clean, performant semantic data model and DAX measure library for an existing or new Power BI solution. Addresses slow reports, incorrect calculations, and model sprawl — the most common causes of BI technical debt in government reporting environments. Delivers a reusable, well-documented model that supports consistent metrics across multiple reports.
What’s Included
- Existing model audit or new model requirements intake
- Star or snowflake schema design with relationship documentation
- Power Query M code development for data transformation and cleansing
- DAX measure library covering all defined KPIs with calculation documentation
- Model performance review and query optimization
- Delivered as a Power BI Dataset with full documentation
GSA MAS Contract No. 47QTCA25D00E2 | SIN 54151S | NAICS 541511
Year 1 Rate: $184.11/hr (fully burdened, IFF included)
All prices are at or below GSA-approved ceiling rates. Eligible for GPC purchase at or below the $15,000 micro-purchase threshold per FAR Subpart 13.2.
GPC Purchase Justification Language
Purchase of Power BI Data Model and DAX Development services from Sapot Systems Inc. under GSA MAS Contract No. 47QTCA25D00E2, SIN 54151S. Services required to design and develop a semantic data model and DAX measure library for [program/system name] Power BI reporting. Rates are at or below GSA-approved ceiling rates.