OllieRossRussell
Data Analytics / Visualisation / Modelling / Strategy
I deliver end-to-end data analytics, from data preparation and dbt modelling to executive dashboards that turn complex data into clear decisions.
About
I’m Ollie Ross Russell, a data analytics consultant focused on delivering end-to-end analytics solutions (spanning data preparation, SQL querying, dbt modelling and executive-ready dashboards).
Whether shaping reliable reporting layers or crafting clear, decision-ready visuals in Tableau and Power BI, I enjoy owning the full analytics lifecycle across telecoms, sports and commercial datasets.
- End-to-end data analytics
- Data modelling & preparation
- Decision-ready visualisations
- Sports & performance analytics
Experience
BSc Mathematics and Statistics
Newcastle UniversityA strong grounding in data and statistics, and the start of a growing interest in applying it to real-world problems.
Operational Specialist
Zeelo · Boston, MAManaged live transit operations, route performance tracking, and data reporting to optimise daily commuter and shuttle services.
Data Specialist
Kantar · LondonProcessed, validated, and analysed large-scale consumer and market datasets to deliver accurate commercial insights for global brands.
Data Analytics Consultant
The Information Lab · LondonTrained at The Data School in Tableau, Alteryx, SQL, and data storytelling before deploying on long-term client placements at Virgin Media O2 to deliver end-to-end visual analytics and data modelling solutions.
Business Intelligence Specialist
Virgin Media O2 · London Via The Information LabBuilt executive Tableau dashboards monitoring the UK mobile sector, including a flagship suite tracking the launch of the UK’s first direct-to-device satellite service powered by Starlink, presenting regularly to senior stakeholders.
Analytics Engineer
Virgin Media O2 · London Via The Information LabDesigning and maintaining scalable data models and analytics pipelines, enabling reliable reporting and self-service insights across the mobile business.
Featured projects
Outside of day-to-day commercial work, I love creating visualisations on Tableau Public about sports, entertainment, and topics I am passionate about. Open a project to explore the story, or see everything on Tableau Public.
Skills
Hover or tap a tool to see experience depth and how I use it across the stack.
Tableau
Executive BI dashboards & creative data storytelling
Alteryx
Data preparation, spatial analytics and automated workflows
Automated repeatable ETL workflows, spatial joins, regex parsing and multi-source blending for client reporting.
SQL
Querying, warehouse transformation and analysis at scale
Production querying across GCP BigQuery and Snowflake, writing window functions, CTEs and optimised analytical views.
dbt
Modular data modelling, testing and documentation
Building staging-to-mart models, incremental materialisations, schema tests and clean BI semantic layers at VMO2.
AI Workflows
AI-assisted analytics, SQL refactoring and automation
Integrating LLM tooling into SQL/dbt development, Python data scripts, documentation and rapid prototyping.
Power BI
Interactive reporting, Power Query and DAX modelling
Building star-schema semantic models, custom DAX measures and clean executive report layouts.
Badges & certifications
Thoughts & notes
Practical guides on Tableau tips, data visualisation and more. Move your cursor across to steer, or click any post to read it here.
Feedback
“Ollie helps translate our Commercial Compliance requirements into workable data and Tableau solutions, giving us better visibility of credit activity and supporting our ability to identify potential misuse and governance risks... the amount of questions you have answered has truly made a difference.”
Pricing Integrity Specialist · Commercial Compliance“Ollie’s support has been invaluable to the team, particularly in helping us translate complex business requirements into practical data solutions and improving the visibility and quality of our reporting. The dedication, patience and expertise Ollie consistently brings to our work has made a significant difference.”
Stakeholder · Mobile Division
Get in touch
I’m always open to new opportunities, collaborations and interesting projects. Whether it’s a project, a question or just a hello, feel free to get in touch or connect below.
- rossrussellollie@gmail.com
- +44 7725 714657
- London, UK