AboutAbout

Timothy Kirk

Solutions Engineer specialising in Data, AI and Automation with six years of experience in business intelligence.

I design and deliver data, reporting, automation, and AI solutions that help organisations make better decisions and reduce manual effort. With six years of experience across business intelligence and solution engineering, I build scalable solutions using Power BI, SQL, Microsoft Fabric, Python, and the Power Platform.

My work spans the full data lifecycle, from data ingestion, warehousing, and semantic modelling through to dashboards, automated reporting, and production support. I focus on creating solutions that are performant, maintainable, and capable of being owned by the business long after delivery.

Alongside traditional BI development, I design and implement automation and AI-driven workflows that streamline business processes, improve data quality, and remove repetitive manual tasks. This includes everything from data pipelines and validation processes to intelligent document processing and operational automation, always with a focus on practical business value and long-term reliability.

Role

Solutions engineer

Focus

Power BI · SQL · SSRS · AI

Experience

Six years in BI

How I workHow I work

How I work

01

Approach

I begin with how the solution will be operated after release: who will own it, where it can fail, and what decisions it needs to support. I then design the model and the SQL to match that requirement.

  • Requirements and constraints are agreed first.
  • The path from warehouse to Power BI is designed as one piece of work.
  • Handover assumes operations can run it without further support.

02

Scope

I deliver Power BI reports, semantic models, SQL, and SSRS reports, together with the administration required for reliable refresh.

  • Semantic models that other reports can reuse.
  • Pipelines and refreshes that run on defined schedules.
  • Reports that stakeholders can use independently.

03

Automation

Where reporting still depends on manual file handling or row-by-row checks, I replace that work with automation. I use AI where it is appropriate, rather than as a default.

  • Integrated into the existing workflow.
  • Reduces manual effort and surfaces data-quality issues earlier.
  • Released only when it operates reliably.
SkillsSkills

Technical skills

Data platform

  • SQL Server
  • SSRS
  • Power BI
  • Semantic models
SQL Server
Querying and transforming data warehouses for models and reports.
Semantic models
Relationships and measures that reports can share.
Power BI
Operational reports designed for ongoing use.
SSRS
Scheduled operational reports in production.

Reporting operations

  • Workspaces
  • Gateways
  • Scheduled refresh
  • Self-service
Administration
Workspace and capacity management for live reports.
Refresh
Gateway configuration and schedules for unattended refresh.
Warehouse
Investigation of data issues that present as report faults.

Systems and automation

  • SQL pipelines
  • AI / ML
  • Data quality
  • Process automation
SQL pipelines
Scheduled ingestion and transformation for reporting.
AI
Classification, extraction, and validation at volume.
Integration
Failure handling agreed before release.

Working with stakeholders

  • Self-service reporting
  • Dashboard UX
  • Technical communication
  • Problem solving
Self-service
Reports that operations teams can filter and reuse without a further request.
Dashboard UX
Layout and hierarchy that make the next action obvious.
Communication
Technical choices explained in the language of the decision they support.
ToolsTools

Working tools

Browser-based tools used in day-to-day delivery.

01 / 05

01 · Bento Designer

Design Power BI canvas layouts, style cells, preview visuals, and export PNG or SVG.

Open full version

01 · Bento Designer

Layout canvas for Power BI backgrounds. The preview loads when this section is in view.

01 · Bento Designer

The layout canvas is built for a larger screen. Open the full version on a laptop or desktop to design and export.

ArticlesArticles

Articles

Short notes on Power BI, SQL, and the tools on this site.

01

Power BI bento canvases

How a 16:9 background is laid out before it reaches the report, and what Bento Designer is for.

Read

02

SQL IN from a pasted list

Turning a column of values into a quoted IN clause without breaking the query.

Read

03

Power BI date tables

Generate a date table in DAX or M, then mark the Date column as a date table in Model view.

Read

View more

StudiesStudies

Public studies

Two Power BI reports built from Kaggle datasets, and a personal project. Not client work.

Power BI

Credit card fraud

Fraud concentration and loss exposure, with trends and segment filters.

Power BI

Barcelona air quality

NO2, O3, and PM10 by time and location, with drill-down filters.

Personal

Neural Racer

Cars learn a track with neural networks and a genetic algorithm, in the browser.

Open Neural Racer

NowNow

Current work

I design and deliver enterprise reporting, data, and automation solutions across Power BI, SQL, Microsoft Fabric, and the Power Platform. My work spans everything from data pipelines and semantic models through to production reporting, scheduled refreshes, and the underlying warehouse architecture that supports them. I focus on improving data quality, performance, and reliability while transforming manual processes into scalable automated workflows.

Alongside traditional BI development, I build AI-assisted solutions that automate document processing, image analysis, data validation, and business workflows. These solutions combine machine learning, automation, and data engineering techniques to reduce manual effort, improve accuracy, and enable faster decision making.

The tools featured on this site reflect the technologies I use every day, whether I'm designing reporting solutions, developing data pipelines, writing and optimising SQL, building automation workflows, validating datasets, or accelerating development with AI-assisted engineering practices.

Keys 1 · 2 · 3 · 4 · 5