Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
>Formatted, cleaned the data and found Total sales, Average sales.> Highlighted top 10% Quantity ordered, countries orderingmost products.> Developed pivot table and charts to represent product and sales.> Created a summary of product sales by providing maximum, minimum, variance , standard deviation of sales.…
Rupjit Dey
updated on 26 Jun 2023
Project Details
Leave a comment
Thanks for choosing to leave a comment. Please keep in mind that all the comments are moderated as per our comment policy, and your email will not be published for privacy reasons. Please leave a personal & meaningful conversation.
Other comments...
Be the first to add a comment
Read more Projects by Rupjit Dey (8)
Project 2 - EDA on Vehicle Insurance Customer Data
>Customer Data is given by the insurance company we have to clean the data and find information of customers who can availpremium discounts. > Found out all the null values then replaced them with meanvalue, replacing all outliers and white spaces in IDE Jupyter Notebook. >Plotted graphs using Seaborn and Matplotlib…
26 Jun 2023 12:45 PM IST
Project 1 - Analyzing the Education trends in Tamilnadu
>Tracked women graduating in different fields > Analyzed Possible issues in gender gap in STEM jobs and sufficient teachers available for students. > Plotted bar graph on scholarship beneficiaries to students in every districts finding out which districts are getting the most. > Men and women working in related…
26 Jun 2023 12:44 PM IST
Project 2 - Gender Bias in Science and Technical field
>Analysis of data that shows literacy rate in Tamil Nadu. > Conducted Female literacy compared to total population. > Created dashboard comprising different graph and charts with respect to women and men graduating and their income with respect to their ethnicity. > Trend…
26 Jun 2023 12:42 PM IST
Analyzing the user's database of Business model Customer to Customer (C2C)
>Create new schema as ecommerce >Import .csv file https://drive.google.com/file/d/11k9D8cfWB9OTjnchgZv9EC7Fu6y9CdRk/view?usp=drive_link
26 Jun 2023 12:40 PM IST
Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
>Formatted, cleaned the data and found Total sales, Average sales.> Highlighted top 10% Quantity ordered, countries orderingmost products.> Developed pivot table and charts to represent product and sales.> Created a summary of product sales by providing maximum, minimum, variance , standard deviation of sales.…
26 Jun 2023 12:39 PM IST
ANALYSIS OF CAREER CHOICES OF ALUMNI OF TWO UNIVERSITIES USING SQL AND EXCEL
Career choices of alumni of two universities will be analyzed with respect to passing year as well as course they completed. >Imported the .csv files into MySQL.Performed Data cleaning by identifying and removing null values. > Imported the views into excel and created pivot chart on location of alumni. > Calculated…
26 Jun 2023 12:31 PM IST
Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
https://drive.google.com/file/d/1_zXjPOmzxKSkGBcbo7QcYcZ1ztrd74Lp/view?usp=sharing
01 Mar 2023 10:18 PM IST
Project 1 - English Dictionary App & Library Book Management System
Project work with help of json,GUI applications,reading and writing file.
18 Sep 2022 07:07 AM IST