Services Data warehousing and modelling

Want one number everyone agrees on?

We design the warehouse and data models behind your reports, so finance, sales and operations work from the same figures.

0Hours back a week
$0Worth a year
0%Of one full-time week
0Jobs taken off your plate

Proof

Over 15 years building systems and workflow automation that works.

5 hours a weekback on reporting at the Art Gallery of NSW, with automated reporting across multiple data sources.
One clear viewof performance across the organisation at Sydney Metro, tracked against the metrics that matter.
Manual to dailyat Velocity Frequent Flyer: insights every day, without the manual processes and legacy tools.
Over two yearsbuilding the reporting Macquarie's operational and executive teams depend on, in their Associate Director's words.
Fabricio Cardoso

About the founder

Fabricio Cardoso

  • Over 15 years: building systems companies trust
  • Experienced in: data platforms, reporting and BI for finance, sales and marketing, turning complex requirements into simple solutions people use
  • Delivered for: Macquarie, Channel Nine, Velocity Frequent Flyer, Sydney Metro, Art Gallery of NSW and ESR

Trusted. In their words.

“Fab has been instrumental in modernising and automating our reporting.”

Client review
Mandy ProwseResearch & Insights Manager, Art Gallery of NSW

“I would recommend any organisation to look into data management and analytics with Fabricio. An investment that will pay dividends.”

Client review
Sarah TanData Centre Site Acquisition & Development, APAC, ESR / AETED

“Any organisation looking for a high-performing data and analytics professional would be fortunate to have him on their team.”

Recommendation
Laila MasriAssociate Director, Macquarie

“Fab has been instrumental in modernising and automating our reporting.”

Client review
Mandy ProwseResearch & Insights Manager, Art Gallery of NSW

“I would recommend any organisation to look into data management and analytics with Fabricio. An investment that will pay dividends.”

Client review
Sarah TanData Centre Site Acquisition & Development, APAC, ESR / AETED

“Any organisation looking for a high-performing data and analytics professional would be fortunate to have him on their team.”

Recommendation
Laila MasriAssociate Director, Macquarie

“Working with Fab Solutions transformed how we approach data across our organisation.”

Client review
Sydney MetroEnterprise client, Sydney Metro

“We can now access actionable insights on a daily basis without labouring through manual processes and legacy tools.”

Client review
Velocity Frequent FlyerEnterprise client, Velocity Frequent Flyer

“Working with Fab Solutions transformed how we approach data across our organisation.”

Client review
Sydney MetroEnterprise client, Sydney Metro

“We can now access actionable insights on a daily basis without labouring through manual processes and legacy tools.”

Client review
Velocity Frequent FlyerEnterprise client, Velocity Frequent Flyer

What we take off your plate

The data jobs that repeat every week. Almost instant once it is built.

JobTodayWith FDXBack a week
Whose number is rightTwo reports, two answers. Reconciled once in the model, so the argument stops.3 h a week3 a week x 60 minAlmost instant1.7 h
Rebuilding report queriesThe same joins rewritten in every report, built once in the warehouse instead.3 h a week4 a week x 45 minAlmost instant1.6 h
Last year comparisonsHistory kept properly, so comparing with last year is a filter, not a project.3 h a week2 a week x 90 minAlmost instant1.5 h
Where is this data?Questions about which table or measure to use, answered by a plain data dictionary.2.5 h a week15 a week x 10 minAlmost instant1.5 h
More details

How we worked it out: the jobs a week, minutes before and after, 80% of them using it, less the upkeep, valued at $115,000 a year per person fully loaded. A person still checks the result, so we count a few minutes for that. Your audit swaps in your real numbers. A person signs off every business definition, like revenue or an active customer, before it goes live.

Time back every week0.0 hoursWorth $0 a year, at $115,000 a year per person fully loaded
0%of one full-time week
  • Whose number is right1.7 h (27%)
  • Rebuilding report queries1.6 h (25%)
  • Last year comparisons1.5 h (24%)
  • Where is this data?1.5 h (24%)
Whose number is right3 a week
Today60 min each
With FDX5 min each

3 x 80% = 2.4 a week, x 55 minutes saved = 132 minutes, less 30 of upkeep = 1.7 hours a week

Rebuilding report queries4 a week
Today45 min each
With FDX5 min each

4 x 80% = 3.2 a week, x 40 minutes saved = 128 minutes, less 30 of upkeep = 1.6 hours a week

Last year comparisons2 a week
Today90 min each
With FDX15 min each

2 x 80% = 1.6 a week, x 75 minutes saved = 120 minutes, less 30 of upkeep = 1.5 hours a week

Where is this data?15 a week
Today10 min each
With FDX1 min each

15 x 80% = 12 a week, x 9 minutes saved = 108 minutes, less 20 of upkeep = 1.5 hours a week

How we build it

Data warehousing and modelling, on the tools you already run.

  • Warehouse design. Dimensional models and star schemas that reports can query quickly.
  • Medallion architecture. Raw, cleaned and business-ready layers, so you can always trace a number back to its source.
  • History that is kept. Changes over time tracked properly, so last year's report still adds up.
  • Performance tuning. Faster queries and refreshes on the platform you already pay for.
  • Documentation. A plain description of every table and measure, so new people can find their way.
SQL ServerAzure SQLSnowflakeDatabricksdbtMicrosoft Fabric

Want one number everyone agrees on?

Eight quick questions, a plan in under a minute, and the full version in your inbox.

See your free audit previewor book a 30-minute call