Category Archives: Data

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

Understanding Excel Dashboards – the practical way.

Current fashion is about Big Data and Analytics. One related term is very popular – Excel Dashboards. Let us start understand the concept first and then explore the  benefits and methods of creating useful Dashboards.

Data visualization with Excel Dashboards

Estimated reading time 10 min

Continue reading Understanding Excel Dashboards – the practical way.

Knowledge Pack: Data Accuracy in Excel

We take accuracy of Excel data for granted.

Often the raw data as well as results of formulas can be wrong, outdated or misleading.

Here is a collection of 13 data accuracy articles which will help you ensure the integrity  of  your Excel data with minimal effort.

Excel data accuracy knowledge pack

Continue reading Knowledge Pack: Data Accuracy in Excel

Using color to simplify interpretation and enhance analysis

Older version of Excel could display only 52 colors. New version (2007 onwards) can display 16 million colors. Yes, that sounds like an overkill, but Excel uses this extra capability in a brilliant way. It provides us with a very easy and useful method of using color to understand information more easily. Read on to find out how…

Use colors for easier analysis in Excel - Dr. Nitin Paranjape Continue reading Using color to simplify interpretation and enhance analysis

High, Medium, Low – visual categories – In-Depth

Please read the previous article so that you understand the context of this article.

In the previous article we saw how to divide available data into three categories: High, Medium, Small. In this article we will explore how to refine this process and have up to 5 categories of classification. We will also see how business context helps you decide the type of visualization.

image

Continue reading High, Medium, Low – visual categories – In-Depth

Show High, Medium, Low values in few clicks

We get lot of data and reports every day. Usually, to understand the information easily, we draw charts. Nothing wrong with that. Except that there are other methods available which may be more effective. Here is one such method which divides the data into three categories – high, medium and low.

image

Continue reading Show High, Medium, Low values in few clicks