Creating a Calendar Table in Excel Power Query and its Benefits

Introduction Excel Power Query is a powerful tool that allows transformation and manipulation of data for more effective analysis and reporting. One valuable technique to transform data is the creation of a calendar table, which typically helps to manage and visualize time-related data. In this article, we will go through the process of creating a calendar table using Power Query and explore the many […]

Continue reading

How to Create Table & Insert Records in Microsoft Fabric Data Warehouse SQL Endpoint

INTRODUCTION Welcome to Excel Jet Consult blog post. Microsoft Fabric Data Warehouse is a cloud-based data platform that enables you to store, analyze, and share large volumes of structured and semi-structured data. SQL Endpoint is a service that allows you to run SQL queries on your data warehouse using a web-based interface. CREATE TABLE & INSERT RECORDS One of the […]

Continue reading

Data Pipeline to Copy Data From Azure Blob and Ingest Into Lakehouse in Microsoft Fabric

Introduction Microsoft Fabric is an all-in-one toolbox for crunching numbers and making sense of data. It’s got a bunch of tools, like moving data around, storing it in lakes, doing engineering work on it, mixing it together, using it for science stuff, keeping an eye on it in real-time, and helping you make smart business decisions. And the best part […]

Continue reading

Publishing Power BI Report into the Power BI Service

Introduction Welcome to Excel Jet Consult blog post. Power BI, Microsoft’s powerful business analytics service, empowers users to transform data into insightful reports and dashboards. After creating a compelling Power BI report on your desktop, the next step is to share it with stakeholders. This is where the Power BI Service comes into play. In this blog post, I will […]

Continue reading

Understanding the YEARFRAC Function in Excel

Introduction Microsoft Excel is an amazing spreadsheet software that offers a wide range of functions to help users manipulate and analyze data efficiently. One such function that proves to be incredibly useful in financial and date-related calculations is the YEARFRAC function. In this article, we are going to delve into what the YEARFRAC function is, how it works, and various […]

Continue reading

Microsoft Fabric Data Engineer: A New Career Pathway

Introduction Welcome to Excel Jet Consult blog post. In this blog, we will be focusing on Data Engineering and Data Engineer in the new Microsoft Fabric technology. Let’s get started. Data is the new oil, as the saying goes because data is the fuel that powers modern businesses, enabling them to gain insights, optimize processes, and create value. To harness […]

Continue reading

New Stale Value Formatting in Excel

Excel to Excel Jet Consult blog post. Microsoft recently introduced a new feature called Stale Value Formatting in Excel that applies strikethrough formatting to any values that become “stale” when tinkered in manual calculation mode. Users can manage this feature through the Calculation Options area in the Formulas tab on the Ribbon Stale Value Formatting is an application setting that […]

Continue reading

CASE, WHEN, THEN and ELSE in SQL Server 2022

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

Continue reading