Recap of the 16th Data & AI Meetup: Azure Bootcamp

Azure Synapse Analytics Screenshot
Azure Synapse Analytics demo shown during the meetup

Yesterday we had the 16th edition of our Data & AI Meetup. This meetup was a hands-on Azure Bootcamp. Let’s have a quick recap!

Agenda:

  1. Welcome & Intro
  2. Azure SQL DB
  3. Azure Data Factory
  4. Azure Synapse Analytics
  5. Visual Analytics with Power BI on Azure

Session recording:

Further information:

The next Data & AI Meetup?

The next Data & AI Meetup will be announced on the Data & AI LinkedIn group and on the Data & AI Meetup page. Feel free to join!

If you’ve dreamed of sharing your Data & AI story with many like-minded Data & AI enthusiasts, please submit your session proposal.

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 in Tableau

Azure Cognitive Services in Tableau: using Python to access the Web Services API provided by Microsoft Azure Cognitive Services
Azure Cognitive Services in Tableau: 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 quite an interesting question:

How can a Tableau dashboard that displays contacts (name & company) automatically look up 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…

Step by Step: Integrating Azure Cognitive Services in Tableau

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:

SCRIPT_STR("
import http.client, urllib, base64, json
YOUR_API_KEY = 'xxx'
name = _arg1[0]
company = _arg2[0]
try:
headers = {'Ocp-Apim-Subscription-Key': YOUR_API_KEY }
params = urllib.urlencode({'q': name + ' ' + company + ' linkedin','count': '3'})
connection = http.client.HTTPSConnection('api.cognitive.microsoft.com')
connection.request('GET', '/bing/v7.0/search?%s' % params, '{body}', headers)
json_response = json.loads(connection.getresponse().read().decode('utf-8'))
connection.close()
for result in json_response['webPages']['value']:
if name.lower() in result['name'].lower():
if 'linkedin.com/in/' in result['displayUrl']:
return result['displayUrl']
break
except Exception as e:
return ''
return ''
", ATTR([Name]), ATTR([Company]))

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!

Get More Insights

This tutorial is just the tip of the iceberg. If you want to dive deeper into the world of data visualization and analytics, don’t forget to order your copy of my new book, Visual Analytics with Tableau (Amazon).  This comprehensive guide offers an in-depth exploration of data visualization techniques and best practices.

I’d love to hear your thoughts. Feel free to leave a comment, share this tweet, and follow me on Twitter and LinkedIn for more tips, tricks, and tutorials on Azure Cognitive Services in Tableau and other data analytics topics.

Also, feel free to comment and share my Azure Cognitive Services in Tableau 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: