01 · Foundations
Data engineering
Nothing downstream works if the data arrives late, twice, or in three
different formats. We design the plumbing: integration between the systems
you already run, ETL that runs on a schedule instead of on somebody's
laptop, migrations that do not lose history, and database design that will
still make sense in three years.
- System integration and scheduled ETL
- Data migration and consolidation between platforms
- Database and warehouse design, including SQL Server and MySQL
- Data quality rules, reconciliation and exception reporting
02 · Interface
Data visualisation
A dashboard is a piece of user interface, not a gallery of charts. We start
from the decisions it has to support and work backwards — which means fewer
visuals, clearer ones, and a report that gets opened on a Monday morning
without anybody being reminded.
- Power BI reports, datasets and workspace structure
- Excel dashboards for teams not yet on Power BI
- Star-schema modelling so totals stay correct under any filter
- Scheduled refresh, gateways and row-level security
03 · Discovery
Data mining
When you suspect something is in there but cannot name it yet. We work
through large datasets looking for the segments, sequences and
relationships that repeat — and we show the working, so the finding can be
argued with rather than simply believed.
- Customer and product segmentation
- Trend, seasonality and anomaly detection
- Basket and sequence analysis
- Plain-language write-ups your board can read
04 · Answers
Data analysis
A specific question, properly answered. What changed last quarter, which
branch is carrying the margin, why the write-offs moved, what a price change
would actually do. Scoped tightly, delivered quickly, with the assumptions
stated up front.
- Ad-hoc investigations with a defined question and deadline
- Month-end and management reporting packs
- Variance, cohort and profitability analysis
- Second opinions on numbers you have already been given
05 · Handover
Training
The part that makes the rest stick. Scheduled Excel and Power BI classes at
three levels, capped so nobody hides at the back — or run privately for your
team using your own reports.
See courses and dates