Overview:
The premise of the Rockbuster Stealth project was to find insights and make recommendations to management to enable a brick and mortar video rental store to transition to a virtual store model.
The tools emphasized in this project were Postgres SQL, Excel, Tableau, and PowerPoint. The deliverable for the project was a PowerPoint slideshow that was to be presented to management. ​​
The code I displayed here is an example from the project. In this example, I defined multiple Common Table Expressions (CTE) to produce increasingly granular result sets.
This approach allowed me to write a code section, then recycle that same code, with minor modifications. This is generally a more efficient way to generate the code to get the desired results. Since CTE are temporary and RAM based, transactions run faster and do not require additional permanent storage.
To sum up, CTE gets the results while saving time and money.
I included the PowerPoint slideshow and the data dictionary below. Due to the limitations of Tableau Public, this is the most convenient and expedient way to show the visualizations created for this project.