Build Your Own Free Personal Data Warehouse with AI & Blazor Hybrid & No Cloud Needed!

Tired of paying for cloud compute just to view your own data? Discover how to build a completely free, open-source personal data warehouse that runs entirely on your machine using Blazor Hybrid and .NET technologies.

In this talk, Microsoft MVP Michael Washington shows how to: – Import data from Excel, CSV, SQL Server, and Microsoft Fabric – Use AI-powered Python/C# code for advanced data transformations – Generate SSRS-style reports – no cloud required – Leverage local compute power to avoid cloud costs Whether you’re a developer, analyst, or data enthusiast, this session will help you take full control of your data with zero hosting fees. Live demos included!

Timestamps

• 0:00 Introduction – Why a Personal Data Warehouse?
• 1:09 Agenda Overview
• 1:57 Understanding the Purpose of Data
• 3:47 Collection, Transformation, and Exporting Explained
• 6:04 Real-Life Data Journey Example
• 10:03 What is the Personal Data Warehouse?
• 10:51 Installation Options (GitHub, Store, WinGet)
• 11:59 Configuring AI & Database Structure
• 13:13 Importing Data from Excel or SQL
• 14:04 Creating Views and AI-Powered Transformations
• 17:13 Why LLMs Should Write Code, Not Calculate
• 18:52 Creating SSRS Reports from Live Data
• 20:01 AI-Assisted Report Editing
• 21:13 Advanced Transformations with JSON Output
• 22:42 Quick Demo: Installing & Using the App
• 25:01 Why Local Transformations Beat Cloud Costs
• 27:19 Exporting & Editing Data in External Databases
• 28:53 Data Visualizations with KQL
• 30:06 Building SSRS Reports with Report Builder
• 33:26 Diving Into the Code: Transformations in C# & Python
• 39:19 How AI Prompts Power Custom Transformations
• 42:33 Generating & Editing Reports Programmatically
• 45:00 Enabling Live Previews in Microsoft Report Builder
• 47:11 Final Thoughts & Community Support