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
Digital Marketing Vs. Traditional Marketing: Which One Is Better?

Digital Marketing Vs. Traditional Marketing: Which One Is Better?

What's the difference between digital marketing and traditional marketing, and why does it matter? The answers may surprise you.

Julie Cave
Julie Cave 14 July 2016
Read more
14 Amazing Examples Of Brands Killing It With Facebook Ads

14 Amazing Examples Of Brands Killing It With Facebook Ads

How do you design the perfect Facebook ad that converts? A lot of people will start throwing money at Facebook, but not see any success. This comes either because they don’t have a proper strategy for their Facebook ads or their ads are not well designed. But for those brands which have a good strategy and work hard to test and refine their advertising, Facebook ads can generate huge profits. And we’ve found 14 of such examples.

Luisana Cartay
Luisana Cartay 11 December 2017
Read more
4 Important Digital Marketing Channels You Should Know About

4 Important Digital Marketing Channels You Should Know About

It goes without saying that a company can't do without digital marketing in today's world.

Digital Doughnut Contributor
Digital Doughnut Contributor 5 November 2014
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 traditional outreach methods to get in touch with targeted buyers or sellers.Here are some of the best and fastest growing global B2B platforms that are helping thousands of businesses in the world to grow and reach their international and local clients.

Salman Sharif
Salman Sharif 7 July 2017
Read more
Collection Of The Best Email Testing Tools Online

Collection Of The Best Email Testing Tools Online

Don’t be afraid of email testing. There are many free or freemium tools online that can help you with testing your SPAM score, deliverability and even the rendering of your email. We feature 30 email testing tools in this article. Check out the complete list!

Roland Pokornyik
Roland Pokornyik 31 October 2016
Read more