raghavdsouza Goto Github PK

capstone-project-

data-visualisation-in-excel

Performed Data Visualisation using Excel. Showing Bar & Column Charts, Line Chart, Area Chart, Pie-Donut, Pie-of-Pie, Histogram and Pareto, Boxplot & Outliers, Heatmap, Combo Chart, Sparkles, Dynamic Chart and Scatter Plot.

data-wrangling-in-excel---project

This is an Excel Project wherein we have applied formulas such as summits, maxims, minis, averageifs, countifs on a large data set. Have also created an interactive dashboard using pivot tables and various data visualisation tools. Presented data validation and conditional formatting. Have also presented VLookup, HLookup, IF and IFERROR Functions.

sql-project-data-handling-in-sql

This is a basic SQL Project wherein Data has been created with Student Data, with the columns been named as Student ID, Name, Score, Branch and Date of Joining. The tasks were to create at least 10 rows. Update Data from 'IT' to 'Computers' and from 'Mechanical' to 'Civil'. The final task was to delete the Student's Data where Student ID is 10.