Skip to content
View oliver-stott's full-sized avatar

Block or report oliver-stott

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
oliver-stott/README.md

🚀 From Web Development to Data Analytics

👋 Hi, I’m Oliver, a Microsoft-certified Data Analyst (PL-300) with 7+ years of experience in full-stack web development, now transitioning into data analytics and data science.

After years of building dynamic, data-driven web applications, I’m now focused on uncovering insights, building dashboards, and solving real-world problems with data.

🧠 Background & Technical Foundation

Over the past several years, I’ve worked in fast-paced agencies and e-commerce startups, developing custom platforms and using analytics tools to inform product and UX decisions.

Core skills include:

  • 🛠️ JavaScript (React, Node.js), PHP, HTML/CSS
  • 🧩 Power BI, SQL, Excel, Python (Pandas, Matplotlib)
  • 📊 GA4, VWO (A/B Testing), Microsoft Clarity, GTM

This hands-on experience with user behavior tracking, performance optimization, and data transformation gives me a unique edge in business intelligence and analytics.

📁 Projects You'll Find Here

This repository showcases hands-on projects that reflect my growing skill set in:

  • 🟢 Power BI: Dashboards, data modeling, DAX, storytelling
  • 📘 SQL: Queries, joins, subqueries, window functions
  • 📈 Excel: Pivot tables, data cleaning, business metrics
  • 🐍 Python: Pandas, NumPy, Seaborn, visual exploration
  • 🔄 ETL-style workflows using a mix of dev and data tools

You can find detailed writeups and links for each project inside their respective folders.

🎯 Career Goal

I’m combining my development background with a growing data skill set to pursue roles in:

  • Data Analysis
  • Business Intelligence
  • Data Science (long-term goal)

I’m looking to contribute to data-driven teams that value technical versatility and insight generation and I’m always adding new projects to this portfolio.

📌 Let’s connect on LinkedIn or explore the pinned projects below!

Pinned Loading

  1. adventure-works-sales-dashboard-powerbi adventure-works-sales-dashboard-powerbi Public

    A detailed PowerBI report built from E2E, and using advanced data modelling, DAX and Power Query to perform normalisation, EDA and create beautiful and digestible interactivity.

  2. maven-market maven-market Public

    A PowerBI reporting exercise, playing around with Data Modelling and more complex DAX Measures.

  3. Setting up a Data Dictionary in Powe... Setting up a Data Dictionary in Power BI
    1 
    Data Dictionary =
    2 
    VAR _columns = SELECTCOLUMNS(
    3 
    FILTER(
    4 
    INFO.VIEW.COLUMNS()
    5 
    ,[Table] <> "Data Dictionary" && NOT([IsHidden])
  4. sean-lahman-baseball sean-lahman-baseball Public

    A deep dive SQL data analysis using the Sean Lahman Baseball database provided by Maven Analytics

  5. Bike-Sales-Dataset Bike-Sales-Dataset Public

    A simple dataset used for Data cleaning, Building Pivot Tables, Generating visualisations and creating a Dashboard.

  6. retail-store-sales retail-store-sales Public

    A data-cleaning and visualisation exercise