Category Archives: BI

Quick Analysis should NOT be done quickly!

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.

Quick Analysis

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!

Global Alert: CSV import Date Misinterpretation Problem – Part 2

This is a very common and dangerous inaccuracy.
Big operational risk!

CSV import date problem

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

Miracle: Instant Report Clean Up using Power Query

Reports generated from business applications often become inputs to new reports.

You end up spending too much time cleaning them up. Here is a new and unimaginably faster way of doing it – using Power Query.

Report clean up using Power Query

Estimated reading time 15 min
Estimated time saving huge!

 

Continue reading Miracle: Instant Report Clean Up using Power Query