Recap of the 15th Data & AI Meetup: Reinforcement Learning; TensorFlow on Azure; Visual Analytics

200 attendees at the 15th Data & AI Meetup at DB Systel in Frankfurt, Germany
200 attendees at the 15th Data & AI Meetup at DB Systel in Frankfurt, Germany

Yesterday we had an amazing Data & AI Meetup in Frankfurt! Let’s have a quick recap!

The venue: DB Systel’s Silberturm

DB Systel kindly hosted the 15th iteration of our Data & AI Meetup on the 30th floor of the Silberturm in Frankfurt, Germany.

Welcome & Intro

Darren Cooper and I had the pleasure to welcome 200 Data & AI enthusiasts! Furthermore, we were happy to announce that our Data & AI Meetup group has 1,070 members and our brand new Data & AI LinkedIn group already has 580 members.

Reinforcement Learning of Train Dispatching at Deutsche Bahn

Dr. Tobias Keller, Data Scientist at DB Systel, showed in his session how Deutsche Bahn aims at increasing the speed of the suburban railway system in Stuttgart (S-Bahn) using Artificial Intelligence. In particular, a simulation-based reinforcement learning approach provides promising first results.

TensorFlow & Co as a Service

Sascha Dittmann, Cloud Solution Architect for Advanced Analytics & AI at Microsoft, showed in his presentation, how TensorFlow and other ML frameworks can be used better in a team through appropriate Microsoft Cloud services. He presented different ways of how data science experiments can be documented and shared in a team. He also covered topics such as versioning of the ML models, as well as the operationalization of the models in production.

Visual Analytics: from messy data to insightful visualization

Daniel Weikert, Expert Consultant at SIEGER Consulting, showed in his session the ease of use of Microsoft Power BI Desktop. He briefly highlighted the AI Capabilities which Power BI provides and showed a way on how to get started with messy data, doing data cleaning and visualize results in an appealing way to your audience.

Speaking at an upcoming Data & AI meetup?

If you’ve dreamed of sharing your Data & AI story with many like-minded Data & AI enthusiasts, please submit your session proposal or reply to the recap tweet:

#data19 Visual Diary: Tableau Conference Europe 2019 in Berlin

Let me share some of my favorite #data19 impressions from Tableau Conference Europe 2019 in Berlin with you (like I did for TC18 in NOLA last year)!

Sunday, 16 June

Arriving in Berlin

Monday, 17 June

Viz for Social Good

Makeover Monday

Welcome Reception

Tuesday, 18 June

Opening Keynote

Data Village | Diversity and Inclusion

Customer Session | Digital Journey of Deutsche Bahn

Data Night Out

Wednesday, 19 June

Tableau Public booth

Customer Session | Leveraging Social Media at Commerzbank

Data Village

Goodbye

What are your #data19 highlights?

Share your favorite moments in the blog post comments or reply to this tweet:

How to research LinkedIn profiles in Tableau with Python and Azure Cognitive Services

Tableau is using Python to access the Web Services API provided by Microsoft Azure Cognitive Services
Tableau is using Python to access the Web Services API provided by Microsoft Azure Cognitive Services

A few weeks after the fantastic Tableau Conference in New Orleans, I received an email from a data scientist who attended my TC18 social media session, and who is using Azure+Tableau. She had a quite interesting question:

How can a Tableau dashboard that displays contacts (name & company) automatically lookup LinkedIn profile URLs?

Of course, researching LinkedIn profiles for a huge list of people is a very repetitive task. So let’s find a solution to improve this workflow…

1. Python and TabPy

We use Python to build API requests, communicate with Azure Cognitive Services and to verify the returned search results. In order to use Python within Tableau, we need to setup TabPy. If you haven’t done this yet: checkout my TabPy tutorial.

2. Microsoft Azure Cognitive Services

One of many APIs provided by Azure Cognitive Services is the Web Search API. We use this API to search for name + company + “linkedin”. The first three results are then validated by our Python script. One of the results should contain the corresponding LinkedIn profile.

3. Calculated Field in Tableau

Let’s wrap our Python script together and create a Calculated Field in Tableau:

4. Tableau dashboard with URL action

Adding a URL action with our new Calculated Field will do the trick. Now you can click on the LinkedIn icon and a new browser tab (or the LinkedIn app if installed) opens.

LinkedIn demo on Tableau Public

Is this useful for you? Feel free to download the Tableau workbook (don’t forget to add your API key), leave a comment and share this tweet:

#TC18 Visual Diary: One Big-Easy Data Fest

