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

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to use single cell formula to create fiscal period calendar table in Excel worksheet. Let’s get started Video Sample Data From the screenshot below, we’ve got date that spanned from 01/01/2020 to 31/12/2013 in column A. Single Cell Formula to Create the Calendar Table […]

Welcome to Excel Jet Consult blog post. In this blog post, we’ll explore how to write SQL to identify products that were consistently sold in every quarter of the year 2017. Let’s get started. With a simple SELECT * FROM factSalesTable, we fetched all the records in the table as seen below To identify the best selling products in every […]

Welcome to Excel Jet Consult blog post. In this video, we are going to learn how to analyze PowerBI Dataset in Excel for the Web. Let’s get started Video The screenshot below shows a dynamic report created in the PowerBI Desktop and published to the PowerBI Service. We want to access the underlying dataset that contains the fact table, dimension […]

Welcome to Excel Jet Consult blog post. In this SQL Server video tutorial, we are going to learn how to calculate total sales by quarters grouped by Year. Let’s get started. Dataset The screenshot contains a simple select all statement to fetch all the records in the Monthly Sales table Total Sales by Quarters Grouped By Year To calculate Total […]

Hello and welcome to Excel Jet Consult blog post. In this blog post, we are going to look at how to handle cache in SSMS to keep your SQL Query sharp. Le’ts get started. IntelliSense is a handy feature in SQL Server Management Studio (SSMS) that helps users to write SQL code more efficiently by providing auto-completion suggestions and syntax […]

Introduction Welcome to Excel Jet Consult blog post. In this blog, I  will walk us through the concept of forcing additive measure in Power BI. Let’s get started Understanding Additive vs. Non-Additive Measures In Power BI, measures can be categorized as additive or non-additive based on how they aggregate when multiple data points are combined. Additive measures are those that […]

Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will learn how to create calendar table and calculate total sales by fiscal period in Power Pivot Data Model. Let’s get started Sample Data and Loading to the Data Model In the screenshot below, we’ve got a sales dataset that is officially stored as an Excel Table using […]