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

        1.In Project II discussed about the demand and supply gap analysis of Uber trip status. 2.Various analysis were taken and action was taken to meet the supply and demand gap analysis.

        1)In Project I discussed about the Covid-19 vaccination of trend analysis 2)Various Visualizations are created for showing the covid-19 vaccination trend analysis  

https://drive.google.com/drive/folders/15-fCL1fqIpnerrsdeCAEUG8vzSyFAhrM?usp=sharing

    1.In this project 1 discussed about the  manufacturing and selling details of the Company ABC Private Limited 2.Formatting options,fiters and the use of Pivot table are also learned

Q1 Total Population statewise Q2 Where are we on Literacy wise Q3 Scholarship/Beneficiaries to students Q4 Number of Institution available Q5 Do we have sufficient number of teachers for the students? Q6 SC & ST students comparison Institution wise.  

1.A pie graph of women inBiological ScientistsChemists & Materials ScientistsComputer & Mathematical OccupationsEngineers & Architects   2.The trend of percent women graduating in Computer science and Engineering from 2000-2015 3.A bar graph of what percent of women are in stem jobs by education in which…

1.Create new schema as alumni                             2.Import all .csv files into MySQL                                 3.Run SQL command to see the structure of six…

        1.In project 1 discussed about creating a new schema and uploading the file in .csv format. 2.The various SQL commands are learned and executed by using Query.

          1.In Project 2 ,discussed about the dataframes by using Pandas . 2.Dropping null values in a dataframe and how to replace null values in a dataframe are discussed . 3.Discussed about the Outliers,Correlation methods and merging of a dataframe .

        1.In this project discussed about the english dictionary app that returns definitions of english words.   2.In Library Book Management System discussed about the development of GUI using tkinter application and sqlite3.