Sales intelligence
Sales, margin, targets, customers, and regions for a specialty coffee brand selling through four channels: B2B distribution, own stores, e-commerce, and marketplaces.
The challenge
Alma Andina sells through four channels and tracked each one in a separate file. Management could not tell whether growth came with margin, which products carried the business, or which reps needed help to hit target.
Python · Power Query · DAX · Power BI
Key findings
- Sales grow 33.1% year over year; e-commerce nearly doubles (+96%).
- Gross margin rises to 33.0% (+4.6 pp); subscriptions are the most profitable category.
- Discounts eat 17% of potential margin; the biggest is with retail chains (15%).
Capabilities shown
- Time intelligence (YTD, prior year, 3-month rolling)
- Dynamic ABC / Pareto analysis
- Targets by rep with TREATAS
- Customer cohorts
Dashboard tour
7 views. Click any view to enlarge it.
Live interactive dashboard
Use the filters and the navigation menu inside the dashboard, just as a manager would.
More prototypes from this service
Power BI dashboard360° digital brand intelligence
Social media, social listening with emotion analysis, web traffic, and campaign ROI in one dashboard to decide what to publish, where to invest, and when to react.
View prototype
Power BI dashboardManagement performance tracking
Balanced scorecard, project portfolio with earned value, action plan, and risk matrix for the management committee of a logistics company.
View prototype
Power BI dashboardLogistics control tower
On-time-in-full deliveries, distribution network map, fleet, distribution centers, and delivery exceptions for a nationwide parcel and freight company.
View prototype
Power BI dashboardFinance & scenarios
Income statement, budget vs. actuals, cash flow, working capital, and a scenario simulator to anticipate liquidity over the next 12 months.
View prototype
n8n + AI automationWeekly AI executive report
Every Monday, management gets a clear report: what happened, why, and what to do.
View prototype
AI agentAsk your data
Managers ask in plain language; the agent explores the database, writes and fixes SQL, charts the result, and answers with findings and a recommendation.
View prototypeReady to turn your data into smart decisions?
We build this kind of solution with your own data. Let’s start with a free 30-minute call.