Location Intelligence & ROI Optimisation

Every Tower Site Has a Story. We Read the Data.

Transform raw network, billing, and operational logs into a Prescriptive Investment Engine — ranking every site by its True Economic Value and Strategic Growth Potential.

4
Source Systems Fused
30+
Site-Level Metrics
∞
Sites Scored & Ranked
4
Insight Categories
The Challenge

Sites Are Costing More Than They Should

Tower sites generate lower-than-expected revenue compared to their cost — but without integrated data, you can't tell if the problem is technical, commercial, operational, or strategic.

Ghost Sites

Infrastructure that is "always on" — consuming power and rent — but serving almost no one. Utilisation under 20% while capacity sits idle.

Hiddenin averages — only visible when you compare usage vs. capacity

Diesel Drain

A "high revenue" site may actually be a low-profit site because fuel consumption eats 70% of the margin. You can't see this from billing data alone.

5xhigher maintenance cost for diesel vs. solar sites

Quality Time Bombs

Sites with high revenue but poor QoS (packet loss, high latency). Users don't complain — they simply stop using data or switch SIMs.

3xfaster churn rate for high-value users on degraded sites

Distribution Gaps

Network-ready sites with high capacity but low revenue — not because of technical issues, but because there are zero retail outlets nearby.

0 POSwithin 2km radius of some high-capacity sites

The Shift: From "What Happened" to "What Should We Do"

OLD QUESTION

Which site made the most money?

NEW QUESTION

Which site has the best net margin after all costs?

OLD QUESTION

Which site has low traffic?

NEW QUESTION

Is the cause technical, commercial, or operational?

OLD QUESTION

Where should we invest next?

NEW QUESTION

What is the ROI-ranked priority list with specific actions?

Data Integration

4 Source Systems, 1 Unified View

We fuse data from four departmental silos — each providing a different lens on the same tower site. The magic happens when they're joined by SiteID.

A. Mediation & Billing (BSS)

Commercial Source

"I need daily aggregated revenue, traffic volume, and Interconnect splits per SiteID."

Total_RevenueData_Traffic_GBVoice_OnNet_MinVoice_OffNet_MinVoice_Intl_MinRoaming_RevVAS_RevSub_Count
Key Insight: High off-net traffic at a site reveals "Community Clusters" — prime targets for family/closed-user-group sales.

B. Network Engineering (OSS)

Technical & Quality Source

"I need site-level QoS, Latency, and Specific Failure Codes."

Call_Drop_RateAvg_Latency_msPacket_LossPRB_Utilization_%Drop_Reason_CodeHandover_Success_Rate
Key Insight: A site with high revenue but 1.5% packet loss is a "Churn Time Bomb" — users won't complain, they'll just switch.

C. CRM & DPI Analytics

Behavioural & Demographic Source

"I need anonymised segment profiles and POS density for each site's radius."

Main_SegmentHigh_End_Device_%Top_App_CategoryPOS_CountCompetitor_Site_Proximity
Key Insight: If a high-capacity site has low revenue, check POS count. No shops nearby but 3 competitor stores? It's a "Distribution Gap."

D. Site Operations & ERP

Infrastructure & Cost Source

"I need the Power Source Profile, Fuel Consumption, and Physical Accessibility."

Power_Source_TypePower_Availability_%Monthly_RentFuel_LitersMax_Capacity_MbpsBackhaul_Type
Key Insight: Diesel sites in "Extreme" accessibility areas have 5x maintenance cost. We calculate Net Contribution Margin, not just top-line revenue.

The Fusion: 4 Files → 1 Unified Site Record

billing_export.csv
network_performance.csv
customer_insights.csv
site_infrastructure.csv
JOIN ON SiteID
Example: Fused Record for
Site S_1002
Revenue
$8,400
Drop Rate
4.8%
Power
Diesel
POS Count
2
Fuel Cost
1,500L
Segment
Youth
Top App
Social Media
Root Cause
High Fuel + Poor QoS
The Solution

The Site Scorecard: Every Site Ranked & Actioned

A multi-dimensional ranking engine that scores every site by its True Economic Value, then prescribes the exact action needed — technical fix, commercial push, or operational upgrade.

End-to-End Processing Pipeline

Source Systems
Billing / BSS
Network / OSS
CRM / DPI
Site Ops / ERP
JOIN on SiteID
Feature Engineering
Net Margin Calc
Revenue − Rent − Fuel − Maintenance
Utilisation Ratio
Actual Usage ÷ Max Capacity
Gap Analysis
Technical vs. Commercial Root Cause
30+ engineered features
AI Analytics Engine
Revenue vs. Quality Matrix
Identifies sites where you're "stealing" revenue from poor quality (High Risk)
Energy ROI Model
Identifies where CAPEX in solar pays for itself in <18 months via diesel savings
Persona-Based Clustering
K-Means grouping by behaviour — compare all "University Clusters" nationwide
Decision Engine: Technical Fix vs. Commercial Push vs. Operational Upgrade
Scored & ranked
Output: The Site Scorecard
RankSiteIDRoot CauseActionUplift
1S_1014Commercial GapOpen 2 retail outlets+40% Revenue
2S_1002Technical GapFix antenna interference-25% Churn
3S_1039Operational GapInstall solar panels+15% Margin
4S_1006Strategic GapUpgrade to 5G for premium users+25% ARPU
Step-by-Step Process

5 Key Questions Answered

The integrated data approach directly solves your operational challenges — moving from opinion-based decisions to evidence-based site management.

01

Identify unutilised or low-utilisation sites

THE OLD WAY

Looking only at low revenue or low traffic.

