About The Customer

Asmira Group operates in the fuel and logistics space, serving a portfolio of clients across multiple locations. Before this project, most operational insight lived in Excel files, POS exports, and ad-hoc reports. Each location had its own way of tracking fuel sales, client activity, and vehicle consumption, making it difficult for management to see a reliable, consolidated picture of the business.

The team knew that with the volume of transactions they handle, manual reporting was not only slow, it was a risk. They needed a platform that could centralize data, respect location boundaries, and surface the right insights without adding complexity to day-to-day work.

Business Need

Asmira Group came to us with a clear set of challenges:

• No single source of truth for fuel transactions Each location was exporting files, maintaining its own spreadsheets, and sending reports upward. Numbers often conflicted, and reconciling them took time.
• Limited visibility into client behavior While data existed, it was not structured in a way that made it easy to answer questions like:
• Which clients are our most valuable?
• Which vehicles consume the most fuel?
• How do weekdays vs. weekends perform by location?
• Multi-location structure with strict access boundaries Asmira needed analytics at both the global and per-location levels, but with a hard rule:
• Employees should only see data for the location they belong to.
• Management should be able to see everything.
• Manual, error-prone imports Fuel transaction data was often fed into the system via exports from pumps or accounting software, then manually adjusted. There was no standard, validated way to ingest large volumes of records.
• Growing complexity in roles and responsibilities As the organization grew, they needed flexible, customizable roles that could be adapted to their internal structure, not a fixed, one-size-fits-all permission model.

Asmira Group was not looking for just a dashboard. They wanted an analytics platform that helped them track every client and every liter, and turn that data into decisions.

Our Solution

We designed and delivered a centralized fuel management and analytics platform tailored to Asmira Group’s multi-location, high-volume operation.

1. Centralized, multi-location data backbone

• Built a single, consolidated database for all fuel transactions across locations.
• Introduced a location-aware data model, so every transaction is tied to a specific branch, tank, pump, vehicle, and client where applicable.
• Added real-time and historical views, enabling managers to look at today’s performance or zoom out to full-year trends.

2. Deep analytics with location-level visibility

• Implemented a global dashboard showing key KPIs:
• Total fuel sold
• Total revenue
• Average unit price per liter
• Added filterable analytics so leadership can drill down by:
• Location
• Date range
• Fuel type
• Volume range
• Built per-location dashboards, so each branch sees:
• Its own fuel sales and revenue
• Top vehicles by consumption
• Top clients by volume and revenue
• Weekday vs. weekend performance
• Distribution of fuel types and pricing trends

Even though the analytics layer is centralized, everything can be sliced by location, by product, by time, and by client.

3. Strict, flexible access control

• Implemented a fully customizable role system:
• Admins can create roles from scratch (for example “Location Manager – Didim”, “Accounting”, “Operations Analyst”).
• Each role can be configured with granular permissions (view, create, import, manage users, manage roles, etc.).
• Enforced location-level access:
• Standard employees only see data for the location they are assigned to.
• Head office users and executives can see aggregated and cross-location data.
• Designed the permissions panel so non-technical admins can adjust roles without developer involvement.

4. High-volume transaction management

• Built a fast, searchable transaction list capable of handling hundreds of thousands of records with:
• Pagination, filtering, and search by receipt, vehicle, location, date, fuel type, and more.
• Added a manual entry form for recording fuel sales with all required operational fields:
• Receipt number, record date, shift date
• Vehicle, product, liters, unit price
• Pump and tank identifiers, operator, location
• Designed the forms to minimize errors with required fields, field validations, and clear error messages for incorrect values.

5. Robust import tools with clear rules

• Implemented a bulk import module that accepts Excel and CSV files from existing systems.
• Provided template and header documentation in both Turkish and English to match Asmira Group’s internal formats.
• Added validation steps so:
• Numeric fields such as liters and prices are checked for correctness
• Invalid rows are flagged with clear error messages
• Successful imports can be tracked and audited

This turned what used to be a painful, manual Excel process into a repeatable, auditable workflow.

6. Operational context and planning

• Integrated calendar-based views to align operational shifts and transaction dates.
• Helped the team see fuel activity in the context of shift changes, seasonal patterns, and planned operational events.

Result

Within a short period after launch, Asmira Group’s team shifted from chasing spreadsheets to working from a single, trusted platform.

• One source of truth for fuel data All locations now feed into the same system, with standardized structures and validation. Management no longer needs to reconcile conflicting reports.
• Per-location focus, company-wide oversight Branch staff work in a clean interface that only shows their location’s data. Executives can see consolidated performance and compare locations without asking for manual reports.
• Faster, more reliable reporting Monthly and weekly reports that used to take hours to prepare are now available on demand, with filters and export options.
• Deeper understanding of clients and vehicles Asmira Group can now:
• Identify their most valuable clients by volume and revenue
• Track vehicles with unusually high consumption
• See how behavior changes by day, fuel type, and location
• Flexible governance as the company grows The fully customizable role system allows Asmira to adapt the platform alongside their organization, creating new roles and accommodating new locations and responsibilities without redesigning access from scratch.

The platform is more than an analytics dashboard. It has become Asmira Group’s operational nerve center for fuel data: a place where they can track clients carefully, analyze everything that matters, and make decisions with confidence.