Emmanuel Ekanem

• Queried and analyzed data across 5 relational tables (customers, products, orders,
order_items, sales reps)
• Identified top-performing products and revenue drivers using aggregation and ranking
functions
• Evaluated sales representative performance, highlighting high and low performers
• Analyzed customer purchasing patterns across regions to support targeted marketing
• Built advanced SQL solutions using:
o Joins for multi-table analysis
o Subqueries for comparative insights
o CTEs for structured reporting
o Window functions for ranking and running totals
• Delivered a structured business report with actionable insights on revenue growth and
operational performance