Taher Hassan | Data Analyst Portfolio

 Managing large corporate databases requires a smart bridge between back-end data extraction and front-end business reporting. In this project, I demonstrate how to use optimized SQL queries alongside Microsoft Excel to analyze customer behavior and sales performance efficiently. 📊 Project Objective: The goal was to query a relational SQL database containing thousands of customer transactions, extract key metrics, and migrate the clean data into Excel to build an automated, executive-ready sales performance dashboard. 💻 Step 1: SQL Data Extraction (The Back-End) To handle the data efficiently and optimize server performance, I wrote advanced SQL queries using critical relational database concepts: - Applied 'SELECT' and 'WHERE' clauses to filter out active sales records. - Utilized 'JOINS' (INNER JOIN) to merge the Customer Profile table with the Sales Transactions table. - Implemented 'GROUP BY' and Aggregation functions (SUM, AVG) to calculate total ...