Project Overview

This project involves analyzing wedding vendor pricing data to assess its correlation with customer satisfaction and preparing cost-effective wedding proposals. It includes tasks like data collection, database design, SQL-based analysis, and crafting an itemized cost breakdown for a client-selected wedding theme.

Key highlights:

• Explored the relationship between wedding vendor pricing and customer satisfaction using data-driven insights.
• Designed and normalized a database in 3NF, representing wedding vendor details and cost data.
• Developed dynamic SQL queries and Python scripts to generate detailed cost breakdowns for clients.
• Provided actionable insights for cost-effective wedding planning.

The project demonstrates advanced skills in database design, SQL, and Python for business analysis and client engagement.

Technologies Used

• SQL: Data modeling, normalization, and query generation
• Python: Dynamic cost breakdown generation and data processing
• Excel: Data collection and reporting
• PowerPoint: Client-ready presentations
• Database Design: ER diagram creation and data structuring

Repository Structure

Code/

• Final_Analysis_Report.py: Python script for generating insights and performing analysis on wedding vendor pricing and customer satisfaction.

Data/

• Weddings Database DD-MBAN 2023.xlsx: Complete dataset of wedding vendor pricing and satisfaction ratings.
• weddings database DD-MBAN 2023.sql: SQL script for creating and populating the database.
• weddings database DD-MBAN 2023.txt: Text file version of the database structure and data.

Documents/

Wedding_Planning_Client_Proposal/

• Business_Challenge_Wedding_Table1_team12.txt: Details of Table 1 for the wedding planning proposal.
• Business_Challenge_Wedding_Table2_team12 (1).txt: Details of Table 2 for the wedding planning proposal.

Wedding_Planning_PPT_Presentation/

• Business Challenge 1_Team12.pdf: PDF of the wedding planning presentation.

Wedding_Planning_Vision_Board_Analysis/

• Vision Board Analysis- Team 12.xlsx: Vision board analysis Excel file.
• Vision Board Analysis_Team12_FMBANDD1.pdf: PDF version of the vision board analysis.

ER Diagrams/

• Weddings ERD DD-MBAN 2023.pdf: Entity Relationship Diagram for the wedding database.

output/

• wedding cost.ipynb: Jupyter Notebook for wedding cost breakdown analysis.
• wedding_cost_data.txt: Text file containing SQL results for wedding cost data.

README.md

• Overview of the project, instructions, and key insights.

Key Insights

• Vendor pricing does not exhibit a strong correlation with customer satisfaction, challenging conventional wisdom.
• Designed a database in 3NF to streamline vendor data management for future scalability.
• Dynamic cost breakdowns provided clear visibility into budget allocation for each wedding department.
• Recommendations for future vendor selections include focusing on affordable options that maintain high satisfaction levels.

Contact

Connect with me on LinkedIn for more information or explore my other projects on GitHub.