Data Visualization

Analyzing global discussions with Exasol, Alteryx and the Twitter API

09 Oct 2018 | Share

How to use Alteryx and the Twitter API to transform and load the social media data into Exasol?

Us humans have shared stories for millennia, verbally, through pictures, and later through written language. With the rise of social media in the last decade, our ability to connect with others, be part of events and movements and contribute our voices to the greater conversation has become easier than ever.

Even if we can’t be present at every event that interests us, through digital media we can follow the action from afar, share things of interest and engage with a community online.

The United Nations’ General Assembly brings together all 193 member states with a session in late September each year, including numerous meetings, debates, initiatives and events. The UN’s Sustainable Development Goals (SDG) Action Campaign is a special initiative in the UN Development Programme and supports the public engagement on the implementation of the SDGs.

During the UN General Assembly, the SDG Action Campaign team is monitoring the conversations on Twitter surrounding the event, different interest groups and topics. To do this most effectively and to collect the data they need to analyze and visualize social media activity following the event, the team has been working with Exasol and the Information Lab.

In this collaboration, a small team of analysts came together to quickly and efficiently collect data, analyze and visualize it. The tools that were used include Alteryx for a workflow that pulls the data via the Twitter API, transforms it and loads it into Exasol where data is stored for fast analysis and processing by analytical software. Tableau is used to visualize the results and make them accessible to a wider audience.

Using Exasol, Alteryx and Tableau together has become a very popular approach for organizations that want to democratize data and put analytics into the hands of their business people.

Join our upcoming webinar on 16th October where we discuss and show in detail how the team used Alteryx and the Twitter API to transform and load the social media data into Exasol. We’ll show how you could easily build a data pipeline to collect information about a specific event or initiative

Eva Murray

Meet Eva Murray

As Exasol’s Head of Business Intelligence and Tableau Evangelist, Eva is responsible for executing Exasol’s data-driven strategy and developing our Center of Excellence. She is highly passionate about bringing data to more people and creating educational content and collaboration opportunities for data analysts across the world to create a community of like-minded professionals who drive action and change.

After studying psychology and business at the University of Wellington, New Zealand, Eva worked as an IT Consultant for Deloitte before moving to Sydney, Australia, as a Senior Solution Designer for Commonwealth Bank. Subsequently, she became a Tableau Consultant and Trainer for Tridant.

Outside of work, she is a keen triathlete, traveler and gelato addict, for which Nuremberg is the perfect environment.

Back to blog

Considering implementing an in-memory database?

Free White Paper