Big Data @ CBS
Dr. Piet J.H. DaasMethodologist, Big Data research coördinator
April 20, Enschede
StatisticsNetherlands
Experiences at Statistics Netherlands
Overview
2
• Big Data
• Research theme at Statistics Netherlands
• Examples of our work
• Lessons learned
• Important topics in 2015
– Data, data everywhere!
X
Two types of data
Primairy data Secondary data
Our ‘own’ surveysData from ‘others’
- Administrative sources- Big Data
4
CBS
Big Data research at Stat. Netherlands
– Exploratory, ‘data driven’‐ Cases: Road sensor data, Mobile phone data, Social media‐ There is no standard Big Data methodology (yet)
– Combination of IT, methodology and content (Data Science)
– Important issues for official statistics‐ Getting access‐ Selectivity (representativity)‐ Data editing at large scale‐ Data reduction (dimension reduction)
5
Results of case studies
Example 1: Roads sensors
Road sensor (traffic loop) data‐ Each minute (24/7) the number of passing vehicles is
counted in around 20.000 highway ‘loops’ in theNetherlands• Total and in different length classes
‐ Nice data source for transport and traffic statistics(and more)• A lot of data, around 230 million records a day• Our current dataset has 56 billion records!
Locations
7
Dutch highways
8
Dutch highways with road sensors
9
Road sensor data
10
Large vehicles (> 12m)
All vehicles All vehicles
All vehicles
Minute data of 1 sensor for 196 days
11
‘Afsluitdijk’ (IJsselmeer dam)
12
‘Afsluitdijk’ (IJsselmeer dam) (2)
Cross correlation between sensor pairs-Used to validate metadata
Trajectory speed vs. point speed- Average speed is 98 Km/h
Overall process
Clean
Transform &Select
Aggregate
Frame
14
‘Reducing’ Big Data
15
Traffic index (prototype)
NUTS 3 area basedtraffic indexes
‐for the main roads‐ per month / week
Example 2: Mobile phones
Mobile phone activity as a data source
– Nearly every person in the Netherlands has a mobile phone‐ Usually on them and almost always switched on!‐ Many people are very active during the day
– Can data of mobile phones be used for statistics?‐ Travel behaviour (of active phones)‐ ‘Day time population’ (of active phones)‐ Tourism (new phones that register to network)
– Data of a single mobile company was used‐ Hourly aggregates per area (only when > 15 events)‐ Especially important for roaming data (foreign visitors)
17
Travel behaviour (of mobile phones)Mobility of very activeactive mobile phone users
‐ during a 14‐day period‐ data of a single mob. comp.
Based on:‐ Mobile phone activity‐ Location based on phone masts
Observed:‐ Includes major cities‐ But the North and South‐east
of the country are much lessrepresented
18
‘Day time population’
– Hourly changes of mobilephone activity
– 7 & 8 May 2013
– Per area distinguished
– Only data for areas with> 15 events per hour
19
Tourism: Roaming during European league final
Hardly anyLowMediumHighVery high
20
Example 3: Social media
– Dutch are very active on social media!‐ Around 60% according to a surveyna altijd bij zich en staat vrijwel altijd aan
• Steeds meer mensen hebben een smartphone!
– Mogelijke informatiebron voor:‐ Welke onderwerpen zijn actueel:
• Aantal berichten en sentiment hierover
‐ Als meetinstrument te gebruiken voor:
• .
Map by Eric Fischer (via Fast Company)21
Dutch Twitter topics
38
(46%)
(10%)(7%)
(3%)
(5%)
12 million messages
(7%)
(3%)
(3%)
23
Sentiment in Dutch social media– About the data
‐ Dutch firm that continuously collects ALL public social media messageswritten in Dutch
‐ Dataset of more than 3.5 billion messages!• Covering June 2010 till the present• Between 3‐4 million new messages are added per day
– About sentiment determination‐ ‘Bag of words’ approach
• List of Dutch words with their associated sentiment• Added social media specific words (‘FAIL’, ‘LOL’, ‘OMG’ etc.)
‐ Use overall score to determine sentiment• Is either positive, negative or neutral
‐ Average sentiment per period (day / week / month)• (#positive ‐ #negative)/#total * 100%
Daily, weekly, monthly sentiment
24
Sentiment per platform(~10%) (~80%)
Table 1. Social media messages properties for various platforms and their correlation with consumer confidence
Correlation coefficient ofSocial media platform Number of social Number of messages as monthly sentiment index and
media messages1 percentage of total (%) consumer confidence ( r )2
All platforms combined 3,153,002,327 100 0.75 0.78
Facebook 334,854,088 10.6 0.81* 0.85*Twitter 2,526,481,479 80.1 0.68 0.70Hyves 45,182,025 1.4 0.50 0.58News sites 56,027,686 1.8 0.37 0.26Blogs 48,600,987 1.5 0.25 0.22Google+ 644,039 0.02 -0.04 -0.09Linkedin 565,811 0.02 -0.23 -0.25Youtube 5,661,274 0.2 -0.37 -0.41Forums 134,98,938 4.3 -0.45 -0.49
1period covered June 2010 untill November 20132confirmed by visual inspecting scatterplots and additional checks (see text)*cointegrated
Platform specific results
26
Schematic overview
27
Vorige maand Maand
Consumer Confidence
Publication date (~20th)
Social media sentiment
Dag 1-7 Dag 8-14 Dag 15-21 Dag 22-28Previous month Current month
Day 1-7 Day 8-14 Day 15-21 Day 22-28
Sentiment
Results of comparing various periods
28
Consumer Confidence Facebook Facebook Facebook+ Twitter * Twitter
0.81* 0.84* 0.86*
0.85* 0.87* 0.89*
0.82 0.85 0.87
0.82* 0.85* 0.89*
0.79* 0.82* 0.84*
0.79 0.83 0.84
0.82* 0.86* 0.89*
0.79* 0.83* 0.87*
0.75* 0.80* 0.81*
LOOCV results*cointegration
Overall findings
29
– Correlation and cointegration‐ 1st ‘week’ of Consumer confidence usually has 70% response‐ Best correlation and cointegration with 2nd ‘week’ of the month
• Highest correlation 0.93* (all Facebook * specific word filtered Twitter)
– Granger causality‐ Changes in Consumer confidence precede changes in Social media
sentiment‐ For all combinations shown!
• Only tried linear models so far
– Prediction‐ Slightly better than random chance‐ Best for the 4th ‘week’ of month
‘Sentiments’ indicator for NL (beta-version)
30
Displays average sentiment of Dutch public Facebook and Twitter messages
Lessons learned (so far)
The most important ones:1) There are many types of Big Data2) Know how to access and analyse large amounts of data3) Find ways to deal with noisy and unstructured data4) Mind‐set for Big Data ≠ Mind‐set for survey data5) Need to beyond correlation6) Need people with the right skills, knowledge and mind‐set7) Solve privacy and security issues8) Data management & costs
31We are getting more and more grip on these topics
Important research topics for 2015
1) Profiling‐ Extracting features from ‘units’ in Big Data sources
• Use this to study i) population changes and ii) input forways to correct for selectivity
• For persons: ‘gender, age, income, education, origin,urbanicity, and household composition’
• For companies: ‘number of employees (size class), turnover,type of economic activity, legal form’
2) Data editing at large scale‐ Combination of methods/algorithms and IT
3) Data reduction (dimension reduction)‐ Reduce size of Big Data while retaining similar information
content (not sampling!)
The Future
33
Thefuture
ofstatistics
looks
BIG
Thank you for your attention !@pietdaas