🧩 Investigate a Relational Database
📊 Project Overview
This project was completed as part of the Udacity Data Analyst Nanodegree. The goal was to explore a relational database using SQL to extract useful insights from real-world data. By querying multiple tables, I investigated patterns, relationships, and summaries within the dataset.
🛠️ Tools & Technologies Used
SQL (PostgreSQL / SQLite)
DB Browser for SQLite (or equivalent database tool)
Data Wrangling & Query Design
Data Analysis & Insights Reporting
🧠 Key Objectives
Design and run SQL queries to explore relationships between tables
Use JOIN, GROUP BY, WHERE, and ORDER BY clauses effectively
Extract meaningful insights and patterns from the dataset
Present findings in a clear, structured report
📑 Deliverables
SQL query scripts (.sql file)
Analytical report (.pdf file)
Optional presentation summary
💡 Insights Example
Some of the insights explored include:
Understanding customer behaviors and purchase patterns
Analyzing data relationships between key entities in the database
Summarizing metrics and identifying trends
👩💻 Author
Doua Nemier Abd AL-Rahman Udacity Data Analyst Nanodegree Graduate
🌐 Project Repository
This repository includes all relevant files:
The final report (Investigate a Relational Database Report.pdf)
SQL queries and supporting files
✨ Future Enhancements
Automating SQL queries using Python
Visualizing query results using Power BI or Tableau
📫 Connect with Me
💼 LinkedIn Profile (www.linkedin.com/in/do3a-nemier) 📧 Email: ([email protected])
Special thanks to the Udacity Data Analyst Nanodegree program for guidance and structure throughout this project.