Cloud & Automation
Designing a Report Engine for UI and API Consumers
Design one governed report backend for interactive UI pages, external APIs, downloads and large asynchronous exports.
Hi, I'm Javi
Data, AI &
Cloud Engineering
I build, learn and share practical knowledge about the Microsoft Data Platform, AI and cloud technologies. My goal is to help engineers and organisations turn data into real-world value.
Technology is a
trampoline to create
opportunities for people.
Focus areas
Microsoft Data Platform
SQL Server, Azure, Fabric, Analytics
Cloud Architecture
Azure, scalability, best practices
AI Engineering
LLMs, data, automation, real use cases
Engineering Practices
Performance, architecture, tools
Latest Articles
View all articles
Cloud & Automation
Pre-Rendered Reports vs Live Queries
Choose pre-rendered, live, or hybrid report execution using freshness, repetition, variability, cost and security constraints.
Cloud & Automation
Report Engine Architecture: Request to Result
Trace a report request through gateway, security, validation, cache, Fabric query, result construction and monitoring.
Featured Projects
View all projectsFabric Data Platform Template
A reusable end-to-end Microsoft Fabric reference implementation: ingestion, Bronze, Silver and Gold layers, serving, Git, CI/CD and observability, built with practical engineering patterns.
SQL Performance Analyzer
A practical SQL Server and Python tool for investigating workload: active sessions, blocking, waits and expensive queries, grouped so the real problem stands out.
AI Data Assistant
A reference application for safe LLM access to structured enterprise data: approved tools, authorization before data access, validated answers and full observability.