Olivia Klose | Technical Evangelist, Microsoft

@oliviaklose

blogs.technet.com/oliviaklose

Meet Olivia | @oliviaklose

• Microsoft Technical Evangelist– Fokus: Big Data, Hadoop, Hive, etc.

• Machine Learning– Informatik mit Mathematik an der University of Cambridge, TU

München und dem IIT Bombay

– Medizinische Bildgebung

– Nuklearmedizinische Klinik in München

• IT Erfahrungen in Großunternehmen

Agenda

Modul Inhalt

1 Intro & Big Data Buzzwords

- Big Data, Hadoop, MapReduce, HDInsight

2 Big Data Szenario: Twitter-Analyse

3 Manage: Daten extrahieren und speichern- Windows Azure Blob Storage, Windows Azure SQL Database, VM

4 Analyse: Daten analysieren

- HDInsight, Hive

5 Insights: Erkenntnisse aus Daten gewinnen

- ODBC Treiber, PowerPivot & PowerView

Modul 2

Big Data Szenario: Twitter-Analyse

• Big Data Workflow

• Big Data Szenario: Story, Big Picture, Technologien,

Voraussetzungen

Big Data Workflow

Modul 2 – Big Data Szenario

The Big Data Workflow

Modul 2 – Big Data Szenario

Big Data Szenario: Twitter Analyse

Story

• Neue Marketing-Kampagne

• Stimmung in sozialen Netzwerken, genauer: Twitter

• Keywords, z.B. Xbox, Skype, HDInsight,…

• Score: positiv, neutral, negativ

The Big Picture

Twitter

The Big Picture

Extract

StreamInsight

Twitter

The Big Picture

Extract

StreamInsight

Real-Time Dashboard

Twitter

The Big Picture

Extract

StreamInsight

SQL Azure

Real-Time Dashboard

Twitter

The Big Picture

Extract

StreamInsight

SQL Azure

Azure BlobStorage

Real-Time Dashboard

Twitter

The Big Picture

Extract

StreamInsight

SQL Azure

Azure BlobStorage

Real-Time Dashboard

Analyze

Hive Tables

…

Twitter

The Big Picture

Extract

StreamInsight

SQL Azure

Azure BlobStorage

Real-Time Dashboard

Analyze

Hive Tables

…

Mash Up & Visualise

Twitter

The Big Picture

Virtual Machine

Twitter

Excel

HDInsight

Voraussetzungen

• Big Data Twitter Source Code: http://twitterbigdata.codeplex.com/

• Windows Azure Konto oder http://aka.ms/azurenow

• PowerPivot Add-In für Excel: http://aka.ms/powerpivot2013

• PowerView Add-In für Excel: http://aka.ms/activatepowerview

• Zusätzliche Setup-Dateien: http://aka.ms/bigdatatwitter-add

DEMOWindows Azure Konto

DEMOExcel Add-Ins: PowerPivot und Power View

DEMOtwitterbigdata.codeplex.com

DEMOBig Data Twitter Demo – zusätzliche Dateien

Agenda

Modul Inhalt

1 Intro & Big Data Buzzwords

- Big Data, Hadoop, MapReduce, HDInsight

2 Big Data Szenario: Twitter-Analyse

3 Manage: Daten extrahieren und speichern- Windows Azure Blob Storage, Windows Azure SQL Database, VM

4 Analyse: Daten analysieren

- HDInsight, Hive

5 Insights: Erkenntnisse aus Daten gewinnen

- ODBC Treiber, PowerPivot & PowerView

©2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Office, Azure, System Center, Dynamics and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.