Skip to content

README.MD

Latest commit

 

History

History
25 lines (20 loc) · 690 Bytes

README.MD

File metadata and controls

25 lines (20 loc) · 690 Bytes

PROJECT OVERVIEW - This project analyzes student performance data using SQL and Python. It demonstrates how to extract data from a database, perform analysis, and generate meaningful insights through visualization.

TECHNOLOGIES USED

  • PYTHON
  • SQL SERVER(SSMS)
  • PANDAS
  • MATPLOTLIB

PROJECT WORKFLOW 1.DATA STORED IN SQL SERVER DATABASE 2.PYTHON CONNECTED TO DATABASE USING pyodbc. 3.DATA FETCHED USING SQL QUERY. 4.DATA ANALYZED USING PANDAS. 5.RESULTS VISUALIZED USING MATPLOTLIB. 6.DATA EXPORTED TO CSV FOR REPORTING.

project output

avg_marks sub_avg

FUTURE IMPROVEMENT- USE ADVANCED VISUALIZATIONS. HANDLE LARGER DATASET.