Philip Assad
Portfolio
Sales Analysis
This project analyzes sales data from a retail business using PostgreSQL, focusing on three core financial metrics: customer lifetime value, cohort revenue trends, and churn behavior. The goal is to move beyond surface-level revenue numbers and uncover the underlying patterns that drive or threaten, long-term business performance.
Financial Analysis Dashboard Customers Cost Centers Excel
This project analyzes customer credit risk, cost estimation accuracy, and revenue impact from returns across the company's customer segments and cost centers from 2021–2024. The goal is to move beyond surface-level metrics and uncover the underlying patterns that drive — or threaten — cash flow stability, operational efficiency, and net revenue health.
Data Jobs Analysis
This project analyzes job market demand for data professionals across three key dimensions: skill trends throughout the year, skill requirements by job role, and compensation for Data Scientists in the United States. The goal is to move beyond surface-level job postings and uncover the underlying patterns that drive hiring decisions, skill priorities, and salary benchmarks across the data industry.
