Erefa Oyeindiepreye Juliet
Data Analyst | SQL | Python | Power BI | ExcelI transform raw data into actionable insights that support business and operational decision-making.
📄 View CVProjects
Airline Passenger Satisfaction Analysis
Analyzed airline passenger data to understand how flight delays and service quality affect customer satisfaction.
Insights & Recommendations
Key Insights
- Flight delays had a strong negative impact on passenger satisfaction.
- Business-class passengers showed sharper dissatisfaction during long delays.
- Poor Wi-Fi and seat comfort worsened dissatisfaction during delays.
Recommendations
- Improve delay management and passenger communication.
- Invest in reliable in-flight Wi-Fi and comfort.
- Introduce compensation strategies for high-value passengers.
Retail Sales Performance Analysis
SQL and Power BI analysis to identify revenue drivers, customer segments, and sales trends.
Insights & Recommendations
- Electronics and Clothing generated the highest revenue.
- Weekend sales consistently outperformed weekdays.
- Returning customers contributed significantly to revenue.
Workforce Planning & Layoffs Trend Analysis
SQL analysis of global layoffs to identify trends across industries and regions.
Insights & Recommendations
- Layoffs increased significantly between 2020–2023.
- The technology sector was the most affected.
- The US recorded the highest number of layoffs.
Data Professionals Survey Analysis
Power BI dashboard analyzing salaries, tools, and job satisfaction among data professionals.
Insights
- Python, SQL, and Power BI were the most used tools.
- Higher experience correlated with higher salaries.
- The US had the highest survey participation.