Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

>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…

>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…

>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…

>Create new schema as ecommerce >Import .csv file https://drive.google.com/file/d/11k9D8cfWB9OTjnchgZv9EC7Fu6y9CdRk/view?usp=drive_link    

>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.…

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…

https://drive.google.com/file/d/1_zXjPOmzxKSkGBcbo7QcYcZ1ztrd74Lp/view?usp=sharing  

Project work with help of json,GUI applications,reading and writing file.