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. […]
Power Automate is Making Life Easier Microsoft does it again with another advancement in technology with the release of Power Automate desktop. As a Power platform and analytics subject matter expert these recent new releases have got me going crazy […]
Power BI “Themes” a Hidden Gem Power BI has hidden gems that are not given enough credit and themes are just one of them. When developing dashboards how often do you sit back and say what can I do to […]
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; […]
The Life Cycle of a Data Warehouse All data warehouses should follow a standardized life cycle. Not all life cycles are required to be exactly the same either. In this post we are going to step away from the how-to […]