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.
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.
Prioritization by business rules
The rules that lived in the analyst's head become automatic scoring.
Reports generated server-side
Reports generate themselves, optimized for massive datasets.
Results & Impact
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
Backend
Data and reports
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.