Specializing in end-to-end data modeling, DAX performance tuning, and executive visualization across Financials, Transactions, Inventory, and Workday People Systems. Built for Fortune 500 scale.
From high-volume transactional pipelines to C-suite variance reviews, we eliminate technical debt and deliver reporting leaders trust.
Ruthless cleaning and alignment far upstream. Conformed Kimball star schemas, surrogate key integrity checks, automated deduplication, and zero Cartesian creep.
Modernize legacy measure sprawl. We replace hundreds of bloated SWITCH measures with dynamic Calculation Groups, C# scripts, and high-performance time intelligence.
No rainbow visual clutter. Structured for the 5-second scan: immediate target status, variance attribution, and ownership tracking using standardized comparison frameworks.
P&L consolidation, EBITDA, multi-ledger balance sheets, trailing variance, and gross margin waterfalls.
Sales order pipelines, pricing dispersion, billings reconciliation, and customer lifecycle metrics.
Stock velocity, turns, lead-time tracking, procurement visibility, and branch distribution networks.
Headcount rollups, span of control, organizational hierarchy tracking, and retention analytics.
If your developers are writing complex data transformation logic inside report-level calculations or local mashups, you are building technical debt with high-interest compounding.
// Upstream Data Flow Architecture [Raw Sources: ERP / Workday / SQL] │ ▼ [Automated Ingestion Layer] │ (Schema validation, null handling, dedupe) ▼ [Data Lake / Silver Layer] │ ▼ [Kimball Conformed Star Schema] │ (Surrogate Keys, Shallow Dims, Fact Alignment) ▼ [Enterprise Tabular Semantic Model] │ ▼ [Calculation Groups Engine] │ (Dynamic Time Intelligence, R12, YoY, Variance) ▼ [Executive Decision Cockpit (IBCS)]
Illustrative cockpits built to the same IBCS, small-multiple, and 5-second-scan standards we apply on production Fortune 500 semantic models. Client data anonymized/synthetic for display.
Honest architectural breakdowns on enterprise BI, semantic modeling, and executive analytics.
Every vendor demo sells the same fairytale: connect your modern data stack, drag three fields onto a blank canvas, and watch executive insights appear like magic. When you’re operating inside a Fortune 500 company, data isn’t a pristine stream—it’s an archaeological dig. Bridging the gap comes down to three non-negotiables: ruthless cleaning, political and semantic alignment, and decision-first visualization.
Founder & Principal Consultant
Chester County, PA • Remote Nationwide
Connect on LinkedInD Fry Consulting LLC was founded to solve a pervasive problem across corporate analytics: brilliant data teams buried beneath crippling technical debt, broken business definitions, and sluggish reports that executives refuse to use.
As a Principal Power BI Developer inside an industry-leading Fortune 500 enterprise, David Fry has spent years architecting and maintaining massive data models governing billions in operational revenue. His experience spans every phase of the analytical lifecycle—from raw ERP and Workday ingestion down to micro-optimized DAX calculations and board-level reporting.
Share your data landscape and primary challenges. We will review your requirements and follow up to schedule an exploratory discussion.