FILTER Quarter 1 and 2 Transactions and Return Specific Columns in Microsoft Excel

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

Continue reading

CTE and Windows Function to Fetch Top Payment Types in 2017 Sales [SQL Server]

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

Continue reading

Append Filtered List using Single Cell Worksheet Functions in Excel [Part 2]

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

Continue reading

Calculate Average Monthly Revenue in SQL Server using Sub Query

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

Continue reading

Month with the Highest Revenue

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

Continue reading

What is Microsoft Fabric Lakehouse?

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

Continue reading