In brief: How Codenatives migrated 140 complex Cognos reports to QlikView and Qlik Sense for a global bank in five months, at 50% of large integrator costs.
Why Migrate to Qlik?
Qlik scores over Cognos in multiple critical areas: superior data visualization capabilities, better performance through the in-memory QIX Engine, enhanced data visualization and search functionality, and stronger integration capabilities with virtually any data source.
Why Choose Codenatives?
Our team brings industry-leading, multi-domain expertise with extensive experience in enterprise BI platforms and analytics migration in implementing reporting and business intelligence solutions across diverse industries and platforms.
Proven Past Performance
A major global bank migration project demonstrated our capabilities at scale:
- 140 complex reports and dashboards successfully recreated
- Five-month timeline from project kickoff to completion
- Performance improvements through comprehensive data model re-engineering
- Enhanced user adoption via improved visualization design and user experience
Our Approach
Deliverables
- Reverse-engineered report specifications from existing Cognos environment
- Recreated reports, dashboards, and visualizations in Qlik
- Agile Scrum methodology for transparent project tracking
- Tool-based inventory assessment of existing report landscape
- Unused object reduction analysis to streamline the migrated environment
Key Takeaways
- No-cost 2-week assessment with comprehensive audit and inventory
- 50% cost savings versus major system integrators
- One-week training in the new Qlik environment for your team
- Hybrid onsite/offshore model for optimal resource utilization
- One-month post-launch support ensuring smooth transition
Our proven migration methodology ensures a seamless transition from Cognos to Qlik, delivering improved performance, better visualization capabilities, and significant cost savings compared to traditional migration approaches.
Technical Migration Details and Outcomes
Technical Migration Challenges
Migrating 140 reports from Cognos to QlikView/QlikSense presented significant technical complexity beyond simple report recreation. The fundamental data modeling paradigms differ between the two platforms: Cognos relies on a metadata layer (Framework Manager packages) that abstracts relational database structures into business-friendly namespaces, while Qlik uses an associative in-memory data model where all table relationships are inferred at load time. Each Cognos report's query subjects, filters, and dimensional hierarchies had to be reverse-engineered and re-implemented as QlikView load scripts and QlikSense data connections. Expression translation was equally demanding. Cognos Report Studio expressions, including conditional formatting rules, cross-tab calculations, and burst-key logic, have no direct equivalents in Qlik's expression syntax. The team built a custom expression mapping catalog that documented over 200 distinct Cognos function-to-Qlik expression translations, significantly accelerating development in later sprint cycles as the catalog matured.
Validation and Regression Testing
With 140 reports serving as the source of truth for a global bank's regulatory and management reporting, data accuracy was non-negotiable. The team implemented a three-tier validation framework. Tier 1 (Automated Data Reconciliation) involved running each Cognos report and its Qlik counterpart against identical data snapshots, then programmatically comparing row counts, column totals, and aggregated values at multiple granularity levels. Tier 2 (Visual Regression Testing) used side-by-side screenshot comparison of report layouts, chart rendering, and conditional formatting to catch presentation discrepancies that data-level checks might miss. Tier 3 (Business User Acceptance) engaged subject matter experts from each reporting domain — risk, finance, compliance, and operations — to validate that migrated reports met their specific analytical requirements and interpretation expectations. Defects identified at any tier were triaged, categorized, and resolved within the same sprint wherever possible.
Performance Benchmarking: Qlik vs. Cognos
Structured performance benchmarks conducted across the full report portfolio revealed substantial improvements after migration. Average report load times decreased by 60 to 70 percent, driven by Qlik's in-memory QIX Engine eliminating the repeated database round-trips required by Cognos's query-based architecture. Complex cross-tab reports that previously took 45 to 90 seconds to render in Cognos consistently loaded in under 15 seconds in QlikSense. Dashboard-style reports with multiple visualizations showed the most dramatic gains, with interactive filter and drill-down operations responding in sub-second times compared to 5-to-10-second waits in the Cognos environment. These performance improvements were measured under concurrent user loads representative of the bank's peak usage periods, confirming that the gains held at production scale.
User Adoption Strategy and Training Program
Technical migration success means little without strong user adoption. Codenatives delivered a structured adoption program beginning with executive stakeholder briefings that demonstrated the tangible benefits of the new platform. Role-based training tracks were designed for three audiences: report consumers received focused sessions on navigation, filtering, bookmarking, and exporting within QlikSense; power users attended workshops on self-service visualization creation, set analysis expressions, and story-building features; and IT administrators completed deep-dive training on QMC (Qlik Management Console) configuration, security rule management, task scheduling, and capacity monitoring. Training was delivered in a one-week intensive format with recorded sessions and quick-reference guides provided for ongoing support.
Long-Term Strategic Benefits
Beyond the immediate migration, the move to Qlik unlocked lasting strategic advantages for the bank. Report generation cycles that previously consumed full business days were reduced to hours, freeing analyst capacity for higher-value interpretive work. The self-service analytics capabilities of QlikSense empowered business units to create their own exploratory visualizations without submitting IT development requests, reducing the reporting backlog by an estimated 40 percent within the first quarter post-migration. Consolidated licensing costs and the elimination of the Cognos infrastructure footprint delivered ongoing annual savings. Most importantly, the modern analytics foundation positioned the bank to incorporate advanced capabilities such as predictive analytics, natural language querying, and real-time streaming data integration as its data strategy matured.
Related solution: Data Analytics & BI — Power BI, Cognos migration and Analytics CoE setup →
