Creating and Managing Workspaces in Power BI Service

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

Continue reading

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