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 readingData 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 readingPublishing 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 readingUnderstanding 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 readingMicrosoft 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 readingNew 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 readingHow To Get Excel Labs Add-in To Author Python Code
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 […]
Continue readingAnalyzing 2018 Quarterly Sales Trends by Product in SQL Server
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 […]
Continue readingCASE, 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 readingCreating 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