Plaisio Group · Greece
Plaisio: the Store Championship, from spreadsheets to one system for the whole network
Store targets were tracked in spreadsheets. Now everyone in the network sees their numbers, their points and their position right away.
- Sector
- Retail store network
- Services
- Business Intelligence · Scoring and ranking · Per-user data security
- Tools
- SAP · Power BI · DAX
Good afternoon Maria! Store B is in 8th place. You need 5 more points to move up to the next position. Let us look at your KPIs.
Sample data- PeriodMay
- StoreStore B
- InspectorArea 2
- RoleStore manager
Sales
€312,480
- Target
- €308,900
- Achievement
- 101.2%
- Sales rank
- 5 / 28
- Sales points
- 304 / 300
- Championship KPIs
- Sales and margin
- Accessories %21.4%
- Target
- 24.0%
- Achievement
- 89.2%
- Rank
- 22 / 28
- Points
- 89 / 100
- Indicator A1.1%
- Target
- 1.5%
- Achievement
- 136.4%
- Rank
- 3 / 28
- Points
- 120 / 100
- Indicator B5.2%
- Target
- 5.5%
- Achievement
- 94.5%
- Rank
- 14 / 28
- Points
- 95 / 100
- Indicator C3.58
- Target
- 3.50
- Achievement
- 102.3%
- Rank
- 9 / 28
- Points
- 102 / 100
- Indicator D90
- Target
- 90
- Achievement
- 100.0%
- Rank
- 13 / 28
- Points
- 100 / 100
- Indicator E24.0
- Target
- 25.0
- Achievement
- 96.0%
- Rank
- 11 / 28
- Points
- 96 / 100
The problem
Plaisio runs an internal “Store Championship”: each store and each role earns points according to how well it meets its targets, and is ranked against the rest.
Tracking was done in spreadsheets. The numbers came from six different systems, and a store manager found out their position with a delay.
There was no ready template to follow. It was the first time something like this was attempted, so the real needs surfaced along the way, and the scope grew with them.
What we built
It is not a simple dashboard. It is an internal application that scores and ranks performance across the whole network, with every number drawn from more than 20 million rows of data.
- Data from six systems in one model. It is fed directly from SAP and brings together sales, targets, stores and staff.
- A championship for each role. Store managers, department managers, specialists, sales staff and cashiers each have their own screen and their own indicators.
- A personal message for every user. On opening the screen, a store manager reads which position their store is in and how many points they need to move up to the next one.
- Every indicator down to the last detail. Each one shows the target, the achievement, the rank among the 28 stores and the points it earns: sales, margin, accessories and the other championship indicators.
- Scoring that calculates itself. Target allocation, points and rankings are computed automatically, and the position is compared with the previous month.
- Everyone sees only what concerns them. Access is defined by role, store and date.
- Documentation inside the tool. Every calculation is explained on a separate page.
The scale
| 20M+ | rows of data |
| 639 | calculations |
| 69 | data tables |
| 675 | charts and elements across 14 pages |
| 5 | staff roles |
| 28 | stores |
The work took eight months, from November 2025 to July 2026.
The outcome
The system is in production and in daily use across the store network. All 28 store managers use it, along with department managers and cashiers.
Where the picture used to arrive by spreadsheet, everyone now sees their numbers and their store’s position right away.