• Expertise
  • Industries
  • Jobs
  • Culture
  • About
  • Contact
Use cases
Department KPIs

Problem

A retail corporation needed to develop a project to optimize IT ticket processes and inventory, evolving from manual Excel management to automated KPIs, enhancing efficiency, reducing errors, and improving report reliability.

The manual data extraction was slow, error-prone, and hindered critical decision-making speed. Additionally, outdated information for market and product managers impacted decision accuracy. An opportunity was identified to improve the information flow, especially during team or department changes, ensuring that knowledge transfer remains continuous and seamless.

Solution

The project was developed in two phases:

  • Phase 1: Focused on manual data extraction from Easy Vista to GCP. Data was processed in BigQuery, generating reports and KPIs for management, but was time-consuming and lacked flexibility.
  • Phase 2: APIs automated extraction, using GCP tools like Pub/Sub, Cloud Functions, and Looker for interactive dashboards.

Results

The project’s implementation significantly enhanced operational efficiency and resource allocation. The new solution ensured reliable information access, optimized internal processes, and improved the user experience, streamlining data integration and ticket management.

The Control Dashboard offered detailed data monitoring with real-time updates, enhancing reporting precision. Improved ticket visibility provided managers with clearer, reliable data, strengthening decision-making. Automation reduced FTEs by streamlining processes, enabling the team to focus on strategic analysis and decision-making, boosting productivity and cutting costs.

This is the work we did
with our clients, in this expertise
Make the next step and get in touch
and see the advantages for yourself