THE NEW APPROACH

Compare Actual Usage against Theoretical Capacity from Planning/OSS data.

THE INSIGHT

Find "Ghost Sites" — infrastructure always on, consuming power and rent, serving almost no one. Decide: decommission or relocate hardware.

02

Measure traffic, revenue, ARPU, and active base per site

THE OLD WAY

Manual reports from the Billing team.

THE NEW APPROACH

Real-time Site Profitability Dashboard — see Net Margin, not just revenue.

THE INSIGHT

A "High Revenue" site may actually be a "Low Profit" site because fuel consumption eats 70% of margin.

03

Compare performance across clusters

THE OLD WAY

Comparing City A vs. City B.

THE NEW APPROACH

Persona-Based Clustering (K-Means) — group by behaviour regardless of geography.

THE INSIGHT

Compare all "University Clusters" or "Industrial Zones" nationwide to find underperformers.

04

Evaluate capacity vs. actual usage

THE OLD WAY

Checking if a site "feels" slow.

THE NEW APPROACH

Congestion Forecasting — join PRB Utilisation (Network) with Data Traffic (Billing).

THE INSIGHT

Sites may look underutilised on a 24hr average but hit 95% congestion every day at 7 PM — the "Peak Hour Bottleneck."

05

Detect technical or commercial gaps

THE OLD WAY

Guesswork between Network and Sales teams.

THE NEW APPROACH

Gap-Analysis Matrix — automatically classify the root cause.

THE INSIGHT

Low revenue + high drops = Technical Fix (send technician). High capacity + low drops + zero POS = Commercial Push (send sales team).

Site Personas: Behaviour-Based Clustering

Industrial Zones
Corporate-heavy, business apps, weekday peak
University Clusters
Youth segment, social media & gaming, low ARPU
High-Value Urban
Premium users, video streaming, high device penetration
Rural / Remote
Low density, diesel-powered, high maintenance cost
Expected Outcomes

4 Categories of Actionable Insight

Insights you can present directly to your Board of Directors or CTO to justify infrastructure investment.

Investment Efficiency

CAPEX / OPEX Optimisation

The Insight

Site S_1039 generates $14.5k/month but consumes 1,200 litres of diesel. Its net margin is actually lower than S_1001, which runs on 100% solar.
Data Reveals
Root Cause
Model Prescribes
Specific Action
Result
+15% Net Margin
Recommended Action
Immediate "Green Upgrade" — switch S_1039 to solar to save $5k/month in fuel and logistics.
Expected Impact
+15% Net Margin

The Decision Tree: What Action for Each Site?

The model automatically classifies underperforming sites and prescribes the right action.

Site Underperforming?
Check metrics
Revenue LOW + Drop Rate HIGH + Drop Reason = "Interference"
Technical Fix

Send a technician to tune the frequency

Capacity HIGH + Drop Rate LOW + POS Count = 0
Commercial Push

Send the sales team — open a retail shop

Revenue HIGH + Fuel Cost HIGH + Power = "Diesel"
Operational Upgrade

Switch to solar — payback in <18 months

Utilisation HIGH + Premium Users + Low Capacity
Strategic Investment

Upgrade to 5G to capture high-end users

What We Need From You

4 CSV Exports. That's It.

We work with your existing systems. Each department provides a simple data export — we handle the integration, modelling, and visualisation.

Mediation & Billing Team

billing_export.csv

DateSiteIDTotal_RevenueData_Traffic_GBVoice_OnNet_MinVoice_OffNet_MinVoice_Intl_MinSub_Count

Network Engineering (OSS)

network_performance.csv

DateSiteIDPRB_UtilizationCall_Drop_RateAvg_Latency_msPrimary_Drop_ReasonHandover_Success_Rate

Site Operations & ERP

site_infrastructure.csv

SiteIDPower_Source_TypePower_Availability_PctMonthly_RentFuel_Liters_ConsumedMax_Capacity_MbpsBackhaul_Type

CRM & Marketing

customer_insights.csv

SiteIDMain_SegmentHigh_End_Device_PctTop_App_CategoryPOS_CountCompetitor_Site_Proximity_m

What Axiom Data Delivers

Everything else is handled by us

AI Analytics Platform

Data fusion & feature engineering
Revenue vs. Quality Matrix
Energy ROI modelling
Persona-based clustering (K-Means)
Congestion forecasting

Interactive Dashboard

Site Scorecard with ROI ranking
Gap-Analysis Matrix
Decision Tree visualisation
Cluster comparison views
Drill-down per site

Infrastructure & Support

Cloud hosting & security
Data pipeline automation
Monthly model refresh
Board-ready report exports
Ongoing technical support
Delivery Timeline

From Data Exports to Live Scorecard

1
Week 1-2

Data Onboarding & Fusion

Receive the 4 CSV exports. Validate schemas, handle missing values, join on SiteID. Build the unified site record.

2
Week 2-3

Feature Engineering & Modelling

Calculate net margins, utilisation ratios, and gap classifications. Train K-Means clustering and decision tree models on your actual site data.

3
Week 3-4

Dashboard & Scorecard

Build the interactive dashboard with site rankings, decision trees, cluster comparisons, and drill-down views. Deploy to secure cloud.

4
Week 4-5

Handover & Board Presentation

Live walkthrough with your team. Export board-ready reports. Train your team on interpreting the Scorecard. Ongoing support begins.

Ready to See Your Sites in a New Light?

Send us the 4 data exports and we'll deliver a scored, ranked, and actioned view of your entire tower portfolio in as little as 5 weeks.

axiomdata.com.au
Sydney, Australia