Current Public Seminars

Architecture & Strategy
Zachman Enterprise Architecture: Modelling Workshop Zachman Certification
Strategic Enterprise Design
Management Strategies for Enterprise Architecture
How Digital is Transforming the Role of IT: Leading with Digital
   
Business Analysis
Business Architecture: The Foundation for Enterprise Transformation
Working with Business Processes: Discovery, Assessment, Mapping, Analysis and Design
Mastering the Requirements Process
Delivering Benefits from Implementing Change
Mastering Business Analysis
   
Enterprise Data Management
Ten Steps to Data Quality
Business Intelligence, Big Data, and Data Warehousing: New Technologies and Developments Explained
Managing Your Information Asset
Predictive & Advanced Analytics
Building an Enterprise Data Lake & Data Refinery for Enterprise Data as a Service
Business-Oriented Data Modelling
Advanced Data Modelling: Communication, Consistency, and Complexity
The Logical Data Warehouse - Design, Architecture, and Technology
Information Management Fundamentals
Data Modelling Fundamentals
Data Modelling Masterclass


Testimonials:

"Rick is a very good presenter and very knowledgeable in this area – I learnt a lot."

Gene Rivera, Analyst – Information Management, Rasgas Qatar

"Great insight in the history, present, and the future of BI industry. Definitely worth attending."

Vladimir Stanković, Software Engineer, Business Intelligence Department, IT Sector, Komercijalna Banka AD

"Attendance at the Seminar is essential for anybody looking for advice, direction or best practice for BI and DW projects. The speakers were extremely knowledgeable about their speciality subjects and I now feel armed with unbiased and useful information that will really help my projects and decision making going forward."

Guy Harvey, Compass Group Plc

2-Day Seminar

New Technologies and Architectures for Data Warehousing and Business Intelligence

Click here for an in-house quote request or for further information regarding in-house training.

Overview
The world of business intelligence (BI) and data warehousing keeps evolving. Technologies such as analytical database servers, big data, NoSQL, mashups, SaaS BI, data virtualization servers, advanced analytics, and SOA, have become available and offer new possibilities to organisations. In addition, the user requirements for business intelligence have also been changing: some need operational BI, others are looking at self-service BI, the third group has a need for more advanced analytical capabilities, and the fourth group wants to integrate everything within their spreadsheets. In short, the world of data warehousing is changing. This two-day seminar focuses on all these new developments, insights, ideas, and technologies. It is a must for every data warehouse specialist.

Learning Objectives

  • Learn what new data warehousing and business intelligence technologies could mean for an organisation
  • Learn how to select the right business intelligence architecture
  • Learn how to migrate to a modern architecture that exploits and benefits from new technologies
  • Learn how to develop a more flexible warehouse environment
  • Learn how to avoid well-known pitfalls
  • Learn from real-life experiences with introducing new technologies

Seminar and Workshop Outline

Introduction

  • The status of data warehousing and business intelligence
  • New trends and their impact on business intelligence:
    • The coming of operational BI - does it require online data warehouses?
    • Analytics of unstructured data - text analytics and text mining
    • Cloud computing and SaaS BI
    • Advanced analytics and self-service analytics
    • New storage and database technology, including appliances and solid state disks

The Stages of a Data Warehouse Project

  • Determining an implementation strategy: top down or bottom up
  • Analyzing a decision process before analyzing information needs
  • Can Agile data warehousing be used to design and implement data warehouses?

Selecting a Business Intelligence Architecture

  • Discussion of the different BI architectures, including Kimball's Data Warehouse Bus Architecture, Inmon's Corporate Information Factory, DW 2.0, the Federated Architecture, the Centralized Warehouse Architecture, the Data Delivery Platform, and the SaaS BI Architecture
  • When to use a Staging Area and when to use an Operational Data Store?
  • Designing an architecture to support operational BI
  • Can production databases be accessed to implement operational BI?
  • The use of conformed data marts
  • Is the only advantage of MDX and cube-based technology improved query performance?
  • What exactly is the Data Vault method? Can it co-exist with the existing architectures?
  • Integrating a BI architecture with Business Process Modelling

