Article

Nikhil Goyal
Nikhil Goyal 24 October 2014
Categories Data & Analytics

Practical Tips For Working On A Data-Driven Report

How can you tell a story using data?

As a data analyst, one is constantly talking to an audience that is short on time, does not like complexity and prefers opening up for Q&A half way through the cover slide! My experience working with fragmented and large data sets have taught me a few things:

 

Give some thought to how the data should be extracted: You cannot build an insightful visualization unless you have the data behind it in the right shape. Whenever possible, extract the data in the format closest to the desired format for analysis. A simple arrangement of rows and columns during extraction can often save much time and heart-burn in reshaping / cleaning the data to a form suitable for graphing. In certain cases, the front end of the data warehouse may not have enough flexibility for extracting data – in such cases, try to get access to the location where the data actually lives behind the front end- chances are it will be an SQL / db2 database. You will discover a treasure trove of information which hides behind the mask. (Beware: getting access might be a long term battle – not one to be fought with a deadline lurking around the corner.)

 

Marry the agenda with the data-preparation: Analysts are often torn between two choices (a) drilling down deeper and deeper or (b) sticking to a script and timelines. There are obvious merits and traps in both approaches and therefore finding a balance is important. To achieve this balance, even before starting the data cleaning, I design a flexible agenda for the report with branches / sub points. After this, I map each section of the agenda to the exact format in which I need the data to perform the analysis. This makes the data cleaning process more focused and efficient. For e.g. the overview section of the agenda may require data on an hourly level time-series across 6 metrics.

 

Please login or register to add a comment.

Contribute Now!

Loving our articles? Do you have an insightful post that you want to shout about? Well, you've come to the right place! We are always looking for fresh Doughnuts to be a part of our community.

Popular Articles

See all
How to Review a Website — A Guide for Beginners

How to Review a Website — A Guide for Beginners

A company website is crucial for any business's digital marketing strategy. To keep up with the changing trends and customer buying behaviors, it's important to review and make necessary changes regularly...

Digital Doughnut Contributor
Digital Doughnut Contributor 25 March 2024
Read more
The Impact of New Technology on Marketing

The Impact of New Technology on Marketing

Technology has impacted every part of our lives. From household chores to business disciplines and etiquette, there's a gadget or app for it. Marketing has changed dramatically over the years, but what is the...

Alex Lysak
Alex Lysak 3 April 2024
Read more
How to Understand Your Customer Needs Through Social Media?

How to Understand Your Customer Needs Through Social Media?

Social media is generally known to be a tool of online communication that is used to easily share information and bring together people with similar ideas on the internet. But brands use them as a marketing tool. And...

Manisha Sukhyani
Manisha Sukhyani 29 August 2017
Read more
Sales and Marketing Collaboration: A Recipe for B2B Success

Sales and Marketing Collaboration: A Recipe for B2B Success

In the world of B2B, the age-old rivalry between Sales and Marketing often overshadows the potential for a fruitful partnership. Yet, when these two departments align their goals, strategies, and efforts, the results...

Zsofia Raffa
Zsofia Raffa 12 September 2024
Read more
3 Reasons Why Building Social into Marketing is a Significant Competitive Advantage

3 Reasons Why Building Social into Marketing is a Significant Competitive Advantage

Understanding the role of social media in your business is important; however, before you get caught up in tactics first ask yourself “Is my business social?” If not, or if you aren’t sure, here are 3 reasons why...

Anna Fox
Anna Fox 31 October 2024
Read more