Francisco Barros
Back to projects
Case study2025 · Commercial Consultant & Data Analyst

AI-Augmented Reporting Pipeline — Skinautica

Executive reporting automation with SQL + Python + Power BI, complemented with Generative AI for narrative and QA.

AIBIAutomation
01

Problem

Weekly and monthly reporting burned person-days on stitching data across sources, running ad-hoc queries and drafting conclusions leadership read in 5 minutes.

02

Solution

Claude orchestration layer that (1) consumes versioned SQL queries, (2) runs KPI and delta computation, (3) drafts executive narrative with citations to underlying cells, and (4) ships Power BI + memo in a single pass.

03

Impact

-60% analysis time in the reporting cycle. Better narrative consistency week over week. Time freed up for actual strategic analysis.

04

Metrics

-60%
Analysis time
14
Reports automated
4
Sources integrated