Live Dashboard
From 3-Day Excel Consolidation to Real-Time Dashboard
This interactive Power BI dashboard shows a fictional Latin American regional P&L across 5 countries and 12 months — covering revenue, margin, OPEX variance, product mix, working capital KPIs, and sales performance. Click, filter, and drill down — a practical example of how consolidated regional data can look when automated.
💡
Try it: Use the Country slicer to filter by region. Click on chart elements to cross-filter. Navigate between pages using the tabs at the bottom of the dashboard.
📈
Page 1: Revenue Overview
Monthly revenue trends by country with KPI cards. Mexico's growth and Colombia's decline visible at a glance.
💰
Page 2: Margin & OPEX
Margin trends showing Colombia's erosion from 38% to 30%. OPEX actual vs budget with cost center breakdown.
🔍
Page 3: Product Mix & PVM
Revenue by product line revealing Colombia's Hardware dependency. Price/Volume/Mix decomposition per country.
⚡
Page 4: Liquidity & Turnover KPIs
Working capital health at a glance: quick ratio, current ratio, cash flow, DSO/DIO/DPO gauges, AR vs AP turnover, and accounts payable aging.
🌎
Page 5: Sales by Country
Revenue by month per country with top 5 customers and top 5 sellers for each market. Filter by month to see seasonal patterns.
Regional reporting can look like this.
Dashboards like this can replace manual consolidation and give the team self-service access to real-time data.
Interested in seeing more? Let's connect.