Check Out the Updated Violin Plot Power BI Custom Visual
I wrote about the violin plot custom visual by Daniel Marsh-Patrick back in February. I thought it was a good visual then, but version 1.3 has recently been released with some nice enhancements. First, the violin plot is now a certified custom visual. This means that it has been tested by the Power BI team… Continue reading Check Out the Updated Violin Plot Power BI Custom Visual
Why We Don’t Truncate Dimensions and Facts During a Data Load
Every once in a while, I come across a data warehouse where the data load uses a full truncate and reload pattern to populate a fact or dimension. While it may not be the end of the world for a small table, it does concern me and I usually recommend to redesign the load. My… Continue reading Why We Don’t Truncate Dimensions and Facts During a Data Load
So You Want to Be A Business Intelligence Consultant
I’ve had a few people ask me recently for advice on getting into business intelligence/analytics consulting. I have been in consulting for 6+ years and have worked for 3 different consulting firms, so I’m sharing my thoughts and experiences here in case they are helpful to someone else. My first response to people asking this… Continue reading So You Want to Be A Business Intelligence Consultant
What You Need to Know About Data Classifications in Azure SQL Data Warehouse
Data classifications in Azure SQL DW entered public preview in March 2019. They allow you to label columns in your data warehouse with their information type and sensitivity level. There are built-in classifications, but you can also add custom classifications. This could be an important feature for auditing your storage and use of sensitive data… Continue reading What You Need to Know About Data Classifications in Azure SQL Data Warehouse