[If corona restrictions prevent us from running on-site or hybrid format, we will revert to virtual delivery.]
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.
Van der Valk Hotel Utrecht
3526 KV Utrecht
Telefoon 030 8000 800
The hotel is very well accessible by public transport. From busstop ‘Kanaleneiland Zuid’ it is only a three-minute walk. You can also take the tram line 60 or 61 from trainstation Utrecht Centraal and get off at stop ‘Kanaleneiland’. 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).
Van der Valk Hotel Utrecht is also located next to the highway A12, exit 17 (Utrecht / Jaarbeurs / Kanaleneiland).
Although the hotel has a large parking garage, we cannot guarantee parking spots. We therefore advise you to go by public transport.
For those who would like to arrive the day before, there is the possibility of staying at the Van der Valk Hotel Utrecht. However, the hotel does not provide special discounts for attendees of events. Therefore, when interested in an overnight stay, please consult Van der Valk directly to make a reservation.
More information about the hotel and the location can be found on their website www.vandervalkhotelutrecht.nl.
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.