BlazorData.com
I love AI. I use it every day. But I'm going to say something that would get me escorted out of most venture capital offices: the only place AI has truly delivered productivity is in creating tools, specifically, in coding. Before you fire up your keyboard to disagree, let's first agree on what productivity actually means. Because that word gets thrown around a lot, usually right before someone…
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…
See the video at: Personal Data Warehouse: QuickStart This tutorial demonstrates how to import multiple Excel files into the Personal Data Warehouse , join the data using a view , and create a report . To begin, download and save the following sample files: AcmeCustomers.xlsx AcmeSales.xlsx Create the Database Note: For installation and upgrade details, see Installing and Upgrading . It's…
BlazorData.Net aims to provide tools that empower users to import, export, manipulate, and present data effectively. At first glance, the concept of data might seem obvious, but understanding it thoroughly is essential to grasp why these tools are needed and how they are used. Data Is Not the Thing – The Thing Is the Thing The most important concept to understand is that data is not a "thing"—it…
BlazorData.net made a recent contribution to a Github project that contains code that will be incorporated into a future version on BlazorData.net . The Github project is kusto-loco and it provides an API that allows you to use Kusto Query Language (KQL) to create visualizations. However, KQL can be hard to learn, so the contribution that BlazorData.net made was to incorporate OpenAI to help you…
Using the Blazor DataSheet allows you to easily view and update data in your Microsoft Fabric Warehouse . Creating Forms is the biggest cost in an application Creating forms is often one of the most time-consuming and costly parts of building an application, but utilizing a Blazor DataSheet can significantly reduce both. By allowing users to view and update data directly within a flexible,…
To import data efficiently into Microsoft Fabric you want to use parquet files. You can leverage C# and Microsoft Blazor for a streamlined process. By utilizing the powerful Parquet.Net library in C# , you can quickly write parquet files, enabling you to handle large datasets with ease. This approach not only speeds up data import but also enhances the scalability and performance of your import…
You can access the data in your Microsoft Fabric Warehouses using the SQL endpoint . This allows you to import , query and update the data using tools such as SQL Server Management Studio and applications such as Microsoft Blazor . What is Microsoft Fabric Microsoft Fabric is an end-to-end analytics and data platform designed to unify various data-related tasks into a single, cohesive solution. It…
Most business applications involve viewing, updating, and deleting data. To facilitate these actions developers using spend a lot of time and money creating forms. In this blog post, we’ll explore how to use an Excel-like data editor control within a Blazor application, to update a SQL database, eliminating the need to create forms. The Application Download the application from:…