← Back to projects
ISA CTEEP · Power sector (Brazil)

Audits with data analysis

For ISA CTEEP, a Brazilian power transmission company: from manually reviewing Excel spreadsheets to an interactive system with advanced filters, visual prioritization and automatically generated PDF/Excel reports.

+60%
Operational efficiency
Thousands
Records analyzed per cycle
Auto
PDF/Excel reports generated

The Problem

In the power sector, the audit review was done by hand over Excel spreadsheets: thousands of records, filters living in the analyst's head and reports built one by one. Slow, error-prone and without objective prioritization.

  • • Manual review of thousands of records in Excel spreadsheets
  • • Filters and criteria living in the analyst's head
  • • PDF/Excel reports assembled one by one, manually
  • • No way to prioritize which cases require attention first

My Process

1. Discovery of the manual process

Understood the real audit flow: what the analyst reviewed, with which criteria and what outputs were generated.

  • ✓ Mapped review criteria and business rules of the area
  • ✓ Inventory of the report types that were delivered
  • ✓ Identified the bottlenecks of the manual process

2. Full-stack application

Built an interactive system that replaced the spreadsheet: data loading, advanced filters and visualization.

  • ✓ Angular 17-18 frontend with advanced filters and interactive tables
  • ✓ .NET Core backend with server-side processing of datasets
  • ✓ Entity Framework on SQL Server for persistence

3. Visual prioritization

Designed a prioritization system based on business rules, so the analyst attacks critical cases first.

  • ✓ Complex business rules translated into automatic scoring
  • ✓ Visual prioritization of cases by risk level
  • ✓ The analyst goes from searching to deciding

4. Automated reports

Automated the generation of PDF and Excel reports with server-side processing for massive datasets.

  • ✓ PDF/Excel reports generated by the server
  • ✓ Optimization for datasets of thousands of records
  • ✓ Result: +60% operational efficiency measured on the real cycle

The Solution

Interactive system instead of a spreadsheet

Thousands of records stop being a static spreadsheet and become a system with filters, search and views.

• Data loading with validation and normalization
• Advanced combinable filters across multiple criteria
• Interactive tables with per-record detail

Prioritization by business rules

The rules that lived in the analyst's head become automatic scoring.

• Complex business rules encoded as scoring
• Visual prioritization by risk level
• The analyst decides on an already-ranked list

Reports generated server-side

Reports generate themselves, optimized for massive datasets.

• Automated PDF and Excel generation
• Server-side processing so the browser doesn't hang
• +60% operational efficiency in the audit cycle

Results & Impact

+60%
Operational efficiency
0
Hand-assembled reports
Thousands
Records per cycle
Auto
Prioritization by risk

Key Learnings

  • ✓ Discover before automating: without mapping the analyst's real criteria, any system automates the wrong process.
  • ✓ Server-side matters: processing massive datasets on the server is what made reports viable without degrading the experience.
  • ✓ Prioritizing changes the work: going from 'searching' to 'deciding' was the real efficiency leap, not the filter itself.

Tech Stack

Frontend

• Angular 17-18
• TypeScript
• Interactive tables
• Advanced filters

Backend

• .NET Core
• C#
• Entity Framework
• Server-side processing

Data and reports

• SQL Server
• PDF/Excel generation
• Scoring rules

Got a manual spreadsheet process that should be a system?

If your team loses hours reviewing Excel, turn that process into an interactive system with prioritization and automatic reports.