How to Deploy Azure Data Factory (ADF) from Dev to QA using Devops

Just wanted to do a quick video to cover the process of deploying ADF artifacts from Development environment to higher environments like QA, etc. these are the basic steps to get it done (please watch the video for detailed instructions) https://youtu.be/7fsIwWheyDk Create a new project in Devops if there is no project set up alreadyMake … Continue reading How to Deploy Azure Data Factory (ADF) from Dev to QA using Devops

Incrementally Load New Files in Azure Data Factory by Looking Up Latest Modified Date in Destination Folder

This is a common business scenario, but it turns out that you have to do quite a bit of work in Azure Data factory to make it work. So the goal is to take a look at the destination folder, find the file with the latest modified date, and then use that date as the … Continue reading Incrementally Load New Files in Azure Data Factory by Looking Up Latest Modified Date in Destination Folder

Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)

Price Volume Mix (PVM) calculation is one of the most popular topics on my blog and YouTube channel. Although, I have covered the DAX for the perfect PVM before, I have gotten a lot of requests to extend the PVM logic to include a separate bucket for discontinued products as well as new products. You … Continue reading Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)

What Kellogg Professor Got Wrong about Effectiveness and Honesty in Data Visualizations

Steven Franconeri, a Kellogg School of Management professor, has written a good article "4 keys to Effective – and Honest – Data Visualizations". I thought that he made some solid points; however, I strongly disagree with his opinion about what makes a chart honest or dishonest. https://youtu.be/E6A0cry7PUw As you look at the global temperature trend … Continue reading What Kellogg Professor Got Wrong about Effectiveness and Honesty in Data Visualizations

Power BI Best Practices Analyzer in Tabular Editor

Wanted to do a quick video on how to use Power BI Best Practices Analyzer using Tabular Editor. There was a great blog post on it here: https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/ that covered a lot of details on what best practices were there to be aware of as well as the tool itself. However, the article seemed to … Continue reading Power BI Best Practices Analyzer in Tabular Editor