Abiola David's contributions

In this video, I covered how to read and analyse Azure SQL Database Table in Databricks Notebook.

In this new video, I am going to walk you through how to write data from Fabric Dataflow Gen2 to Azure SQL Database.

In this end to end video, I walked you through how to implement Azure Databricks Autoloader which allows incremental loading of new files from Azure Data Lake Storage Gen2.

In this Power Query video, I covered how to create fiscal Year and perform aggregation using Power Query M Code.

In this Data Engineering episode, I covered how to read multiple sales parquet files resident in Google Cloud Storage to Azure SQL Database leveraging Azure Data Factory.

This videos show how to use SQL and DAX languages to compute Total Sales and Total Cost achieving the same result in Fabric Warehouse and Power BI.

In this Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse episode, I am going to walk you through how to -- Enabling System Assigned Managed Identity required to publish data to Fabric Onelake. -- Connect to Azure SQL logical server using SQL Server Mgt Studio. -- Create Microsoft Entra ID authenticated login in the master database. -- Switch Database we want to Mirror in Fabric. -- Create database user to connect to the Entra ID login created above. -- Create and Insert records to SalesData table and ensure it contains primary key. -- Set up Mirroring in Fabric Warehouse workspace. -- Mirror the replicated Salesdata table in SQl Analytics Endpoint. -- Create insert new records to the SalesData from the SSMS, replicate again and query the table to see new records. -- Create product table, insert records and replicate to see the new table replicated for querying. -- Talk about the observed limitation.

In this episode, I am going to walk you through how to integrate multiple category of files in ADLS Gen2 to Azure SQL Database via Azure Data Factory data pipeline activities focusing on filter and other pipeline activities.

This end-to-end video shows how to configure and build DTB model in the DTB cloud focusing on Microsoft Fabric.

This videos show how to use SQL and DAX languages to compute Total Sales and Total Cost achieving the same result in Fabric Warehouse and Power BI.

In this video, I demonstrated how to perform SQL Data Analysis in Azure Synapse Analytics using built-in serverless pool.

In this data engineering and data analysis episode, I covered how to provision single snowflake database table in azure sql database and then use Power BI desktop to connect to the data to create Power BI report.

In this video, I demonstrated how to read Multiple ADLS Gen2 CSV Files using SAS in Databricks Notebook.

In this Azure Data Engineering episode, I discussed how to perform SQL Data Analysis using Azure Synapse Built in Serverless Pool

In this new episode, I demonstrated how to Read Parquet Data to Fabric Warehouse using COPY INTO & INSERT INTO SQL Statements.

In this episode, I walked you through how to create storage credentials and external locations to ADLS Gen2 in Azure Databricks.

In this Data Engineering episode, I was you through to to append and convert multiple CSV Files to Parquet File leveraging the Azure Data Factory

In this Azure Databricks episode, I covered how to use the Group By All clause to efficiently query data in the SQL editor.

In this Data Engineering episode, I covered how to use Azure Data Factory Dataflow to read, appends multiple CSV files from ADLS Gen2, clean and transform the data and sink to the Azure SQL Database for analysis.

In this video, I walk you through how to continuously stream data from SharePoint Folder to Fabric Warehouse leveraging Dataflow Gen2 for transformation and Data Pipeline for ingestion.

This video shows how to use the ADDCOLUMNS DAX function to generate full calendar table that includes in Power BI.

In this video, I covered how to use Azure Synapse Analytics to integrate data from Google Big Query to Azure SQL Database.

In this Data Engineering video, I covered how to implement automated incremental load from Snowflake Warehouse to Fabric Warehouse leveraging Fabric Data Pipeline. If you enjoy this video, give it a thumps up, comment, share with your friends and subscribe to the channel for more content.