Skip to content
/ studentReportGeneration Public

The following project is my first Internship Experience in my undergrad where i have implemented mySQL procedures inorder to AGGREGATE, CLEANSE and generate grade reports of students.

0 stars 1 fork Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

VadlamudiNaveen/studentReportGeneration

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
README.md
README.md
 
 
Regular.xls
Regular.xls
 
 
Results.txt
Results.txt
 
 
supple.xls
supple.xls
 
 

Repository files navigation

Student Report Generation 📊

Input/Output ⬇️

  • Data Input -> Raw Excel Sheet

  • Data Ouput -> Aggregated Report of Students Table With their Grade

Steps Followed 🚀

  • Input data: In this project we have raw data that is in the form of excel.

  • Ingestion: We convert the data into SQL format using Excel to SQL tool that is provided in mysql.

  • Transformation/Cleansing/filtering: This process is done my the above PLSQL Procedure.

  • Report: Finally once entire data is cleaned and ran for multiple times, we are performing table joins to generate a report.

About

The following project is my first Internship Experience in my undergrad where i have implemented mySQL procedures inorder to AGGREGATE, CLEANSE and generate grade reports of students.

Topics

mysql plsql dataset procedures-table

Resources

Readme
Activity

Stars

0 stars

Watchers

2 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

No packages published