Big Data for Data Warehouse and Business Intelligence Professionals.

Fix common data warehouse headaches with big data concepts and technologies.
Find out about the limitations of big data.

Duration: 1 day. Onsite in EMEA. Virtual classroom webinar world-wide.
Trainer: Uli Bethke, CEO Sonra.




 
 
  • Overview

    Do you have a background in data warehousing, business intelligence or relational databases?
    Are you about to embark on a big data journey and need vendor neutral advice?
    Do you want to learn more about how you can benefit from big data concepts and technologies but also want to understand the limitations?
    Then this training course is for you.

    Audience

    Data Warehouse and Business Intelligence Professionals
    Data Warehouse Managers
    Data Warehouse Architects
    ETL Developers
    Data Warehouse Project Managers

    Location:
    On-site in EMEA. Webinar world-wide.

    Price:
    700 Euros for individuals
    3,000 Euros for groups of up to 15 participants

    Don’t miss the opportunity to understand Big Data and became Data Warehouse professional. Register today!
    REGISTER HERE
  • Agenda

    Big Data Concepts
    What is Big Data?
    Big Data and the Enterprise Data Warehouse

    Data Warehousing on Distributed Relational Databases (MPP)
    Massively Parallel Processing & Shared Nothing Architecture
    Data Distribution
    Data Model
    Processing Model
    Data Storage & Indexes
    Concurrency, Latency & Throughput
    Limitations 1: Concurrency
    Limitations 2: Scalability
    Limitations 3: Resilience
    Limitations 4: Unstructured Data
    Limitations 5: Tight Coupling
    Limitations 6: License Costs
    Matrix MPP Vendors
    MPP on Hadoop

    See more.

    Data Warehousing on Distrubuted File Systems
    Why Hadoop?
    Data Distribution & HDFS
    Data Model
    Processing Model
    Data Storage & Indexes
    Concurrency, Latency, Throughput
    Scalability
    Availability
    Hadoop Limitations
    Spark
    Spark Limitations
    Trends and Innovations

    See more.

    Data Warehouse Optimization
    Limitations of Relational Databases for Data Warehousing
    What is Data Warehouse Offload?
    Data Warehouse Offload Opportunities
    Next Generation Data Warehouse Architecture
    Data Warehouse and Cloud

    See more.

    The Future of Dimensional Model and ETL
    Dimensional Modelling in the Age of Big Data
    The Future of ETL

    Streaming Architecture
    The what and why of streaming architecture
    Components and Architecture Details
    Message Brokers/Queues
    Stateless & Stateful Computations
    Delivery Semantics
    Lambda Architecture
    Checkpoints
    End to End Consistency
    Event Time & Processing Time
    Windowing. Types of Windows.
    Batch vs Realtime
    Approximate Querying
    Comparison of Streaming Engines

    See more.

    Data Lakes, Self-Service & Advanced Analytics
    The Concept of the Data Lake
    Is the Data Lake useful?
    The Concept of Data Preparation and Self-Service Analytics
    Sandbox Environments
    Next Generation Advanced Analytics Architecture
    From Big to Smart Data
    Types of advanced analytics
    Data Preparation & Science Tools

    See more.

What's the trouble with the data warehouse?

  • Data warehouses are bursting at the seams.
  • Data volumes and costs are exploding.
  • Relational data warehouses don't get on with graphs, unstructured data, keyword searches, machine learning, predictive analytics etc.
  • It takes forever to get data into the data warehouse and insights out of it.
  • Only 20% of enterprise data finds its way to the data warehouse.
  • Writing ETL code is slow and hard to maintain.
  • Traditional data warehouse architecture sucks for real-time analytics.

Does this sound familiar?

Yes? Then this training course is for you.

Who should attend?

  • Data Warehouse and Business Intelligence Professionals
  • Data Warehouse Managers
  • Enterprise/Solution Architects
  • Data Warehouse Architects
  • ETL Developers
  • Data Warehouse Project Managers
  • Data/Business Analysts

Why attend?

  • Learn how to reduce data warehouse costs.
  • Find out if Hadoop is a good fit for your data warehouse.
  • Learn about the pros and cons of the three different types of distributed technologies to process large data volumes.
  • Understand the benefits of cloud data warehousing.
  • Find out about the role of the cloud in data warehousing.
  • Find out if data lakes are just hype or a useful design pattern.
  • Understand if it makes sense to implement real-time analytics.
  • Learn about metadata driven ETL with code templates to automate data warehouse loads.
  • Learn if and how advanced analytics can help to make better decisions.
  • Learn how to make more data available to more people in the enterprise without creating data anarchy.
  • Learn more about current trends in data warehousing.
  • Understand the benefits and limitations of big data technologies.
  • Future proof your data warehouse.

Where will it be?

As a private course on-site in your office (Europe).
As a private webinar (rest of the world).

Price

250 Euros for a recorded online session
700 Euros for individuals
3,000 Euros for groups of up to 15 participants

Don’t miss the opportunity to future proof your data warehouse. Register today!
GET A QUOTE

Agenda

Big Data Concepts
What is Big Data?
Big Data and the Enterprise Data Warehouse

Data Warehousing on Distributed Relational Databases (MPP)
Massively Parallel Processing & Shared Nothing Architecture
Data Distribution
Data Model
Processing Model
Data Storage & Indexes
Concurrency, Latency & Throughput
Limitations 1: Concurrency
Limitations 2: Scalability
Limitations 3: Resilience
Limitations 4: Unstructured Data
Limitations 5: Tight Coupling
Limitations 6: License Costs
Matrix MPP Vendors
MPP on Hadoop

See more.

Data Warehousing on Hadoop and Spark
Why Hadoop?
Data Distribution & HDFS
Data Model
Processing Model
Data Storage & Indexes
Concurrency, Latency, Throughput
Scalability
Availability
Hadoop Limitations
Spark
Spark Limitations
Trends and Innovations

See more.

Data Warehousing in the Cloud
Pay as you go model
Self-managing
Comparison Snowflake, Athena/Presto, Redshift

Data Warehouse Optimization
Limitations of Relational Databases for Data Warehousing
What is Data Warehouse Offload?
Data Warehouse Offload Opportunities
Next Generation Data Warehouse Architecture
Data Warehouse and Cloud

See more.

The Future of Dimensional Modeling and ETL
Dimensional Modelling in the Age of Big Data
The Future of ETL

Real-time Analytics
Real-time. Hype or hope?
Streaming architecture
Message Brokers/Queues
Stateless & Stateful Computations
Delivery Semantics
Lambda Architecture
Checkpoints
End to End Consistency
Event Time & Processing Time
Windowing. Types of Windows.
Batch vs Realtime
Approximate Querying
Comparison of Streaming Engines

See more.

Data Lakes, Self-Service & Advanced Analytics
The Concept of the Data Lake
Is the Data Lake useful?
The Concept of Data Preparation and Self-Service Analytics
Sandbox Environments
From Big to Smart Data
Types of advanced analytics
Data Preparation Tools

See more.

Bringing Big Data for Data Warehouse Professionals to Air New Zealand (online webinar).

Bringing Big Data for Data Warehouse Professionals to Air New Zealand (online webinar)

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.

Uli holds degrees in political science from Freie Universität Berlin, Albrecht Ludwigs Universität Freiburg, and the University of Ulster, Coleraine.

Last but not least, Uli is the CEO of Sonra, the data liberation company. Sonra develops Flexter, a tool to automate the conversion of complex XML to a database, text, or Hadoop.

Are you a consulting company? We are always looking for resellers of the course.
Talk to us to find out more.