Gramener Covers Yet Another Election Successfully

Gramener has once again demonstrated its #DataJournalism credentials by assisting Republic TV in creating simple and insightful data stories around Gujarat and Himachal Pradesh assembly election results. The whole project from ideation to execution was done in a 3 week period. A 10 member team consisting of designer, developers and testers worked in a agile fashion building visual storyboards, iterating on them based on input and making them ready for primetime. 

We thank Arnab & the Republic team for the opportunity  & making this a successful collaboration.

Team Gramener with Arnab

TV Analysts had this to say about Gramener’s Election visuals;

“Your graphics and election data management were simply super on screen, compliments”

“Your storyboards have taken Visual quality one notch above the rest”

The data stories were narrated using the below 3 Visual Storyboards. Source data was the data published by Election Commission of India.

COMPASS – This storyboard gives a comparison of constituency level result between 2012 and 2017. The visual comparison is also represented over a map of each state using a color code – Orange for BJP, Green for Congress and Yellow for OTHER parties. All assembly constituencies were broken down into BJP Strong, Congress Strong, BJP mild, Congress mild and Swinger. If a party won the last 3 assembly election in a constituency, it was grouped under Strong. If a party won 2 consecutive assembly elections of last 3 assembly elections, the constituency was grouped as Mild. All constituencies that are not Strong or Mild will fall under Swinger.

Live Tracker – This is a real time tracker would plot the performance of the leading candidate in each constituency on a Voter share %(Y axis) vs Lead % (X axis). Each constituency is represented by a bubble and the color of the bubble indicates the party that has the lead. Click on each bubble would show an overlay display the top 3 candidates in the constituency with Name, party they represent and the count of votes they received.

Color Map – This storyboard plots each of the constituencies as a bubble over the map of state. The color of the bubble indicates the party that has the lead. The comparative view of 2012 and 2017 shows the swing of electoral fortunes in each state.

Post analysis of election results point to an interesting fact. None Of The Above (NOTA) option ranked #3 in 115/182 constituencies in Gujarat state. In 30 constituencies the count of NOTA votes exceeded the victory margin of the winner. Interesting enough BJP won 15 of the 30 constituencies with INC winning 13 and Independents winning the remaining 2.

For glimpse of Gramener’s storyboards in action on Republic TV please look at video below. 

A round-up of #Dataviz at Gramener in 2017

We’ve had a lot of fun at Gramener in 2017 creating some exciting dataviz. It is that time of the year to look back with satisfaction and also spark the desire to do even better dataviz in 2018. This post is a round-up of some of our favorite work this year.

Two of our dataviz properties found their way to Andy Kirk’s ‘Best of the Visualization Web’ in 2017. The interactive Elvis Presley Jukebox was a result of one of our experiments in creating data portraits.

Interactive Elvis Presley Jukebox

The exploratory viz on  ‘voting patterns of senators’ was the other to get listed in Andy Kirk’s Best of the Visualization Web in 2017. The visual techniques used in this work in particular inspired the data community to discussing merits and demerits of the representation. Dataviz guru Alberto Cairo described  it as a ‘simple but rich graphic’. Famed Statistician Andrew Gelman wrote a critique of the viz suggesting improvements – Alberto Cairo responded  with a powerful improvisation. Here’s how the original version looks.

Senator Voting Patterns


At Gramener we’ve done a lot of dataviz on Cricket already but we just couldn’t resist the temptation to create another one, this time an interactive infographic – Dhoni’s ODI Sixes

Dhoni’s ODI Sixes

In the guise of analysis we also had a lot of fun listening to Kishore Kumar.

Exploring the works of Kishore Kumar

We did an analysis on the Independence Day speeches of Prime Ministers.


Our folk too were bitten by the GOT bug.

Ned Stark Refuses to Die

We were not to be left behind in the iPhone mania as well.


Sketchnotes make excellent communication narratives. Here’s one of our sketches.


We tried our hands at different narrative techniques to communicate the enormity & context of numbers. Sometimes a simple juxtaposition of images & text helps like in this one.

