Abiola David's contributions

Learn how to use Excel's DATE function for effective data validation. Set criteria for a date column to ensure entries fall within a specific range, enhancing accuracy and data quality.

In the article, Explore the power of Microsoft Excel with the LET, VSTACK, and HSTACK functions. This article guides you through creating complex formulas for dynamic data combination and summarization across multiple tables.

In this article, we'll delve into the Microsoft Fabric Data Warehouse features: Save as Table and Analyze Result. These functionalities offer users and analysts several advantages in terms of data management and visualization.

This SQL query is a powerful tool for in-depth sales analysis, utilizing joins and aggregations to break down sales data by account manager, payment type, and region in Microsoft Fabric Data Warehouse.

The UK South and UK West regions of Microsoft Fabric provide cloud-based data integration and analytics capabilities, with a focus on meeting data residency requirements in the United Kingdom. The pricing structure for Microsoft Fabric is based on Capacity Units (CUs), with costs varying depending on the region and subscription plan. For the UK South and West Regions, the pay-as-you-go hourly and monthly rates are presented in a cost-efficient manner.

This article focuses on DirectLake in Microsoft Fabric Data Warehouse and its Benefits. DirectLake is a feature of Microsoft Fabric Data Warehouse that allows analysts, engineers, and users to access and query data directly from Azure Data Lake Storage without loading the data into the warehouse.

This blog focuses on Proper Column-Naming Conventions in Microsoft Fabric Lakehouse. Microsoft Fabric Lakehouse offers a user-friendly cloud-based data platform where you can seamlessly prepare, manage, and explore data. It simplifies the process of connecting to different data sources, transforming data, and creating machine learning models.

This article effectively explains how to integrate data from different sources using Excel's HSTACK and XLOOKUP functions. The step-by-step breakdown and the clear demonstration with sample data make it easy for readers to understand and implement the data integration process seamlessly.

This article is about OneLake in Microsoft Fabric. OneLake, an integral part of Microsoft Fabric, provides a robust and streamlined approach to analytics data management within organizations. Leveraging the power of Azure Data Lake Storage (ADLS) Gen2, OneLake offers several distinct advantages that make it a valuable asset for businesses.