Abiola David's contributions

Discover how Excel’s DATABRICKS.SQL and DATABRICKS.TABLE functions connect spreadsheets directly to Databricks, enabling live SQL queries, enterprise data analysis, and real-time insights.

Learn how to run multiple SELECT statements in a Microsoft Fabric Warehouse and easily switch between their individual result sets. Using practical examples with Region, Product, and Orders tables, this article shows how multiple queries can simplify data exploration, validation, troubleshooting, and everyday SQL development in Fabric.

Learn to calculate shipping days in Fabric Dataflow Gen2 using Power Query. Handle date types, missing values, and invalid dates for robust data transformation.

Learn when to upgrade from Excel Power Pivot to Power BI for scalable, collaborative, and real-time business intelligence. Extend your analytics.

Uncover the hidden Power BI publishing process: from PBIX upload to cloud asset separation, semantic models, and secure data.

Automate Microsoft Fabric Lakehouse creation using Python notebooks and notebookutils. Streamline deployments, provision environments, and integrate with CI/CD.

Master Databricks SQL query optimization with EXPLAIN FORMATTED. Uncover Spark's execution plans, identify bottlenecks, and tune performance.

In this article, you'll learn hoe to master SQL Server's SHOWPLAN_ALL for query optimization. Understand execution plans, avoid pitfalls, and tune for peak performance.

Create dynamic, custom star KPIs in Power BI using DAX and SVG for visually engaging reports. Enhance data interpretation instantly.

Unlock real-time intelligence with Microsoft Fabric's Eventstream. Ingest, transform, and route streaming data instantly for immediate insights and action.

Master Power BI RLS to secure sensitive data. Learn to create, manage, test, and deploy roles for granular data access control.

Unlock Power BI dynamic security with USERPRINCIPALNAME(). Securely filter data by user email for personalized, scalable reports in the Power BI Service.

In this article, you will learn how to load files to Fabric Lakehouse tables using existing table append behaviour of the graphical user interface

This article is about the new feature in Microsoft Fabric that allows you to adjust column width

Audit Databricks query history to identify and optimize costly, long-running queries, ensuring financial governance and platform performance.

Databricks Catalog Commits revolutionize Lakehouse governance with multi-table ACID transactions, enhanced security, and improved performance.

In this article, I demonstrated how to use the COPY INTO Command to Load Data from Microsoft Fabric Lakehouse to Fabric Warehouse

Learn how to extract ZIP files directly within Microsoft Fabric Lakehouse using a Fabric Notebook, Python, and PySpark. Automate data ingestion and streamline ETL pipelines.

Modernize analytics by migrating from Power Pivot for Excel to Power BI. This guide covers migration steps, challenges, and benefits for a scalable solution.

Learn how to seamlessly integrate Salesforce data into Microsoft Fabric using Dataflow Gen2. Unlock insights with a low-code approach for analytics & reporting.

Unlock real-time Stripe payment data in Databricks without ETL! Access transactions, customers, and more instantly for faster analytics and AI. No pipelines needed!

Learn how data retention works in Microsoft Fabric Warehouse, including retention periods, time travel, recovery, OneLake storage costs, and compliance considerations.