Our designers had a great time at the design hackathon. Here’s the winning entry;

Winners – Design Hackathon

The runners up came up with some fantastic work as well. You can view them over here and here.

Other interesting reads include our analysis on Silk-Board traffic , the curious nature of names, the power of defaults & the different aspects of Data Science .

Hope you enjoyed our work throughout this year. We hope to bring you more exciting data visualizations, infographics, data stories & sketches in the forthcoming new year. Thanks for reading. Wishing you the very best for 2018.

Talking Movies – ‘OK’, how about Talking Data!!

By Amit Pishe

During childhood, we were all at some point pushed or encouraged to participate in Story Telling competition. Story telling had key characters and depiction of inanimate things described through words which kind of used to create some picture or motion in our minds. Stories were used to teach and learn.

Nothing much has changed today in applying the same ‘storytelling’ concept for data/datasets – in what we now call Narratives/ Data Narratives.

Big Data is the buzz word, however visualising and explaining the entire dashboard may pose some challenges, not all the info displayed may be required for all the users.

Narratives/Data Narratives come in handy to pass on all the relevant information, yet being easy to grasp it succinctly. Narratives are basically the Talking data (highlighting insights, trends, unique patterns, exploring factors shaping data) for the data driven stories, they provide crisp, concise information. More advanced in a visualization dashboard format, trying to tell us the characteristics of data.

Leveraging the Data Narratives and writing one (in general):

  1. Understanding the overall data components (metrics & dimension), individually mapping those to weave a story line for a given chart/dashboard. Story line is the central theme of the narration. Always question yourself, why are you considering only that particular data component
  2. Storyline can be translated in multiple ways, pick any one version and compare how it scores with the rest. Are all the data points included?
  3. Flow of information/ insight should transition effectively throughout story without abruptly ending
  4. Target audience needs to be kept in mind – BFSI, Health care, Media, Telecom etc. to provide information accordingly.
  5. Get to know the Inputs, Analysis of the data, result orientation and finally conclusion

Sample Template/use case (Investment Banking): for a given Business user (Racey) by an Indian bound Mutual Fund investment banking firm.

Wealth Management Report

Date: dd-mm-yyyy

Dear Racey,

Information about your portfolio

a. Portfolio update for Last quarter vs current month growth/loss. Net worth for the year ending financial fiscal. Peer rating compared to other investors. Benchmarking the performance.

b. Equity portfolio – returns on investments information, fund index and NIFTY. Type of investments in different segments (Mid cap, advantage funds, MIP and so on). Display chart with comparison between CRISIL, NIFTY, current portfolio returns

Similar investors at our bank has given a return of 8.3%. Crisil Composite Bond Fund Index has given a return of 5.4%. NIFTY has given a return of 2.0%. Your portfolio has given a return of 15.8%, i.e. on par with or better than Similar investors at our bank, Crisil Composite Bond Fund Index and NIFTY

c. Fixed income portfolio details (~ 1% of total portfolio) are mostly in intermediate term funds, this investment is driven by short term plan growth investments options.

d. Your Portfolio description through charts spread across segments

Your equity investments (99% of total portfolio) are mostly in large cap growth oriented funds. Your portfolio is dominated largely by Canara Robeco Treasury Advantage Fund – Institutional Plan- Growth option, UTI – Treasury Advantage Fund – Institutional-Growth and HSBC MIP – Savings – Growth.

e. Suggestion on investment – based on average cash balance in savings account (~15% of savings into xxx plan). I would suggest investing in Pure Value fund growth options

For the detailed report, please refer

Gist: In the sample example, the data components are underlined (Portfolio, Equity portfolio, Fixed income portfolio and so on). The entire dashboard would have multiple other charts, the key data component points will provide holistic view without going into too much specifics.

  1. Main summary is to highlight on how the user portfolio is performing over variety of time periods, provide benchmarking info and analyse the saving patterns of the user.
  2. Based on the savings, suggest the investment as a conclusion.