Real results from real companies. See how organizations transformed their data operations with the Nexus Model Architecture.
Price Comparison Platform
NMA at Pricewise: From Data Chaos to Competitive Advantage
A successful price comparison platform with 20+ data sources, legacy on-premises infrastructure,
and weekly manual reporting processes that couldn't scale with business growth.
20+
Data Sources
12 weeks
Implementation
90%
Faster Integration
€2.6M
Annual Value
The Challenge
Pricewise operated a successful price comparison platform helping Dutch consumers find the best deals
on essential services. However, their data infrastructure had become a critical bottleneck:
Legacy on-premises SQL Server with manual ETL processes
Separate databases for each product line (Energy, Insurance, Telecom, Mortgages)
Weekly manual data extraction and consolidation for management reports
No self-service BI; all reports custom-built by IT
6-8 weeks to integrate a new data source
Limited visibility into data problems, frequent reconciliation errors
The Solution
Full Nexus Model Architecture implementation (Mara DWH) with Azure cloud migration—transforming from a
maintenance burden into a strategic asset.
Phase 1: Foundation
Set up Mara database structure, deploy framework tables, establish SSIS project structure.
First data source: Customer Orders from SQL1.
Phase 2: Core Entities
Integrated Products, Product Groups, Households, Contacts, Google Analytics data,
and Marketing channels. Consolidated 4 product-specific databases.
"We consolidated 20+ data sources in weeks, not months. Daily automated reporting replaced our
weekly manual processes—saving 40+ hours per week of analyst time." — Pricewise BI Team
Mobile Subscriptions
Creative Clicks: Complexity Simplified
Mobile subscription platform with complex multi-channel attribution, 30+ data sources, B2B and B2C
reporting needs, and persistent data quality issues affecting business decisions.
30+
Data Sources
50M+
Records
30%
Revenue Growth
85%
Quality Improvement
The Challenge
Creative Clicks operates a sophisticated mobile subscription platform connecting consumers with mobile
carriers through publisher networks. Their data challenges were more complex than typical e-commerce:
Multi-channel attribution: Subscribers acquired through 100+ publisher networks
B2B and B2C: Both consumer subscriptions and business accounts
International operations: Multiple countries, currencies, carriers
30+ fragmented data sources (CRMs, billing systems, ad platforms)
Data quality issues: Publisher-reported data inconsistent with billing data
The Solution
Enhanced Nexus Model Architecture with specialized Mobile domain—building on Pricewise learnings to create
an even more sophisticated implementation.
Azure-Native Deployment
Cloud-first architecture with Azure SQL Database and Azure Data Factory.
Scalable for international expansion.
Hash-Based Grouping
Advanced hash functions for complex dimensionality. ARPU analysis with
null-aware hashing for accurate grouping.
Mobile Domain
Specialized schemas for subscription lifecycle analytics, publisher performance,
and conversion rate analysis.
Real-Time Monitoring
Grafana dashboards for real-time ETL monitoring and data quality metrics.
Proactive issue resolution.
Key Features Implemented
Enhanced ResultLog: Advanced customer journey tracking with conversion attribution
Mobile Schema: ARPU analysis, subscription metrics, hash-based grouping functions
Publisher Analytics: Medgen schema for publisher/network performance analytics
B2B Reporting: Enterprise clients get custom analytics without custom development
Automated Quality Monitoring: Fallout system reduced data errors by 85%
The Results
Analytics Impact
✓ Advanced subscription lifecycle analytics
✓ Accurate multi-channel attribution
✓ 100+ publisher networks tracked
✓ Real-time operational dashboards
Business Value
✓ 30% revenue growth enabled by analytics
✓ €1.2M annual ad spend optimization
✓ Self-service BI reducing IT dependency by 60%
✓ Measurable data quality improvement
"New data sources that used to take 6-8 weeks now take 3-5 days. Our team can focus on analytics
instead of integration plumbing." — Creative Clicks Data Engineering Lead
Ready to Write Your Success Story?
See how the Nexus Model Architecture can transform your data operations. Schedule a consultation today.
