top of page
Government BI modernization – Cognos & Power BI architecture

Enterprise BI Modernization – PSPC

Enterprise Managed Service

Modernizing a 2,200-user Cognos and Power BI environment across 15+ environments to deliver faster insights, high uptime, and consistent enterprise reporting.

Client: Public Services and Procurement Canada 

Sector: Federal Government 

Services: BI Architecture, Governance, System Optimization 

Tier: Enterprise Managed Service

Technologies: IBM Cognos, Power BI, SQL Server, Oracle, Azure

PSPC Case Study –

Business Intelligence

Infrastructure &

Modernization

 

Client Context

Organization: Public Services and Procurement Canada (PSPC)
One of the largest federal departments in Canada, responsible for government-wide procurement, real property, and asset management.
Engagement: JCG has provided BI consulting and architecture support since 2004, most recently leading the modernization of PSPC’s enterprise analytics environment.
Environment: 2,200+ users across 15 environments and 56+ Protected B-classified servers, spanning Cognos 8.1 → 12.0.3, Power BI Service, Oracle, SQL Server, and hybrid cloud infrastructure (AWS/Azure).

​

Challenge

PSPC’s enterprise BI environment had grown complex after multiple version upgrades and expanding data sources.
Aging infrastructure (Windows Server 2012, Oracle 11g) and fragmented governance were creating performance bottlenecks and compliance risks.
Internal hiring freezes limited access to specialized BI and architecture expertise, threatening operational continuity and modernization goals.

​

Solution

Jackson Consulting Group (JCG) provided enterprise BI architecture and administration leadership across all environments, including:

  • Multi-version Cognos 8.1 → 12.0.3 upgrade and hybrid cloud modernization

  • Migration of Oracle 11g → 19c and Windows Server 2012 → 2019 environments

  • Power BI governance and RBAC security model design (OIDC + GCpass)

  • Creation of a distributed SQL Server/SSIS architecture for scalability

  • Implementation of audit-ready SA&A, DR, and compliance documentation

  • Mentorship, onboarding, and the establishment of a BI & ERP Competency Centre

These initiatives provided a sustainable, secure, and compliant foundation for enterprise analytics.

Results

  • 20–30% increase in overall report output and performance

  • < 1% system downtime, with support response times under one hour

  • Consistent, repeatable change-management and deployment cycles across all branches

  • Maintained a single version of the truth for enterprise reporting

  • Eliminated the need for two–three additional full-time technical staff through JCG’s expert continuity

  • Achieved one of the highest overall quality ratings internally — data integrity, governance, uptime, and user satisfaction

​

Alignment with JCG Managed Services

​

This engagement reflects the Enterprise Managed Service tier — providing continuous BI administration, modernization, and governance support under a predictable, scalable model.

​

Technologies: IBM Cognos 8.1–12.0.3, Microsoft Power BI Service, SQL Server, SSIS, Oracle 19c, AWS EC2/S3, Azure, PeopleSoft, ERWin, GCpass, OIDC.

bottom of page