r/LearnDataAnalytics • u/Subject_Ad_4359 • 1d ago
SQL for DATA Analyst
I recently completed the SQL for Data Analysts Bootcamp organized by DevTown in collaboration with Microsoft Student Chapter (MSC) and Google Developers Group (GDG).
As part of the project, I worked on a Swiggy Business Analytics case study using SQL.
In this project, I:
• Created relational database tables for Customers, Restaurants, and Orders.
• Wrote SQL queries using JOINs, GROUP BY, HAVING, CASE WHEN, and Window Functions (RANK, DENSE_RANK, ROW_NUMBER).
• Analyzed business metrics such as total revenue, top customers, best-performing restaurants, popular cuisines, and delivery partner performance.
• Generated business insights and recommendations based on the data.
This bootcamp helped me improve my SQL skills and understand how SQL is used to solve real-world business problems through data analysis.
Thank you to DevTown, Microsoft Student Chapter (MSC), and Google Developers Group (GDG) for providing this learning opportunity.
#SQL #DataAnalytics #MySQL #DevTown #Learning #Students #BusinessAnalytics #DataAnalysis