Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to filter quarter 1 and 2 transaction in Microsoft Excel using the FILTER function. Let’s get started. Video   Dataset The screenshot below shows the transaction data we are going to be working with. The data is officially formatted as an Excel Table and […]

Welcome to Excel Jet Consult blog post. In this blog, we are going to learn how to filter the quarter 1 and 2 transactions in SQL Server 2022. Let’s get started SQL Server Table The screenshot below all the records in the factSalesTable of the SalesData database. The table contains 55,552 records as seen at the bottom right of the […]

Welcome to Excel Jet Consult blog post. In this blog post, we will explore how to use the CTE and Windows Function to Fetch Top Payment Types in 2017 Sales [SQL Server]. Let’s get started. With a simple SELECT * FROM factSalesTable, we fetched all the records in the table as seen below CTE and Windows Function to Fetch Top […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to continue in learning how to Append Filtered List using Single Cell Worksheet Functions in Excel. Let’s dive in Dataset We are going to use the same dataset used to perform the same operation using the new PY function as seen below. Note the three tables are […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to continue in learning how to use the Python in Cell to append filter multiple table. Let’s get started. Dataset In the screenshot below, we have got three transactions tables. Note the three tables are formatted officially as an Excel Table using the CTRL + T. The […]

Welcome to Excel Jet Consult blog post. In this SQL Server video tutorial, we are going to learn how to calculate Average Monthly Revenue using Sub Query. Let’s get started. Dataset The screenshot contains a simple select all statement to fetch all the records in the Monthly Sales table Average Monthly Revenue using Sub Query To calculate the Average Monthly […]

Welcome to Excel Jet Consult blog post. In this SQL Server video tutorial, we are going to learn how to calculate total revenue for each month. Let’s get started. Dataset The screenshot contains a simple select all statement to fetch all the records in the Monthly Sales table Total Revenue for Each Month To calculate the Total Revenue for Each […]

Hello and welcome to Excel Jet Consult blog post. In this tutorial, I am going to show you how to import data from Excel to Microsoft SQL Server 2022. Lets get started Dataset in Excel The screenshot below shows the two column of data we intend to into into SQL Server using the SSMS. Note, the Excel workbooks is saved […]

Welcome to Excel Jet Consult blog post. In this SQL Server video tutorial, we are going to write the SQL query to find the month that has the highest revenue. Let’s get started. Dataset The screenshot contains a simple select all statement to fetch all the records in the Monthly Sales table   Month with the Highest Revenue To calculate […]

Introduction Welcome to Excel Jet Consult. In this blog, we will focus on Lakehouse object of the Microsoft Fabric technology. Let’s get started. What is Microsoft Lakehouse? Microsoft Fabric Lakehouse is an amazing data architecture platform that allows organizations to store, manage, and analyze structured and unstructured data in a single location. It is a flexible and scalable solution that […]