Case Studies
Real companies that transformed their operations with data, automation, and intelligence
Quality Control Automation and Price Analysis
Automotive Dealership Network
The Challenge
An automotive dealership network published dozens of vehicles daily but had no way to detect incomplete listings or compare their prices with the market.
My Solution
Automated system that scans listings, detects errors, compares prices with competitors, and sends daily reports via email.
Results
- 300+ vehicles monitored daily vs. manual review
- Automatic report at 7 AM — from 3 hours of manual work to 0
- Immediate detection of listing errors and off-market prices
"Before, we had to review everything by hand, and errors still slipped through. Now every morning we receive a summary with cars missing photos, prices that are off-market, and clear recommendations. It's like having an analyst working 24/7 for us."
— Commercial Manager, Automotive Dealership Network
Financial and Operational Visibility
Veterinary Clinic Network
The Challenge
An expanding veterinary clinic had no clear view of financial performance. Information was scattered across multiple files with no strategic reporting.
My Solution
Automated system that extracts data from their management system, processes it with Power Query, and generates visual reports with clear performance visibility.
Results
- From manual Excel exports to a real-time updated dashboard
- Full visibility by section: revenue, procedures, trends
- Management runs from the dashboard — they barely need to log into the ERP anymore
"We had the data, but not the complete picture. Now we can see how each section of the clinic is performing, how much we're generating, and which areas need improvement. It gave us the professionalism boost we needed to grow."
— Director, Veterinary Clinic Network
Complete Financial Visibility for Short-Term Rentals
Real Estate Holding
The Challenge
The partners couldn't see the real profitability of their short-term rental apartments. Data was scattered across the booking platform, accounting, and external variables like UF and dollar exchange rates.
My Solution
We integrated Cloudbeds (bookings), Softland (accounting), and UF/dollar data from the CMF into a single Power BI dashboard. Revenue per room, booking lead time, guest origin, and live income statements.
Results
- 3 data sources integrated: bookings + accounting + financial indicators
- Per-unit profitability visible in real time
- Actual vs. projected cash flow — partners informed without depending on the accountant
"We went from an accounting black box to having total visibility of the business. Today we see revenue per room, booking lead time, guest origin, live income statements, and actual vs. projected cash flow — all in one place."
— Partner, Real Estate Holding
HR Analytics and Interactive Org Charts
Financial Group
The Challenge
Organization with 4,000+ employees. Org charts were updated manually in PowerPoint (4+ hours). Performance evaluations had undetected biases. Existing software cost USD 15,000/year.
My Solution
NodalTree: interactive org chart from HR data (Excel/CSV/DB). Automatic updates, drag & drop editing, PDF export. Evaluation calibration system with bias detection.
Results
- Org chart updates in 10 minutes (vs. 4 hours)
- Biases identified across 100+ evaluating managers
- Replaced USD 15,000/year software
Could your company be the next success story?
Let's discuss your business's specific challenges