BI

Building a Medallion Architecture for ETL in Microsoft Fabric: Polishing Your Data into Pure Gold!

In today's data-driven world, to manage the sheer volume and variety of information, organizations are constantly looking for smart, scalable ways to wrangle their data, and that's where the Medallion Architecture really shines. Paired with the powerhouse that is Microsoft Fabric, offers an incredible pathway to build slick,...

by Rajdeep Sarkar
Tag: datawarehouse
11-Aug-2025

Data Engineering

Snowflake Document AI : Unlocking Insights from Unstructured Data

Fun fact! Around 80%-90% of the world's data is unstructured. I was shocked when I read this fact. The unstructured data contains images, emails, PDF files social media posts, and other formats. Even though it is widely present 70% of data is not being used to drive insights and get analytics. As a Data Engineer, you must have...

by Akshay Vijay Girulkar
Tag: datawarehouse
09-Mar-2025

BI

Mastering Redshift to SQL Server Data Migration with SSIS: Challenges, Solutions, and Best Practices

Businesses utilize SQL Server Integration Services (SSIS) for transferring or merging data between Amazon Redshift and SQL Server. SSIS provides a robust ETL (Extract, Transform, and Load) Infrastructure for managing these migrations, ensuring data is accurately transferred and appended to existing datasets in SQL Server. Extracting data...

by Rajdeep Sarkar
Tag: datawarehouse
10-Oct-2024