How swaapnaa/sql-projects works
Project type and purpose
• This is a set of SQL-based data-analysis projects, each ingesting CSV data into a relational database (SQL Server or MySQL), performing cleaning/ETL, running analytical queries, and delivering tabular or visual insights for leadership.
File structure
• Top level:
• “Analyzing Employee Trends/” – contains a CSV of HR data and a .sql script for analysis
• “Exploring Trends in the Automotive Industry/” – CSV + .sql for car sales analytics
• “call center data cleaning/” – CSV + .sql for call center data cleansing and summary
• No application code (no “src” or “backend” folders)—scripts only.
• No configuration or build pipelines—each .sql file is standalone.
README for additional insights
• Each subproject follows the same flow: import CSV → data validation/cleaning → SQL analytics (joins, aggregates, window functions) → present results.
• The README outlines tasks performed, SQL techniques, and usage instructions.
Elements
• Clear labels for: “Raw CSV,” “ETL Scripts,” “Database Engine,” “Analytical Queries,” “Report Output,” “Business Consumers”
• Processes (rectangles in green)