AL1's Projects
Analysis with SQL on audio tracks store database, providing quick insights to questions and requests.
Developed a web crawler using python library scrapy. It scrapes the books data in a book store website and store it in the form of CSV file, we can store the data in any place like SQL Database or No-SQL database like Mongo-DB.
This is an end-to-end data analytics project in which a real business problem is solved using SQL (to perform ad hoc requests for which the business needs insights) and Power BI, to develop a dashboard for top-level management for real time monitoring.
Impulse, a endless game. Avoid obstacles, collect coins, score high!
Developed a robust ETL pipeline for Next Cola Pvt. Ltd data which extracts data from many different OLTP sources, converts them into dimensions and facts and load into datawarehouse for analytical workload.
Trying out Google Gemini Pro free API on custom PDFS
This is an end-to-end data analysis project, in which we have taken a real dataset of 2022 annual CDC survey of 400k+ adults related to their health status.
Pakistan's job market data(Dec 2019 - Mar 2021) analysed using Excel. Dataset is available on Kaggle.
This is a medical bot built using Llama2 and Sentence Transformers. The bot is powered by Langchain and Chainlit. The bot runs on a decent CPU machine with a minimum of 16GB of RAM.
This is the final year project of university, in which my group is developing a chatbot for university admissions using LLMS and RAG. The bot is powered by Langchain and FastAPI. The UI and frontend is developed in Next.js.
Course: Web Engineering
This is an end-to-end Data Analysis project using python and it's libraries pandas, numpy, matplotlib, seaborn. I have performed full data analysis steps on largest retail e-commerce orders dataset of Pakistan from problem statement to presenting report. It contains half a million transaction records from March 2016 to August 2018.
Extracting insights for ad-hoc requests and business questions with SQL interacting with MySQL database of sales and promotions of a company.
Exploratory data analysis on The Holy Quran, which is the central text for 1.5 billion Muslims around the world. It literally means "The Recitation." It is undoubtedly the finest work in Arabic literature and revealed by Allah (God) to His Messenger Prophet Muhammed (Peace Be Upon Him) through angel Gabriel.
STF Website using custom classes
This is a simple data analysis project done using Excel. An Indian store data is given which is cleaned, analyzed and then presented in a dashboard for stakeholders to see their annual performance and make future data-driven decisions.
This is end-to-end project of Supply Chain in Fast-Moving Consumer Goods(FMCG) domain, in which a real business problem is solved and provided useful insights with an interactive dashboard to the stakeholders using Power BI.
Exploratory Data Analysis on T20 Internationals data. This extensive dataset serves as a comprehensive repository of historical information regarding T20 International (T20I) cricket matches dating back to the inception of the format.
Analyzing the dataset of a telecom company to track it's important KPIs, compare post and pre 5G launch performance and performing market competition analysis to provide insights to the executives in the telecom domain.
Toy Defenders is a hyper-casual tower defense game made for the Rookie Game Jam 2023 by Team EliteGamers. In this game, you are actually in a kid's fictional dreams, and you have to defend the player from toy enemies, by placing defense toy towers strategically, kid wake up from sleep with a nightmare, if you failed to do so.
Exploratory data analysis on the entire world educational dataset ( avaiable on Kaggle). This meticulously curated dataset offers a panoramic view of education on a global scale , delivering profound insights into the dynamic landscape of education across diverse countries and regions.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent