Skip to content
View aleivaar94's full-sized avatar
🌮
A taco
🌮
A taco

Highlights

  • Pro

Block or report aleivaar94

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
aleivaar94/README.md

Hi 👋
I'm Alejandro

 

  • ⚙️ An enginner/scientist turned data geek.

  • 🐈 Highly curious and always learning something new.

  • 📊 My projects are available in my GitHub repository. Click Repositories above or you can also see a list of all my projects below.

  • 🫱🏼‍🫲🏽 You can reach me on LinkedIn

🧰 Data Stack

Python | SQL | Microsoft Azure | Azure DevOps | Power BI | Tableau | Excel

🔢 All Projects

Last update: 2024-04-30

Data Science | Data Analysis

State of the alternative protein industry in 2023 - Analysis of the alternative protein company database from the Good Food Institute (GFI) to describe the state of alternative protein market since it's decline in 2019. 2024-01-22

University World Rankings 2023 - Bar chart race of rankings extracted from The Times Higher Education World University Rankings website from 2011 to 2023. 2023-01-17

Optimizing ROA of a marketing campaign - Optimizing an Ad Campaign in the food CPG industry: An Analysis of Return on Ad Spend (ROAS). Applicable to Google Ads, Amazon Ads and Google Analytics. 2023-01-26

Market Basket Analysis - Analyzing purchasing patterns to provide personalized buying recommendations. 2022-09-10

Credit Card Offer Analysis - Is a credit card offer giving "miles" better than a cash back card? 2022-09-06

Grocery Store Sales Prediction - Predicting grocery store sales using XGBoost. 2022-10-07

Renew Amazon Prime - With rising cost of services due to inflation, should I renew Amazon prime? A cost-benefit analysis. 2022-08-24

Analyzing Canada's Food Safety Recalls (Part III and IV) - Analyzing and Visualizing Government of Canada Recalls 2011-2022 .2022-09-12

Grupo Bimbo Inventory Demand - First project I made while starting to learn python for data analysis. 2020-09-29


Data Engineering

AirQ-Forecaster: An ETL-to-ML Pipeline for Predicting Air Quality Index - ETL (Extract, Transform, Load) pipeline to extract air quality measurements from the OpenAQ API and store them in DuckDB and MotherDuck (SQL OLAP database). An ARIMA model is used to predict the air quality index (time-series forecasting). 2023-11-05

Data Visualization

[What job would you like to do at CERN?](https://github.com/aleivaar94/CERN_Jobs) - Data visualization of a science activity survey at CERN (Conseil Européen pour la Recherche Nucléaire). 2020-03-31


Web App

Find My Wage - Findmywage is an app that provides reliable and up to date wages for various job positions based on the NOC classification in Canada. 2023-01-20


Databases | SQL

SQL Database of Save-On-Foods products extracted using API - Reverse engineering Save-on-Foods eCommerce website to extract thousands of grocery products purchased from their website. 2021-09-18

Analyzing World Factbook Data - Exploring CIA World Factbook Database with SQL Queries. 2022-09-07

Power BI & Tableau

Visualizing Insights of Canada's Food Recalls from 2011 to 2022 - This dashboard is part of my project to extract and analyze Canada's Food Safety Recalls from 2011 to 2022. 2022-09-12

Supermarket Sales Dashboard - Sales dashboard of open data from a grocery retail store. 2021-01-01

Breakfast Cereals - Healthy or Unhealthy? - Dashboard comparing nutritional information of various well known breakfast cereals based on Canada's Health guidelines. 2020-01-01

Google Search Trends 2020 - Dashboard of most searched diets in Canada in 2020. 2020-06-10

Excel

Sanitation KPIs - Sanitation KPIs in a Plant-based meat manufacturing plant. 2021-01-01


Web Scraping

Scrapping Canada's Food Safety Recalls (Part I and II) - Scrapping Food Recalls from Government of Canada Recalls and Safety Alerts 2011- 2022. 2022-09-05

Web scrapping Canada's Food Safety Recalls using Selenium and BeautifulSoup - Solidified my interest in learning to web scrape so I can retrieve data and make original data projects. 2021-02-15

Web scrapping Canada's Food Safety Recalls using BeautifulSoup - First time I realized the power of learning how to code to web scrape data from the internet. 2021-02-15

Popular repositories Loading

  1. TEER-NOC-Wages TEER-NOC-Wages Public

    Findmywage is an app that provides reliable and up to date wages for various job positions based on the NOC classification in Canada

    Jupyter Notebook 1

  2. Grupo-Bimbo-Inventory-Demand Grupo-Bimbo-Inventory-Demand Public

    First project I made while starting to learn python for data analysis

    Jupyter Notebook

  3. Project-Profitable-App-Profiles-Apple-Google-Play-Store Project-Profitable-App-Profiles-Apple-Google-Play-Store Public

    Analysing app profiles from the Google App Store

    Jupyter Notebook

  4. Project-Exploring-Hacker-News-Posts Project-Exploring-Hacker-News-Posts Public

    Analysing user posts from the Hacker News website

    Jupyter Notebook

  5. Project-CFIA-Food-Recalls-Web-Scrapping-Selenium-BeautifulSoup Project-CFIA-Food-Recalls-Web-Scrapping-Selenium-BeautifulSoup Public

    Extracting Canada's Food Recalls with Selenium and BeautifulSoup

    Jupyter Notebook

  6. Project-CFIA-Food-Recall-Web-Scrapping-BeautifulSoup Project-CFIA-Food-Recall-Web-Scrapping-BeautifulSoup Public

    Extracting Canada's Food Recalls with BeautifulSoup

    Jupyter Notebook