Ever wanted to get a set of dates, but don’t want to manually type? Here are three ways to insert dates in Excel automatically. Option1: Enter a start date and Drag down This is the easiest option if you just want a handful of dates. Just type in your starting date in a cell. Click […]

SVG (Scalable Vector Graphics) is a great way to add a bit of flavor and pizzazz to your boring Power BI reports. I have been using them for a while and really love how easy and fun they are to work with. So today, let me share the technique and provide sample measure code that […]

1. Introduction Insurance is a perfect industry for data analysis. There is plenty of data – right from lead generation to to underwriting to policy issuance to administration to claims processing. With a careful and well thought data strategy insurance companies can become profitable. Power BI makes data analysis in insurance space a breeze. Whether […]

JSON (JaveScript Object Notation) is a popular and easy format to store, share and distribute data. It is often used by websites, APIs and streaming (real-time) systems. But it is also cumbersome and hard to use for performing typical data tasks like summarizing, pivoting, filtering or visualizing. That is why you may want to convert […]

DAX offers powerful way to analyze “new” vs. “returning” customers. In this article learn easy and simple DAX measure patterns to count number of new customers and number of returning customers from your data. What is a Returning Customer? A returning customer is someone who comes back to our business and does another transaction. For […]

Let’s say you have two lists of values in Excel and want to find out all the common values (ie duplicates) and extract them. In this article, let me explain the formulas for this. Formula for counting number of duplicate values in two columns: Here is the formula to count number of common values between […]

Ever have a report that is too big to fit in one screen but when you scroll you loose the context? Something like this.. Use FREEZE PANES option in Excel to “Freeze” top rows / columns We can use the excellent “Freeze panes” option in Excel to make the top few rows (and columns) sticky. […]