My prortfolio : Data analysis

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 

1. 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.

Task 6: Regional Sector Performance Analysis

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.