Presentation
My services include building and querying relational databases using SQLite, writing complex SQL queries involving JOINs, aggregations, subqueries and CASE statements, and translating data into clear Excel reports using VLOOKUP, pivot tables and charts.
In a recent project, I built a complete football squad management database with 3 related tables covering 25 players, their injury records and contract details. I wrote 6 business-driven SQL queries answering questions around wage expenditure, player availability and contract risk, then replicated the analysis in Excel using pivot tables and dynamic lookups.
Whether you need a database built from scratch, existing data cleaned and structured, or reports created in Excel, I deliver accurate results with clear explanations that non-technical clients can understand.
