Data analysis project focused on maritime heritage transformation, creative economy development in port cities, and European-North African market comparisons
As data analysis practice, i had chosen to work on maritime heritage transformation and creative economy development with a focus on European port cities as well as and European-North African market comparisons.
PS: The data used is fictional and created specifically for educational purposes based on general knowledge. It's not sourced from any specific dataset or publication, it is sample data designed to demonstrate analysis capabilities.
Database
The data base is spread on four tables
Maritime sites, Glascow focused
Glasgow Harbour: Transformed from commercial shipping area to modern mixed-use development
Pacific Quay: Former shipbuilding site now home to media companies
Riverside Museum: Built on the site of a historic shipyard, now a Zaha Hadid-designed transport museum
Govan Graving Docks: Historic dry docks that are currently abandoned but have heritage protection
Finnieston Crane: Iconic heavy lifting crane that symbolizes Glasgow's shipbuilding heritage
Each entry includes the site's historical maritime purpose, current usage, when the transformation occurred, its heritage protection status, and approximate area in square meters.
2. Creative industries
Information about creative businesses located at each of the five Glasgow maritime sites
Glasgow Harbour (site_id 1): Home to digital media studios and an architecture firm
Pacific Quay (site_id 2): Major media hub featuring BBC Scotland, STV Productions, tech companies, and design firms
Riverside Museum (site_id 3): Features museum-related companies and cultural event organizations
Govan Graving Docks (site_id 4): No active creative businesses yet (as it's still abandoned with pending redevelopment)
Finnieston Crane area (site_id 5): Smaller creative enterprises focusing on arts and heritage media
3. Economic impact
Data showing cultural-economic metrics for each Glasgow maritime site over different quarters .
It demonstrates :
Seasonal patterns across all sites with higher visitor numbers and economic activity in summer (Q2, Q3) versus winter (Q1, Q4)
Local business growth is measured as percentage increase compared to previous quarter, showing how these sites stimulate surrounding economic development
Cultural events include exhibitions, performances, festivals, and other public activities that contribute to the sites' cultural significance
4. Market comparison
Sample data regarding : Sweden, Scotland, and Germany, Netherlands, Spain, Morocco, Tunisia, Egypt and Algeria. For comparing European and North African countries.
This data shows :
Regional differences
Sector-specific patterns
Growth trends
Market share
SQL Analysis
I have performed twenty-four analyses on the MySQL database mentioned earlier, the SQL technical elements used ranged from : Basic filtering with WHERE clauses to Data aggregation with GROUP BY, to JOINs , to Subqueries, to CTEs to temporary tables. For brevity, this section highlights the standout queries and their key takeaways.
Purpose: This query identifies newer, rapidly-growing creative companies that have achieved substantial employment numbers despite their young age. Technical Elements:
Multiple conditions using AND operator
Filtering on both numeric values (employee count and year)
Insight: These companies represent high-growth players in the creative economy, potentially indicating which sectors are experiencing rapid expansion and might be strategic targets for further investment or support.
Purpose: This query aggregates key performance metrics by industry type to compare the relative strength and economic impact of different creative sectors. Technical Elements:
Multiple aggregation functions (SUM, AVG, COUNT)
GROUP BY clause to segment data by industry category
Insight: The results reveal which creative sectors employ the most people, generate the highest average revenues, and have the greatest number of companies, helping prioritize industry types for maritime site development strategies.
Purpose: This query compares economic performance metrics across different geographic regions and industry sectors to identify regional strengths. Technical Elements:
Multiple aggregation functions across different metrics
Multi-field GROUP BY for geographical and sector-based segmentation
ORDER BY clause for organized presentation of results
Insight: The analysis reveals which regions excel in specific sectors based on trade volume, growth rate, and market dominance, potentially identifying successful regional development models that could be adapted elsewhere.
Purpose: This query provides a complete view of all maritime sites along with any available economic impact data, including sites that may not yet have measured impacts. Technical Elements:
LEFT JOIN to preserve all records from the maritime_sites table
All-columns selection for comprehensive data review
Insight: This comprehensive overview helps identify both high-performing sites and opportunities where economic impact hasn't been measured or hasn't materialized yet, flagging potential areas for development.
Purpose: This query creates a complete mapping of all possible site and industry combinations, effectively implementing a FULL OUTER JOIN in MySQL. Technical Elements:
Combination of LEFT JOIN and RIGHT JOIN with UNION to simulate a full outer join
Table aliases for readability
WHERE clause on the second query to avoid duplication
Insight: This comprehensive view identifies both unutilized maritime sites and unhoused creative industries, providing a complete picture of potential matching opportunities for planners and developers.