Speaker

Jean-Pierre Voogt

Jean-Pierre Voogt

Experian Data Engineer

Pretoria, South Africa

South African Data Tinkerer and @Microsoft Fanboy | @dataplatformjhb leader | Formula 1 enthusiasts and Father | (He/Him)

Jean-Pierre speaks at the Johannesburg SQL User Group, trying to give back to the SQL community as much as possible. He loves to tinker with SQL Server and see how he can approach a problem with a different angle.

Area of Expertise

  • Information & Communications Technology

Topics

  • SQL
  • Microsoft SQL Server
  • Azure SQL DW
  • Azure SQL Database
  • Azure SQL Server
  • Azure Data & AI
  • Azure Data Platform

PyConZa 2019

Working with data in Python for the Aspiring Data Scientists

Data Science is the latest data buzzword, but what does this mean for us, the analysts and developers? Well, this is just another opportunity to grow and learn a new skill. The great thing about the era we live in is that information is everywhere, but can be a little overwhelming for someone who is just starting off in a new field or wants to learn a new skill.

In this session, we will use Python in an easy-to-understand layout by using Jupyter Notebooks as our interface and pandas as our data manipulation library. This session is for everyone that is just starting off in Python. We will learn how to import/export data into Python, as well as manipulate and analyze data. Finally, we will look at how to bring this back into our SQL Server world.

October 2019 Johannesburg, South Africa

Johannesburg Data Platform User group

Working with data in Python for Beginners

Data Science is the latest Data Buzz word, but what does this mean for us the Analysts and Developers. Well, this is just another opportunity to grow and learn a new skill. The great thing about the era we live in is that information is everywhere but can be a little overwhelming for someone who is just starting off in a new field or wants to learn a new skill.

In this session, we will use Python in an easy to understand layout by using Notebooks as our Interface and pandas as our data manipulation library in Python. This session is for everyone that is just starting off in Python. We will learn how to import/export data into Python as well as manipulate and analyse data. Finally, we will look at how to bring this back into our SQL Server world.

October 2019 Johannesburg, South Africa

SQLSaturday #897

Working with data in Python for Beginners

Data Science is the latest Data Buzz word, but what does this mean for us the Analysts and Developers. Well, this is just another opportunity to grow and learn a new skill. The great thing about the era we live in is that information is everywhere but can be a little overwhelming for someone who is just starting off in a new field or wants to learn a new skill.

In this session, we will use Python in an easy to understand layout by using Notebooks as our Interface and pandas as our data manipulation library in Python. This session is for everyone that is just starting off in Python. We will learn how to import/export data into Python as well as manipulate and analyse data. Finally, we will look at how to bring this back into our SQL Server world.

September 2019 Cape Town, South Africa

SQLSaturday #903

Working with data in Python for Beginners

Data Science is the latest Data Buzz word, but what does this mean for us the Analysts and Developers. Well, this is just another opportunity to grow and learn a new skill. The great thing about the era we live in is that information is everywhere but can be a little overwhelming for someone who is just starting off in a new field or wants to learn a new skill.

In this session, we will use Python in an easy to understand layout by using Notebooks as our Interface and pandas as our data manipulation library in Python. This session is for everyone that is just starting off in Python. We will learn how to import/export data into Python as well as manipulate and analyse data. Finally, we will look at how to bring this back into our SQL Server world.

September 2019 Johannesburg, South Africa

Johannesburg Data Platform User group

Back to Basics: Data Types

April 2019 Johannesburg, South Africa

SQLSaturday #808

What is Temporal Tables

In this session we will take an introduction look at Temporal Tables in SQL Server. How do we query a temporal table and how do we manage a large temporal table with Stretch Database to Azure. We will look at when to use Temporal tables and why would you use it.

November 2018 Oregon City, Oregon, United States

Johannesburg Data Platform User group

First Look as Azure Databricks

We will discuss what Databricks is and where/when it should or can be used. We will take a look at how to setup it up, working with sample data to gather valuable insights. We will cover the basics of Notebooks on how to display data and run your Notebooks

October 2018 Johannesburg, South Africa

SQLSaturday #785

First Look as Azure Databricks

We will discuss what Databricks is and where/when it should or can be used. We will take a look at how to setup it up, working with sample data to gather valuable insights. We will cover the basics of Notebooks on how to display data and run your Notebooks

September 2018 Johannesburg, South Africa

Johannesburg Data Platform User group

Easy Data Quality Checks

March 2017 Johannesburg, South Africa

SQLSaturday #554

What!!! a new AdventureWorks? Welcome to WorldWideImporters

We will be going through how to setup the new Microsoft Sample database and have a look at the new features and workloads that can be run against the new same database.

September 2016 Johannesburg, South Africa

Johannesburg Data Platform User group

Getting started with temporal tables

In this talk we will be going back in time using SQL and a feature soon to be introduced into SQL Server 2016, ‘Temporal Tables’. During this session we will look at what temporal tables are and how we can use them to answer the question, “What did my table look like X days ago?”.

March 2016 Johannesburg, South Africa

Jean-Pierre Voogt

Experian Data Engineer

Pretoria, South Africa