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

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