Rogier Werschkull
Rogerdata
[Please note that this compact morning seminar is delivered as a virtual training from our studio. We are well equipped with multiple cameras, monitors and microphones in order to allow adequate interaction! Previous online sessions have been very well evaluated. See also the description in Venue tab]
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.
Seminar
In this half day 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.
Learning objectives
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.
The virtual seminars and workshops will be offered through an online meeting platform, usually Webex or Zoom, from our video studio. The virtual classroom is equipped with multiple professional cameras and microphones and we have a two person crew available so that we can offer a similar experience to that of the traditional classroom and, more important, still offer adequate interaction with the speaker.
The presenter / trainer will still use his Powerpoint, combined with flipchart and paper, virtual whiteboard and physical whiteboard and will be accompanied by a operator / moderator at the scene. The presenter does not have to worry about technical issues such as switching, splitting, microphone settings and such but can fully focus on the course material and on engaging with the online attendees.
All of the above is to ensure that it does not become an impersonal one-way webinar but an interactive virtual classroom setting.
Those attending an online event or a hybrid event with the online meeting platform will be sent an invitiation with the meeting hyperlink and instructions a few days before, so well in advance of the course.
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.
Collaborative BI Requirements Analysis & Dimensional Modeling Training A 3-day dimensional modelling course presented internationally by leading data warehousing expert and author Lawrence Corr, covering the latest agile techniques for systematically gathering Business Intelligence (BI) requirements and designing effective DW/BI systems.
November 11 - 13, 2024
Utrecht
Organizations need data science, self-service BI, embedded BI, edge analytics, and customer-driven BI. This seminar provides guidelines, roadmaps, design criteria, tips, design rules, use cases, case studies, and practical examples for developing a new future-proof data architecture.
November 26-27, 2024
Utrecht
Business Intelligence, Data Warehousing, Big Data and Data Management Independent portal on Business Intelligence, Data Science & Analytics, Data Warehousing, Data Management and Big Data in The Netherlands. BI-Platform offers a wealth of content, such as blogs, interviews, videos, whitepapers and more.