I am Ayokunle James @ay0kunl3 , a Data professional learning SQL, Excel, Tableau, PowerBI, Python and R for data cleaning, analysis, visualization, and database management. I am a firm believer in harnessing the power of data to drive growth, strategy, and make business decisions.
This research project designs and optimizes a scalable national product information management (PIM) system for the NHS, enhancing data access, quality, and interoperability to improve supply chain efficiency, product data management, and patient safety. Tools used: MySQL, DigitalOcean, Streamlit, Python, Oracle Data Modeller
Analyzed carbon emissions from university staff commuting to calculate daily and annual impacts. Processed and cleaned survey data using MS Excel and Power BI, calculated emissions and identified key trends and anomalies. Developed a comprehensive Power BI dashboard to visualize insights and provided recommendations for reducing the university's carbon footprint through greener commuting options and policy changes. Tools used: Power BI, MS Excel, R.
In this project, I tackled the challenge of transforming raw data into Power BI reports and dashboards to track KPIs, analyze sales performance across multiple regions, identify high-value customers, and analyze product-level trends to identify growth opportunities. My report successfully provided a clear view of sales performance, identified underperforming areas, and highlighted opportunities for growth.
In this project, I extracted insights from a charity organization's donations database by defining the business problem, carrying out a Root Cause Analysis (RCA) of the problem, and visualizing insights extracted to aid planning and strategy for the fundraising team.
In this project, I performed exploratory data analysis on a modified snapshot of data collected during a household census conducted in England in 2021 to derive insights about socio-economic conditions of the data subjects based on gender, income, level of education, ethnicity, marital status, and housing conditions.
In this project, I scrapped the IMDB movie website to collect Movie Reviews and User Ratings on select movies. I then used a sentiment analysis tool, namely, VADER to identify sentiments in the reviews, and finally evaluated them against User Ratings.
In this project, I did a comprehensive analysis of casualties resulting from traffic accidents in the Netherlands in 2016, specifically to understand who the casualties involved were.
In this project, I design an information system for a humanitarian organization using Oracle SQL Modeller. I then implement the database using PostgreSQL. I also write some queries to derive insights from the database, and discussed data security, integrity and ethics.
In this project, I cleaned up the Nashville Housing Dataset using PostgreSQL.
Exploration of Maven Movies Dataset in MySQL.
Data Cleaning, Analysis (Pivot Tables), Visualization and creation of Bike Sales Dashboard in MS Excel