Service · Data and analytics

Data warehouse

The case for a warehouse is strongest when numbers are scattered over many tools and a colleague spends days each month gluing spreadsheets. Comarch ERP, Symfonia and the Allegro seller panel all stay in place; the warehouse pulls data from them, harmonises it and stores it in one location, which Power BI or Looker Studio reports then read from. Sales, finance and marketing finally look at identical numbers.

1 database
behind every report
EU region
chosen for the warehouse
History
kept month after month
Nightly
automatic loading

Included in this service

We design the model only after listing the questions to answer and the audience for each report.

Talk the scope through with an engineer

Business questions

The purpose of each report, its readers and the decision it feeds. The list of questions from the board is our starting point.

Data sources

Comarch ERP Optima or XL, Symfonia, enova365, Subiekt nexo, the Allegro API, BaseLinker, a WooCommerce, Shoper or PrestaShop store, Google Ads, GA4 and the handful of spreadsheets that genuinely matter.

EU platform

Azure SQL, Microsoft Fabric or BigQuery in a chosen EU region. Access runs through Entra ID or Google Workspace accounts.

Shared model

Customer, product and sales channel are linked across systems, so an Allegro order and its ERP invoice join up as one transaction.

True cost of sale

Marketplace commission, Allegro Ads spend, delivery costs and returns are set against revenue, giving you a margin you can trust.

Reports and permissions

Power BI or Looker Studio dashboards with access by department and role, readable on a phone too.

How we work together

We give a date for report one after reviewing the data sources. Each subsequent report is quicker, building on work already done.

01

Choosing report one

We start with whichever report costs the most manual effort today, most often sales and margin by channel.

02

Design

Schema, cross-system linking of customer and item identities, plus a timetable for data loads.

03

Build and reconcile

Loads are built, the dashboard follows, and its totals are checked line by line against what finance has been producing manually. Differences are explained one at a time.

04

Further areas

Stock, receivables, marketing. Each new report is added onto the existing model.

Revenue on Allegro is easy to count; margin is far harder. The seller panel shows sales, but commission, promotion fees, Allegro Ads campaigns, shipping and returns are billed separately and often land in a different month. Only when they are matched with purchase prices from the ERP can you see which listings genuinely make money and which merely inflate turnover.

Questions and answers

Licence and cloud costs depend on how many people view reports and how much data there is. We check current vendor prices and include them in the estimate before we start. The build is priced as a fixed fee or at PLN 190/hour excl. VAT.

Yes, and we encourage it. You receive a documented data model, and one or two people on your team get short training in Power BI or Looker Studio. We can keep watching over the loading jobs and source-system changes under an ongoing support contract.

This is one of the warehouse’s strengths. Reports read from its model, not directly from the source, so a migration only means swapping the loader for one system. History from before the switch stays in the warehouse, and year-on-year comparisons still work.

Board-level reporting is fine with an overnight load. More frequent loads cost more and put strain on source systems. Stock levels and marketplace orders are the usual exception, and we refresh those hourly or faster when the business case justifies it.

Bring your figures together

List the reports someone still assembles manually and the systems behind them. Report one will be built and checked against your existing spreadsheet totals.

Hours
Mon-Fri 8:00-18:00 CET, reply within one working day
Meetings
Online via Teams or Google Meet

We set strictly necessary cookies only: they keep the site running and remember the city you chose. Nothing here is used for advertising or tracking. More in our privacy policy.