Retail sales network

One source of data for a nationwide sales network

SAP, SQL, SharePoint and marketing in one model, with email reports several times a day.

Fresh reports several times a day

Talk about an implementation at your company

The situation before

Reporting relied almost entirely on sprawling Excel files. Separate spreadsheets were built for data from SAP, SQL databases, files on SharePoint and marketing sources.

Over time several versions of the same reports began to circulate in the company. Departments used their own copies of files with different data, formulas and metric definitions.

People wasted time working out which version of a report was current, instead of analysing results and making decisions.

What we did

We built a central reporting system based on Power BI and a shared data model. We integrated the sources: SAP, SQL databases, SharePoint, Google Analytics, BigQuery and marketing tools.

Data is pulled, transformed and combined automatically in a single model. Every report uses the same definitions of sales, margin and plan completion.

People receive scheduled email reports several times a day, and at the same time they can explore results on their own by region, store, product or channel. Access control means a regional manager sees only their area, while the board sees everything.

See the result

From the situation before to a finished solution.

Raw data in a spreadsheet before it was organised — Before: data scattered across spreadsheets, each department with its own version.

Architecture integrating many sources into one model — Integration of sources (SAP, SQL, SharePoint, marketing) into one data model.

Retail network sales report with a store ranking — Result: sales, margin and profit by category and store, with year-over-year change.

We changed company names and the data in the screenshots to protect client confidentiality (NOVARA, FlowWarehouse and Red Dragon are demonstration names). The graphics show a real type of report or app, not a specific client.

Results

What changed.

One consistent source of data for sales, operations and marketing.
Automatic distribution of reports by email several times a day.
The end of the many-versions-of-one-spreadsheet problem.
Identical KPI values across all reports, down to the decimal.
Secure access matched to role and region.

Talk about an implementation

Your company

Have a similar problem?

Leave your contact details and we'll get back to you within 24h. We'll check what can be put in order at your company. No obligations.

Roughly: we start with an audit for PLN 2,000, the first system is ready in about a month, implementation from PLN 6,000. After handover you'll maintain the report yourself, and we stay in touch.

See another industry Logistics

Book a free consultation

Prefer to pick a time right away? Book a call in the online calendar.

Pick a time that suits you

or leave your contact

Leave your contact and we'll get back to confirm a slot. No obligations.