lecture @dhbw: data warehouse 00 course intro › ~buckenhofer › 20191dwh › ...increase sales...
TRANSCRIPT
-
A company of Daimler AG
LECTURE @DHBW: DATA WAREHOUSE
00 COURSE INTROANDREAS BUCKENHOFER, DAIMLER TSS
-
ABOUT ME
Andreas BuckenhoferSenior DB Professional
Since 2009 at Daimler TSS
Department: Machine Learning Solutions
Business Unit: Analytics
Contact/Connect
vcard
• Oracle ACE Associate
• DOAG responsible for InMemory DB
• Lecturer at DHBW
• Certified Data Vault Practitioner 2.0
• Certified Oracle Professional
• Certified IBM Big Data Architect
• Over 20 years experience with
database technologies
• Over 20 years experience with Data
Warehousing
• International project experience
mailto:[email protected]:[email protected]://twitter.com/ABuckenhoferhttps://twitter.com/ABuckenhoferhttps://de.linkedin.com/in/buckenhoferhttps://de.linkedin.com/in/buckenhoferhttp://wwwlehre.dhbw-stuttgart.de/~buckenhofer/http://wwwlehre.dhbw-stuttgart.de/~buckenhofer/http://wwwlehre.dhbw-stuttgart.de/~buckenhofer/http://wwwlehre.dhbw-stuttgart.de/~buckenhofer/http://wwwlehre.dhbw-stuttgart.de/~buckenhofer/https://www.doag.org/de/themen/datenbank/in-memory/http://wwwlehre.dhbw-stuttgart.de/~buckenhofer/http://wwwlehre.dhbw-stuttgart.de/~buckenhofer/https://www.xing.com/profile/Andreas_Buckenhofer2https://apex.oracle.com/pls/apex/f?p=19297:3:16881272565360:https://www.doag.org/de/themen/datenbank/in-memory/http://wwwlehre.dhbw-stuttgart.de/~buckenhofer/
-
As a wholly-owned Daimler subsidiary,
we give 100 percent, always and never
less! We love IT and pull out all the
stops to develop Daimler with our
expertise on its journey towards the
future.
Our objective: We make Daimler the
most innovative and digital mobility
provider.
NOT JUST AVERAGE: OUTSTANDING.
Daimler TSS
-
DAIMLER TSS. WINNING THE DIGITAL RACE
The continuous development of our IT DNA is a key factor for the digital competitiveness of our parent company.
In the domains of Customer and Transformed Vehicle we focus on the following product lines: Mobility, Sales & Care, Digital Vehicle, Digital Production and Cyber Security.
With a holistic IT understanding and high product requirements, we create measurable added value for Daimler.
Daimler TSS
-
Company Presentation | Feb 2019Daimler TSS
DIGITAL PRODUCTIONSALES & CARE
DIGITAL VEHICLEMOBILITY
CYBER SECURITY
STRATEGIC INITATIVES
PRODUCT LINES. OUR VALUE FOR DAIMLER
AUTONOMOUS DRIVING
Include AI as decisive game changer.
DIGITAL PRODUCTS
Increase sales and
value creation through
attractive digital
offers.
CUSTOMER JOURNEY 360°
Create an integrated customer
understanding through
trustable data collec-
tion & analysis.
LEARNING
THROUGH
GLOBAL PRESENCE
Be effective among the
digital, international competition.
INTEGRATION
OF 3RD PARTIES
Encourage profitable
cooperation through
the technical exchange.
MODERN IT UNDERSTANDING
Ensure the fundamentals for the digital
transformation with advanced IT.
DAIMLER
PLATFORM ECONOMY
Interact directly with Daimler
customers in the digital ecosystem.
ELECTRIC MOBILITY
Accelerate intelligent drive
systems with modern IT.
FOCUS
TRANSFORMED
VEHICLE
CUSTOMER
5
-
FLAGSHIP PROJECTS
• car2go
• InCar-Delivery
• EQ-Ready
• Mercedes me
• PrivateCarSharing
Daimler TSS
-
LOCATIONS
* as of Dec 2018
Daimler TSS China
Hub Beijing
7 employees*
Daimler TSS Germany
4 locations
Ulm (headquarters)
Stuttgart
Berlin
Karlsruhe
1203 employees*
Daimler TSS Malaysia
Hub Kuala Lumpur
49 employees*Daimler TSS
-
Data Warehouse / DHBWDaimler TSS 8
Who are you?
Knowledge or experience:- Databases- SQL- DWH- Big Data
Your expectations?
ABOUT YOU
-
• Understand the importance of a data-driven culture
• Know tools relevant for DWH and Big Data
• Name DB technologies and techniques that are well-suited for DWHs
• Describe different DWH and Big Data architectures in detail
• Explain DWH data modeling (physical models)
• Explain Data integration/engineering (ETL) processes
• Understand Streaming technologies
• Specify visualization & metadata & security & PM requirements
• Name current DWH and Big Data trends
DWH LECTURE – TOPICS WITH LEARNING TARGETS
Data Warehouse / DHBWDaimler TSS 9
-
Daimler TSS
Data
Source
Data
Usage
Data Infrastructure
Data Management
Data Processing
Data Flow
Data Security
Data Governance
Data Culture
LogsOLTP
File Formats
Social Media
Images
Do
cum
en
ts
Machines
Star Schema
ODSData Vault
3NF
(SQL) Engines
Appliance
Virtualization
Reporting
Dashboarding
Search
Data Mining
Exploration
Simulation
Info
rmati
on
Desi
gn
ETL Batch
Str
eam
ing
CleansingProfiling
Map Reduce
ELT
RAM
SSD
Harddisk
Video
Sensors
Geospatial
Staging
Data Mart
Data Lake
Monitoring Scheduling Logging
Ethics Law GDPR
Data Catalog Metadata Domain Model
#dataops agile Project Management
Execution
Integration
Error Handling
Authentication Authorization Anonymization
Clic
kst
ream
Archive
On premises
In-MemoryMPP
RDBMS NoSQL Hadoop
MDM
Cube Core Warehouse Layer
KappaLambda
Real time
Micro Batch
Graph Models
Automation
Collection
Self Service
Planning
An
aly
tics
Audio
Glossary Data Quality
Cloud
Legacy
Text
Mobile
Data Hub
-
DWH department in every (bigger) end user company, also in many medium-sized or small-sized companies
DWH department in every (bigger) consulting company
DWH-only specialized consulting companies
DWH tool vendors
MANY EMPLOYMENT OPPORTUNITIES
Data Warehouse / DHBWDaimler TSS 11
-
DWHs are complex, much more complex compared to most OLTP systems
Challenging job profiles with comprehensive requirements
• Data Architecture
• Data Integration / ETL
• Data Modeling (not only 3NF)
• Data Visualization
• Data Quality
• Data Security
• Requirements Engineering
• Project Management
MANY EMPLOYMENT OPPORTUNITIES – CHALLENGING JOB REQUIREMENTS
Data Warehouse / DHBWDaimler TSS 12
OLTP = online transaction processing
-
JOB DESCRIPTION EXAMPLES
Data Warehouse / DHBWDaimler TSS 13
-
JOB DESCRIPTION EXAMPLES
Data Warehouse / DHBWDaimler TSS 14
-
• 36 semester periods per week (Semesterwochenstunden)
• Structure of the lecture
• Review of the preceding lecture
• Presentation of content with (group) tasks
• Group exercise
• Exam
• 1h
• Questions in German
ABOUT THE LECTURE
Data Warehouse / DHBWDaimler TSS 15
-
• Download slides from
http://wwwlehre.dhbw-stuttgart.de/~buckenhofer/
COURSE MATERIAL
Data Warehouse / DHBWDaimler TSS 16
http://wwwlehre.dhbw-stuttgart.de/~buckenhofer/
-
• Who is the class representative?
• Do you have a class email address?
• Please send me an email so that I have your contact data
COURSE CONTACT
Data Warehouse / DHBWDaimler TSS 17
-
LITERATURE
Data Warehouse / DHBWDaimler TSS 18
-
LITERATURE
Data Warehouse / DHBWDaimler TSS 19
http://btw2017.informatik.uni-stuttgart.de/slidesandpapers/Tutorial/SDM_slides.pdf
http://btw2017.informatik.uni-stuttgart.de/slidesandpapers/Tutorial/SDM_slides.pdf
-
FINALLY
Data Warehouse / DHBWDaimler TSS 20
Questions?Any time
FeedbackAfter lecture or by email
-
Daimler TSS GmbHWilhelm-Runge-Straße 11, 89081 Ulm / Telefon +49 731 505-06 / Fax +49 731 505-65 99
[email protected] / Internet: www.daimler-tss.com/ Intranet-Portal-Code: @TSSDomicile and Court of Registry: Ulm / HRB-Nr.: 3844 / Management: Christoph Röger (CEO), Steffen Bäuerle
Data Warehouse / DHBWDaimler TSS 21
THANK YOU