Skip to content
View axeldrtdata's full-sized avatar

Block or report axeldrtdata

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.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

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

Report abuse
axeldrtdata/README.md

Hi, I'm Axel 👋

Curious by nature, analytical by training

Data Analyst based in Lyon, France. I turn raw data into clear decisions, with Python, SQL and data visualisation.

I'm completing a Data Analyst degree with OpenClassrooms (RNCP Level 6, Bachelor's equivalent). Before that, I lived in Australia, Sweden and the Netherlands, and I work fluently in French and English. I'm especially interested in helping retail and e-commerce businesses understand what really drives their performance.

🌐 Portfolio: axeldrtdata.github.io · 💼 LinkedIn: Axel Derobert

Featured projects

Project What it shows Links
Spotting counterfeit banknotes from six measurements Four machine-learning models compared, 99% accuracy, best model shipped as a reusable script Case study · Code
Which cities are worth investing in on Airbnb? Three-page Tableau dashboard comparing 986 cities in 16 countries, from global market to neighbourhood Case study · Live dashboard · Code
Where should a French poultry brand export first? 164 countries, 15 PESTEL indicators, PCA and clustering turned into a three-stage export roadmap Case study · Code
Who still enrols in the Data path? dbt and Snowflake pipeline with SHA-256 pseudonymisation, INSEE enrichment and 47 data tests, then an analysis of four years of students Case study · Code
Is a 7.3% budget overrun under control? Power BI dashboard tracking 104 IT and marketing projects on costs, delays and deliverables, with DAX and Row-Level Security Case study · Code
Was the wine shop really sitting on three years of stock? Stock and sales analysis for an online wine shop, then an audit of my own notebook with Claude and Gemini, rebuilt with 10 pandera validation rules Case study · Code
What really drives sales at an online bookshop? Two years of sales analysed: revenue trends, catalogue Pareto, Lorenz curve and five statistical tests on customer profiles Case study · Code
What do 34,000 property sales reveal about the French market? Relational database of 34,000 property sales and twelve SQL queries, from joins to window functions Case study · Code
Does the world produce enough food to feed everyone? Public-health study for the FAO on four datasets: undernourishment, how many people the food could feed, where it goes and where aid goes Case study · Code
What do 30,000 home insurance contracts reveal? SQLite database of 30,335 contracts and twelve SQL queries on customers, homes and premiums Case study · Code

All case studies are on my portfolio.

Toolkit

  • Languages · Python, SQL, DAX
  • Libraries · pandas, NumPy, scikit-learn, Matplotlib, Seaborn, Plotly
  • Tools · Power BI, Tableau, dbt, Snowflake, SQLite, Excel, VS Code, Git

Pinned Loading

  1. counterfeit-banknotes counterfeit-banknotes Public

    Detecting counterfeit euro banknotes from 6 geometric measurements. 4 ML models compared (logistic regression, random forest, KNN, k-means): 99% accuracy, 98/100 fakes caught. Python · scikit-learn

    Jupyter Notebook

  2. airbnb-investment-dashboard airbnb-investment-dashboard Public

    Tableau dashboard to compare Airbnb investment opportunities across 986 cities in 16 countries, from global market to neighbourhood. Python · Tableau

    Jupyter Notebook

  3. poultry-export-markets poultry-export-markets Public

    International market study for a French poultry exporter: 164 countries, 15 PESTEL indicators, PCA and clustering (hierarchical + k-means) to rank export targets. Python · scikit-learn

    Jupyter Notebook

  4. student-demographics-dbt student-demographics-dbt Public

    A dbt and Snowflake pipeline that cleans, pseudonymises and enriches four years of OpenClassrooms enrolments with INSEE data, then reads how the student profile is changing

  5. sanitoral-powerbi-dashboard sanitoral-powerbi-dashboard Public

    A Power BI dashboard that tracks 104 IT and marketing projects for an oral care company in 52 countries on costs, delays and deliverables, for three levels of directors

  6. online-bookshop-sales online-bookshop-sales Public

    Two years of sales and 680,000 purchases: revenue trends, catalogue tops and flops, customer concentration and five statistical tests (chi-squared, Spearman, Kruskal-Wallis, ANOVA) on what a custom…

    Jupyter Notebook