Reporting for 200 stores, 8 times a day
I automated results reporting for about 200 stores and resellers with Power BI, Power Apps and SharePoint. It went from one update a day to 8, and ~200 hours of manual work per week went away.
[Vivo]Market intelligence on demand
Find out what your sales are hiding
Sales, customer and competitor analysis for companies without a data team.
Which one is you?
Retail and store chains
You have: invoices and ERP data.
You find: market basket, cross-selling and customers who left.
Talk about thisInternet providers
You have: a subscriber base.
You find: churn, high-potential regions and plan upgrades.
Talk about thisSales and marketing teams
You have: CRM and campaign data.
You find: what sold, who bought and where to invest.
Talk about thisThe offer
7-day sales diagnosis
You send the data you already have. I give back what it says about your customers and what to do about it.
You send
Your invoice XMLs (Brazilian NF-e or NFC-e) or the sales report from your ERP. A spreadsheet works too.
- Timeline
- 7 days after I get the data
- Format
- A report plus a call to walk you through it
- Price
- On request, fixed before we start
You get
- Market basketWhich products sell together and which bundles make sense.
- Cross-sellingWhat to offer each kind of customer at the counter and after the sale.
- RFMWho buys a lot, who is cooling off and who is gone, so you can act on each group.
- 5 prioritized actionsWhat to do first, with the size of each opportunity.
I use my own importer that turns invoice XMLs into a per-store database, so messy invoices are not a problem.
Get the diagnosisHow it works
- 01
A 20-minute call
You tell me what you want to understand about your sales. The call is free and ends with a fixed quote.
- 02
You send the data
XMLs, ERP exports or spreadsheets, however they are. I'll sort them out.
- 03
You get the report
Within 7 days, with the analysis and the 5 actions. We go through it together.
Who does it
I'm Felipe Arede. I spent 8 years in market intelligence and strategy at TIM and Vivo, two of Brazil's largest telcos, working on sales for hundreds of stores and a base of tens of millions of customers. Now I bring the same method to companies without a data team.
8+
years in analytics and strategy
~200 h
of manual work removed every week
−60%
in analysis turnaround time
Cases
Results from my time at Vivo and TIM.
Stock without stockouts
I tracked 250+ SKUs straight from the ERP. Turnover, stockout risk and purchase needs started guiding how devices moved between stores.
[Vivo]The right offer for each region
I grouped Brazil's 67 area codes by market share, potential, income, competition and network quality. The model was rolled out nationally to decide which offer goes to each region and channel.
[TIM]See 4 more cases
Competitor monitor
A Python scraper collects Vivo and Claro prices, data allowances, perks and promotions on demand, replacing manual surveys.
[TIM]FWA pilot
I used 5G tower usage to find the regions with the most potential. The MVP launched in Rio sold 100% of the test CPEs.
[TIM]Triple A strategy
Network, Sales and Media ratings, with incremental analysis and control groups, to prioritize tens of millions of reais in investments.
[TIM]AI-built presentations
Python and SQL feed a single JSON source, and AI builds the dashboard and the presentation. An analysis that took about two days now takes half a day.
[TIM]FAQ
My data is a mess. Will it work?
Yes. Almost everyone has data spread across invoices, ERP and spreadsheets, and sorting it out is part of the job. If something important is missing, I'll tell you on the first call, before you pay.
My business isn't retail. Will it work?
Yes. If you have sales, customers or competitors recorded somewhere, it can be analyzed. On the 20-minute call we figure out which analysis fits your case.
What about privacy (LGPD)?
I only use what the analysis needs and work with anonymized customer identifiers. I'll sign an NDA if you want and delete the files when the project ends.
How much does it cost?
It depends on the data volume and how many stores are included. The 20-minute call is free and ends with a fixed quote, with no surprises later.
How long does it take?
7 days from when I get the data. If your base is very large, we agree on the timeline before starting.
Do I need a specific system?
No. Invoice XMLs come out of any issuing system, and most ERPs export sales reports as spreadsheets.
Shall we look at your sales?
Message me on WhatsApp and we'll book the 20-minute call.
Get the diagnosisPrefer email?lf.arede@gmail.com