This Article is co-authored by Khaled Chowdhury and Lance Rubin, Mr. Excel, and the

How do you get benefits out of it? Remember Two things: Action, get started todays.

A twenty-nine-year-old newly minted FP&A manager for an NYSE listed public company sat in utter

Power BI is a business intelligence and data visualization tool developed by Microsoft.

Welcome to the cutting edge of data management—Microsoft Fabric is here to redefine how we interact with data ecosystems. In a landscape where information is currency, having the right tools to navigate and utilize data is paramount. But what makes Microsoft Fabric not just another platform in the market, but a revolutionary force? Let’s unwrap […]

In self-service BI tools, having column names that are user-friendly is crucial for creating an environment that is easy for business users to navigate. The use of whitespace is significant in these instances, as it helps maintain the simplicity and user-friendliness of reports and dashboards. Power BI semantic models and dataflows support column names with […]

Microsoft Fabric features two storage-compute platforms for batch data processing, namely Lakehouse and Warehouse, which offer the capability to store and query data for use in other components. These elements are seamlessly integrated with other parts of the Fabric, serving as central hubs for data storage. These storage systems are aimed for different use cases […]

Microsoft Fabric’s Lakehouse platform use Delta Lake for its tables, an open-source format that enables versioning and ACID capabilities to Lakehouse. Since storage forms the most important part of a data architecture, it is essential to understand the practices that could improve performance and reduce costs. This blog aims to explain the concept of Delta […]

Microsoft Fabric has multiple experiences such as Data Engineering and Data science that provides options to analyze data and build insights. The Data Activator experience is one that majorly differs from others, as it allows us to automate actions based on the insights derived from the data. Data activator continuously monitors data from sources such […]

Microsoft Fabric offers a robust platform for modern data management, enabling streamlined processing and advanced analytics. Data Pipelines, one of the tools, allow for automated extract, transform, and load processes, essential for ingesting transactional data into analytical data stores. Data pipeline is similar to Azure Data Factory/Synapse pipelines. You can create pipelines by using multiple […]

Microsoft Fabric was introduced almost a year ago and the certification associated with it was released during Jan 2024. It was in beta for 2 months and now it is generally available to be taken up. Now that the exam is available generally, let us see what you need to prepare and the things you […]

Dataflows is a collection of tables that perform data transformation in Power BI services independently. It leverages the Power Query engine with a common data model to do the required transformations and make it available for reuse by different dataflows and the Power BI semantic model (previously known as a dataset). Transformation is essential not […]

What is DBT? DBT stands for “Data Build Tool.” It is an open-source tool that analytics engineers to transform data in their warehouse easily and in a scalable manner. It is a declarative ELT framework that allows transformations to be expressed as SELECT statements and corresponding configurations in YAML files. Microsoft Fabric has a dbt […]

Microsoft Fabric is an all-in-one analytics solution for enterprises that helps you create, use, and govern data insights across your organization. In the context of Fabric, Spark integration enables developers to leverage Spark’s capabilities for big data processing within the Fabric ecosystem. Spark is a powerful open-source distributed computing framework that specializes in scalability, speed, […]

Are you writing the same SQL code repeatedly? Thinking of a way to reuse the code? If yes, then you have come to the right place! Or if you want to know about stored procedure and how to create/execute them, this article is for you as well. A stored procedure is a group of SQL […]

Data orchestration is an automated way to manage and organize data from different sources, making it ready for analysis. It’s also known as data pipeline orchestration or data workflow orchestration. This process covers many parts of data management, such as ensuring data quality, following data rules (governance), and automating various tasks. It also handles moving […]

Microsoft Dynamics 365 Finance and Operations (D365 F&O) is a critical tool for modern businesses, offering a comprehensive suite of applications to manage financials, supply chain operations, and enterprise resource planning (ERP). This powerful platform helps organizations streamline their processes, gain deeper insights through advanced analytics, and drive operational excellence. However, despite its robust capabilities, […]

Microsoft Fabric provides SQL Endpoint on Lakehouse and Warehouse through which we can run SQL queries and Stored Procedures on the stored data. Whenever we run SQL statements, they need to be authenticated by a principal so that the SQL Engine can check whether the principal is authorized to access and execute statements. But unlike […]

Advanced Dataflow Backup Strategies for Microsoft Fabric & Power BI Using PowerShell Introduction Version control is a vital aspect of managing any dynamic system, especially when it comes to data workflows. As organizations increasingly rely on Power BI for business intelligence, ensuring that your dataflows are backed up regularly and versioned correctly becomes critical.  However, […]

The Power of Partitioning: Efficient Data Management with Microsoft Fabric In today’s data-driven world, managing large datasets efficiently is crucial for maintaining performance and ensuring seamless operations. One way to achieve this is through data partitioning. In this post, we’ll explore how I handle New York taxi data spanning from 2016 to 2018 using partitioning […]

To Pie or not to Pie When it comes to visualizing data, choosing the right chart can make all the difference. The right visual not only makes your data easy to understand but also helps convey the insights more effectively. In this article, we’ll explore when to use pie charts and when to opt for […]