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 […]
Smart Narratives in Power BI Power BI and the Microsoft team has released a new feature in public preview called smart narratives. This addition to Power BI is amazing and provides some versatility. Let’s talk about this feature for a […]
Changing the version of SSAS after installation I recently ran into an issue where a newly created SQL Server environment was handed over to me with the wrong version of SSAS installed. It’s a common practice for many IT […]
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; […]
Predictive Analytics with Machine Learning and Databricks Series Pt 2 “Starting Up a Cluster” In the first part of this four-part series we focused on getting comfortable with the console. In this blog and second part of our series we […]
Predictive Analytics with Machine Learning and Databricks Series Pt 1 “The Databricks Console” Are you one of those IT professionals that wants to become a data scientist? Do you want to find somewhere that you can follow step by step […]
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 […]