wonderakwei
| Data Analyst | Data Scientist | Market Research Analyst | Python Programmer | DevOps| ML |
Pinned Repositories
Advanced-PHP-Contact-Form-with-Database-Integration
Contact form with PHP backend & email notification. Features server-side validation, CSRF protection, & Google reCAPTCHA. MySQL storage & PHPMailer for email notifications. Styled with Bootstrap for responsive design.
Bank-Marketing-Campaign-Analysis-with-Machine-Learning
Optimize future bank marketing with Machine Learning analysis. Explore past campaign patterns, employ a data-driven approach to enhance effectiveness. Predict success in telemarketing for strategic development.
Database-Design-and-Optimization-Project
This Database Design and Optimization Project, utilizing PostgreSQL, encompassed a thorough initiative aimed at elevating data management. Through strategic enhancements to the database structure, performance improvements, and operational streamlining, the project has successfully transformed the system.
diamonds-price-prediction
This project utilizes Diamonds Price Dataset from kaggle, featuring attributes like carat, cut, color, and clarity. Explore diverse diamond types and harness machine learning to predict prices. This project delves into diamond valuation through insightful data analysis.
flight-fare-prediction-with-deployment
Empower travel decisions! Elevate your journey with precise flight fare predictions using ML models. Uncover patterns, explore correlations, and benchmark algorithms for budget-friendly choices.
pdf-viewer-streamlit-upload-and-display
PDF Viewer with Streamlit: Upload and display PDF files. Utilizes #Streamlit for UI and interaction, #PyPDF2 for PDF processing. Enhance PDF experience with text extraction. Ideal for user-friendly PDF handling. #Python
Product-Performance-Analysis-and-Recommendation-System
Analyzed a dataset comprising over 1,000 products to reveal consumer preferences and identify e-commerce trends. Employed rigorous data preparation and analysis techniques to delve into the extensive product landscape on Amazon. Developed a recommendation system and performed sentiment analysis using machine learning.
sales-marketing-data-analytics-using-python
This project utilizes Python, employing regression and correlation analysis to optimize marketing campaigns. By analyzing sales impact across different hospital account types, it unveils key strategies, culminating in actionable recommendations and a comprehensive ROI table for effective decision-making.
Supply-Chain-Management-Database
Optimized business operations with a comprehensive database system. Streamlined inventory management, order processing, manufacturing processes, and logistics. Ensured quality control and efficient employee management for a seamless end-to-end solution.
telecom-customer-churn-prediction
This project predicted customer behavior to retain Orange Telecom's valuable customers. Relevant data was analyzed, and a focused retention model was developed using the Churn Dataset. Models were built on customer activity data, indicating subscription cancellations.
wonderakwei's Repositories
wonderakwei/Database-Design-and-Optimization-Project
This Database Design and Optimization Project, utilizing PostgreSQL, encompassed a thorough initiative aimed at elevating data management. Through strategic enhancements to the database structure, performance improvements, and operational streamlining, the project has successfully transformed the system.
wonderakwei/Robust-Data-Pipeline-CSV-to-PostgreSQL-with-Airflow-Docker-and-Pandas
Built a strong data pipeline that effortlessly moves CSV data to PostgreSQL, combining the power of Airflow for task orchestration, Docker for containerized deployment, and Pandas for efficient data processing. Achieved seamless integration and reliable data workflows.
wonderakwei/Supply-Chain-Management-Database
Optimized business operations with a comprehensive database system. Streamlined inventory management, order processing, manufacturing processes, and logistics. Ensured quality control and efficient employee management for a seamless end-to-end solution.
wonderakwei/Advanced-PHP-Contact-Form-with-Database-Integration
Contact form with PHP backend & email notification. Features server-side validation, CSRF protection, & Google reCAPTCHA. MySQL storage & PHPMailer for email notifications. Styled with Bootstrap for responsive design.
wonderakwei/Automated-Traffic-Data-ETL-Project
Automated Traffic Data ETL: Python scripts convert, reformat, and upload traffic data to BigQuery via GCS. Terraform ensures efficient resource provisioning, and APScheduler automates daily cron jobs.
wonderakwei/Banking-Database-Design-using-PostgreSQL-and-pgAdmin
Designed an efficient banking database using PostgreSQL and pgAdmin. Focused on optimizing transaction management included key aspects like data modeling, database architecture, security, and performance.
wonderakwei/Product-Performance-Analysis-and-Recommendation-System
Analyzed a dataset comprising over 1,000 products to reveal consumer preferences and identify e-commerce trends. Employed rigorous data preparation and analysis techniques to delve into the extensive product landscape on Amazon. Developed a recommendation system and performed sentiment analysis using machine learning.
wonderakwei/AI-Image-Generator-with-API-Integration
The AI Image Generator Website uses HTML, CSS, and JavaScript to transform text prompts into images via an integrated API. Users can specify the number of images to generate, view results in a responsive gallery, and download the images easily.
wonderakwei/blog-website-with-Laravel-and-Filament-PHP-Admin-Panel
Built a complete blog website using Laravel and Filament PHP. The project involved setting up a Laravel project, installing Filament, managing blog posts, customizing layouts, and adding features like user authentication, roles, likes, post views, search functionality, and a comments section. It's designed for scalability and user engagement.
wonderakwei/Car-Rentals-Website
Rently provides a dynamic and responsive car rental platform in Ghana, designed for easy exploration, booking, and management of car rentals.
wonderakwei/Connecting-Frontend-to-Backend-with-PHP
Successfully connected HTML forms to MySQL using PHP. Featured a responsive signup system with validation, password hashing, and prevention of SQL injection. The interface was enhanced with Bootstrap and Font Awesome. Easy setup, customizable, and open for contributions.
wonderakwei/convert-pdf-to-word-V1
Created a simple PDF to Word converter involved utilizing libraries that could handle PDF manipulation and text extraction. One popular library for working with PDFs in Python was PyPDF2, and for creating Word documents, python-docx was used.
wonderakwei/DentCare-Website-with-CMS-PHP-SilverstripeCMS
DentCare CMS is a responsive, dynamic website for a dental clinic built with HTML5, CSS3, Javascript, Bootstrap, SilverStripeCMS and PHP. It features customizable content, service management, appointment booking, and a user-friendly admin interface.
wonderakwei/End-To-End-Data-Engineering-Project-with-Etsy-API
A comprehensive data engineering pipeline, orchestrates data workflows with Apache Airflow, Python, Kafka, Zookeeper, Spark, and Cassandra. Containerized using Docker: to deploy and scale effortlessly. This Etsy API Data Pipeline extracts, processes, and analyzes Etsy marketplace data—retrieving product listings, shop details, and reviews.
wonderakwei/Healthcare-Database-Management-System
The Healthcare DBMS is a robust solution for managing patient records, appointments, staff, and medical supplies. Leveraging PostgreSQL, PgAdmin, and Docker, it ensures data integrity, HIPAA compliance, and offers a streamlined experience for healthcare professionals and administrators.
wonderakwei/Hotel-Website-HTML-CSS-Javascript
This project is a responsive hotel booking website designed to showcase hotel services, rooms, and amenities. It includes smooth scrolling animations, a responsive navigation menu, and various sections to provide a comprehensive user experience.
wonderakwei/Job-Application-System-with-PHP-and-MySQL
Built a Job Application System using PHP, MySQL, phpMailer, and reCAPTCHA. Streamlined the job application process with secure data submission, including personal details, resumes, and cover letters. Integrated advanced security measures like reCAPTCHA and CSRF protection for spam prevention and safeguarding against unauthorized form submissions.
wonderakwei/Laravel-Task-Manager-project
This is a Laravel-based Task Manager application using Jetstream and Blade. The application includes two types of users: admins and normal users. Admins can manage all tasks, while normal users can only view and manage their own tasks.
wonderakwei/Library-DBMS-with-T-SQL-and-SQL-Server
This LibraryDBMS was developed using T-SQL and SQL Server, utilizing Microsoft SQL Server Management Studio for managing book loans, publishers, branches, borrowers, copies, and authors. The project included tailored stored procedures for efficient and organized operations in library management.
wonderakwei/Northwind-Database-Design-with-MySQL-DBeaver-and-Docker
Embarked on a database design journey with Northwind, MySQL, DBeaver, and Docker. Explored sample SQL queries and data analysis, with detailed documentation for installation, usage, and learning.
wonderakwei/PHP-Environment-Information-Script
This PHP script serves as a handy tool for quickly retrieving essential information about your PHP environment and server settings. When executed, the script displays details such as the PHP version, server software, server name, address, port, and various PHP configuration settings.
wonderakwei/real-time-chat-application-using-Laravel
Robust and secure real-time chat application designed to facilitate instant communication between users. Built with Laravel, Vue.js, and Pusher, it leverages modern web technologies to provide a seamless and interactive messaging experience.
wonderakwei/Real-Time-News-Website-with-JavaScript-and-News-API-Integration
📰 Developed a live news website using HTML, CSS, and JavaScript, fetching real-time data from the News API. This project demonstrates how to use async/await functions in JavaScript to integrate public APIs, creating a responsive and dynamic news aggregator.
wonderakwei/Real-Time-Pipeline-with-Apache-Flink-Kafka-Elasticsearch-and-Docker
Ecommerce Sales Analytics Data Generation, developed a detailed system architecture using Apache Flink, Kafka, Elasticsearch, and Docker. Implemented real-time data streaming, established a robust, scalable data pipeline. Flink was set up, transactions were aggregated in Postgres and Elasticsearch, concluding with a dynamic streaming dashboard.
wonderakwei/Responsive-Hamburger-Menu-with-HTML-CSS-Javascript
This project is a simple and responsive hamburger menu designed for modern web applications. The menu is implemented using HTML, CSS, and JavaScript, and it provides a sleek and user-friendly navigation experience.
wonderakwei/Responsive-Product-Card-Popup-Modal
This project demonstrates a card-based user interface with popup modals using HTML, CSS, and JavaScript. Each card represents a product, and clicking on a card opens a modal with more detailed information about the product.
wonderakwei/Restaurant-website
Restaurant website
wonderakwei/Retail-Employee-Data-Management-and-Analysis
Efficiently managed retail employee data with a SQL-based solution. Streamlined HR processes, performed data analysis, and made informed decisions for optimized retail operations.
wonderakwei/Smart-Chatbot-with-JavaScript-and-Google-API
This project demonstrates a chatbot built with HTML, CSS, and JavaScript, integrating Google’s Gemini API for responses. The chatbot features a sleek, responsive interface for a seamless user experience. It serves as a virtual assistant, understanding and responding to user queries in real time.
wonderakwei/SQL-Case-Study-Sales-Data-Analysis
Explored Data Mart's sales data, cleansed sales data, uncovered missing weeks, assessed yearly transactions, and delved into regional, platform, and demographic insights. Gained valuable perspectives on the impact of sustainable packaging on past sales performance.