Olist - Superstore Project

Tools : Power BI, Tableau, SQL, Excel. Unveiling Olist's strategy, I highlighted diversification's success, managing 4,143 monthly orders. Recommendations: loyalty programs, dynamic pricing, and improved customer service for enhanced profit.

COVID-19 data analysis

Embarking on a Tableau-driven COVID-19 data analysis journey, the initial surge in daily cases was effectively contained by a 2020 lockdown. A new variant sparked a second-wave upsurge, mitigated by a robust vaccination drive, resulting in a noticeable decline in active cases from August 2021 onward

Airbnb Analysis

Airbnb, valued at $75 billion, faces criticism for rent impacts. Insideairbnb assesses its neighborhood effects. This article stresses understanding the business model for effective analytics, using CRISP-DM on Airbnb's dataset.

PwC Churn Customer Retention

Analysis unveils a 27% churn risk for 7043 customers, totaling $16.06M yearly charges. Monthly charges are $456.12K. Recommendations: promote 1 and 2-year contracts, offer task-based discounts, encourage Online Security and Tech Support, and implement a 5% yearly increase for enhanced retention.

PwC - Diversity and Inclusion

Key report indicators: Women primarily hired in lower grades. Diversity and Inclusion impact noted in Italy, Switzerland, Germany, France. FY19 outperformed FY20 in average performance rating. FY20 saw significant women's inclusion improvement in promotions, while FY21 indicates a decline.

Superstore Project

Analyzing the Superstore dataset with Power BI for insightful visualizations and trends. Uncover sales, inventory, and customer behavior patterns. Unlock the potential of your data with Power BI and Tableau.

Call centre analysis

Insights: Calls primarily rate satisfaction as 3 and 4, declining monthly with a peak in January. January sees the highest issue resolution, and mornings witness the majority of calls.

Bike Sales Dashboard

Insights reveal male bike buyers, earning more, have a higher purchase rate, influenced by income. North America surpasses the Pacific and Europe in bike purchases. The middle age group (31–54) dominates purchases, married individuals buy more than singles, and shorter commutes (0–1 miles) correlate

Data Professional Survey

Breaking into tech is feasible with accessible resources, mentorship, and networking. Python is key for data professionals, but promoting diverse skills enhances the tech landscape. Prioritize competitive compensation, internships, and well-being for a thriving workforce.

Car Dekho Project

I recently undertook a comprehensive SQL project case study using the Car Dekho company dataset, where I applied various database querying techniques to gain valuable insights into the automotive industry. Leveraging my SQL skills, I conducted an in-depth analysis of the dataset, exploring factors.

Music store data analysis

Just completed a SQL project on a fascinating music store dataset!

Bank Loan of customers

Tools used: PowerBI, Tableau, SQL, Excel.Objective: Analyzing loan data provided by a financial institution for diverse customers with varied grades and sub-grade levels, considering loan disbursement reasons, funded amount, revolving balance values, payment modes, and last payment values.