Data Analytics With Swagg!
Data Profiling and Cleansing Part 1 Azure Synapse with Azure Data Catalog Data analytics is a broad term but the foundational concepts of extraction, transformation and loading (ETL) OR extraction, loading and then transforming (ELT) are developmental practices that we […]
Calculated Columns Vs Measures Optimizing Power BI I have had the honor of developing a lot more solutions in Power BI over the past few years. Having a data analytics background in analysis services and data modeling has helped tremendously. […]
The Merge Join Transformation and an SSIS Sorting Tip My previous blog was about the SSIS Lookup task and how it really works. Now that I have shown that the Lookup task shouldn’t be used for one-to-many or many-to-many joins; […]