I have noticed that most customers are reluctant to pay the 9$ license cost for Power BI. Here is how you can use Power BI free of cost. I am a strong proponent of purchasing licensed software. This articles is not meant to show you how to cheat on the licensing cost. In fact, I will show you how to get tangible value by using Power BI free version so that you can easily justify the cost of the license with a strong and compelling business justification.
The idea is simple. Use Power BI just like we use Excel. Create Power BI Reports, save PBIX files on OneDrive / Teams. Share the reports with each other as links or attachments – exactly the way we do with Excel files. All users must have Power BI Desktop free version. This process does not cost any money. Power BI free version offers all the features and connectors with no time limit or restrictions.
Then the next question is – if this works for free, why pay Microsoft that 9$ per user per month license for Power BI Pro? Good question. Sharing PBIX files may seem satisfy your needs – but it has many disadvantages. Read on to find out more…
Continue reading How to use Power BI free of cost
While working with Power BI we often need to convert Seconds to Duration. This is easily done in Excel just by applying the formatting code “HH:MM:SS”. Unfortunately in Power Query or DAX, this is not possible. Here is the solution:
Continue reading Power BI Seconds to Duration
Grouping means combining multiple items into fewer items. It helps us consolidate and summarize things to understand them at a higher level of granularity. Let us see how to use Power BI Grouping done easily and quickly. This is useful for Ageing Analysis, Bin or Bucket Analysis, week / custom date range analysis.
Continue reading Power BI Grouping
Power BI is becoming popular. Therefore, many companies are interested in considering a Power BI Pilot project as a proof of concept. While interacting with customers, I have noticed that many such pilots fail. The failure is NOT due to the capabilities of the product, but due to other factors which are controllable. In this article, I have listed a process which prevents common errors and improves the credibility of the outcome.
Continue reading How to conduct a Power BI Pilot
PowerView button missing in Excel 2016 – Insert tab? It it visible in 2013. Here is how you add it.
Continue reading PowerView button missing?
A brilliant new feature is now available in Power BI – Split column into rows. To understand why we need it, you must go and read the article – Analyzing badly captured Survey data or feedback forms. This method used Power Query concepts of Split and Unpivot. Now these have been combined into a single, intelligent command called Split columns into rows. It sounds confusing at first. But soon you will realize that it is an amazing tool. Learn it just 4 minutes.
Raw data looks like this
And you get a report like this. No need to use formulas or do any manual work.
You must have the May 2017 update for Power BI Desktop installed.
Continue reading Split column into rows
This is a short post. It is like an FYI mail. Excel never understood any dates before 1900. We got used to that limitation over the decades. But Power BI does understand Dates before 1900. The best part is, you do not have to take any specific action. It just works.
Here is the raw data and the Power BI output.
If you try this in Excel, it just will not work. Now that you know this, starting using Power BI with Dates before 1900.
Mind you, the Power BI documentation says that the earliest limit is 1900. It still works for dates before 1900. Drill down is also supported. Here is the same data at Day level.
This ability may make historians and archeologists partially happy. There time scales are huge and Power BI does not support that much of a range. But still, it is an improvement worth knowing about.
As you know, I recently published a Power BI Desktop course on Udemy. A few days ago, I received a message from a potential student, Andrew, asking whether taking this course would help him. He wanted to know why Excel-based Power BI is not covered in my course.
Continue reading Power BI Desktop vs Excel-based Power BI
This keynote was delivered at the CIO Crown event in Mumbai (India), August 2016. 200+ CIOs attended the session. It was an honor to showcase the power of Office365 to a highly motivated and intelligent audience… love it!
View on YouTube
View it in 720p resolution in full screen for maximum impact.
Continue reading CIO Crown Session Video: Disruption, Transformation and Acceleration using Office
I am happy to announce that my first detailed training course is now up and running at Udemy. It is about Power BI. But it starts with what you already know – Pivot Tables. That is why the course is called Pivot Table to Power BI.
Continue reading Announcing Pivot Table to Power BI course