Corelly
Book a Call
Book a Call
Back to services

Data Warehousing

I build and analyse data warehouses so a report over millions of rows takes seconds rather than minutes.

What is included

  • Dimensional model design
  • ETL and ELT pipelines
  • Automated data loading
  • Analytical query optimisation
  • Data quality checks
  • A reporting layer

What you get

  • A working warehouse with load pipelines
  • Data models ready for reporting
  • Pipeline documentation
  • Quality monitoring

Tech stack

BigQuerySnowflakedbtAirflowSQL

Who it is for

For organisations with data spread across many systems that need a single source of truth.

What you can come to me with

You do not need to know what it is called. If something on this list sounds like your situation, it is work for me.

  • A single source of truth

    Data from several systems in one place, counted the same way.

  • A dimensional model

    A structure where a report takes seconds.

  • ETL pipelines

    Automatic fetching, cleaning and loading of data.

  • Making systems agree

    Shop, stock, accounting and CRM stop arguing about numbers.

  • History of changes

    Not only today's state, but how it looked six months ago.

  • Data quality checks

    A signal when data did not arrive or arrived strange.

  • A reporting layer

    Ready tables that Power BI reads without workarounds.

  • Speeding up an existing warehouse

    A report that takes 20 minutes should take seconds.

  • A move to the cloud

    From the server under the desk to BigQuery or Snowflake.

  • Documentation of the flows

    Where every number comes from and what recalculated it.

What it looks like inside

A preview of what gets built. Not a screenshot of somebody else's system, just a mock-up, so we both know what we are talking about.

An illustrative view. Yours will look different, because it gets built around your data and the way you work.

Other services

  1. 01

    Web Development

    Websites and web apps

    Modern websites and web apps in React, Next.js and TypeScript. Responsive, fast and beautiful.

  2. 02

    Management Systems

    Custom business systems

    Custom systems for managing your business, land, stables, tailored to your workflow.

  3. 03

    Databases

    Design, migration, optimisation

    Database design and optimization. SQL Server (SSMS), stored procedures, T-SQL: a solid foundation for your app.

  4. 04

    Data Analysis

    Reports and dashboards

    Reports, dashboards and analyses that turn raw data into business decisions. Python, SQL, visualisations.

  5. 06

    AI Solutions

    Models and automation

    Integrating artificial intelligence and machine learning into business applications.

Let us talk about your project

Tell me what you want to achieve. I will come back within 24 hours with a first assessment and a suggested next step.

Book a call