Iron Viz contest at Tableau Conference TC18 in New Orleans
Iron Viz contest at Tableau Conference TC18 in New Orleans

Let me share some (personal) Tableau Conference #TC18 experiences with you!

Oct 22

Registration

Viz for Social Good

Welcome Reception

Oct 23

Opening Keynote

My 1st Session | Rock your Social Media Data with Tableau

Data Village | Diversity and Inclusion

Community Appreciation Reception

Oct 24

Keynote | Devs On Stage

My 2nd Session | Rock your Social Media Data with Tableau

Tableau User Group | Tip Battle

Iron Viz

Data Night Out

Oct 25

Keynote | Adam Grant

Data Village

Fanalytics

Goodbye

What are your #TC18 highlights?

Share your favorite moments in the blog post comments or reply to this tweet:

#TC18 Sessions: Rock your Social Media Data with Tableau

My TC18 sessions in New Orleans: "Rock your Social Media Data with Tableau"
My TC18 sessions in New Orleans: “Rock your Social Media Data with Tableau”

Anyone can analyze basic social media data in a few steps. But once you’ve started diving into social analytics, how do you bring it to the next level? This session will cover strategies for scaling a social data program. You’ll learn skills such as how to directly connect to your social media data with a Web Data Connector, considerations for building scalable data sources, and tips for using metadata and calculations for more sophisticated analysis.

First session: Tues, 23 Oct,  12:30-1:30 (Location: MCCNO – L3 – 333)

Second session: Wed, 24 Oct, 10:15-11:15 (Location: MCCNO – L3 – 346)

Twitter Analysis #TC18 Dashboard featured as Tableau Public Viz of the Day
Twitter Analysis #TC18 Dashboard featured as Tableau Public Viz of the Day

Here are some key takeaways and links (i.e. additional resources) featured during my TC18 sessions to help you formulate your social media data program in order to build a stronger presence and retrieve powerful insights:

Prolog: Introducing data artist Noah

Step 1: Understand How to Succeed with Social Media

Apple has officially joined Instagram on 7th August 2017. This isn’t your average corporate account as the company doesn’t want to showcase its own products. Instead, Apple is going to share photos shot with an iPhone:

The Customer-Centric Data Strategy

Apple’s Instagram account is more an extension of the “Shot on iPhone” billboard ad campaign.

And there are plenty takeaways for every business:

  • Wrap your data around your customers, in order to create business value
  • Interact with your customer in a natural way
  • Understand your customer and customer behaviour better by analyzing social media data

Step 2: Define Your Social Objectives and KPIs

A previous record-holding tweet: In 2014, actor and talk show host Ellen DeGeneres took a selfie with a gaggle of celebrities while hosting the Oscars. That photo has 3.44 million retweets at the time of writing:

Social Objectives:

  • Define specific KPIs for social media platforms
  • KPI objectives need to be measurable
  • Metrics should be in line with the business goals

Step 3: Assemble Your KPIs

Brand Awareness and Reputation

Step 4: Connect Your Social Media with Tableau

Option 1 – Directly from the platform: Get data directly from Facebook, Twitter, YouTube, and more

Option 2 – Via web automation: Use a service like IFTTT to store data on Google Sheets

Option 3 – Via web data connector: Use Tableau’s web data connector, e.g. the Twitter Web Data Connector by Alex Ross (a.k.a. Tableau Junkie) -> http://bit.ly/tc18_twitter

Option 4 – Code your own solution: Use an API provided by the platform -> http://bit.ly/tc17_r_fetch

Option 5 – Via a third party platform: Get data from an integrated social media platform, such as Talkwalker -> http://bit.ly/tc17_talkwalker

Talkwalker - Via a Third Party Platform

Step 5: Apply some Tips to Level Up

Gather Historic Data

Step 6: Explore Social Media Listening

Social listening means that you look beyond your own content. E.g. Talkwalker offers AI for image recognition and ggregation for online/offline media: http://bit.ly/tc17_talkwalker

Step 7: Leverage Your Analytics Tool Chain

Use Your R and Python Skills

Demo/Tutorial: Let’s See this in Tableau!

How to analyse Social Media traffic with Google Analytics in Tableau (YouTube):

How to analyse Social Media data from Twitter in Tableau (YouTube):

Slide Set

The slides presented at Tableau Conference are also available on SlideShare.

Are you on Social Media?

Feel free to retweet/share:

[Update 25 Oct 2018]: Missed the sessions? Watch the recording online!