David Geller / Toronto, Canada

Senior Data Analyst · Analytics, Automation & Applied AI

Turning complex data into clear decisions.

I connect analytical thinking, reliable automation, and practical AI to help people make sense of what comes next.

Analytics workflow
ExploreConnectUnderstand

My work spans analytics, automation, and applied AI.

Areas of expertise ↓

01 / What I bring

Areas of expertise

From the first question to a repeatable workflow, I bring technical care and a practical understanding of how people use data.

01

Analytics & business intelligence

Useful reporting starts with a well-defined question.

I translate operational questions into consistent metrics, SQL analysis, and Power BI reporting that people can use with confidence.

In practice

Building reporting views that help teams interpret activity, compare periods, and understand workforce trends.

SQL · Power BI · DAX

02

Python automation

Less repetition. More room for analysis.

I build and maintain recurring workflows, from extracting and preparing files to validating outputs and investigating failed runs.

In practice

Automating routine exports and spreadsheet processing, with clear checks and logs to make recurring work easier to support.

Python · pandas · Playwright

03

Workflow improvement & data quality

Confidence in the process, not just the result.

I work through definitions, source differences, and exceptions so that analytical outputs are repeatable and easier to trust.

In practice

Reconciling records and reporting logic, clarifying counting rules, and making data-quality issues visible before results are shared.

Validation · Reconciliation · Documentation

04

Applied machine learning

Practical models. Thoughtful interpretation.

I contribute to operational forecasting and prediction workflows, with attention to input quality, evaluation, and reliable execution.

In practice

Supporting forecasting workflows through data preparation, performance analysis, and troubleshooting how predictions are produced.

Python · Forecasting · Model evaluation

The toolkit

DRAG · FLICK · BOUNCE

Tools & technologies

AutomationProfessional practice

A general-purpose programming language widely used for data analysis and automation.

Analysis, recurring automation, validation, and prediction workflows.

AnalyticsProfessional practice

A language for querying and transforming data in relational databases.

Reporting queries, joins, cohort logic, and reconciliation.

AnalyticsProfessional practice

Microsoft’s platform for interactive dashboards, reports, and data analysis.

Interactive reporting, operational measures, and decision support.

AutomationProfessional practice

A Python library for working with tables and time-series data.

Preparing, transforming, and checking tabular data.

AnalyticsProfessional practice

The formula language used to create calculations and measures in Power BI.

Reusable measures, date context, and period comparisons.

AnalyticsProfessional practice

Microsoft’s spreadsheet application for organizing, calculating, and analyzing data.

Reporting, analysis, workbook validation, and repeatable preparation.

MLProfessional practice

A Python library for numerical calculations and multidimensional arrays.

Numerical processing and analytical preparation.

AnalyticsProfessional practice

A tool for connecting to, cleaning, and reshaping data in Power BI and Excel.

Data preparation in Power BI and Excel workflows.

AutomationProfessional practice

A toolkit for controlling web browsers through code.

Browser automation for recurring extraction and download workflows.

MLApplied ML work

A Python library for training and evaluating machine-learning models.

Working with predictive-model workflows and evaluation.

AnalyticsProfessional practice

Microsoft’s relational database management system.

Analytical querying and temporary-table analysis.

AutomationPrior professional use

A programming language designed for statistical analysis and data visualization.

Analytics and automation, including R-to-Python modernization.

AutomationProfessional practice

A Python library for reading and editing Excel workbook files.

Reading, updating, and validating Excel workbooks.

AutomationProfessional practice

A toolkit for automating web-browser interactions.

Automated browser navigation and recurring report extraction.

ProductProfessional and project use

A version-control system that tracks code changes and supports branching and collaboration.

Version control and keeping technical work reviewable.

ProductPersonal product work

A platform for hosting Git repositories and collaborating on software.

Source repositories and collaboration around personal projects.

ProductDevelopment environment

A code editor with tools for development, debugging, and version control.

Working with code, scripts, and version control.

MLApplied ML work

A Python library that simplifies machine-learning experiments and model comparison.

Exploring and comparing modeling approaches.

MLModel evaluation

A machine-learning library that builds predictive models using boosted decision trees.

Evaluating forecasting models and comparing predictive performance.

MLModel evaluation

A machine-learning library for efficient gradient-boosted tree models.

Explored as a candidate modeling approach in forecasting work.

AutomationProfessional practice

A Windows tool that runs programs and scripts at scheduled times or after specific events.

Scheduling recurring runs and supporting their execution.

AnalyticsProfessional practice

Microsoft’s application for creating presentations.

Communicating analytical findings and operational trends.

ProductKeystone product work

An open-source relational database system.

Hands-on database schema migrations for Keystone.

ProductKeystone product work

A development platform built around PostgreSQL, with authentication, storage, and APIs.

Creating and applying database migrations in product development.

ProductPersonal product work

A programming language that adds type checking to JavaScript.

Building and refining product features with AI assistance.

ProductProject exposure

A JavaScript library for building interactive user interfaces.

Collaborative, AI-assisted product development.

ProductProject exposure

A programming language used to add behavior and interactivity to websites and applications.

Personal and collaborative browser-based product work.

ExploringExploration and local testing

Tools that connect AI assistants to Power BI workflows through the Model Context Protocol.

Investigating AI-assisted authoring and analytical workflows.

AutomationProfessional practice

Microsoft’s platform for automating tasks and connecting workflows across applications.

Building automated workflows to support day-to-day work.

ProductWorkflow and collaboration

A tool for tracking tasks, issues, and project work.

Organizing and tracking work.

ProductVersion control and collaboration

A platform for hosting Git repositories, reviewing code, and collaborating on development.

Working with Git repositories and collaborating on code.

Drag to push · Flick to throw · Click for context

Click a tool for details · Select All to move the words around

Drag to push · Click for context · Reduced motion enabled

02 / Beyond the day job

Personal projects

Alongside my analytics work, I help develop Keystone Web and am building a resort-management game with AI assistance.

Product development · Co-founder

Keystone Web

I contribute to a Canadian website-building platform through product planning, UX, testing, and AI-assisted development, including work on its AI assistant, Archie.

Ongoing product workVisit Keystone ↗

Personal project · Simulation & game design

All Inclusive

A resort-management game in development, with systems for pricing, staffing, and guest experience. I use AI assistance to develop and test the game.

In developmentAsk me about it ↗

03 / Blog posts

Notes from the workbench.

All blog posts ↗

04 / Site statistics

This site,
in data.

Explore the site’s content by word count and reading time.

— words across — published URLs

Select a bar to explore a page.

Turning complex data into clear decisions.

Analytics capabilities, the interactive toolkit, personal projects and recent notes.

Visit Home ↗

Estimated read—

About me

Career progression, education, working approach, and an expanding interest in applied AI.

Visit About ↗

Estimated read—

Blog posts

The index of published explorations in data, automation and AI. Article bodies are counted separately.

Visit Notes ↗

Estimated read—

I gave an AI coding agent 24 hours to build a business intelligence tool

I gave an AI coding agent 24 hours to build KeyBI, a browser-based alternative to Power BI. Six reports and a million-row benchmark later, here’s what worked, where the agent fell short, and what I’d test next.

Read article ↗

Estimated read—

What I learned building a Power BI report with AI and MCP

An experiment in Power BI model development, report design and validation—with synthetic data throughout.

Read article ↗

Estimated read—

Contact

Get in touch

I’m interested in opportunities where analytics, thoughtful automation, and practical AI can make a difference. Let’s talk about what you’re working on.