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 the percentage of career choice of alumni ofboth the colleges and used various aggregate functions