Data Analytics
Airbnb Market Analysis
Comprehensive analysis of Cape Town's Airbnb market, identifying pricing trends and investment opportunities.
Project Contains:
- Interactive visualizations
- Market trend analysis
- Pricing strategy recommendations
Smart Home
Home Assistant Capstone
Comprehensive analysis and optimization of Home Assistant automation system with energy monitoring, security integration, and voice control.
Project Contains:
- Jupyter notebooks with Python code
- Database query examples
- Detailed documentation
- PowerPoint presentations
Business Intelligence
Customer Churn Analysis
Predictive analytics model to identify at-risk customers and provide targeted retention strategies.
Project Contains:
- Dataset analysis
- Tableau visualizations
- Predictive modeling
- Retention strategy recommendations
Data Analytics
Kickstarter Growth Analysis
Analysis of successful crowdfunding campaigns, identifying key factors that contribute to project success.
Project Contains:
- Excel data analysis (2009-2012)
- Comprehensive PowerPoint presentation
- Success factors breakdown
- Trend analysis
Business Intelligence
British Airways Service Quality
Analysis of British Airways service quality through customer reviews and operational metrics.
Project Contains:
- Customer review analysis
- Service quality metrics
- Detailed presentation with recommendations
- Excel data analysis
Business Intelligence
Global Food Supply Chain
Power BI dashboard analyzing global food supply chains, identifying inefficiencies and trends.
Project Contains:
- Supply chain analytics
- Efficiency improvement recommendations
- Interactive visualizations
Resources
SQL Resources
Collection of SQL learning resources, guides, and practical examples for data analysis.
Resources Include:
- SQL Basics Guide
- Column Operations Tutorial
- Annotated SQL examples
- Best practices documentation