[At the request of the hotel staff or Adept Events organisation, you will have to use the CoronaCheck app to present a valid coronavirus entry pass. You can generate a coronavirus entry pass using the CoronaCheck app on your mobile phone.
To provide the live video stream in the hybrid format, we require a minimum of three online attendees.]
As we stand, engineers have been building cloud tech based data warehouses in The Netherlands since 2015. But how do we actually design a cloud based data warehouse that really leverages the new technological capabilities the cloud brings? How does it differ from the classical, on premise data warehousing approach? And how can we go about implementing such a cloud based data warehouse technically?
Organizations are increasingly looking into the pros and cons of cloud data warehousing as the technology is evolving rapidly and more and more organisations are ‘taking the leap’. One of the main advantages of cloud analytical databases is their virtually ‘endless’, independently scalable (cheap) storage and compute. For most companies, however, migrating an existing data warehouse to the cloud is not that trivial. An important reason for this is that to take advantage of the independently scalable storage and compute, a lift-and-shift approach often does not work. The common cause for this is that the data architectural design principles that were used to design the classical data warehouse are outdated too!
In addition, the ‘modern data warehouse’ often demands a different consumption pattern than that we are used to in the classical data warehouse setup. As they are, these architectures were often focused on tactical / strategical information provisioning. However, in this day and age of data science and advanced analytics, it is only logical for the data scientist to be one of the primary users of the data warehouse. After all, people have started to realize that data scientists currently perform a lot of work that could and should be covered under the label of ‘data warehousing’. A well designed modern data warehouse can therefore offer a competitive advantage for any modern data driven / information supported company.
In this seminar, Rogier Werschkull will explain how one should deal with the solution and data architectural changes, offering lessons learned and best practices. Should you indeed move your data warehouse to the cloud? If so, what could be the new design principles forging your ‘modern data warehouse’? How do the different cloud data warehouse vendors compare? What cloud data warehouse solution and surrounding toolset should we choose and why? And how can we start building such a new data architecture, learning from how others have done it so far?
The cloud analytical databases that will be looked at will be restricted to the major players: Amazon Redshift, Google BigQuery, Snowflake and Azure SQL Data Warehouse / Synapse. The supporting tools we will look at, fall in the category of EL tools (for onboarding data) like Fivetran and Stitch and modern ELT tools like Data Build Tools (DBT) and Matillion.
It is important to realize that while we will look at the technical aspects of these new cloud based solutions, the focus of this seminar will be to get a head start with implementing an analytics data architecture that you can really call a ‘modern data warehouse’. The essence of this is to grasp what implementing a cloud based ELT (not ETL!) analytical data architecture means in real life.
Attendees will learn:
Who is It For?
Data management and analytics program and project managers, Data management and analytics architects. Data warehouse architects, Technology strategists and planners, Data engineers, Data warehouse / ETL developers and data integration specialists. Anyone with a role in migrating legacy data warehouses to the cloud.
This event takes place at:
1213 TS Hilversum
Telephone +31 (0) 35-6231341
For a full itinerary, please see the website of the Amrath Hotel.
The Hotel Lapershoek can also be reached by public transport. Be sure to take the train to ‘Station Hilversum Sportpark’ from which it is only a three minute walk.
Please consult www.9292.nl (door-to-door journey planner, also available in English) or call 0900-9292 (travel advice by phone, € 0.70 p/m).
For attendees interested in an overnight stay, we have made a special price agreement with the hotel. Please let us know if you wish to make use of this.
Practically all of our seminars and workshops can be offered as an In-house course for your company exclusively. We can tailor with extra focus on specific topics that apply to your organization. Also available in online format or in face-to-face format with live video stream.