Olivier Van Steenlandt
BI Teamlead @ X²O
Sint-Niklaas, Belgium
Actions
Olivier Van Steenlandt is a Business Intelligence Professional who spent most of his early career assisting retail companies to get more value of their data using the Microsoft BI Stack (SSIS, SSAS, SSRS, Power BI).
As his first experience in the field (in Business Intelligence), Olivier worked as a Big Data Analyst using tools such as Hadoop and Spark.
In 2015 the focus changed to traditional data warehousing & reporting using SSIS, SSRS & MicroStrategy. A bit later, around June 2019, the opportunity arose to fill the position of BI Teamlead. In this function he was able to set up a hybrid BI Team (team members in Belgium and Belarus).
Early 2020, Olivier joined the dataMinds crew as a core member, assisting to organise several events.
Around April 2021, Olivier started a new position as BI Teamlead in another Retail Company to support business growth. Besides the challenge to help the BI Team grow and deliver projects on time, he started to use SSAS & Power BI.
When Olivier is not working there is a high chance that you find him on a football field, studying (BI Related), playing music (Saxophone / Piano) or cooking.
Links
Awards
Area of Expertise
Topics
Database Unit Testing for Data Professionals
In traditional software development, Unit Testing is pretty well known. But what about Unit Testing for database solutions?
Or more specifically, what about Unit testing for Data Warehouse solutions?
In this session, we will dive into the world of Unit Testing for databases, with a focus on Data Warehousing solutions.
Before we dive into practical examples, we need to understand the key concepts and the importance of Unit Testing.
As soon as the basics are set, we will talk about different possibilities/frameworks to implement Unit Testing.
Near the right before the halfway mark, we will dive into the tSQLt Framework specifically and we will start to get more practical.
What are we going to discover?
* How to create 1 or more Test Classes?
* How to create different Unit tests?
* What's possible with tSQLt?
* How to automate your Unit tests?
If you are wondering how to get started with Unit Testing for Data Warehouse solutions or databases in general this session is for you!
Improving Team Collaboration Using Database Projects and Azure DevOps
Having source control in place sounds like the default these days. Although, a lot of companies didn't implement source control yet. This session will guide you how to setup source control step by step, using Database Projects and Azure DevOps.
At the beginning of the session, a couple of use cases will be explained why it is important to use source control within your organization (use cases out of personal experiences). Some examples: deployments take a lot of time, change of priorities, urgent bugfixing, fast growing team perhaps...
During the session the ease of use will become clear and multiple ways how to setup source control will be explained step by step.
Do you want to have everything in source control at once or would you like a phased approach, everything is possible if you know how to start. Principles of Git will be explained shortly.
Near the end of the session, a couple of topics will be covered how to move forward after a successful implementation of database projects and Azure DevOps since this is only the beginning.
At the end of the session you should have a starting position to be able to start your adventure and where you might get to in the end.
Database Deployment Automation using Database Projects & Azure DevOps
You have implemented Database Projects and Azure DevOps for database development successfully in your organization and you want to make your life easier by automating your database deployments? If the answer is yes, this session is for you!
At the beginning of this session, we will do a quick recap of Database Projects and Azure DevOps. Just to make sure that we are all on the same page.
During the session, we will set up an example build and deploy pipeline. Since there are a couple of ways to deploy changes from Azure DevOps to your target database, We will discuss a couple of scenarios and I will show you which method I'm using.
- 1 Pipeline to rule them all
- multi-step deployment
During this session, we will also cover the deployment pipeline differences between SQL Server and AzureSQL.
At the end of this session, you should have all you need to start with database deployment automation.
Migrating from SSRS to Power BI Paginated Reports
Are you wondering how to transition from SSRS to Power BI Paginated Reports?
Since Power BI Paginated Reports became a Power BI Pro feature, Paginated Reports took my attention.
In this session, I will be explaining how to migrate your SSRS reports to Power BI Paginated reports. How to handle subscriptions, timed & data driven subscriptions in Power BI and what the differces are and which alternatives you can use.
During this session will we will be migrating a single SSRS report during a demo and I will be explaining how to migrate multiple SSRS reports at once.
By the end of this session, you will have a great starting point to migrate your SSRS reports to Power BI using several methods. One-by-One, Multiple reports at the same time and how to setup your subscriptions.
Apache Spark for SQL Data Warehouse Developers
Are you wondering how to get started with Azure Databricks? Are you currently working with SQL Server or Azure SQL (MI)? Or, are you a Data Warehouse developer?
Apache Spark gained popularity in the past few years and became the new cool kid on the block. But what is Apache Spark and how can we leverage its capabilities? Which skills do we need? During this session, I will show you how we can use Apache Spark within Azure Databricks.
In this session, we will start with an introduction to Apache Spark and we will learn how we can use our SQL knowledge in Azure Databricks.
After the introduction, we will be focussing on practical examples and we will be comparing how we will solve challenges in SQL, and what the alternatives are in Azure Databricks.
You will learn how you can apply your SQL knowledge in Azure Databricks.
By the end of this session, you will have a solid understanding of how you can use your SQL skills to solve challenges in Azure Databricks.
Are you wondering how to get started with Azure Databricks? Are you currently working with SQL Server or Azure SQL (MI)? Or, are you a Data Warehouse developer?
Apache Spark gained popularity in the past few years and became the new cool kid on the block. But what is Apache Spark and how can we leverage its capabilities? Which skills do we need? During this session, I will show you how we can use Apache Spark within Azure Databricks.
In this session, we will start with an introduction to Apache Spark and we will learn how we can use our SQL knowledge in Azure Databricks.
After the introduction, we will be focussing on practical examples and we will be comparing how we will solve challenges in SQL, and what the alternatives are in Azure Databricks.
You will learn how you can apply your SQL knowledge in Azure Databricks.
By the end of this session, you will have a solid understanding of how you can use your SQL skills to solve challenges in Azure Databricks.
DataSaturday Madrid 2024 (SQLSatMadrid) Sessionize Event Upcoming
Data Saturday Croatia 2024 Sessionize Event
Data Saturday Stockholm 2024 Sessionize Event
DataGrillen 2024 Sessionize Event
Techorama 2024 Belgium Sessionize Event
KCSSUG
Migrating from SSRS to Power BI Paginated Reports
Athens Power BI User Group User group Sessionize Event
Data Saturday München 2024 Sessionize Event
DAISF
Database Deployment Automation using Database Projects & Azure DevOps
KCSSUG
Improving Team Collaboration Using Database Projects and Azure DevOps
PASS Data Community Summit 2023
Database Projects & Azure DevOps, 101, From Hero to Zero
Future Data Driven Summit 2023 Sessionize Event
PASSMN Monthly Meeting
Migrating from SQL Server Reporting Services to Power BI Paginated Reports
Data Saturday Gothenburg 2023 Sessionize Event
Multicloud4u
Getting started with SQL Server Data Tools & Azure DevOps
Microsoft Data Platform User Group - Birmingham (Virtual)
Improving Team Collaboration Using Database Projects and Azure DevOps
SQL Saturday New York City 2023 Sessionize Event
Data Saturday Denmark - 2023 Sessionize Event
SQLSaturday MN 2022 Sessionize Event
Data Bristol Meetup
Bristol Data User Group Meetup
When? November 23rd, 2022 at 18h30 GMT
Where? Immersive Labs, 6th Floor, The Programme, All Saints' St, Bristol BS1 2LZ (Registration via Meetup.com required)
DataGrillen 2022 Sessionize Event
Olivier Van Steenlandt
BI Teamlead @ X²O
Sint-Niklaas, Belgium
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top