The traditional modern Data Warehouse
2022TL; DR
This session will go through and show you how to setup a very simple ETL framework based on Data Factory, Data Lake, SQL DB and Power BI. All code will be made available for you to download and use!
Session Details
Big data, Databricks and now also Synapse Analytics. Microsoft really focuses on how to put together BI and DWH solutions that can handle huge volumes of data. But what about the "ordinary" solutions in the SME market? How do we put together a sensible and affordable Azure solution for them? Where we can reuse the competencies we have already built from making the same solutions on SQL Server.
This session will go through and show you how to setup a very simple ETL framework based on Data Factory, Data Lake, SQL DB and Power BI. All code will be made available for you to download and use!
3 things you'll get out of this session
Speakers
Just Blindbæk's other proposed sessions for 2026
Advanced Semantic Model development with Tabular Editor - 2026
Building a Unified Semantic Model - The 20-Minute Pattern - 2026
Choosing the Right Storage Mode: Import, Direct Lake, DirectQuery & Hybrid - 2026
Deep Dive: Mastering Semantic Model Size & Refresh Efficiency in Fabric Capacities - 2026
Deep Dive: Mastering Semantic Model Size & Refresh Efficiency in Fabric Capacities - 2026
Demystifying the Data Lakehouse in Microsoft Fabric - 2026
Mastering Spark Notebooks and Capacity Optimization in Microsoft Fabric - 2026
Panel Debate: Real-World Microsoft Fabric Administration - Lessons from the Trenches - 2026
Unified Semantic Models & KPI Reporting: Architecture That Scales - 2026
Just Blindbæk's previous sessions
Mastering Fabric: Workspace Governance and Organization
Learn how to optimize and master workspace organization in Fabric. Explore best practices for effective governance, enhancing user experience, security, and permissions management. Gain practical insights and checklists for streamlined workspace management.
The Hitchhiker's Guide to navigating Power BI
Learn to navigate Power BI seamlessly in this concise session. Explore key areas: Internal Report navigation, App transitions, and Web Portal optimization. Elevate user experience with insights on service navigation, integration, and essential tools like Drill Through, Buttons, and Bookmarks.
Architectural blueprints for the Modern Data Warehouse
This session will walk you through three different ways to set up an affordable Azure based Data Warehouse solution. Covering pros and cons with each of the architectures.
Power BI: From Self-Service to Enterprise
How do you master to grow a Power BI solution from self-service to something that is scalable, managed and governed? A solution that can be trusted and used in the whole enterprise! Make a successful ownership transfer!
Excel Services 2013-the BI frontend of the future
The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective.
(1) Overview of the publish options
(2) How to control the layout
(3) Tips & Trick from real world examples