💼 My Role

SQL / Business Analyst

Responsibilities

• Database analysis
• SQL query writing
• Data exploration
• Customer analysis
• Employee performance analysis
• Insight generation
• Business recommendation development

📌 Project Overview

A business analytics and SQL project focused on customer value optimization, employee performance analysis, and catalog performance insights for Chinook Media, a digital entertainment retailer specializing in online music sales.

The project used PostgreSQL and analytical SQL queries to uncover business insights related to customer behavior, revenue generation, employee effectiveness, and product performance.

🎯 Business Problem

Chinook Media lacked a data-driven understanding of:

• Customer purchasing behavior
• Employee support effectiveness
• Product catalog performance

This limited the company’s ability to: