Welcome to Excel Jet Consult blog. In this blog post, we are going to explore how to write SQL to Analyze 2023 Quarterly Sales Trends by Product in SQL Server. Let’s get started Below is the table we are going to work with. We have use SELECT * FROM factSalesTable to return all the records.   Analyzing 2023 Quarterly Sales […]

Welcome to Excel Jet Consult blog post. Structured Query Language (SQL) is the backbone of managing and manipulating data in relational database systems like SQL Server, mySQL, OracleSQL, PostgreSSQL, IBM DB2, Terada and so on.  To perform conditional operations within SQL queries, we often use the CASE statement along with its companions WHEN, THEN, and ELSE In this blog, we will […]

Welcome to this Excel Jet Consult blog post. In Power BI Service, workspaces act as containers that holds reports, dashboards, and datasets, making it easier to manage and share content with others users and groups within an organization. In this blog, we are going to consider how to create and manage workspaces in the Power BI Service. Creating a Workspace […]

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