Crunch, Data Engineering and Analytics Conference, October 29-31, 2018 Budapest
Grega Jerkič

Grega Jerkič

CEO at IN516HT

Bio:

Grega Jerkič is an international senior data developer, consultant and mentor with a focus on the implementation of complex analytical systems. He has done multiple trainings for Microsoft and IBM in Europe and Middle East, and he is a co-author of a book for Microsoft on the data warehouse - Training Kit (Exam 70-463) Implementing a Data Warehouse with Microsoft SQL Server 2012. For last 10 years, he is also an owner of the company In516ht where the team is implementing different analytical solutions for large clients in the Adriatic region and abroad. In 2018 he got a reward from Snowflake as the person of the year for the Central and Eastern Europe.

Workshop:

Building your first modern cloud data warehouse using Snowflake

Topics:
data warehouse
data integration
sql
cloud
Level:
Beginner

This course offers a hands-on detailed overview of how to build a modern cloud data warehouse and to use the data with different BI and data science platform for further analysis. We will use one of the leading cloud data warehouse platform Snowflake to learn all the needed steps of data warehousing – from modelling, ingesting data, transforming the data and learn about new capabilities that a cloud data warehouse can bring to an organization.

Each attendee will have an ability to build the solution by himself using the Snowflake 30-day trial account.

Objectives

Data warehouse principles and what has changed with the cloud-native solutions
Data modelling
Data loading
Data ingestion of semi-structured data
Transforming the data using SQL
Populate the dimensional model
Perform various ad-hoc analysis
Learn about new capabilities like cloning, time-travel and other possibilities using Snowflake

Audience

This is a beginner course, so it is useful for any data analyst, data engineer or a data scientist that would like to learn more about data warehousing and how to properly prepare the data for his organization.

Prerequisites

Any knowledge of SQL is a plus.