A major part of the ‘power’ which Power BI offers, can be attributed to a powerful self-service ETL tool in Power BI, called Power Query or otherwise known as the ‘Edit Query’ functionality in Power BI desktop. With a simple Graphical user interface (GUI), it can consume data from almost all data sources. It also
Power BI Tips: Discovering Power Query ‘M’ functions Read More »
You’ve probably faced a data analysis scenario of having to calculate year-to-date values to meet reporting specifications. And of course, for most data analysis cases involving dates, YTD is a widespread de-facto standard of evaluation. As some of you may have experienced, achieving year-to-date analysis, based on a selected year and period, in Excel is
Power BI Tips: Calculate Year-to-date Values 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 »
