InHouseIQ℠
Healthcare analytics infrastructure you own and govern.
InHouseIQ℠ brings medical, pharmacy, disability, leave, and administrative data into one governed platform, deployed in your environment or securely hosted under your governance controls, so your team can reconcile every dollar, test vendor claims, and answer its own questions.
Own the data. Govern the logic. Deliver defensible insight.
When Analytics Lives Outside Your Organization
When analytics infrastructure is managed externally, organizations lose direct control over data models, refresh cadence, and transformation logic.
While convenient, this structure introduces operational constraints:
Limited access to underlying source data
Fixed or opaque transformation logic
Delayed data refresh cycles
Reduced flexibility to adapt reporting frameworks
Ongoing dependency on external vendors
In complex healthcare environments, constrained data governance becomes a strategic risk — limiting transparency, slowing innovation, and weakening internal analytic maturity.
InHouseIQ addresses this constraint by embedding governed analytics infrastructure within your environment.
Core Infrastructure Capabilities
This isn’t a vendor relationship. It’s a transfer of capability and ownership.
InHouseIQ establishes a governed analytics foundation — integrating enterprise healthcare data into a modular architecture designed for long-term control and scalability.
Modular, Extensible Architecture
Data architecture designed for flexibility and scalability across evolving data sources. Add new sources and domains without starting over.
Integrated Cross-Source Visibility
Integrated view across claims, HRIS, pharmacy, disability, leave, and program data.
Governed Logic Framework
Customizable business rules aligned with internal governance standards, built on 2,000+ pre-built metrics.
Executive & Operational Dashboards
Dashboards and reports structured around defined performance objectives, with 50+ customizable templates.
Direct, Controlled Data Access
Timely access to refreshed source data within your controlled environment, including direct SQL and Python access for your analysts.
Secure, Governed Deployment
Deployed in your environment or securely hosted, with compliance-aligned controls.
InHouseIQ℠ provides the enterprise infrastructure layer supporting Health Analytics Connect analytic components, including Outcomes Analyzer℠, AI Advisor℠, Report Generator℠, and Analytic Recipes℠.
2,000+ metrics · 50+ templates · 4 levels of analytics · Under 9 months to production
Descriptive: What happened?
Complete financials from billed to paid, including administrative, cost containment, and management fees. PMPM and PEPM views, trends, and benchmarks on incurred and paid bases.
From What Happened to What to do Next
One governed home base for every metric, across descriptive, diagnostic, predictive, and prescriptive analytics.
Diagnostic: Why did it change?
Trend decomposition separates price from utilization across any dimension: service type, condition, episode, or population.
Predictive: What’s coming?
Clinically grounded risk scoring, or your own model, plus the Workforce Health Continuum℠, which segments populations by risk and models how they're likely to shift.
Prescriptive: What should we do next?
Outcomes Analyzer℠ uses matched comparison groups to show which programs actually deliver, and AI Advisor℠ turns the results into recommended next steps.
Answers in the Format Each Conversation Needs
Interactive Reporting
50+ customizable templates, guided drill paths, and views tailored to each user's role.
Presentation-Ready Packages
A governed master report package, exported to PDF or PowerPoint. Your team can copy and tailor its own version without touching the master.
The Live Link
Pull up the same report mid-meeting and drill into live data by subgroup, plan type, or time period. Answer follow-up questions on the spot instead of scheduling a callback.
Automated production creates labeled report packages for every business unit, plan, or client account in a single run.
Every Dollar Reconciled
Full Picture of Your Financials
Every Dollar Reconciled, Down to the Admin Fee
Carrier and vendor financial reports show totals. InHouseIQ captures administrative data alongside claims, so you can see what makes up those totals.
• Reconcile carrier and vendor financials to claims detail
• Drill into each management and administrative fee
• Track rebates, savings, and member contributions
Financial Overview
Network claims: Medical · Pharmacy · Dental
Management fees: Fixed charges · Cost containment · Surcharges · Assessments
Administration fees: Medical · Pharmacy · Dental · Vision
Savings: Rebates · Copay assistance
Member contributions: Payroll deductions and premiums
✓ Financials reconciled to claims detail
Enterprise Outcomes in Practice
Challenge
A Fortune 50 employer managing over 150,000 covered lives relied on multiple commercial carriers and an outsourced data warehouse vendor. Reporting was siloed across carriers, constrained by black-box vendor logic, and lacked enterprise-level customization.
Solution
Health Analytics Connect implemented InHouseIQ℠ directly within the client's existing data environment, replacing the external vendor model. The platform unified medical, pharmacy, and vendor data into governed analytics infrastructure, deployed in under nine months.
Results
Deployed into enterprise production, replacing a legacy outsourced model
Consolidated multi-carrier reporting into a single controlled framework
Millions of dollars in savings identified through deep-dive analytics
Accelerated time to insight
Business Impact
The organization moved from vendor dependency to enterprise analytic ownership, gaining control over data modeling, reporting logic, and platform evolution. The multi-year engagement has since been extended.
“The transition from outsourced reporting to an embedded analytics platform transformed how we manage data, vendors, and strategy. InHouseIQ delivered speed, flexibility, and long-term control.”
AI Advisor: Grounded in Your Data
Ask a Question. Get an Answer.
AI Advisor℠ helps every user interpret results and decide what to do next, without waiting on an analyst.
• Summarize any page and highlight key takeaways
• Interpret results with targeted recommendations
• Rank programs by ROI, PMPM impact, and savings
• Draft board- and leadership-ready summaries
Answers are grounded in your governed data and defined measures, and follow each user's access permissions.
Included with InHouseIQ℠ and Outcomes Analyzer℠. Available on every page.
Built to Work Together
InHouseIQ connects directly with HAC's program evaluation, AI, and training capabilities, all on the same governed data. Each is also available on its own.
Faster Answers: Drill into live data during the conversation, not after a callback
Full Ownership: Under your governance, on your infrastructure or securely hosted
No Queue: Changes and new reports go through your team, not a vendor queue
Built-In Depth: Training and program evaluation on the same platform.
Independent, statistically defensible evaluation of programs and vendors, using matched comparison groups to show whether a program delivered the savings and health improvement it promised.
AI Advisor℠
Summaries, key takeaways, and recommended next steps on every page, grounded in your governed data.
Healthcare Analytics Foundations℠
Training for internal analysts and the teams you serve, building the practical fluency to interpret results and ask sharper questions. Custom training materials are available for your platform.
Enterprise Deployment & Ownership Model
A structured path from deployment to full ownership, built around your environment, your governance, and your team.
Who InHouseIQ is Designed For
Self-Funded Employers
Employers seeking full control over benefits data and reporting logic
Employers integrating non-standard data sources into performance analytics
Internal teams building long-term analytic independence
Health Plans & TPAs
Plans strengthening internal analytics and reporting infrastructure
Organizations reducing reliance on external vendor reporting
Teams aligning analytics with governance and compliance standards
Brokers & Benefits
Consulting Firms
Firms building internal analytics infrastructure to support employer clients
Firms integrating multi-client data into governed reporting environments
Consultants seeking scalable, configurable analytic frameworks under their control
Healthcare Innovation
& Analytics Teams
Teams standing up internal data architecture
Teams requiring configurable logic and structured KPI frameworks
Leaders seeking infrastructure that scales with analytic maturity
Start the Conversation
You don’t need another dashboard. You need an analytics structure you can trust, understand, and control.
In a first conversation, we'll cover:
• Your current data and reporting setup
• Where decisions are getting stuck
• What your own data is already telling you