Excel & Power Query

Excel & Power Query: Reliable imports, transformations and models for recurring reporting and planning tasks.

Data preparation, modelling, visualisation and automation can be combined according to your existing Microsoft environment.

A focused solution for your existing processes.

The exact scope is defined around your data sources, users and current Microsoft environment.

  • Clear requirements and a transparent scope
  • Maintainable logic instead of hidden workarounds
  • Tests with realistic scenarios
  • Understandable handover and documentation
Possible building blocks

From raw data to a usable result.

01

Data preparation

Import, clean, combine and validate source data.

02

Logic and model

Define calculations, rules, KPIs and dependencies clearly.

03

Output and handover

Provide a usable result, explain the logic and document the essentials.

Send a question about this topic

Use the contact page or write to me directly.

Contact