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
We get data and make reports repeatedly. Often we forget to look at the same data in different ways. Due to this unbelievable amount of useful information is lost.
Act Now is a new idea I am trying. It asks you to do some activity and post the results.
Continue reading Act Now: Discover one new and useful thing from familiar data
Read the previous article to understand the context of this article. Quick Analysis gives you many types of data visualizations instantly. But that is NOT the real benefit. The real benefit – as usual – is elusive and difficult to grasp in this “instant” mode of living life.
Read on to find out what you are missing – even if you know how to use Quick Analysis!
Continue reading Quick Analysis should NOT be done quickly!
We are used to bar charts. But do you know that we can add bar charts within cells? Have a look and see what you were missing all this while! (These have been there for 8 years).
Continue reading Bar charts with a difference
Unbelievable analytics using Excel:
Here is a quick overview of how we can analyze data more effectively using new Excel tools. You can also refer to the collection of 51 articles about data analytics for a more detailed coverage. Data Analytics: Knowledge Pack.
This is a very common and dangerous inaccuracy.
Big operational risk!
Check all your dates imports after reading this article.
Share it with your colleagues as well.
Estimated reading time 15 min
Continue reading Global Alert: CSV import Date Misinterpretation Problem – Part 2
Yes. You read it correctly. Everyone does it. But still.It is very dangerous.
DO NOT do it.
Read on to find out why.
Estimated reading time 7 min
Continue reading NEVER import CSV files into Excel – Part 1
Here is the Power Pivot way of customizing sort order for any table.
Read the previous article first.
Estimated reading time 8 min
Continue reading Repairing Month Sorting Order in Power Pivot – Part 2
||If you use text month in a Power Pivot Table, it is sorted in alphabetical order.
Here is the solution to the problem.
Quick Solution time 2 min
Detailed reading time 15 min
Continue reading Repairing Month Sorting Order in Power Pivot – Part 1
Data Analysis and Reports has been a major theme for my articles so far.
Here is a collection of 50+ articles, categorized and sorted in the recommended reading order.
Continue reading Knowledge Pack: Data Analytics