Power BI is one of the most prominent data analytics technology out there. Power BI is also one of the most marketed and hyped technology out there. Unfortunately, both of…

Calendar (or date) table is crucial for performing date intelligence calculations in Power BI.  Normally, you would find a reasonable calendar table in most data models. But occasionally I come across models…

In our everyday life, the words Merge and Combine have almost the same meaning. However, when you’re working in Microsoft Excel, there are important differences in their meanings! Video: Merge…

We can calculate any Finance & Accounting KPI values using Excel easily. In this article, I  am sharing the top 10 accounting KPI calculations. These are… Topics Net Profit Margin…

So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job. Episode outline: My…

When you’re printing financial reports in Excel, do you set them up to print one page wide? That feature saves paper, but it can make the header and footer text…

Ladies & gentlemen… I have an exciting announcement. I am relaunching my podcast!!! It only took me 7 years, but Chandoo.org podcast is now BACK! I am planning to make…

Power BI has a LOT of chart types. More than 30 of them. So, picking the correct chart for a data analysis situation is hard. Here is a picture of a frustrated…

It’s almost the end of June, and there’s a long weekend coming up! To celebrate, let’s take a look at some of the spreadsheet news from the past month. Here…

Do you ever need to compare two lists in Excel, and see if there are some items in one list, that aren’t in the other list? The video below shows…