New Virtualization Architectures: the Data Delivery Platform and SaaS BI

  • The essence of the Data Delivery Platform: decoupling data consumers from data stores to increase flexibility
  • How to migrate from a classic BI architecture to the Data Delivery Platform?
  • Is the DDP comparable to a federated architecture?
  • The ultimate virtualized BI architecture: SaaS BI (BIaaS)

The Market of Tools for Reporting and Business Analytics

  • Categorization of BI tools, ranging from simple query tools and reporting tools to tools for business analytics, forecasting, and business process optimization
  • The rise of the analytic applications; or "BI out-of-the-box"
  • Collaborative analytics: the marriage of social networks and BI
  • The role of the Enterprise Information Portal in a data warehouse
  • What do they mean with (managed) self-service BI and with BI for the masses?
  • Open source solutions from Actuate, JasperSoft, Jedox, SpagoWorld, and Pentaho
  • Integrating mashups and business intelligence: the BI mashup
  • Working with unstructured data: text mining and text analytics

The Market of Database Servers and Appliances

  • How useful are classic relational database servers, such as DB2, Informix, Ingres, MySQL, Oracle, Pervasive PSQL, SQL Server, and Sybase, for data warehousing?
  • Market of analytical database servers, including those of Aster Data, Exasol, EMC/Greenplum, Actian VectorWise, Kognitio, Microsoft, IBM/Netezza, Oracle/Sun, ParAccel, Teradata and Vectra (HP)
  • Merging OLAP technology with relational database servers, such as DB2, Oracle11g, and SQL Server
  • The strength of columnar/bitwise database servers, including Paraccel, Sybase IQ and Vertica
  • The market of open source database servers

Logical and Physical Design of a Data Warehouse

  • Increasing the flexibility of an information model
  • How to design our tables: normalized, denormalised, starschema, or snowflake?
  • Modelling historic data: from static to dynamic databases
  • Are star schema and snowflake designs appropriate for operational BI?
  • What is the added value of Data Vault?
  • Physical data warehouse design is for specialists

The Quality of Data

  • How and where should data be cleaned?
  • How well can data profiling tools spot incorrect data?
  • Market overview of data profiling tools
  • Differences between data cleaning and data profiling tools

Data Logistics - Copying and Integrating Data

  • Batch integration or on-demand integration?
  • Market overview of ETL tools, including those of Ab Initio, IBM/Cognos, Informatica, iWay, Microsoft, Oracle, SAP/BO, and SAS
  • Can we use federation servers for integrating data on-demand?
  • What are data mart generators, such as Balanced Insight, BI-Ready, and Kalido?
  • Using a Service Oriented Architecture for copying data
  • Web services and mashups for importing external data

Meta Data and Master Data Management

  • The importance of meta data for users
  • The differences between technical, business, and operational meta data
  • What is a Master Data Management system?
  • Tools for developing business vocabularies

Summary and the Future

Audience

  • Business Intelligence Specialists
  • Data Warehouse Designers
  • Business Analysts
  • Technology Planners
  • Technical Architects
  • Enterprise Architects
  • IT Consultants
  • IT Strategists
  • Systems Analysts
  • Database Developers
  • Database Administrators
  • Solutions Architects
  • Data Architects
  • IT Managers

Speaker Biography

Rick van der Lans

Rick F. van der Lans is an independent consultant, author and lecturer specialising in business intelligence, data warehousing and database technology. He is the Managing Director of R20/Consultancy. Rick has advised many large companies worldwide on defining their data warehouse architectures. He is the chairman of the European BI and Data Warehousing Conference (organised annually in London), and a columnist for two major newspapers in the Benelux, and he writes regularly for the B-eye-Network.

In-House Training
If you require a quote for running an in-house course, please contact us with the following details:

  • Subject matter and/or speaker required
  • Estimated number of delegates
  • Location (town, country)
  • Number of days required (if different from the public course)
  • Preferred date

Please contact:
Jeanette Hall
E-mail: jeanette.hall@irmuk.co.uk
Telephone: +44 (0)20 8866 8366
Fax: +44 (0) 2036 277202

Speaker: Rick van der Lans
Rick van der Lans

Click here if you would like to receive a copy of all Rick van der Lans’ articles that have appeared in our free monthly e-newsletter.  To subscribe to this e-newsletter click here.


Endorsed by:
DAMA International
DAMA INTERNATIONAL
  UK Chapter