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

Welcome to Excel Jet Consult blog post. In this blog, we will learn how to get daily and weekly historical stocks data of IBM and Microsoft from Alpha Vantage API. Lets get started Alpha Vantage API The first thing we need to do is go to www.alphavantage.co to register and generate API key. Next, we are going to flip to […]

Welcome to Excel Jet consult blog post. In this post, we are going to learn how to write Excel formula to generate weekdays and Month. Let’s get started Generate Weekdays Starting on Sunday The first demo we want to cover is how to write the Excel formula to generate weekdays with Sunday is the first day of the week. To […]

Introduction Excel Power Query is a powerful tool that allows transformation and manipulation of data for more effective analysis and reporting. One valuable technique to transform data is the creation of a calendar table, which typically helps to manage and visualize time-related data. In this article, we will go through the process of creating a calendar table using Power Query and explore the many […]