My Works


Data Analysis -

EDA ON TRAFFIC VIOLATION DATA

Python - Pandas - Matplotlib


  • Collected real time data from the public through Google form to get the real insights on the event.
  • Used pandas to clean the data and make it ready for the analysis on it. Tried to include most of the frequently used pandas functions.
  • Did EDA on it and visulaized it using matplotlib to generate insights. One of the main insights was that most of the traffic violation and accidents occur during night. This insight lead to one of my other projects which is 'Automatic Number Plate Recognition'

View Work →

WORLD CORONA DATA ANALYSIS

SQL


  • Used the publicly available world covid data to do exploration it to derive insights.
  • Used Microsoft SQL to run the queries and overcame the challenges faced while doing it.
  • Tried to incorporate main SQL functions and got insights such as the infection rate and its impact on the population, countries and continent wise covid death rate and vaccination rate.

View Work →

DASHBOARD FOR HOTEL CHAIN MANAGEMENT

Power-Bi


  • Built a dashboard for analyzing the Revenue report and Booking performance report of a hotel chain from which insights has been gained. Learned the process of ETL while doing the project.
  • Used power query editor to clean and arrange the data to make to ready for dash boarding. Handled the Data from different tables and created the model view in such a way that data in every table has a relationship.
  • Experimented using DAX to create measures and used the measures to create meaningful visualizations for the company. Used the visualization tools which made clear explanations to present the data in a meaningful way and easy to understand on a low level view.

View Work →

DASHBOARD FOR CAR SALES

Excel


  • Used raw car sales data and cleaned it in excel to make it ready for analysis and dashboarding ready. Used excel formulas to create new columns/attributes from the existing to create more useful data.
  • Made meaningful pivot tables from the data and visualized the pivot tables made for easy understanding.
  • Created a sales dashboard finally with the visualizations/charts and used slicers to get dynamic visualizations.

View Work →

Web Development -

The Sparks Bank

HTML - CSS - Bootstrap - Javascript - Django - Sqlite


This website is a project i worked on during my internship at The Sparks Foundation. It's a simple banking app. I used HTML,CSS,Javascript for the front end and Django for the backend. Sqlite is being used as the database to store the account and transaction details.

Visit Site →

To-Do App

HTML - CSS - Javascript


I created a simple todo app using vanilla javascript. I personally love its color pattern and i gave it a simple yet easy to use UI. I would suggest you to bookmark it in your bookmarks tab and check your to-do's whenever you enter your browser so that you keep track on what you want to do and does'nt miss anything !

Visit Site →

Chat App

HTML - CSS - Jquery - Django - Sqlite


Built a live chat app with django as the server. Several users can join in a single chat rooom. If the room doesn't exist, new room will be created. The webapp is fast and responsive

Visit Site →

Blogging Site

HTML - CSS - Javascript - Django - Sqlite


Created a personal blogging website using django framwork from scratch. Alwayss wanated to share my random thoughts and the things i like to talk about to the world. The UI lookks simple and clean and yes i went for the dark and minimal look again. Turned out to be good.

Visit Site →

IFFA - Indian Football Fans Association

HTML - CSS - Javascript - php - MySql


Always wanted to create a football fans Association in my city. Didnt know where to start. Started creating this website hoping that this might be a good start. The UI turned out good. Gaining more contacts for the Association is the next thing to do. Wish me good luck xD. It's static, pardon me.

Visit Site →

Personal Portfolio

HTML - CSS - Javascript


Created my personal portfolio and hosted it in github pages. I wanted to keep it minimalistc as i love minimalistc designs. I really love the colors and font i used lol. I'm pretty sure you'd have seen it but i you didn't please do check it out.

Visit Site →