RDS-to-BQ
This project involves migrating data from a MySQL database (Shopware) to BigQuery. The migration process is automated using AWS Lambda, triggered daily by EventBridge.
Skills: AWS Lambda, Data Bridge, S3, IAM, Bigquery, Data Transfer, Boto3
Transaction-categorization
The goal was to gain insight into spending divided into categories. Final Data Studio dashboard shows data separately for each bank and combined into one plot. The flow is using two python scripts - application (app.py) and Cloud Function code. Cloud Function code is designed to process Bank data stored in a Google Cloud Storage bucket. It reacts to changes in the bucket, triggering the function whenever a file is overwritten. Works on multiple files from various banks. Application script is a user friendly frontend used to extract data from account.
Skills: Cloud Functions, Cloud Storage, Bigquery, Data Studio, Flask, Open Banking
Semantic analysis of key sentences in cryptocurrency articles
The aim of this project was to create a program that will read cryptocurrency related articles and output the report with semantic analysis of sentences containing cryptocurrency names.
Skills: Python, NLTK, pandas, numpy, scrapy, Bigquery, Data Studio, textblob, seaborn, re
WebPortfolio
A website I made from scratch that gathers all my individual work, interests and plans for future projects.
Skills: Python, HTML, CSS, SCSS
Covid analysis
The aim of this project was to find some valuable insight into data and to try answer to some questions. First time used Jupyter Notebook to perform calculations and present results.
Skills: Python, pyplot, numpy, pandas, seaborn, matplotlib, Jupyter Notebook
Investigate a relational Database
The program concerned the sorting of data from movie rentals. It has been divided into four subqueries, each providing an answer for one question. Performed on data provided by Udacity.
Skills: SQL
Investigate a Bikeshare database
The program's task was to provide data on users and bicycle rentals in three cities in the USA. Depending on the user's input, different data ranges were given. First, the user chooses the city from which he wants to display results. Then selects the month, day.
Skills: Python, pandas, numpy, Jupyter Notebook