Articles by Abiola David

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.

Cut storage costs with Microsoft Fabric's OneLake! Automate data tiering (hot, cool, cold) using lifecycle policies for optimal performance & savings. Learn how!

Simplify Databricks Lakeflow Jobs with disabled tasks! Boost flexibility, streamline debugging, and optimize deployments. A must-have for efficient data pipelines.

In this article, I covered how to aster Power BI small multiples! Learn to create insightful charts for comparing trends, identifying anomalies, and enhancing data storytelling. Simplify complex data!

Learn how to insert images into Power BI reports to enhance visual appeal, branding, and user experience. Discover best practices for optimal performance and design.

Master Microsoft Fabric Data Pipelines by disabling activities! This guide shows how to debug, test, and optimize workflows without deleting crucial steps. Improve deployments and save costs!

Master Microsoft Fabric capacity! Architect for performance, scalability, & cost control. Learn workspace design, workload tiering, & governance best practices.