SQLBlog Nederland Business Intelligence & Datawarehousing

Two weeks ago, Microsoft introduced a revolutionary data and analytics platform named Microsoft Fabric, which experts predict will provide a significant edge over major competitors Amazon and Google in the fiercely competitive cloud market. The comprehensive Microsoft Fabric platform offers a suite of tools that empower corporate users to store, …

The cloud computing landscape has never been more competitive. Among the leading contenders in the industry are Microsoft Azure, Amazon Web Services (AWS), and Google Cloud Platform (GCP). Each platform has its unique strengths and differentiating features that appeal to a variety of businesses and users. This article aims to …

Introducing the RANK Window Function in DAX: An Overview and Example Introducing the RANK Window Function in DAX: An Overview and Example Introduction: Data Analysis Expressions (DAX) is a collection of functions, operators, and constants used in Microsoft’s Power BI, Analysis Services, and Power Pivot in Excel. Among its suite …

The enterprise Business Intelligence and IT community have been waiting with bated breath for a feature that could revolutionize the way we work with Power BI. Finally, that day has arrived – Power BI CI/CD DevOps solutions are now available in Preview form for testing and prototyping​. This new addition …

Microsoft Fabric has unveiled its new tool, Data Factory, which is designed to meet the increasingly complex data integration needs of businesses undergoing digital transformation. The tool brings together the best of Power Query and Azure Data Factory, offering a modern data integration experience that empowers both data and business …

In the world of data management, there are several data storage and processing models that organizations use to handle their ever-growing data needs. Three of these models, which have risen to prominence over the past few years, are data warehouses, data lakes, and more recently, data lakehouses. Each of these …

In the world of data visualization and business intelligence, Microsoft Power BI continues to evolve and introduce powerful new features that enhance data reporting and analysis. One of the standout updates in recent times is the Zebra BI Cards 1.6 update, which introduces a myriad of features that will revolutionize …

Excel, a widely used tool in the world of finance, has been the go-to platform for data analysis for decades. The formula-based structure of Excel allows analysts to manipulate, aggregate, and analyze data with relative ease. However, with the advent of more complex datasets and the need for more advanced …

Title: Advanced T-SQL Window Functions: A Comprehensive Guide with Examples Introduction Transact-SQL (T-SQL), Microsoft’s proprietary extension of the SQL language, provides a rich set of tools for managing databases on SQL Server and Azure SQL Database. Among these, window functions have gained attention due to their ability to perform complex …

Introduction SQL Server is a powerful relational database management system developed by Microsoft. It is widely used in various industries for data storage, processing, and retrieval. However, like any other system, SQL Server can sometimes consume more CPU resources than necessary, leading to slower performance and reduced efficiency. This article …

Business Intelligence (BI) is continuously evolving, with innovations and trends shaping its future. As we look forward to the rest of 2023 and beyond, several key themes emerge that will define the BI landscape. These trends include integrated systems, network advancements, data proactivity, edge computing, data marketplaces, machine learning, and …

Introduction: In today’s data-driven world, businesses of all sizes can benefit immensely from harnessing the power of business intelligence (BI) tools. While larger enterprises have long been leveraging BI solutions, small and medium-sized enterprises (SMEs) have also started recognizing the value of these tools. In this blog post, we will …

The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel is a comprehensive guide to mastering DAX (Data Analysis Expressions), Microsoft’s formula language for Power BI, Analysis Services, and Excel. The guide, co-authored by Marco Russo, a seasoned business intelligence consultant and mentor, …

Navigating the Identity Crisis in the Data Industry: Recalibrating for Success The data industry, the foundation of modern technology and business, is currently undergoing an existential crisis. This predicament springs from an incongruity between the changing landscape of the data industry and its deeply rooted, traditional practices. In other words, …

Title: Embracing the Future: Generative AI Guidelines in Power BI Introduction Artificial Intelligence (AI) has become an integral part of our daily lives, revolutionizing numerous fields, from healthcare and education to finance and technology. One of the most intriguing aspects of AI is the subset known as Generative AI. This …

Wat is een Postcodetabel? Een postcodetabel is in wezen een database van alle postcodes in een bepaald land, in dit geval Nederland. Het omvat niet alleen de postcodes zelf, maar vaak ook andere nuttige gegevens zoals straatnamen, huisnummers, coördinaten en andere relevante informatie. Deze informatie kan worden gebruikt om klantgegevens …

Microsoft’s Power BI tool has released a new feature (currently in preview) that allows users to modify existing data models directly in the Power BI service. This opens up new possibilities for users to edit relationships, create DAX measures, manage Row-Level Security (RLS), and collaborate with others on the same …

Introduction In the past few decades, businesses have been accumulating massive amounts of data from various sources like apps, services, and Internet of Things (IoT) sensors. However, unlocking the full potential of this data has always posed a challenge, with issues like data silos, inconsistency, and poor quality hampering innovation …

Title: “Power BI vs. MicroStrategy: Why Power BI Emerges as the Superior Choice” Introduction: In the ever-evolving world of business intelligence (BI), two names have prominently stood out over the years – Microsoft’s Power BI and MicroStrategy. Both these platforms offer robust BI solutions and have their unique strengths. However, …

SQL Server Disk Performance Metrics: An In-depth Guide Understanding your SQL Server’s disk performance metrics is crucial for maintaining an efficient, high-performing database. These metrics provide insights into how well your storage system is performing and where there might be bottlenecks or problems that need to be addressed. In this …

Sure, here is a draft for the blog post: 10 Common Mistakes in SQL Server Performance Optimization and How to Avoid Them Microsoft SQL Server is a powerful, robust and feature-rich relational database management system (RDBMS). Despite its capabilities, improper usage or configuration can lead to suboptimal performance. Here are …

Introduction Microsoft Power BI is a suite of business analytics tools that enables organizations to analyze data and share insights. Through its comprehensive dashboards, interactive reports, and compelling visualizations, businesses can transform raw data into meaningful information to drive strategic decisions. Industry leaders across various sectors are harnessing the power …

From Excel to Power BI: Transitioning to Advanced Analytics Over the past few decades, Excel has firmly established itself as a cornerstone of data management, manipulation, and visualization. However, in the evolving world of data analytics, tools like Microsoft Power BI have emerged as powerful alternatives, offering advanced functionalities that …

For the sixteenth consecutive year, Microsoft has been recognized as a Leader in the 2023 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms. In addition, for the fifth year running, Microsoft has been positioned furthest to the right for ‘Completeness of Vision’ and highest in the ‘Ability to Execute’ …

Making Sense of Time: An Introduction to SQL Server’s DateTime Functions When it comes to managing and manipulating data, there’s no doubt that SQL Server is one of the most popular choices. One of the reasons for its popularity is the rich set of functions it provides for a variety …