Services / Overview
Services
Focused on what eats time in practice: recurring Excel work, reports, data prep, and grown Office systems. Each area has its own service page.
VBA · Excel + Access
Office automation as one discipline: Excel macros with Option Explicit and custom error classes, Access apps with 32→64-bit migration, backend moves to SQL Server. Refactor beats rebuild.
Learn more
Excel templates & structure
Template architecture instead of spreadsheet chaos: separated input/logic/output zones, ListObjects instead of range addresses, validation, protection logic, a file your team still understands 18 months later.
Learn more
Reporting automation
Monthly and weekly reports from click marathon to a reproducible pipeline: Power Query as ETL, Power Pivot/DAX as model, KPI definition table, audit trail on every refresh.
Learn more
Internal business tools
Lean internal helpers that colleagues work with directly: input masks instead of email chains, small lookup and status tools, internal mini-dashboards. Small scope, clear ownership, no enterprise overhead.
Learn more
Knowledge bases
Structured team knowledge: glossaries, process documentation, handover skeletons, searchable snippets. Head knowledge becomes team knowledge, without anyone needing wiki discipline first.
Learn more
Access VBA & databases
Maintain, refactor, or migrate grown Access applications: 32→64-bit, DAO/ADO, ODBC, SQL Server backend. Experience from public-sector and mid-size business environments.
Learn more
Power BI & Data Analytics
A star-schema data model instead of one giant flat table, DAX measures instead of calculated columns, connections to SQL Server, Azure, and Microsoft Fabric. Dashboards that refresh themselves and a second analyst can understand.
Learn more
ITSM & IT Infrastructure
Clean up and document Active Directory, Citrix, Windows Server, networking, and access concepts. Monitoring that reports real problems, and a backup concept that is tested, not just claimed.
Learn more
Process automation
Office and file workflows as one strung-through pipeline: CSV imports with schema validation, PDF chains with reproducible layout, Outlook chains with logging. Where Excel hits limits, Power Query and Python step in.
Learn more
Power Query & data prep
Reproducible ETL with the M language: typed imports, query folding back to source, parameter tables, a custom-function library, schema validation with Try/Otherwise. Refresh often 5-30x faster.
Learn more
Python & SQL
Where Excel hits limits: typed Python pipelines with pandas/polars, SQLAlchemy, pydantic, pytest, loguru. SQL tuning via execution plans, views, materialized views, partitioning.
Learn more
AI · Integration
Local LLMs (Ollama, vLLM, llama.cpp), RAG with Qdrant/pgvector, n8n as on-prem orchestrator, MCP servers as a tool bridge. GDPR and EU AI Act as part of the architecture, not bolted on.
Learn more
Training
Excel, VBA, Access, Power BI, and SQL/Python data prep as compact 1 to 2 day formats, remote or in-house. You bring anonymized examples, I structure exercises and outcomes.
Learn more
AI has its own page because the topic needs more room than a service card.
/ Next step
Not sure where to start?
A 30-minute intro call costs nothing. You outline the topic, I give an honest read, directly with the engineer, no sales sequence.