Five by Five Consulting Five by Five Consulting

Our Work

Five by Five has helped clients across 18 long term projects, each turning unique data into decisions.

Industry

Technology

BC Liquor Distribution Branch

2025–Present

Microsoft Fabric Data Modernisation

GovernmentRetailWholesale
Microsoft Fabric Azure Power BI

Design and develop significant subject areas of the LDB Microsoft Fabric implementation, a programme to modernize aging data infrastructure. Work within a larger team involving Microsoft, LDB employees, Ernst & Young, among others. Participated in the full migration and re-assessment of all data subject areas, creating new data consumption assets for business stakeholders, in particular Fabric Semantic Models.

Navira

2024–2025

Data Warehouse & Power BI Semantic Model

RetailEcommerceWholesale
Snowflake Python Power BI APIs Azure

Built a net-new data ecosystem from the ground up to give Navira unified visibility into purchasing, sales, inventory, and margin performance. Delivered a centrally governed Power BI Semantic Model on a Snowflake Data Warehouse, establishing a single source of truth for profitability analysis across the business.

Fusion92

2023–2025

Advertising Analytics & Financial Data Ecosystem

AdvertisingMarketing
Snowflake Python Power BI APIs Azure Netsuite

Built a net-new data ecosystem to bring together advertising management, client profitability, and financial analysis into a single governed platform. Delivered a centrally managed Power BI Semantic Model on Snowflake, giving Fusion92's teams consistent, reliable metrics across their entire client portfolio.

Duer Jeans

2022–2024

Financial, Operations & Sales Data Platform

RetailApparel
Snowflake SAP Power BI Azure

Designed and delivered financial, operations, and sales data models for Duer, integrating SAP Business One as a core source system alongside API-connected data streams. Built a governed Snowflake data warehouse providing the business with a unified, reliable foundation for performance and profitability reporting.

Motorola Solutions Inc.

2021

Project Management Analytics

TechnologyCommunications
SAP Power BI Salesforce APIs

Contribute to a large scale migration between Atlassian JIRA and Salesforce, requiring data profiling, catalog management, migration analytics and data cleansing. Large scale migration and integration effort involved four geographical regions and multiple business units.

Aspire North

2022–2023

Data Warehouse & Client Reporting Portal

AdvertisingMarketing
Snowflake Power BI APIs

Built a custom data warehouse drawing from internal product and cloud software sources via bespoke API integrations. Delivered a client-facing reporting portal alongside internal sales and financial management assets, giving Aspire North a complete view of performance across their business.

Book Depot

2021–2022

ERP Data Warehouse & Operational Analytics

RetailWholesaleEcommerce
Snowflake MongoDB Power BI Azure

Designed a data warehouse and operational data store sourced from Book Depot's custom ERP, financial, and purchasing systems — including MongoDB as a core operational source. Delivered operational reporting, profitability analysis, and inventory tooling tailored to the unique demands of a large-scale book distribution business.

Arc'teryx Equipment

2019–2020

Qlikview to Power BI Migration

RetailApparel
Power BI Analysis Services SQL Server Suite SAP

Provided design and development resources for Arc'teryx's full Qlikview-to-Power BI migration. Delivered Warehouse and Stock Transfer model conversions as part of the broader corporate BI modernization.

lululemon

2019–2020

Azure Analysis Services Semantic Model

RetailApparel
Analysis Services Snowflake SQL Server Suite Azure

Led technical consolidation of ~50 Qlikview assets, including three large OLAP cubes and numerous legacy extracts and reports. Unified reporting under the Microsoft Azure and Snowflake umbrella, eliminating duplicate data products across business units.

lululemon

2018–2019

Netezza to Azure Data Warehouse Migration

RetailApparel
Azure IBM Netezza SQL Server Suite

Served as technical architect during the migration of IBM Netezza database systems to Microsoft Azure Data Warehouse and associated Azure services. Guided architectural decisions across a large-scale, high-complexity data environment.

Change Healthcare

2018–2019

Compliance & Quality Reporting Suite

Healthcare
TIBCO Spotfire SQL Server Suite Salesforce

Partnered with the Customer Success team to build dashboards and reports supporting Compliance and Quality reporting. Leveraged TIBCO Spotfire against a SQL Server 2016 Data Warehouse to deliver company-wide visibility.

LMI Technologies

2018–2019

Acquisition Data Warehouse & Production Reporting

TechnologyManufacturing
SQL Server Suite Netsuite

Supported LMI's onboarding of a new production-focused acquisition by developing a custom Data Warehouse and suite of reporting tools. Integrated with operational systems (Exact JobBoss) to streamline production visibility and reduce inventory overhead.

BGC Engineering

2017–2019

Executive Power BI Reporting Initiative

EngineeringConsulting
Power BI Azure

Built a greenfield integration warehouse in Azure SQL to underpin a Power BI pilot programme for executive-level reporting. Delivered the full solution in an environment with no existing BI infrastructure, from concept through to deployment.

Kit and Ace

2016–2022

Analytics Modernisation & Self-Serve Reporting

RetailApparel
Power BI Analysis Services SQL Server Suite Snowflake Netsuite

Maintained and improved analytics across the organization while modernizing legacy reporting systems. Drove adoption of SSAS Tabular and Power BI, expanding access to self-serve tools across the business.

Fraser Health

2016

Management KPI Development

HealthcareGovernment
SQL Server Suite SharePoint

Advised Fraser Health on the design of management KPIs for a newly built SharePoint site. Recommendations proceeded to development using SSRS KPIs integrated with SQL Server 2016 for leadership-level visibility.

Indochino

2016

Analytics Strategy & SSAS Tabular Implementation

RetailApparelEcommerce
Analysis Services SQL Server Suite Sage

Turned around Indochino's information delivery effort through strategy, proof of concepts, development, training, and data governance. Led the organization toward an SSAS Tabular implementation to modernize analytics across the business.

Teekay Corporation

2014–2015

Financial Data Warehouse

Oil & GasTransportationMaritime
SQL Server Analysis Services

Designed and implemented a Financial Data Warehouse covering GL, Projects, and Operational Expenses for corporate financial operations. Custom rapid-refresh ETL achieved average data freshness of 15 minutes with automated testing throughout.

CHC Helicopter

2012–2014

Enterprise Data Integration & Self-Serve Analytics

AviationTransportation
Analysis Services SQL Server Suite

Delivered self-serve analytics for Order Management and Repair Lifecycle programmes, reducing costs through improved operational visibility. Also led an enterprise data integration programme spanning all key business systems including AMOS, Lawson M3, Workday, and Salesforce.