Excel Jet Consult
151 FOLLOWERS
Excel Jet Consult - Business Data Analytics. Our vision is to be the foremost Microsoft Excel and Power BI professional training institute in Nigeria and West Africa sub-region using the latest software to drive our course contents.
Excel Jet Consult
1M ago
Welcome to Excel Jet Consult blog post. This video shows how to author advanced formula using GroupBy function with dynamic conditional formatting. Groupby Magic in Excel Video ..read more
Excel Jet Consult
2M ago
What is Endorsement in Microsoft Fabric? Endorsement is basically a way to highlight the best items in the Microsoft Fabric ecosystem, making them easier to find and use by users within an organization. Endorsement ensures that reliable, high-quality data, processes, and content are easy to find within Microsoft Fabric. Types of Endorsement in Microsoft Fabric Succinctly, there are two types ..read more
Excel Jet Consult
2M ago
Microsoft Excel has long been a staple for number-crunching and data analysis, but recent additions to its formula arsenal, such as the LET function and dynamic arrays, take spreadsheet calculations to a whole new level. In this article, we’ll explore a sophisticated advanced Excel formula that generates randomised dates and at the same time, extract day, month, year and quarter using single ..read more
Excel Jet Consult
2M ago
As a person data analyst working in the retail industry, imagine you’re tasked with simulating weekly retail sales that could represent the variability in daily sales with higher values during weekends (multiples of 7) and lower values during weekdays? Or you’re working as a data analyst in the energy firm and your manager asked you to simulate weekly energy consumption ..read more
Excel Jet Consult
2M ago
Welcome to Excel Jet Consult blog post. In this post, we will consider how to leverage the XLOOKUP function combined with LET function to dynamically retrieve data. Let’s get started. In this examples, we’ve got data showing Month and Units in columns A and B respectively as seen in the screenshot below Our goal is to use nested XLOOKUP function ..read more
Excel Jet Consult
3M ago
Welcome to Excel Jet Consult blog. In this video, I walked you through how to perform Credit Card Fraud Detection Machine Learning video: Download Source Code Here: Credit_Card_Fraud_Detection_Machine_Learning ..read more
Excel Jet Consult
4M ago
Welcome to Excel Jet Consult blog. In this blog, I am going to walk you through on how to embed Power BI Report to Fabric Notebook. Let’s get started. Video One of the benefits of embedding Power BI Report to Fabric Notebook, from the developer point of view, might be to version control and collaborate with others by seamlessly integrating ..read more
Excel Jet Consult
4M ago
Welcome to Excel Jet Consult blog post. In this blog, I am going to walk you through how to create a cross-tab report in Fabric Warehouse using the Pivot Operator. Let’s get started. Video Pivot Operator The PIVOT operator in SQL Server and Fabric Data Warehouse allows you to transform rows into columns and perform aggregations on your data. One ..read more
Excel Jet Consult
4M ago
Welcome Welcome to Excel Jet Consult blog post. In this tutorial, we are going to talk about writing Inner Join SQL Query in Fabric Notebook using PySpark. Let’s get started Video What is PySpark? PySpark is a Python API for Apache Spark which is a distributed computing framework that allows users to process large-scale data in parallel and with ..read more
Excel Jet Consult
4M ago
Welcome to Excel Jet Consult blog post. In this post, I’m going to walk you through how to create advanced conditional formatting using the new rule and then use the checkboxes to turn of and on the highlighting of the rows. Let’s get started. Video Sample Data In the picture below, we’ve got a sample sales data with handful of ..read more