Categories: Azure

Free Webinar – Build a data warehouse on Azure Data Platform for $150

I’m presenting a free webinar at MSSQLTips.com at Thursday, July 10, 2025 at 6PM UTC (8PM CET or 2PM EDT). The abstract:

When you watch some conference sessions, or read some blog posts, it always seems like everyone is drowning in petabytes of (streaming) data. They’re proclaiming you need the fastest, best, most scalable, distributed shared-nothing (or everything?) multi-parallel system that can also get coffee.
But guess what?

  • Not every company has to deal with a scale that businesses like Google, Amazon, or Tiktok have to deal with.
  • Not every company needs streaming data with Kafka, Spark Streaming or Event Hubs.
  • Not every company has complex unstructured data that you need to deal with in a data lake with tools like Databricks.

Some companies have just a couple of gigabytes of data (or even less). Maybe a terabyte if we’re pushing it. They don’t need fancy streaming real-time dashboards, they just want to analyze their financial and sales data. It’s ok if it just runs once a day. Their source systems are regular databases, maybe some Excel files and a SharePoint list. In this session, you’re going to learn how you can build a data analytics platform in Azure that is dirt cheap.
We’re going to cover the following technologies and patterns:

  • Cheap ingestion with Azure Data Factory using a metadata-driven framework, in combination with Azure Logic Apps and Azure Functions
  • A data warehouse implementation in Azure SQL Database. We’ll cover design best practices and scaling options.
  • A Power BI model for presenting the data to the end users

In each section, we’ll look at how costs can be contained. After all, we want a data warehouse which doesn’t cost more than $150 per month!
Note: it’s assumed you have basic knowledge of Azure Data Factory, databases and SQL.

As you might learn from the abstract, the session is aimed at people working with “small data”. Just a couple of gigabytes, biggest table is below 100 million rows. But you would be surprised how many companies actually fall into this category 🙂
You can register here. I hope to see you there!


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Recent Posts

Power BI PBIR Format Admin Setting

The Power BI Enhanced Report Format (PBIR) will soon become the default, and that's a…

3 days ago

Logged in as a member of an Azure AD Group Error while Deploying DACPAC

Quite a long title for a short blog post :)While deploying a DACPAC (from a…

7 days ago

Export a Power BI Report that cannot be Downloaded

Yes, you're reading that right, we're going to download a report that cannot be downloaded.…

2 weeks ago

dataMinds Connect 2025 – Slides & Scripts

You can find all the session materials for the presentation "Indexing for Dummies" that was…

1 month ago

Cloud Data Driven User Group 2025 – Slides & Scripts

The slidedeck and the SQL scripts for the session Indexing for Dummies can be found…

2 months ago

Retro Data 2025 – Slidedeck

You can find the slides of my session on the €100 DWH in Azure on…

2 months ago