Now, before we get into it, I have to admit that I am somewhat of a Data Science sceptic. Not that I do not believe in Data Science, quite the opposite, I think it is a critical field in data analytics world that will eventually mature enough to be the dominant force in insight generation. … Continue reading We Don’t Need Data Scientists?!?
I found this interesting chart on Datawrapper.de and it made me think about how (and whether) my chart selections also changed over time. https://youtu.be/NV5QeQdnv1Y (Datawrapper is a pretty cool tool that allows users to upload their data and create pretty stunning visualizations) In this chart, Datawrapper has analyzed changes in distribution of chart styles selected … Continue reading How Good are Your Chart Choices?
I have to admit that up until recently I have been oblivious to this topic myself. I am not a graphics designer, but I have always tried to pay attention to the esthetics of my reports/charts; picking colors and palettes was something that I would spend a considerable amount of time obsessing about. A short … Continue reading Tools to Check If Your Reports are Color-Blind People Friendly
Constant currency analysis is very popular when we need to take out FX rate fluctuations from our analysis. There are many different methodologies that companies used for determining what constant FX rate to apply to the historical values. In our tutorial, we will take a look at the time window for our analysis, figure out … Continue reading Constant Currency Analysis (Power BI DAX Tutorial)
Unfortunately, life is hard and in BI world we are guaranteed to fail with our Data Persuasion every now and then. Having failed with my BI presentations many a time, I decided to write this article and frame up my top five reasons why I did and also suggest a few things for what you … Continue reading Data Persuasion with BI: Top 5 Reasons Your Last Presentation was a FAIL
If you are looking to challenge your DAX skills while trying to figure out how to calculate a Cumulative Discount (or a Cumulative Commission) then this tutorial is for you. https://youtu.be/9hGowlw4YPc A Cumulative discount is calculated by finding the cumulative sales in the specified discount window, and then, using the cumulative sales as the parameter … Continue reading Cumulative Discount or Commission Calculation (Power BI DAX Tutorial)
I use Sales data a lot in my tutorials and usually the Sales Fact table will have the following fields in it: DateProductRevenueUnits Along with a bunch of other stuff…. Now, it is actually very common for a company to only provide Units in the Sales Table along with a Price History and/or Cost History … Continue reading How to Calculate Revenue and Margin Using Price and Cost History Tables (Power BI DAX Tutorial)
The older and wiser that I get, the more I realize that our framework of values and motivations is often not so much based on our own experiences and learnings but rather on effectiveness of persuasion of individuals who have taken their time and used their skills to instill our values and to create our motivations. You too can learn how to use data to persuade your audience...
I have heard some CEOs say some crazy things, but this is a special kind of crazy talk that we are dealing with here, folks! In this article, Sudheesh Nair (who is the CEO of ThoughtSpot), gives us his critical view of the BI industry in the context of COVID19 aftermath as he attempts to … Continue reading This Is Crazy: ThoughtSpot CEO wants to kill BI and for all dashboards to die
EDIT 2021-03-18: I have added two additional buckets for PVM analysis with New Products and Discontinued Products in this new blog post/video. This is the third installment in the series; however, you are not required to read the previous two to follow along. Part I - I frame up the basic concept of analysis in … Continue reading DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial)