Seminars, workshops and keynotes presented by Rick F. van der Lans are grouped by topic (all the sessions can be presented in English and in Dutch):

The Logical Data Warehouse, Data Virtualization, and Modern Data Architectures

Big Data and Fast Data (Hadoop, NoSQL, and Spark)

Data Warehousing and Business Intelligence

Information Technology Trends

SQL and Advanced SQL

Presentation Skills

Inhouse sessions: All the sessions can also be presented inhouse and can be adapted to the needs of the customer. Sessions can also be combined. Please contact Diane Cools (diane@r20.nl) for more information.

KEYNOTE: It's Time for the Logical Data Warehouse

An explanation of the benefits of the logical data warehouse, and why it allows organizations to develop more flexible business intelligence systems.

SEMINAR: Lean Data Architectures to Minimize Data Copying

Lean data architectures minimize copying of data. The advantages are manyfold, such as the architecture is more flexible, improves productivity and maintenance, lowers low data latency enabling real or near real data-on-demand solutions, and less error-prone.

KEYNOTE: Data Vault + Data Virtualization = Double Flexibility

A data vault-based data warehouse can be transformed to a more flexible environment by replacing the multitude of physical data marts by virtual data marts using data virtualization.

SEMINAR: Practical Guidelines for Designing Modern Data Architectures

This seminar answers, through guidelines, tips, and design rules, many common questions raised when designing a modern data architecture. Concepts and technologies, such as data lakes, big data, datavault, cloud, data virtualization, Hadoop, NoSQL , and data warehouse automation, are explained.

KEYNOTE: Flaws of the Classic Data Warehouse Architecture

The classic data warehouse architecture has served us well the last 25 years. But does it still meet the business intelligence needs and requirements of today. What are its weak spots, and what can we do about it?

SEMINAR: The Logical Data Warehouse - Design, Architecture, and Technology

The logical data warehouse architecture fullfills all the modern business intelligence needs and requirements. This architecture is based on the decoupling of the data consumers and data producers leading to more flexible BI systems that can expoit modern big data technology more easily.

SEMINAR: Introduction to Data Virtualization: Technology and Use Cases

Data virtualization is a new and agile technology for integrating data from all kinds of systems. This  seminar discusses the benefits and characteristics of data virtualization technology; products are compared, use cases are discussed; and the relationship with topics, such as MDM, Data Governance, and the IoT are discussed.

KEYNOTE: Fast Data: The Next Frontier of Big Data

Organizations have started to enter the second stage of big data: fast data. Fast data is about streaming massive amounts of data and analyzing that same data instantaneously. It’s the next frontier of big data. Especially the Internet of Things is pushing the adoption of fast data.

KEYNOTE: The Battle for Data

Data is a key business asset. Having the right data at the right time can mean commercial success or failure. Conclusion, it's not difficult to see that in the near future it's going to be a battle for data.

KEYNOTE: Overview of Big Data and Fast Data Technology

With the introduction of big data and fast data, a tzunami of new technologies  for data storage, processing, and transportation was introduced. Hadoop, Spark, Kafka, NoSQL, MapReduce, Hive, SQL-on-Hadoop are just a few of the countless technologies that have become available for developing big data systems.

SEMINAR: Incorporating Big Data, Hadoop, and NoSQL in Business Intelligence Systems and Data Warehouses

Big data, Hadoop, NoSQL, Spark, and Kafka are just a few of the many new technologies that have become available for developing BI systems. Most of them are very powerful and allow for development of more flexible and scalable BI and data warehouse systems. But which ones do you pick? And for which use cases do they work best?

SEMINAR: New Big Database Technologies; A Market Overview of Technologies and Products

Big Data, Hadoop, NoSQL, analytical database servers, MapReduce, appliances are all immensely popular terms in the IT industry. For most organizations they questions are: How mature are all these new technologies? Are they worthy replacements for the more traditional SQL products? How should they be incorporated in the existing Data Warehouse architecture?

KEYNOTE: The Big BI Dilemma

The big BI dilemma most organizations are facing today, is how to integrate their current BI systems with the new BI workload consisting of self-service BI; investigative analytics; data science; new storage technologies, such as Hadoop and NoSQL; big data; and so on. In this keynote this dilemma is explained and solutions are presented.

This session discusses a design approach called SuperNova that makes data stored in Data Vaults easier to access and change without the need to create derived data stores. This reduces operating costs and improves flexibility. The SuperNova approach relies heavily on data virtualization technology.

SEMINAR: Modern Data Warehouse Architectures

Today, data warehouse architects are confronted with many questions. Should the data warehouse be developed with Hadoop and Spark? Do we still need data marts?  What does it mean to design datavault-based data warehouses? How does data streaming and the IoT fit in? This session discusses all the architectural developments. 

SEMINAR: The Essentials of Business Intelligence and Data Warehousing

The world of business intelligence (BI) and data warehousing uses a unique terminology and deploys its own set of technologies, design techniques, and products. For newcomers all this can be overwhelming. What do all these new terms exactly mean, such as star schema, data mart, ETL, self-service BI, data science, big data, staging area, and BI in the cloud? In this new seminar, which has been set up specifically for newcomers,  all the typical BI terms, concepts, techniques, architectures, and technologies are explained. It’s a complete and critical introduction.

SEMINAR: Data Warehousing, Big Data, and Business Intelligence: New Technologies, Trends, and Techniques

Big data, Hadoop, in-memory analytics, self-service BI, data warehouse automation, analytical database servers, data virtualization, data vault, operational intelligence, predictive analytics, and NoSQL are just a few of the new technologies and techniques that have become available for developing BI systems. This seminar gives a clear and extensive overview of all the new developments and their inter-relationships.

WORKSHOP: Introduction to SQL

SQL is still THE language for accessing data in databases. This workshop teaches developers the basics of SQL, including how to create and change tables, insert and delete data, how to query the data, how to secure the data.

WORKSHOP: Developing Advanced Queries with SQL

The query capabilities of SQL are enormously powerful. Unfortunately, out of habit, many developers limit themselves to simple select statements, and are therefore not exploiting the full capabilities of their database servers. This session teaches how developers can use the full richness of the SQL query capabilities.

SEMINAR: Presentation Skills for IT Specialists

This seminar is aimed at those for whom speaking in public is not their job. It has been developed specifically for IT specialists, and is presented by an IT specialist: Rick van der Lans. It teachs how to build up a technical story and how to present it.