PROJECTS

  • Titel dia

    LOGICAL DATAMODEL ENERGY TRANSITION

    Knop
  • Titel dia

    MEDICINE DATAWAREHOUSE CLOUD MIGRATION

    Knop
  • Titel dia

    REAL ESTATE DASHBOARDS

    Knop
  • Titel dia

    MASTERCLASS DATA ANALYTICS

    Knop
  • Titel dia

    BUSINESS ANALYSIS & AUDIT DASHBOARDS

    Knop
  • Titel dia

    DATA CONSULTANCY 

    Knop
  • Titel dia

    SOLAR & ENERGY GROUP PURCHASING DASHBOARDS

    Knop
  • Titel dia

    BUSINESS ANALYSIS PLASTIC RECYCLING

    Knop
  • Titel dia

    AZURE DATAWAREHOUSE WINE 

    Knop
  • Titel dia

    DASHBOARDING MEDIA & ADVERTISING

    Knop

MEDIA & ADVERTISING


SNOWFLAKE  •   TABLEAU •   PYTHON   •   DBT

RTL

DASHBOARDING MEDIA & ADVERTISING

July 2024 - Jan 2025

Results:

  • Dashboarding Media and Advertising
  • Dashboarding Finance and Audit
  • Created new datasources based on efficiënt datamodeling


RENEWABLE ENERGY


SNOWFLAKE  •   POWERBI   •   PYTHON   •   DBT

ESSENT

DATAMODELING THE ENERGY TRANSITION

Aug 2023 - Mar 2024

Results:

  • Logical Datamodel that combines all Essent Datawarehouses into one
  • AWS Cloud Dataplatform that accelerates Dutch Energy Transition




COMMODITY


SQL  •   POWERBI   •   PYTHON   •   AZURE

SLURPINI

AZURE DATAPLATFORM WINE

May 2023 - Sep 2023

Results:

  • Complete Azure Dataplatform for Wine
  • Automated ETL with Azure Databricks, Azure Data Factory
  • Automated dashboards with PowerBI



HEALTHCARE


SQL  •  POWERBI •   AZURE

CBG

DATAWAREHOUSE CLOUD MIGRATION

May 2023 - Sep 2023

Results:

  • Migration of Datawarehouse to Azure Cloud
  • Business Analysis SQL Server Datawarehouse



FINANCE


SQL  •  TABLEAU  •   AZURE

MILEWAY

FINANCE & REAL ESTATE DASHBOARDS

Feb 2022 - Nov 2022

Results:

  • 21 Billion Recapitalization of Mileway
  • Automated Audit Dashboards



EDUCATION


SQL  •  TABLEAU  •  POWERBI •   PYTHON

SPRINGBOARD

MASTERCLASS DATA ANALYTICS

Aug 2020 - Nov 2022

Results:

  • + 5.000 IT Students graduated
  • + 31.000.000 Dollar raised to expand education platform



INDUSTRY


SQL  •  POWERBI •   AZURE

MIMAKI

BUSINESS ANALYSIS & AUDIT DASHBOARDS

Sep 2021 - Jan 2022

Results:

  • Automated audit reporting
  • Tech support dashboard
  • + 99.20% Revenue 2020-2021


DATA CONSULTANCY


SQL  •  POWERBI  •  TABLEAU  •  PYTHON  •  AZURE  •  DBT

VIQTOR DAVIS

BUSINESS ANALYSIS & DASHBOARDS

Sep 2020- Sep 2021

Projects:

  • 01.2021 – 09.2021: RIVM - COVID Vaccination Dashboard
  • 03.2021 – 06.2021: VION - Masterdata Management Migration Analysis
  • 11.2020 – 05.2021: MSCA - Multiple Sclerose Dashboard
  • 10.2020 – 01.2021: VION - Detailed Assessment BI Landscape
  • 09.2020 – 11.2020: Aalberts HFC - Blueprint Migration Cloud


RENEWABLE ENERGY


SQL  •  TABLEAU  •   AZURE

ICHOOSR

SOLAR & ENERGY GROUP

PURCHASING DASHBOARDS

Feb 2017 - Dec 2019

Results:

  • Automated reporting and forecast modeling
  • + 650.000 Solar panels installed
  • + 67.000 Green energy switchers in last auction
  • + 2.600.000 Households switched with group purchasing campaigns
  • + 765.000.000 Euro saved

RECYCLING


POWERBI    •    PYTHON

PLASTIC HUNTERS

BUSINESS ANALYSIS &
PLASTIC RECYCLING PLATFORM

Sept 2016 - March 2017

Results:

  • New educational track 3D printing and recycling on elementary schools
  • + 32% Plastic recycling in Amsterdam South-East