Articles by Abiola David

Learn how to master the EXPLODE function in PySpark using Microsoft Fabric Notebooks. This guide simplifies how to transform nested arrays or maps into separate rows for easier analysis.

Experience seamless development with Microsoft Fabric and VS Code integration. Write, debug, and manage SQL queries directly in your editor, connect to Fabric Warehouse, and boost productivity with real-time data access.

This article covers creating dynamic, customizable date tables for advanced time intelligence, enabling better reporting, filtering, and analysis in your Power BI dashboards.

Master essential Time Intelligence DAX functions in Power BI to analyze trends, compare year-over-year data, and build dynamic, time-aware reports that drive smarter business decisions and insights.

Learn how to efficiently clean, transform, and manage large datasets with high-performance tools. Discover scalable, fast, and flexible data workflows designed for today’s data engineering needs.

Connect Power BI Desktop to Azure Data Lake Storage Gen2, combine CSV files in Power Query, transform the data, and create a sales report.

Discover techniques to preview, filter, and analyze large datasets using Apache Spark. Whether you're working with PySpark or big data processing, enhance your workflow with efficient DataFrame visualization.

This article walks through defining schemas, specifying column names, and using SQL-like DDL in a Fabric Notebook. Explore StructType, StructField, and various ways to display and verify DataFrame content efficiently.

Learn how to use Databricks AI_EXTRACT to pull entities such as people, dates, locations, and organizations from unstructured text with SQL.

This article dives into how to use databricks preloaded datasets. Databricks Datasets provide ready-to-use, real-world data built into the Databricks platform, enabling users to easily access, analyze, and refine machine learning, big data, and data science projects seamlessly.

The SQL TRUNCATE command, newly introduced in Fabric Warehouse, offers an efficient way to delete all rows from a table without logging individual row deletions.

Azure Databricks simplifies big data analytics and machine learning with managed Spark clusters on Azure. It scales dynamically, optimizing resource usage and costs. Integrated with Azure services, it supports high-performance data processing.

Learn how to enable GitHub integration in the Microsoft Fabric Admin Portal, configure delegate settings, and connect a GitHub account for workspace Git integration and CI/CD workflows.

Understanding Query Folding in Fabric Dataflow Gen2 (Power Query Online)" explores the concept of query folding within Microsoft's advanced data integration tool. Learn how query folding optimizes data transformation processes, enhances performance, and streamlines ETL tasks in Power Query Online.

Explore seamless data integration from Fabric Lakehouse to Snowflake Database using a robust data pipeline. This process involves extracting, transforming, and loading data efficiently, ensuring smooth migration and synchronization between the two platforms.

One of the crucial responsibilities of #FabricAdmin is ensuring high-quality and trustworthy items are endorsed either by promoting or certifying those items. In this definitive guide, I explained how to practically endorse items by promoting and certifying Fabric items.

This article is about Understanding the Supported File Types for Data Ingestion into the KQL Database in Fabric Real-time Analytics. Supported file types include JSON, CSV, XML, & Text. Note: XLSX is not supported. See how to ingest & transform data using Data Factory.

This article shows how to Generate Randomised Dates and Extract Day, Month, Year, and Quarter using a Single Formula in Excel. Explore advanced Excel formulas using the LET function and dynamic arrays to generate 100,000 rows of randomized dates.

Learn how to generate and visualize a bell-shaped or normal distribution using PySpark and Matplotlib in Microsoft Fabric Notebook. Explore the characteristics of a normal distribution, its symmetry, central tendency, and variability.

This article dives into how to share data gateway with users and resource groups in Microsoft Fabric. The Sharing Data Gateway in Microsoft Fabric Portal streamlines access and data transfer between on-premises and the cloud, promoting collaboration, optimizing resource usage and ensuring security.

Learn how Medallion Architecture organizes Microsoft Fabric Lakehouse data into Bronze, Silver, and Gold layers for progressively refined analytics data.

This article dives into how to implement a simple linear regression model in Microsoft Fabric Notebook. The main goal of simple linear regression is to find the best-fitting line through the data points that minimizes the sum of the squared differences between the observed values.

In this article, I walked you through how to embed Power BI Report in Microsoft Fabric. This features enable you to version control and collaborate with others by seamlessly integrating your workspace with GitHub through Azure DevOps.

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.