Text Visualizations with manyeyes

Text and Data visualization ? Try many eyes.

You can explore and create spectacular and compelling data visualizations. The name of the site is apt as you can view data through "manyeyes".

You need to register to log in to use your own data. 

well in addition to normal visualizations, the best part of the site is text analytics. This is quite important in the context that everyone is viewing to get insights of from huge piles of data generated on social media! Bringing out essence from text is made possible through various text analytical tools available.

Here, I present you the way religions describe The God. I have taken from Internet how various religions describe The God.

Sabka Malik Ek......means - One God Governs All

This is how It appears if I create a Word Cloud without editing data!

This is an example.

You can load your own data like text of your own speech, text from an article etc. and analyze the essence of the text!

Just to ignite your thoughts... 

~ Use the brand message text...
~ Use your CEO's Speech...
~ Use your brand detailing story...
~ Use text from your own presentation....
~ Use Ted Transcripts

I recommend Word Cloud  and Word Tree 

Word Cloud to know what the audience will hear from you (Top most repeated words. Obviously! )

Word Tree to know how a word is contexted.

Visit the site Watch the Video to learn more! Click the link. 

Many Eyes

Outlook 2010 - Edit "Subject" of a Message

Most often,you find the e mail messages from Outlook  go to and fro between people without any change in the "Subject" that gives you an idea or hint about the content of the message. 
      As the conversation grows,more and more mails accumulate either with "FW:" or "RE:" without change of "Subject".You may now find it difficult to trace the appropriate mail.
A simple solution to this is : Editing the subject to a meaningful and recognizable header to trace it easily for future reference.
To edit the "Subject" , follow these 4 Simple Steps..
 Step 1: Open the message.
 Step 2: Click Action >>  Edit Message (as shown in the picture)
 Step 3: Go to Subject>> Edit it and close the message.

 Step 4: When it prompts you to Save changes,Click Yes.

Extracting bounced back email IDs from Outlook : Addressing the pain point in e-mail marketing

Email  marketing is abuzz! 

With great efforts you collect e mail Ids. With greater enthusiasm you send e-mails.

Click Send.
Give the system a sec…A series of bounced mail ids land in to your Inbox…. 

The reason , Wrong Mail Ids…..
Now the job is to compile all wrong mail Ids from all those bounce back mails or Wrong mail Ids. It’s dreadfully painful (Is this expression correct ?)to go to each return mail and collect the Id.

Recently I faced similar challenge! 
I Googled and bumped in to looooong Macros. 
Some suggested Import export…I tried and failed with all those solutions and may be because of ability to understand and execute the solution... and then….

Falsh $#@%^&* Flash…….!

New Idea !   Indian Jugad ! Quick and Dirty !

The Idea is as simple as ... Select , Copy and Paste.

Ctrl + A , Ctrl + C and Ctrl + V.

Here below is the explanation….

Open the  Outlook  .

Keep all mail Delivery failures in a Folder. Now do the following as shown in...

Picture 1 : On the fields bar , Select Field Chooser

Picture 2 : Menu Opens up like this. Drag to  the fields bar
Picture 3 : Now you have  “to” Mail Id and Other fields

Now It's just  Ctrl + A , Ctrl + C .

Open Excel and Ctrl + V.

Bingo… Now you have an excel with a column full of wrong mail Ids....

It was an eureka moment when I found the simplest solution. I was remembering the story...Americans had spent millions of dollars to invent a pen that writes in space where as Russians wrote with pencil !

Jugaad Zindabad

Identifying level for description of IMS data in Excel

This post/ tip is for Pharma market research professionals who use IMS data.
IMS Health uses EphMRA (European Pharmaceutical Marketing Research Association) classification system across the world while producing data.

These codes when downloaded from some IMS Data sources are demarcated by several "empty spaces" before each code/description. As the excel download of the data will have hundred of rows, identifying the level through a formula will make analytics easy.
Here is a simple solution using excel formulae.
You can download the excel file here or @Downloads.

Create Stunning Timelines in a Jiffy on PPT

Show timelines in presentations with a Style! 
Bring in the WOW factor.
Here is an Office add-in you can use to create stunning and great looking timelines. 
The add-in is absolutely free and can be downloaded here. It has an easy to use interface and wizard that helps you create timelines in a jiffy! Download Office Timeline add-in here

With a Free edition, you can create an unlimited number of timelines, Change, Edit them on the fly.
It's absolutely free, easy to use, creates stunning timelines on a PowerPoint. I recommend It.

Watch the Timelines in Action here

Cartograms - It's a new World out there...

A couple of days back, I had an idea to create World Map based on variables such as Population, GDP, Per capita health care expenditure etc.
I was excited...I thought I found a new visualization model...I dreamt of  ...name.....fame...new contribution to the world of visualization...
Then, I did a little search on Google. I understood such visualizations are in vogue and are called Cartograms...
In the end, I cursed that someone copied my idea even before I could conceive it...
However, I have come to terms with it...

Let's see what these Cartograms are..
For those who are familiar with Bubble Charts, understanding Cartogram is easy...
Cartograms are simply maps of the world wherein the size of an entity like a country or a Continent is proportional to the size of the variable being depicted.

Let me give you an example.

If we were to create a Cartogram of the world based on the Area of each country, you will see the Map exactly like the world map we see... Like the one on the right side...

If we were to create a cartogram of the world based on the Population of each Country, you will see the map like this. on the left side...

You will see the world from a different viewpoint...


World Mapper is one such brilliant site that Created innumerable Cartograms. Many are available for Free download as Posters...

Maps by Mark Newman, data by Danny Dorling, text by Anna Barford, quality control by Ben Wheeler, website by John Pritchard, poster design by Graham Allsopp, and individual country maps by Benjamin Hennig.
There are few software programs to create Cartograms.
Visit Cartogram Central for exploring the options.

I tried to recreate the same on Excel with varied results.
I will share with you the template once I have a fair amount of success. Share with me if you have any ideas on creating Cartograms in Excel.
Till then, enjoy World Mapper.
For more information on Cartogram, click the link below
Cartogram Types

Numbers numbers all the way!

You often hear statements like "Our company has 2 billion dollar turnover"

Do you know what a billion is ? Can you write down the number ?

I guarantee that most can not write this most often used number .I have an easy way to remember!

1,000 is 10 to the power of 3 - so to say one followed by 3 zeros 

                 i.e 10 X 10 X 10 written as 10^3

1,000,000 is 10 to the power of 6 is  Million....

1,000,000,000 is 10 to the power of 9 is a Billion 

1,000,000,000,000 is 10 to the power of 12 - Trillion

The trick is remembering  the 3 Table

• 10^3 is Thousand,
• 10^6 is Million,
• 10^9 is Billion,
• 10^12 is Trillion and
• 10^15 is Quadrillion and so on....

Here are some fun facts:

Zillion : Means a very large number. This has no defined Mathematical meaning!

Googol : This is the number from where Our "Google" name originated!

googol means 10^100 ie 10 to the power of 100!, one followed by 100 zeros!

Googolplex :  Means  10^Googol ie 10 raised to the power of Googol

in Mathematical terms it is 10^10^10^2

I can not write this number @#$!%^&  
Sure, I am not going to get a job in a company that has a Googol or Googolplex dollar turnover!