Skip to content
View floriankilian's full-sized avatar
  • Zurich, Switzerland

Highlights

  • Pro

Block or report floriankilian

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
floriankilian/README.md

Florian Bötsch

Data analyst and project manager with a background spanning academia, venture capital, and cultural institutions. I build things that turn messy data into decisions. ETL pipelines, BI dashboards, and automated reporting workflows.

Education: M.A. Business Innovation, University of St.Gallen (HSG)


Skills

Languages & Tools · Python · SQL · R
BI & Reporting · Power BI (certified) · DAX · Excel / Power Query
Cloud · Azure (AZ-900)
Methods · ETL pipelines · data modelling · process automation · stakeholder reporting


Selected Work

Project Stack Description
ETL Pipeline – Historical Museum Basel Python · Excel / Power Query Processed and normalised 35,000+ heterogeneous collection records spanning 70+ years
Management Cockpit – University of St.Gallen Power BI · DAX Centralised KPI dashboard for governance and international accreditation reporting
Course Evaluation Automation Excel · Power Query Automated semi-annual evaluation workflow for 1,000+ courses — 90% reduction in processing time
Global Sales Performance Analysis – Mercedes-AMG Excel Competitive analysis across AMG, Porsche, BMW M, Audi RS, and Bentley — segmented by geography, product category, and powertrain type to inform AMG's 2020 sales strategy

Portfolio projects coming soon.


Certifications

  • Microsoft Azure Fundamentals (AZ-900) · 2026
  • Microsoft Power BI Data Analyst · 2024
  • IBM Data Science Fundamentals with Python and SQL · 2021
  • Google Data Analytics Professional Certificate · 2021

Contact

florian@boets.ch  ·  LinkedIn

Pinned Loading

  1. SaveToReadwiseReaderOnTwitter SaveToReadwiseReaderOnTwitter Public

    JavaScript 7

  2. davidnewschool/sound-delay davidnewschool/sound-delay Public

    A Python tool to estimate the distance of an explosion in a video based on the sound delay between the flash and boom of the explosion

    Jupyter Notebook 33 5

  3. Audio-Transcribition Audio-Transcribition Public

    Jupyter Notebook

  4. OpenFrontStats OpenFrontStats Public

    JavaScript