A data warehouse is one store that holds a reconciled copy of the figures from every system you run — sales, jobs, stock, accounts — matched, kept with their history, and read by every report, dashboard and spreadsheet in the business. It is for businesses whose systems each tell a different story. Ozwebnet builds data warehouses from scratch in Adelaide, South Australia, for businesses across Australia: one fixed quote staged against milestones, and the source code handed over with the IP assigned to you.
DETAIL OF SHEET 06 — DATA PLATFORMS →
A data warehouse is a database of your own that holds a copy of the figures from every system you run, pulled on a schedule and kept in one shape. Reconciled means the copies have been matched — the customer in Xero is the same customer as the one in simPRO and on the till — and the differences resolved by a rule you agreed, once, in writing. The store keeps every figure with its date, so last month's numbers still read the same next year. Dashboards, reports, Excel and your accountant all read from this one copy.
Each system you run is listed with what it holds — customers, products, jobs, invoices, stock — and for each kind of record, which system's version wins when two disagree. This is agreed before any figure is copied.
Figures are read from Xero, MYOB, simPRO, ServiceM8, Cin7, your point of sale or your own database on the schedule you set — nightly, hourly, whatever each figure needs. The warehouse only reads; nothing in the source is changed and nothing is re-entered.
The same customer is spelt one way in accounts, another on the job board, and is a number at the till. The rules that join them into one record are written down, applied the same way on every load, and anything that will not match is listed for a person to decide.
The store holds each figure as it stood on each date. An invoice edited in June still reads as it did in the May report, and a price changed today does not rewrite last year's sales.
Every row carries the system it was read from, the record it came from and the time it landed, so any number on any report can be traced to its source in one step.
Row counts and totals are compared with the source system each time figures land. A load that fails, a gap in the schedule or a total that has drifted is reported to someone straight away, rather than left for a wrong report to find.
The warehouse is a standard database, not a locked product. Your dashboards read from it, and so can Excel, Power BI, a scheduled report or your accountant's own query; you receive the source code with the IP assigned to you.
TYPICAL SCOPE FOR THIS KIND OF SYSTEM — YOUR EXACT SCOPE IS FIXED IN WRITING AT THE SPECIFICATION STAGE.
Not sure which? Ten minutes on 1300 699 321 tells you — Mon–Fri 9–5 ACST.
One fixed quote, set in writing at the specification stage (02 Blueprint) and staged against the five milestones below. Each milestone ends with a working system; stop at any milestone and keep what has been built.
SEE THE FIVE STAGES ANIMATED →We list every system that holds a figure, what each one calls a customer, a job and a sale, and where the totals disagree today.
Which system is the authority for each customer, job and sale, the rules that match them and the schedule each load runs on are written into the specification; the fixed quote is set here, staged against milestones.
Each source is loaded and matched in turn, so at every milestone there is a store you can query and figures you can check, not only at the end.
Every total in the store is reconciled back to the system it was read from, and the loads are run on the live schedule before launch.
The scheduled loads are switched on, your reports and spreadsheets are pointed at the store, and you receive the source code with the IP assigned to you.
Usually not. If one system holds your figures and its reports agree, dashboards can read it directly. A warehouse earns its place when two or more systems each hold a version of the same customer, job or sale and the totals disagree — and we will say so either way.
No. The warehouse only reads from your systems, on a schedule you set; nothing in the source is changed and nothing is re-entered.
One fixed quote, set in writing before the build and staged against milestones.
Yes — source code delivered, IP assigned to you. It is a standard database, so Excel, Power BI or any reporting tool can read it as well as the dashboards we build.
Yes — Adelaide first, Australia-wide. The warehouse is written in Adelaide and reads from your systems wherever your office is.
Call, or answer a few short questions — what you run, what breaks, when you need it working — and we reply within one business day. The quote is fixed in writing before any build starts.
