Slide 1

Slide 1 text

Difference between a Data Warehouse and a Live Datamart Kai Wähner [email protected] @KaiWaehner www.kai-waehner.de LinkedIn / Xing à Please connect!

Slide 2

Slide 2 text

Key Messages –  A Data Warehouse is used for analysis and reporting of historical data! –  A Live Datamart is used to manage operations in real time! –  A Live Datamart combines automated streaming analytics and proactive human interaction

Slide 3

Slide 3 text

© Copyright 2000-2015 TIBCO Software Inc. Agenda What is a Data Warehouse? What is a Live Datamart? Spoilt for Choice

Slide 4

Slide 4 text

© Copyright 2000-2015 TIBCO Software Inc. Agenda What is a Data Warehouse? What is a Live Datamart? Spoilt for Choice

Slide 5

Slide 5 text

Data Warehouse http://www.exforsys.com/tutorials/msas/data-warehouse-database-and-oltp-database.html … used for storing historical data.

Slide 6

Slide 6 text

Business Intelligence = Reporting + Statistics + Data Discovery

Slide 7

Slide 7 text

Live Demo Reporting and Analytics with TIBCO Spotfire

Slide 8

Slide 8 text

© Copyright 2000-2015 TIBCO Software Inc. Agenda What is a Data Warehouse? What is a Live Datamart? Spoilt for Choice

Slide 9

Slide 9 text

Live Datamart Live Datamart Continuous Query Processor Alerts   BusinessEvents   FTL   EMS   Ac4veSpaces   BusinessWorks   Social  Media  Data   Market  Data   Sensor  Data   Historical   Data   Ac4veSpaces  Datagrid Enterprise   data   Market Data IoT Mobile Social Live UI Command & Control ACTION   Con4nuous  Query   … used for operations in real time.

Slide 10

Slide 10 text

Live Demo Operations in Real Time with TIBCO Live Datamart

Slide 11

Slide 11 text

© Copyright 2000-2015 TIBCO Software Inc. Agenda What is a Data Warehouse? What is a Live Datamart? Spoilt for Choice

Slide 12

Slide 12 text

© Copyright 2000-2015 TIBCO Software Inc. Spoilt for Choice Data Warehouse Live Datamart Historical Data 1) Reporting 2) Data Discovery to find Patterns 3) Optional: Analyze using Statistics Real Time Data (and historical data integrated) 4) Operations 5) Optional: Apply Statistics

Slide 13

Slide 13 text

Key Messages •  A Data Warehouse is used for analysis and reporting of historical data! •  A Live Datamart is used to manage operations in real time! •  A Live Datamart combines automated streaming analytics and proactive human interaction

Slide 14

Slide 14 text

Please contact me! Kai Wähner [email protected] @KaiWaehner www.kai-waehner.de LinkedIn / Xing à Please connect! Questions?