Welcome Welcome to Excel Jet Consult blog post. In this tutorial, we are going to talk about writing Inner Join SQL Query in Fabric Notebook using PySpark. Let’s get started Video   What is PySpark? PySpark is a Python API for Apache Spark which is a distributed computing framework that allows users to process large-scale data in parallel and with […]

Recently, Microsoft Excel Product team announced Checkbox in Excel. The new feature allows you to insert checkboxes in cells, and use them with conditional formatting, formulas, and more and it is currently available to users in the Beta channel as at the time of writing this blog. In this video, I will walk you through how to use the Checkboxes […]

Welcome to Excel Jet Consult blog post. In this post, I’m going to walk you through how to create advanced conditional formatting using the new rule and then use the checkboxes to turn of and on the highlighting of the rows. Let’s get started. Video Sample Data In the picture below, we’ve got a sample sales data with handful of […]

Welcome to Excel Jet Consult blog post. In this post, we will be looking at Microsoft Fabric Data Warehouse Save as Table and Analyze Result functionalities that offer several benefits to users and analyst. Benefits of Save as Table and Visualize Result Save as Table functionality allows users to save query results into a table. Users can select the warehouse […]

Introduction Welcome to Excel Jet Consult blog. Microsoft Fabric, a cloud-based data integration and analytics powerhouse, empowers users to seamlessly access, manage, and leverage data and insights from diverse sources within a unified, AI-driven platform. In this article, we are going to be focusing on the licensing and pricing for UK South and West Regions. Let’s Understanding the UK South […]

Welcome to Excel Jet Consult blog post. In this blog, we will be looking at proper column-naming convention in Microsoft Fabric Lakehouse. Let’s get started. Microsoft Fabric Lakehouse offers a user-friendly cloud-based data platform where you can seamlessly prepare, manage, and explore data. It simplifies the process of connecting to different data sources, transforming data, and creating machine learning models. […]

In this article, we will be looking at what is DirectLake in Microsoft Fabric and its benefits. What is DirectLake and why the fuss about it? DirectLake is a feature of Microsoft Fabric Data Warehouse that allows analyst, engineer, and users to access and query data directly from Azure Data Lake Storage without loading the data into the warehouse. DirectLake […]

Scalable data movement is one of the key activities of Data Engineers. In this article, we will learn how to create data pipeline to copy data from Data Warehouse to Lakehouse in Microsoft Fabric. Let’s get started We have already create A to Z of Warehouse workspace and there is data in the Transaction data warehouse that we will ingest into the […]

Introduction Data integration is a critical aspect of working with spreadsheets, especially when dealing with diverse data sources or multiple datasets. In this article, we’ll explore an efficient method for data integration using the HSTACK and XLOOKUP functions. These two powerhouse functions can help you merge data from different sources seamlessly. Understanding the Challenge Imagine you have data in multiple […]

Introduction Microsoft Fabric is a real-time analytics service that allows you to interact with your data in the context of databases. Kusto Query Language (KQL) is a powerful language that enables you to query and analyze data in Microsoft Fabric. In this blog, we will learn how to create a KQL database and table and ingest flat file data into […]