how to start with your own data stories

How To Start with Your Own

Data Stories

Demetrios Pogkas Journalist / Business, Tech, Data BA, Communica:ons & Mass Media, University of Athens

Know Us Better

Journalist 27 yrs old Business & Tech Data Journalism

Why Data

4 400 000 000 000 0

GB produced in 2013 (IDC/EMC, 04/2014)

Data Data

Stories Vs Track Decide Internal

Tell Communicate

External

In Ad & Pr

“The mission of journalism is to inform [...] The business of journalism is to provide marketing partners with new ways to

reach consumers.” (Lewis Dvorkin for Forbes, 2012)

In Ad & Pr

“Data Is the Next Big Thing in Content Marketing”

(Alexandra Samuel for Harvard Business Review, 2015)

In Ad & Pr

Infographics Native Advertisements Brand Journalism Longforms

Some Inspiration

e-food.gr, 04/2014, e-food.gr/blog/o-%CF%87%CE%AC%CF%81%CF%84%CE%B7%CF%82-delivery-%CF%84%CE%B7%CF%82-%CE%B5%CE%BB%CE%BB%CE%AC%CE%B4%CE%B1%CF%82

Some Inspiration

e-food.gr, 02/2016, e-food.gr/blog/iphone-vs-android

Some Inspiration

e-table.gr, 09/2016, blog.e-table.gr/2-xronia-fagito-etablegr

Some Inspiration

Taxibeat, 05/2015, taxibeat.gr/2015/05/18/4-years-taxibeat

Some Inspiration

travelplanet24, 10/2014, blog.travelplanet24.com/2014/10/city-breaks-i-nea-tasi-stis-fthinoporines-apodraseis

Planning a Data Story

Collect Clean Analyse Visualise



YOU understand YOU extract YOU correlate YOU don’t mess up



They get it RIGHT

Beware!

“The wave of bullshit [P.R.] data is rising” (Jacob Harris for NiemanLab, 2014)

Planning your Data Story


Hands-on with Excel

(alternatively, use Spreadsheets or Calc)

Hands-on Excel The FinTech startup you’re working for wants to produce a visual with graphs to communicate its performance during the first 3 Q’s of 2016. The company’s analytics guru has exported for you a spreadsheet with raw CRM data on every transaction made during that period. It’s up to you to make sense out of the data in order to identify key metrics and interesting tidbits for the story you want to tell the audience.

Hands-on Excel 1) How many unique customers made a transaction during 2016Q1-Q3? (Remove Duplicates) 2) What is the total amount of transactions our product cleared? (Sum Function) 3) What is the average amount of money our customers spent? (Average Function) 4) How many transactions are coming from x country? (Countif Function) 5) Where women spent their money on most and where did men? (Pivot Tables) 6) Which geographical regions spent more money? (Conditional Formatting & Visual Basic

Editor – Macros)

Hands-on with Tableau

(alternatively, use plot.ly or JavaScript)

Hands-on Tableau Now that you got all the interesting stats and fun facts about your product out of your spreadsheet, it’s time to work some visuals magic. You know how to use Photoshop and infogr.am but you want to create a handful of line, bar and map plots to include in your final output.

Hands-on Tableau 1) What was the fluctuation of the total amount of transaction we cleared M/M in

2016Q1-3? (Line Plot) 2) Which activities do our customers spent their money on most? (Bar Chart) 3) Which locations our most active customers are coming from? (Heatmap)

In-lab Exercise

Use Excel and Tableau (or your favourite proprietary or open-source software)

Identify at least 5 key metrics (as big or as niche as you want) and measure their performance. Produce at least 2 graphs or maps for some of these metrics.

Thank You! Read: www.demetriospogkas.com Ping: [email protected] Connect: FB.com/demetriospogkas Follow: @pogkas

How to Start with Your Own Data Stories Panteion University, ADandPR Lab, December 14, 2016

how to start with your own data stories

Data & Analytics