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 readingFILTER Quarter 1 and 2 Transactions in SQL Server
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 […]
Continue readingCTE 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 readingAppend 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 readingPython In Excel Code To Append Filtered DataFrame
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 […]
Continue readingCalculate 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 readingCalculate Total Revenue for Each Month in SQL Server
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 […]
Continue readingImport Data From Excel to MS SQL Server 2022
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 […]
Continue readingMonth 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 readingWhat 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