a
Lowes Petroleum and bp
Case Study Oil and Gas Snowflake Qlik Cloud

Snowflake Unified
Data Platform

Modernising Fuel Distribution Analytics with Snowflake and Qlik Cloud

9/10
Out of 10 Net Promoter
Score (NPS)
Client
Lowes Petroleum
Industry
Oil and Gas / Petroleum
Location
Australia
Size
Enterprise
Employees
500-1,000+
01 · Customer Profile

About Lowes Petroleum

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.

The Context

Context: Replaced fragmented extraction with a governed ingestion layer designed for incremental loading of large transactional datasets.

02 · Challenges

What Was Holding Reporting Back

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.

03 · Solution

How Decision Inc. Delivered

Snowflake · Qlik Cloud · Microsoft Azure
decision-inc / lowes-petroleum / solution
solution --module 01

Modern Data Platform

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.

Snowflakedbt CoreAzure Data FactoryAzure Data Lake StorageTerraform
solution --module 02

Qlik Cloud Governance

Designed a target-state Qlik Cloud governance model across 13 business domains, with separate development and production spaces, native groups and ICT-led administration.

Qlik Cloud13 business domainsNative groups
solution --module 03

End-to-End Traceability

Completed a field-level audit of Sage 300 and third-party source tables to establish traceability from source ingestion through Snowflake to reporting.

Sage 300Field-level auditSource to report
solution --module 04

Governed Data Ingestion

Replaced fragmented Qlik extraction with a governed Azure Data Factory ingestion layer into Snowflake, designed for incremental loading of large transactional datasets.

Azure Data FactoryIncremental loading
solution --module 05

Scalable Data Foundation

Established an architecture that can support additional data domains while maintaining governance, performance and controlled platform consumption.

GovernancePerformanceControlled consumption
13Business domains in the Qlik Cloud governance model
3In-scope applications with full source-to-report traceability
3Medallion layers: Bronze, Silver and Gold
9/10Net Promoter Score (NPS)
04 · Results

What Lowes Petroleum Now Has

Delivered

Delivered full source-to-report traceability for three in-scope applications.

Delivered

Established a shared, evidence-based view of reporting requirements across core business domains.

Delivered

Designed and provisioned a cost-aware Snowflake environment with separate development, production and Qlik reload warehouses.

Delivered

Established a structured Qlik Cloud governance model based on business domains and controlled access.

Delivered

Created a scalable foundation for onboarding additional datasets and business domains.

Salvo Spina
PHOTO
"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"
Salvo Spina
ICT Manager, Lowes Petroleum
Solution Used

The Technology

AnalyticsQlik SaaSData CloudSnowflakeCloudMicrosoft AzureTransformationdbt CoreInfrastructureTerraform

Ready to UnifyYour Data Platform?

Talk to our team about building a governed, traceable data foundation for your reporting.