Advanced Conditional Formatting: Turn On & Off Cell Color with CHECKBOXES in Excel

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 […]

Continue reading

Fabric Data Warehouse: Save as Table and Analyze Result Functionalities

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 […]

Continue reading

Microsoft Fabric Licensing and Pricing for UK South and West Regions

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 […]

Continue reading

Proper Column-Naming Convention in Microsoft Fabric Lakehouse

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. […]

Continue reading

What is DirectLake in Microsoft Fabric Data Warehouse and its Benefits?

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 […]

Continue reading

Data Pipeline to Copy Data from Data Warehouse to Lakehouse in Microsoft Fabric

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 […]

Continue reading

Efficient Data Integration using HSTACK & XLOOKUP Functions

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 […]

Continue reading

Create Database and Ingest Data into KQL Table in Microsoft Fabric

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 […]

Continue reading