This folder contains essential resources for connecting to the PostgreSQL database, querying the data, and analyzing the results. Below is a breakdown of the files and their purposes:
This file provides the PostgreSQL connection URL to access the TravelTide database. Use this link to connect and explore the data directly.
This file contains the SQL query used to retrieve data from the TravelTide database. The query includes specific filters to:
- Focus on recent user sessions (starting from January 4, 2023) to ensure data relevance.
- Exclude older trips, as they may not reflect the current user behavior and patterns.
This file stores the results of the SQL query in CSV format. It allows for further analysis and serves as a basis for segmentation and insights generation.
Curious to see the visual representation of the first insights? Click the icon below to explore the Dashboard Folder, where key metrics and trends come to life through an interactive Tableau dashboard:
➡️ Dashboard