LICENSED DRIVERS DATA ANALYSIS IN USA
Performed an in-depth exploration and cleaning of two datasets using Pandas.
Developed and maintained a series of SQL queries to uncover patterns and test hypotheses regarding the distribution of licensed drivers across age groups, gender, and state governing party.
Generated insightful visualizations using Python libraries Matplotlib and Seaborn to effectively communicate the findings.
FOOD SALES AND CUSTOMER ANALYSIS
Developed a robust food sales and orders database utilizing four PostgreSQL tables.
Leveraged SQL expertise to analyze data and extract key insights, including customer satisfaction rate, repeat customer percentage, top-selling products, and net profit revenue.
Constructed an interactive KPI dashboard in Tableau to visualize trends, provide actionable business metrics, and uncover opportunities for improvement.
THE YELP DATASET
Conducted a comprehensive profiling and analysis of businesses and user data to establish correlations between user reviews and various metrics, including the number of fans, customer success rates, and business rating distributions across categories and locations.
Technologies: Postgresql, SQL, Google Docs
TABLEAU
Developed an interactive KPI dashboard and crafted insightful ad-hoc reports to effectively communicate trends, uncover valuable metrics, and share data-driven recommendations.
SQL Window Functions
Practiced most common window functions by analysing the Employee dataset
