Kaggle Datasets Expert with advanced expertise in Database Design, Python Programming and SQL.
This database, designed with MySQL, serves as a central hub offering an exhaustive perspective on the structural,
operational, and strategic aspects of database management tailored to cater to the needs of the European Film Industry
and fully integrated with Microsoft Power BI Service providing users with insightful visualizations and real-time data analysis capabilities.
This project implements an ETL pipeline to extract the largest banks by market capitalization from Wikipedia, transform the data by converting market capitalization into 50 different currencies and load the processed data into both a CSV file and an SQL database. The database allows managers from different countries to query market capitalization values in their local currencies.
I designed a comprehensive enterprise database schema in PostgreSQL using pgAdmin 4, covering key business domains such as company information, industry classification, product segmentation, billing, subscriptions, warranty claims, and RMA processes. The schema includes robust entity relationships, foreign key constraints, and normalization techniques to ensure data integrity and efficiency. Key components include multi-level industry and product hierarchies, company branding and billing details, subscription and invoice management (integrated with Stripe).
Paw & Heart is an animal rescue charity that operates animal shelters and liaises with local families to foster animals in need. The organisation aims to use this app, developed with Microsoft Power Platform, to improve record-keeping on animals staying at their shelters and foster homes.
Utilizing the Spotipy library in Python, Spotify artist data and playlists were scraped. Subsequently, rigorous data cleaning procedures were conducted to transfom the data and ensure this data is primed for EDA, Predictive Analysis, Visualization and more.
In this project, I used Python to collect data on cars for sale in Nigeria from Jiji.ng, one of the country’s leading online marketplaces. The dataset includes detailed features such as Make, Model, Year of Manufacture, Color, Price, Location, Trim, Drivetrain, Engine Size, Number of Cylinders, Horse Power, Interior Color, Seats, etc.
A New York based coffee shop chain is looking to expand nationally and as part of their expansion process, they want to streamline operations and revamp their data infrastructure. I designed their relational database system for improved operational efficiencies and to make it easier for their executives to make data driven decisions.
This project involved scraping real estate data from Nigeria Property Centre, a leading property listing platform in Nigeria. The dataset includes critical property details such as Property Type, Number of Bedrooms, Bathrooms, Toilets, Parking Spaces, Total and Covered Area, Price, District, and State.
Exploring artist discography and the distribution of keys (major or minor) each musical piece is built on, mapped onto the Circle of Fifths. Artist data was extracted from Spotify with Python and analysis was conducted with Tableau.
The Music & Mental Health Survey Analysis aims to identify what, if any, correlations exist between an individual’s music taste and their self-reported mental health.