Gal Beeri's Projects
Building an interactive dashboard to describe and explore the Belly Button Biodiversity dataset using JavaScript and HTML. The dataset reveals that a small handful of microbial species (also called operational taxonomic units, or OTUs, in the study) were present in more than 70% of people, while the rest were relatively rare.
Analysing skin cancer study
Using various techniques to train, evaluate, and identify the creditworthiness of borrowers with logistic regression on the loan and risk historical dataset.
Analysing Chicago Crime Data
Building an ETL pipeline using Python, Pandas, and other libraries and dictrionary methods.
Using unsupervised learning to predict if crypto currencies are affected by 24-hour or 7-day price changes.
Creating a sophisticated web application for transaction analysis, incorporating ML, Bootstrap, Dash, and Plotly. Users can seamlessly upload credit card CSV files, exploring transactions interactively in both tabular and dashboard report formats.
Creating an interactive Leaflet map to visualise earthquakes data
Building Power BI sales report
Creating an interactive dashboard to explore the Nasdaq 100 share index using APIs to call the data, Python and SQLAlchemy to clean and transform the data, as well as loading the data to a SQLite database using SQLAlchemy's ORM.
Analysis of the UK Food Standards Agency, in particular food hygiene ratings using NoSQL and Bash. Importing the json data using Bash and using NoSQL to perform CRUD operations on the json data as well as exploritory analysis to answer the questions specified in the readme file
Using openpyxl to analyse sales data
This project provide area-wide analysis for school budgeting as well as students scoring (reading & math) for 15 schools. The analysis aggregates the data and showcase obvious trends in school performance.
Demo repo from Youtube
This project inlcludes python scripts to analyse two different datasets (PyBank & PyPoll) and provide a text file output containing the results. The first dataset, budget_data.csv, contains financial records of a company in two columns: "Date" and "Profit/Losses".
Design the SQL tables and dependencies to hold the data from the CSV files, import the CSV files into a SQL database, and answer questions about the data.
Using SQLAlchemy to do basic climate analysis and data exploration. Specifically using SQLAlchemy ORM queries, Pandas, and Matplotlib.
Using Tableau, this project analyses CitiBike's July 2023 data to understand user behaviour (Python is employed for ETL processes). Objectives include user segmentation, popular stations, ride characteristics, and geographical concentration. Key findings are summarised in two dashboards for member and casual users.
Analysing stocks using VBA
This project contains two web scrapping methods: scrapping a webpage and scrappping a web page table for analysis purposes
Creating a Python script to visualise the weather of over 500 cities of varying distances from the equator using citipy Python libraryLinks and OpenWeatherMap APILinks to create a representative model of weather across those cities.