Addressing the Business Question (SQL Analysis)
Congrats on becoming a business analyst! Your database has been designed based on your requirements. Now it’s time to answer your business question:
Are wedding vendors with sustainable practices more cost effective?
Introduction:
The wedding industry is known for its extravagance and often high prices. However, a growing number of couples are seeking to make their weddings more environmentally friendly and sustainable. This begs the question: are wedding vendors who offer sustainable practices more cost-effective than their traditional counterparts?
To answer this question, we will analyze data from our wedding vendor database, focusing on vendors who offer specific sustainable practices such as using locally sourced ingredients, eco-friendly decorations, and energy-efficient operations. We will compare the average cost of these vendors with the average cost of traditional vendors, taking into account factors such as vendor type, location, and services offered.
Data Analysis:
We will select data from our wedding vendor database for vendors who offer at least one of the following sustainable practices:
We will also collect data for a comparable group of traditional vendors who do not offer any of these sustainable practices.
We will compare the average cost of sustainable vendors and traditional vendors for different types of services, including:
We will also consider additional factors that may affect vendor costs, such as:
We will use various statistical analysis tools to compare the costs of sustainable and traditional vendors. These may include:
Results and Discussion:
Based on the data analysis, we will answer the following questions:
Conclusion:
By analyzing our wedding vendor data, we will be able to determine whether sustainable practices are associated with higher or lower costs for wedding vendors. This information will be valuable for couples planning their wedding and for wedding vendors who are considering adopting sustainable practices. It will also contribute to the broader discussion about the sustainability of the wedding industry and how to make it more environmentally friendly without sacrificing affordability.
Limitations:
It is important to acknowledge the limitations of this study:
Future Research:
This study provides a starting point for understanding the relationship between wedding vendor sustainability and cost-effectiveness. Further research could explore: