Videos by Abiola David

In this video, I walk through how to architect and implement a Cross-Tenant Delegated OneLake Shortcut in Microsoft Fabric. Discover how organisations can securely access and consume data stored in another Microsoft Fabric tenant without physically copying, moving, or replicating the data. Through a

Learn how to create relationships and cross dataset measures in Databricks AI/BI Dashboard with Abiola David. Explore dataset relationships and measures for better data analysis.

Learn how to connect Outlook mail data with Power BI Desktop, import email-related data, transform it using Power Query, and prepare interactive reports and visualizations. Follow this step-by-step Power BI tutorial to understand the Outlook connector workflow and data analysis process.

Learn how to stream SharePoint data to Databricks using Declarative Automation Bundles, Unity Catalog, schema evolution, and scalable Azure Databricks pipelines.

Learn how to share SQL Views with different users in Microsoft Fabric Warehouse using Data Control Language (DCL) and manage secure, role-based access permissions.

Learn how to efficiently ingest files from SharePoint folders into your Microsoft Fabric Lakehouse for powerful data analytics and insights.

In this video, I will show you how to seamlessly publish your Azure Databricks data directly to Power BI Online, eliminating the need for complex export-import workflows. You'll learn how to configure the necessary permissions, set up Unity Catalog integration, and publish datasets with just a few clicks, saving you valuable time in your data analytics process

In this video, I dive deep into creating Managed and External Tables in Databricks, blending theory with practical examples to provide a comprehensive understanding. Whether you're building robust data pipelines or exploring database management, this guide equips you with essential skills for effective implementation.

In this video, I showcase how to use workspace identity in the Fabric Data Pipeline and explore Lakehouse shortcuts. This demonstration includes configuring workspace identity for seamless access control across data pipelines, enhancing collaboration and security within Fabric. Additionally, I delve into how Lakehouse shortcuts can streamline data access, providing users with efficient pathways to navigate large datasets and improve productivity in data engineering workflows.

In this video, I showcase how to technically load tasks from Microsoft Planner to Power BI for analysis and visualization

In this new video, I showcase how organizations can leverage the power of Databricks SQL Warehouse's AI_Forecast function to generate accurate predictions, empowering informed business decisions in budgeting, resource allocation, and strategic planning.

In this Databricks episode, I demonstrated how to implement an automated solution that ingest sales data stored locally into the Databricks DBFS Failestore, read and write the data into a table attached to SQL Warehouse and built AI/BI Dashboard for downstream reporting.

Exciting news! In my latest video on DP700 Exam Prep, I dive deep into implementing Row-Level Security (RLS) in Fabric Warehouse. This topic is part of the "Securing and Managing Analytics Solution" skill measured in the Microsoft Certified Fabric Data Engineer exam.

??In this comprehensive end-to-end data engineering video, I demonstrated how to architect real-time streaming data solutions in Databricks, starting from weather data captured in VS Code, seamlessly integrated with Azure Event Hubs. The setup leverages the robust capabilities of the Medallion Architecture and the advanced features of Unity Catalog to ensure efficient data management and processing.In this video, you will learn how to: ?? Create Event Hubs and Share Access Policies ?? Generate weather streaming data using Python in VS Code ?? Send the events to Azure Event Hubs ?? Create Databricks Cluster and Install Maven Library to authenticate access Azure EventHub ?? Create unity catalog, schemas and volumes using medallion architecture ?? Read and write streams across the bronze, silver and gold layers ??Access Power BI Desktop in Marketplace Partners Connect tab ?? Build near real-time Power BI report using DirectQuery

I'm excited to share my latest tutorial on Real-Time Intelligence, where I walk you through how to generate data using Python, send it to Azure Event Hubs, stream it to Microsoft Fabric EventHouse, and create a real-time dashboard with Power BI. What You'll Learn in This Video: ? Data Generation – How to use Python in VS Code to generate realistic real-time data. ? Azure Event Hubs – Learn how to set up and send data for real-time processing. ? Microsoft Fabric EventStream – Stream data from Azure Event Hubs to Fabric EventStream. ? EventHouse Integration – Store and manage real-time data in EventHouse. ? Real-Time Dashboard – Build a live, interactive dashboard to visualize and analyze data. ? Power BI Report – Create a Power BI Report using streaming data.

In this new video, I covered what is Azure Event Hubs, its components and a demo on how to create Azure Event Hubs service and send events using custom payload events. In the next video, I will be cover how to get data from Azure Event Hubs to KQL Database in Fabric and create real-time dashboard. Stay tuned.

In this end-to-end practical video, I covered how to implement a Databricks Delta Live Table Pipeline that seamlessly integrates with the Medallion Architecture and Star Schema data modeling technique. You will learn how to: Mount an ADLS Gen2 container. Read data from the mount point to the Bronze layer. Read, clean, and transform data from the Silver to Gold layers using SQL. Set up the DLT pipeline and run it. Interpret the DLT graph and consume data from the Hive metastore.

In this end to end data engineering video, I covered how to prepare and executive cross-warehouse queries in Microsoft Fabric using the brand new T-SQL Notebook.

In this Databricks video, I covered how to use the Databricks SQL QUALIFY with window functions in SELECT list and in QUALIFY clause.

In Databricks SQL, nested data structures like arrays and structs allow you to elegantly manage and query complex, hierarchical data with ease, transforming intricate datasets into insightful, actionable information. In this video, I demonstrated how to create, insert, and query nested data structures seamlessly without Pyspark!

In this Data Engineering episode, I covered how to connect to files resident in on-prems folder and transform the data using Factory Data Factory dataflow gen2 and publish to the new SQL Database for downstream analysis in Power BI

In this video, I covered introduction to Microsoft Fabric Notebook talking about the different features and functionalities. I also demo how to use the notebook to implemment data visualization

In this video, I demo how to use the powerful Databricks AI_Mask Function to obfuscate sensitive data

In this end to end data engineering episode, you will learn how to implement automated data integration in Snowflake using TASK.

In this episode, I demonstrated how to author 4-level advanced CTEs query using the new Microsoft Fabric T-SQL Notebook.