Blog about Microsoft Data Platform and Azure cloud. #SQLServer #PowerBI #Azure #New
Power BI is a great platform that helps companies understand their data. However, it’s easy to make mistakes when using it. In this article, I will show six common mistakes made by Power BI developers, and most importantly, how to avoid them. Let’s get started! Skipping Documentation and Code Comments Alright, folks, here’s a mistake […]
Today I would like to write few words about one of the most important techniques used to improve performance in your Lakehouse – two specific keywords: OPTIMIZE and ZORDER. Let’s start by introducing those two terms. The OPTIMIZE command in Delta Lake helps tidy up how data files are stored in a Delta table. It […]
In my latest post, I wrote a few words about the warehouses available within Fabric. Today, I would like to show you an end-to-end analytical scenario with the second most important item available on the platform, which is the Lakehouse. Microsoft’s Fabric Lakehouse serves as a cutting-edge data architecture platform that consolidates the storage, management, […]
One of the key components of Microsoft Fabric is Synapse Data Warehouse. This entity within the Fabric is specifically designed to facilitate the storage of data within the OneLake concept. It provides a seamless interface for interacting with the data through TSQL commands. If you were to consider Synapse SQL pools, such as Dedicated SQL […]
Subscribe to be up to date with new articles!
#sql #powerbi #data #azure
Last comments