Service · Data and analytics

Data warehouse

A data warehouse earns its keep when figures live in several systems and someone spends days each month stitching them together in Excel. It does not replace e-conomic, Business Central or your online shop. It collects data from them into one shared picture that Power BI can present.

Send an enquiry See the scope

One source

for every report

EU region

data stays in Europe

History

kept over time

Nightly

automatic refresh

What the service covers

We start from the questions management wants answered. The data model is designed only once the list of reports is agreed.

Talk it through with us

Questions before tables

What each report must answer, who reads it and which decisions depend on it.

Sources

Your finance system via its API, a Shopify or WooCommerce shop, the CRM, Google Analytics 4 and those spreadsheets nobody can live without.

Platform in the EU

Azure SQL or Microsoft Fabric in a European region, so personal data stays inside the EU and access is governed through Entra ID.

Shared data model

Customers, products and departments are matched across systems so a customer is only counted once.

Automated loading

Data is pulled overnight, keeping the load off source systems while staff are at work.

Power BI

Reports and dashboards with permissions per department, so each manager sees their own numbers.

How we deliver it

The first report is usually ready within four to six weeks. Later ones are faster because the foundation is already in place.

Pick the first report

We start with the two reports that currently eat the most hours of manual work.

Design

Data model, matching of customers and products between systems and a fixed refresh schedule.

Build and reconcile

Loading, the report itself and a reconciliation against the figure finance has so far calculated by hand.

Extend

New reports are added on the same foundation as needs arise.

The first test is whether the number matches the old spreadsheet. If the report is even slightly off, people quietly keep their own files. So we always reconcile against the previous calculation and explain every difference before the report is shared across the business.

Common questions

Built-in reports only see the system's own data. Once sales need to be viewed alongside web traffic, campaigns or CRM leads, they fall short. Heavy queries against the live database can also slow the system down for everyone.

Many organisations manage with Power BI Pro for the people who view reports and a small Azure SQL database. Fabric capacity becomes relevant with larger data volumes or many readers. We cost both options before you choose, and build hours are billed as agreed or at DKK 895 per hour excl. VAT.

For management reporting one overnight refresh is usually enough. Near real-time loading costs more and puts pressure on source systems. Begin with a daily cycle and increase frequency only where there is a genuine need, such as stock levels in an online shop.

Related services

View the whole area

Service Master data management One version of every customer, supplier and item Service Intelligent document processing PDF invoices and delivery notes captured automatically

Build your data warehouse

List the reports that are assembled by hand today and the systems the figures come from. We will build the first one and reconcile it with your own calculation.

Email
office@apply.dk

Coverage
All of Denmark, delivered remotely

I agree that Apply may handle my details as set out in the privacy policy