- Import files, clean and transform with AI, explore with charts, and export polished results — all in one open‑source, local‑first app built with Blazor.
✨ What you can do
- Import your data from CSV/Excel and other common formats.
- Ask questions in plain English. Personal Data Warehouse writes the code for you.
- Clean & transform: join, filter, sort, compute new columns, and fix messy data.
- Visualize with clear charts and quick summaries.
- Export results back to files or SQL server or Fabric Warehouse.
Click here to download and install it from the Microsoft Store
Run this command in your terminal: winget install "Personal Data Warehouse"
Build Your Own Free Personal Data Warehouse with AI & Blazor Hybrid – No Cloud Needed
Click here for YouTube videos / Click here for the Quick-Start Tutorial
Some people make a lot of promises about AI, often claiming it can do things it cannot, such as predicting the future. What AI is truly good at is calculating. This application allows you to import your data, transform it using AI to perform calculations, and report and export the results.
This application enables you to create your own Personal Data Warehouse by:
- Importing your data from Excel, SQL Server, and Microsoft Fabric Warehouse
- Feeding the structure of your data, as well as your data questions and transformations, to the AI of your choice, either in the cloud or running on your local computer
Typically, a data warehouse operates in the cloud. When you access your data—even just to view it—you incur compute costs (in other words, you pay). But you already have a computer with a CPU and memory capable of handling most tasks. Wouldn’t it be great to view, edit, and transform your data right on your own machine? Now you can!
This tool allows you to:
- Import data from sources such as:
- Excel
- CSV
- Parquet
- SQL Server
- Fabric Warehouse
- Transform data using AI-powered features.
- Python
- C#
- Export data back to any of the supported formats:
- Excel
- CSV
- Parquet
- SQL Server
- Fabric Warehouse
By doing the compute locally on your own computer, you avoid expensive cloud compute costs while enjoying the flexibility and control of your own system.
QuickStart.mp4
SizzleReelOne.mp4
🙌 Credits
Created and maintained by Michael Washington. Built with Blazor and the .NET platform.
- BlazorDatasheet
- Blazored.LocalStorage
- Blazored.TextEditor
- ClosedXML
- CS-Script
- CsvHelper
- ExcelDataReader
- KustoLoco.Core
- Microsoft.Extensions.AI
- Parquet.Net
- Pyodide
- Radzen.Blazor
- ReportViewerCore.NETCore
- SimpleBlazorMonaco
- SSH.NET
- System.Linq.Dynamic.Core
Contact: [email protected]