Excel
Advanced formulas, pivot analysis, financial models, and operational reporting.
Capability directory
Tools for Analysis and Delivery
Analytics & business intelligence
Google Sheets
Shared planning systems, live trackers, and dashboards for collaborative teams.
Power BI
Power Query transformations, DAX measures, and interactive KPI dashboards.
Tableau
Visual exploration and geographic or commercial dashboards for stakeholder decisions.
Looker Studio
Connected reports and performance dashboards that make recurring metrics easy to review.
Zoho Analytics
Business data analysis and reporting views for monitoring team performance.
Full-stack development
Django
Server-rendered templates, ORM models, and service logic for complete web applications.
HTML5 & CSS3
Semantic pages, responsive layouts, and accessible forms for mobile and desktop.
JavaScript
Interactive forms and browser workflows using Fetch, FormData, and geolocation.
JSON endpoints
Validated requests and structured responses connecting browser interactions to backend services.
Authentication & access
django-allauth, email verification, OAuth support, staff TOTP MFA, and Turnstile checks.
Maps & geolocation
Location capture, map interfaces, and geographic filtering for civic issue reporting.
Admin & moderation
Staff review tools, permission checks, and transaction-safe status changes.
Uploads & media processing
Upload validation, image handling with Pillow, and video processing with FFmpeg.
Streamlit
Data and operations interfaces for practical internal tools and everyday workflows.
Databases & integration
SQL
Joins, aggregations, validation queries, and reusable datasets for reporting.
PostgreSQL & PostGIS
Relational application data, spatial models, and location-based queries.
SQL Server
Structured data extraction and relational reporting for business analysis.
Database design
ER diagrams, relationships, constraints, indexing, and query optimization.
Connected Sheets & integration
Combine source data and connected spreadsheet workflows into consistent reporting inputs.
dbt & Supabase
Dimensional data transformations and optional hosted persistence for operations applications.
Programming & analysis
Python
Reusable scripts for data processing, application logic, and operational analysis.
pandas
Clean, transform, aggregate, merge, and validate data before analysis or reporting.
RapidFuzz
Fuzzy matching to reconcile inconsistent names, identify duplicates, and align records.
R & RStudio
Statistical workflows, tidyverse data preparation, and tidymodels model comparison.
SPSS
Statistical analysis and interpretable summaries for research and reporting.
Exploratory & statistical analysis
Investigate patterns, test assumptions, and translate findings into useful recommendations.
Automation & spreadsheet applications
VBA & macros
Automate repetitive Excel tasks, workbook controls, and reporting routines.
Google Apps Script
JavaScript workflows, scheduled triggers, and automation across Google Sheets tools.
Spreadsheet applications
Reusable templates, calculators, and guided inputs with validation and clear outputs.
Reporting automation
Repeatable reporting systems and Outlook draft workflows that reduce manual preparation.
Document generation
Excel, Word, and PDF outputs using OpenPyXL, python-docx, and ReportLab.
YouTube & Reddit extraction
Collect and structure platform data for analysis, research, and reporting.
Engineering & delivery
Automated testing
Django unit, integration, and security tests for permissions, validation, and application workflows.
Git & GitHub
Version control, repository-based project sharing, and static showcase publishing.
Requirements & workflow design
Turn business needs into practical workflows, reporting requirements, and usable tools.
Documentation & training
Clear guides, handover notes, and staff training that help teams use and maintain solutions.
Client & stakeholder communication
Clarify requirements, share progress, and explain findings to technical and business audiences.
Operations & process improvement
Remote operations support, reporting coordination, and better processes for daily team work.