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

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

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

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

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

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

Welcome to Excel Jet Consult blog post. In this blog post, I am going to wslk you through how to enable the Excel Labs add-in which is an editor that we can use to author Python code in Excel using the new PY function. Let’s get started. The Python Editor is a new addition to Excel Labs that allows users to write […]

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