Modernising Fuel Distribution Analytics with Snowflake and Qlik Cloud
Lowes Petroleum is a regional Australian fuel, energy and lubricants distributor operating as a joint venture with BP Australia. The business supplies and transports fuel across regional Australia, with an expanding network of service stations and commercial customers.
Context: Replaced fragmented extraction with a governed ingestion layer designed for incremental loading of large transactional datasets.
01Reporting relied on fragmented, application-level data extraction and transformation.
02Business logic was duplicated across Qlik load scripts, creating inconsistent definitions and no shared source of truth.
03Limited traceability existed between reports and source systems, including Sage 300 and third-party applications.
04The move to Qlik Cloud required a scalable, governed data platform capable of supporting future business domains.
Designed a Snowflake medallion architecture across Bronze, Silver and Gold layers, supported by dbt Core, Azure Data Factory, Azure Data Lake Storage and Terraform-managed infrastructure.
Designed a target-state Qlik Cloud governance model across 13 business domains, with separate development and production spaces, native groups and ICT-led administration.
Completed a field-level audit of Sage 300 and third-party source tables to establish traceability from source ingestion through Snowflake to reporting.
Replaced fragmented Qlik extraction with a governed Azure Data Factory ingestion layer into Snowflake, designed for incremental loading of large transactional datasets.
Established an architecture that can support additional data domains while maintaining governance, performance and controlled platform consumption.
Delivered full source-to-report traceability for three in-scope applications.
Established a shared, evidence-based view of reporting requirements across core business domains.
Designed and provisioned a cost-aware Snowflake environment with separate development, production and Qlik reload warehouses.
Established a structured Qlik Cloud governance model based on business domains and controlled access.
Created a scalable foundation for onboarding additional datasets and business domains.
"Thanks to the Decision Inc team, soon we'll be able to reliably provide our decision makers with the clean, contextualised data that they need, without the noise"
Talk to our team about building a governed, traceable data foundation for your reporting.