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
Infographic: 5 Key Findings from the Content Marketing Maturity Report

Infographic: 5 Key Findings from the Content Marketing Maturity Report

A new report from London Research and ContentCal explores how content marketing leaders are able to excel at this discipline, and reap the rewards. The infographic below summarises five of the key findings.

Linus Gregoriadis
Linus Gregoriadis 18 October 2021
Read more
New Research Reveals Content Marketers’ Biggest Battle

New Research Reveals Content Marketers’ Biggest Battle

A crucial step in the journey to content marketing maturity involves converting senior management enthusiasm into an in-depth understanding of the benefits of a strategic approach, and what is required to establish one.

Michael Nutley
Michael Nutley 27 September 2021
Read more
7 reasons why social media marketing is important for your business

7 reasons why social media marketing is important for your business

Social media is quickly becoming one of the most important aspects of digital marketing, which provides incredible benefits that help reach millions of customers worldwide. And if you are not applying this profitable...

Sharron Nelson
Sharron Nelson 6 February 2018
Read more
Top 10 B2B Platforms to Help your Business Grow Worldwide

Top 10 B2B Platforms to Help your Business Grow Worldwide

Although the trend of a Business to Business portal is not new but the evolution of technology has indeed changed the way they function. Additional digital trading features and branding has taken the place of...

Salman Sharif
Salman Sharif 7 July 2017
Read more
Top 10 Skills to Become a Rockstar in Digital Marketing

Top 10 Skills to Become a Rockstar in Digital Marketing

Technology is continuously evolving, prompting marketers and entrepreneurs to dive into digital marketing to increase brand awareness, reach their target market, and ultimately drive sales and profit. 

Jessica Andriani
Jessica Andriani 7 September 2018
Read more