SQL for Beginners: Pharmacy Openings & Closures Analysis| End-to-End Data Analyst Portfolio Project

SQL Project for Beginners: Pharmacy Openings & Closures Analysis | End-to-End Data Analyst Portfolio Project (MySQL)

Download the dataset here:
https://drive.google.com/uc?export=download&id=1KngbAETTcUflfZ59UlnPcoNdGJFPkk5e

In this video, I walk through a complete SQL project from scratch using a real-world pharmacy openings and closures dataset. This is an end-to-end data analysis project designed for aspiring Data Analysts, Data Engineers, and beginners learning SQL using MySQL Workbench.

If you're building your data analyst portfolio, this project demonstrates how to clean, transform, and analyze data using SQL — exactly what hiring managers look for.
---

🔎 What You’ll Learn in This SQL Project

✔ SQL project for data analyst portfolio
✔ SQL project using MySQL Workbench
✔ Data analysis project start to finish
✔ How to clean messy date columns using STR_TO_DATE()
✔ How to analyze trends in pharmacy openings and closures
✔ Monthly and yearly trend analysis using SQL
✔ GROUP BY, ORDER BY, WHERE vs HAVING explained
✔ Real-world business insights from raw data
---

🛠 Tools Used

MySQL

MySQL Workbench

Excel (for initial data review)

SQL for data cleaning and analysis
---

📈 Project Breakdown (Step-by-Step)

1️⃣ Import dataset into MySQL
2️⃣ Clean and standardize date columns
3️⃣ Convert text to proper SQL DATE format
4️⃣ Perform monthly and yearly trend analysis
5️⃣ Identify peak pharmacy openings and closure periods
6️⃣ Generate insights useful for healthcare planning

This is a complete data analysis project walkthrough, perfect for:

SQL projects for beginners

SQL projects using MySQL

Data analyst project step by step

Data analysis projects for final year students

Data analyst project using Excel, SQL and Power BI
---

🎯 Who This Video Is For

Aspiring Data Analysts

Beginners learning SQL

Students looking for data analysis project ideas

Anyone building a strong data analyst portfolio in 2026

Professionals transitioning into tech
---

🚀 Why This Project Matters

Healthcare data analysis is a growing field. Understanding pharmacy openings and closures can help:

Identify healthcare access gaps

Track business trends

Support data-driven decisions
This is not just a tutorial — it’s a real data analyst project start to finish that you can confidently add to your portfolio.
---

📌 Related Topics

SQL projects for portfolio
SQL projects for data analyst
Data analysis project end to end
Data analyst project Python & Power BI
SQL project for data engineer
Data analysis project documentation
---

If this video helped you, don’t forget to: 👍 Like
💬 Comment
🔔 Subscribe for more SQL and Data Analysis projects

Видео SQL for Beginners: Pharmacy Openings & Closures Analysis| End-to-End Data Analyst Portfolio Project канала My Data Projects