Power BI Cleaning and Transforming Data Pivot and unpivot columns in Power BI is very useful functionality for structuring data that cannot be used for reporting as-is. The first blog post on data preparation covered the basics of cleaning and transforming your datasets. This blog post, will go into more advanced cleaning and transformation steps
Data Preparation Part 2 – Pivot vs Unpivot Columns Read More »
Pivot and Unpivot walkthrough in Power BI Power Query in Power BI provides very effective functionality to pivot and unpivot columns. For the pivot functionality you turn rows to columns and for the unpivot functionality the inverse is true where columns are transformed into rows. Power BI Pivot We will be working with the following
Power BI: Pivot and Unpivot Columns Read More »
Welcome to our first of the Power BI Tips series. Over the past two weeks, I have been asked the same question by people who have just started the awesome journey towards revolutionizing their reporting experience through Power BI: “Instead of the default alphabetical sorting, how do I sort the months in my charts by
Power BI Tips: Sort by Month Name Read More »
So far I’ve given you a very small glimpse of this marvelous thing called Power BI, and the old (IT dependent) vs. the new (Self-service BI) approaches. Let’s quickly paint a scenario: You wake up one morning and you have a beautiful red Ferrari parked in your garage (Oh yeah!!)… but you decide to walk
Power BI: The Ferrari that never left the garage… Read More »
So here we are, it’s the year 2016 and things are looking sweeter than ever!!! Have you ever heard of Power BI? You haven’t? Well, you should get to know all about it…and for a very good reason. The old days… Long gone are the days when companies need the help of an IT
The good, the wonderful, the magnificent Power BI!!! Read More »
