MikeIT.dev
Portfolio
Selected projects, anonymized and without internal system detail.
Data management
Metadata Governance Platform
Central management and quality assurance of metadata across a grown Access and MySQL landscape.
View project
Business Intelligence
Power BI Executive Dashboard
Star-schema data model and automated KPIs instead of monthly hand-maintained reporting spreadsheets.
View project
IT infrastructure
Office 365 & Access Migration Toolkit
Grown 32-bit Access applications brought to 64-bit under Microsoft 365 and Citrix, without a rebuild.
View project
Data collection, automation
DWD Weather Data Crawler
Weather data fetched automatically, matched to locations via geocoding, and stored in MySQL for analysis.
View project
AI infrastructure
Local AI Infrastructure with Ollama & Qdrant
RAG applications on your own documents, fully on-prem with Ollama and the Qdrant vector database.
View project
Industry, manufacturing
SmartFactory Control Center
Scattered production and process data brought together in one central monitoring tool.
View project
/ Next step
Similar challenge in your team?
Describe your workflow briefly, I will give a realistic view of what Excel, VBA, or Power Query can do.