📊 SQL Data Analytics Learning Project

Welcome to my SQL Data Analytics Learning Project repository! 🎯
This project showcases hands-on practice in SQL for Data Analytics, where I explored real-world data scenarios, wrote analytical queries, and strengthened my skills in data exploration, transformations, and business intelligence using SQL.

---

🎯 Objectives

• Learn and practice SQL fundamentals
• Perform data exploration and cleaning
• Write analytical SQL queries for insights
• Understand time-series and ranking analytics
• Apply window functions, aggregate functions, and joins

---

📂 Project Files

File Name	Description
__init__database.sql	Database setup and initialization scripts
change_over_time_analysis.sql	Trend & time-based analysis queries
date_and_dimention.sql	Date dimension and calendar intelligence queries
exploring_data.sql	Raw data exploration and inspection queries
exploring_measures.sql	KPI calculations and business measures
magnitude_analysis.sql	Comparison and magnitude-based analytics
ranking_analysis.sql	Ranking, row numbering & window function queries

---

🛠️ Skills Practiced

• SQL Joins (INNER, LEFT, RIGHT)
• Aggregate functions (SUM, AVG, COUNT, etc.)
• Window functions (ROW_NUMBER, RANK, DENSE_RANK)
• Date functions & time-series analysis
• Subqueries & common table expressions (CTEs)
• Data cleaning and transformation queries

---

✅ Learning Outcomes

• Improved SQL query writing skills
• Learned how analysts break down business problems
• Built industry-style analytical SQL scripts
• Strengthened foundation for BI and data engineering projects

---

🙏 Acknowledgment

Special thanks to Baraa Khatib Salkini for guidance and support during this learning journey.

---

🚀 Next Steps

• Visualize these SQL outputs in Power BI / Tableau
• Practice performance tuning and indexing
• Build end-to-end analytics projects with ETL + SQL + Dashboard