Abiola David

SQL Vs DAX: Calculating Total Sales & COGS using SQL and DAX

ADF: Provision Snowflake Database Table in Azure SQL Database and Create Power BI Report

Read Multiple ADLS Gen2 CSV Files using SAS in Databricks Notebook

SQL Data Analysis using Azure Synapse Built in Serverless Pool

New in Fabric Warehouse SQL: TRUNCATE

Read Parquet Data to Fabric Warehouse using COPY INTO & INSERT INTO SQL Statements

Azure Databricks: Create Storage Credentials and External Locations to ADLS Gen2

Azure Databricks: GROUP BY ALL

BigQuery to Azure SQL Database using Azure Synapse Analytics

Analyzing Azure Databricks Unity Catalog data in Power BI Desktop

Azure Databricks: Create Unity Catalog | Schema | Table | SQL Query

Azure Data Factory: Direct Data Integration to Fabric Lakehouse Delta Table

Azure Datatricks: Switching from PySpark to SparkSQL for Analysis

Azure Databricks | JSON to PySpark Data Transformation

Recursive Traversal in Azure Synapse to Fabric Lakehouse

Implementing Practical CI/CD in Fabric Notebook Leveraging Azure DevOps

Read, Combine and Analyse ADLS Gen2 CSV files using Spark SQL

Nested IF AND THEN ELSEIF Statement in Fabric Dataflow Gen 2 and Power Query PBI

Intro to Azure Synapse Analytics: Create Synapse Workspace

Introduction to Spark Scala in Fabric Notebook for Analysis

FOLDER Files to Fabric Warehouse using Dataflow Gen2

Invite and Share Power BI Reports and Semantic Model with External User

Azure Data Factory Git Integration using Azure DevOps

Advanced Power Query: Re-ordering of Columns Across Worksheets in the same Excel Workbook

AzureDataFactory: Multiple CSV Blog Storage Files to Azure SQL Database as Consolidated Table

Power BI Reports to Fabric FOLDERS

Advanced Excel Formula: Single-Cell Leveraging LET, VSTACK, HSTACK, FILTER, CHOOSECOLS & SUM

ETL: Bulk CSV Files from GCS to SQL Server as a Single Table using Fabric Data Pipeline

Azure Data Factory: Implementation of Blob Event Trigger for Data Movement

SQL Server Database Tables to Azure SQL using Fabric Data Pipeline

Automate Correction of Inconsistent Order of Columns using Power Query

Mirror Azure Cosmos DB in Fabric Warehouse

Cross Workspace Lakehouses Data Transfer using Pipeline Dynamic Content

Azure Data Factory to Ingest Data From ADLS Gen 2 to Azure Cosmos DB

[Data Engineering] Orchestrate BigQuery Data to Fabric Lakehouse using Data Pipeline

Replace Year Part of Date Values in Multiple Columns at Once in Excel

ETL Data from Google Cloud Storage to BigQuery for Analysis

Azure Data Factory to Copy Data From GCS to ADLS Gen 2

Get Data from Azure Data Lake Gen 2 to Excel for PivotTable Analysis (Power Query)

Fabric Lakehouse Shortcut to Google Cloud Platform

XLOOKUP/RECHERCHEX Function in Excel (Download Excel File in Description)

Summary Statistics, Measure of Location & Correlation Coefficient in Excel (Download File)

Migrate 34m Records from SQL Server to Warehouse using Fabric Data Pipeline

Create Azure ADLS Gen 2 and Fabric Lakehouse Shortcut for Analysis

Advanced Power Query Filter Referencing List

Ingest Data from Azure Blob Storage to Snowflake Warehouse using Azure Data Factory

Leverage Fabric Data Pipeline to Migrate Snowflake Data to Azure SQL Database

Ingest Data into Azure SQL Database using SSMS

How to Calculate SPLY Var (%) Properly in Power BI using Variables in DAX

ETL Data from Fabric Lakehouse to Snowflake Database using Data Pipeline