5/10/2023
This contains analysis of a rental transactions database using SQL queries and data visualizations to provide summary analyses.
This project, queries the Sakila DVD Rental database. The Sakila Database holds information about a company that rents movie DVDs. This project, queries the database to gain an understanding of the customer base, such as what the patterns in movie watching are across different customer groups, how they compare on payment earnings, and how the stores compare in their performance.
One quirk you may notice as you explore this "fake" database is that the rental dates are all from 2005 and 2006, while the payment dates are all from 2007. Don't worry about this. ) Once the user provides the necessary inputs, the script reads the corresponding dataset file and performs various calculations and computations to generate statistical information and insights.
SQL: Postgresql MS EXCEL or Tableau
To assist you in the queries ahead the schema for the DVD Rental database is provided in the code section. You can download the database sql file from here
Here are some resources that may be helpful for completing this project:
- SQL Documentation: This website provides a comprehensive guide to SQL syntax and usage.
- PostgreSQL Documentation: If you are using PostgreSQL, this documentation will be useful for understanding the specific features and functions of PostgreSQL.
- Data Visualization Best Practices: This article provides some best practices for creating effective data visualizations.