Hi! I'm Smith.
Hi! I'm Smith.
I turn data into stories.
I turn data into stories.
Embedded Files
Projects
User Engagement Analysis
User Engagement Analysis
In this real-world analytics project, I analyzed over 150,000 businesses across the USA and Canada to uncover what drives restaurant success on Yelp. By transforming unstructured JSON data into relational databases, I derived insights about user behavior, sentiment, and time trends using SQL and Python visualizations.
Sales Performance Analysis & Customer Segmentation
Sales Performance Analysis & Customer Segmentation
E-commerce platforms thrive on personalized experiences. But how can we group customers based on their shopping behavior? Can these segments help improve marketing strategies and customer engagement?
Credit Card Revenue Leakage & Analysis
Credit Card Revenue Leakage & Analysis
Developed a credit card usage dashboard to uncover ₹1.9 Cr in revenue loss from dormant users, highlight ₹3.9 Cr revenue from active segments, and surface 68% cross-sell opportunity. Delivered actionable insights using Power BI and Python (pandas).
Customer Churn Analysis
Customer Churn Analysis
Analyzed customer Churn data using Python, Pandas, and Seaborn to identify churn drivers. Found higher churn among month-to-month contracts, electronic check users, first-year customers, and senior citizens. Recommended strategies include contract incentives, early engagement, and personalized support to boost retention and align with business goals.
Financial Performance Analysis For Apple Inc.
Financial Performance Analysis For Apple Inc.
Designed a Financial Statement Analysis Dashboard using Excel and Power BI to deliver actionable insights on profitability, liquidity, and capital structure, helping drive strategic financial decisions and operational improvements.
🔗 Read More ➝
🌐 Open Live Dashboard
Plant Co Performance Analysis (2023-2024)
Plant Co Performance Analysis (2023-2024)
A dynamic Power BI dashboard for analyzing Plant.Co’s Sales, GP, and Quantity performance for 2023 and 2024. Users can switch metrics, drill down by country, month, and product, and compare YTD vs PYTD trends.
Technical Skills
Programming Languages & Libraries
● Python — NumPy, Matplotlib, Pandas, PySpark, SpaCy, NLTK
● SQL — MySQL, PostgreSQL
Tools & Softwares
● Power BI — Data visualization & dashboarding
● Jupyter Notebook — Data analysis & scripting
● Microsoft Excel & Google Sheets — Data manipulation
Concepts
● Data wrangling and preprocessing
● Exporatory data analysis & Feature Engineering
● Data modelling, relational databases, and database querying
● Big data processing and distributed computing
● Data visualization
● Database Querying & Management
Experience
➡Conducted in-depth analysis using Power BI to uncover key insights into revenue, customer behaviour, city-specific trends, sales modes, and demographic age groups.
➡Created and presented 2 comprehensive reports that contributed to a 10% increase in active users and a 15% boost in profit, enhancing market position and financial performance.
Education
University of Mumbai
University of Mumbai
Bachelor Of Commerce | Financial Accounting and Auditing
Bachelor Of Commerce | Financial Accounting and Auditing
June 2022 - July 2025 | Mumbai, India
June 2022 - July 2025 | Mumbai, India
Relevant coursework: Computer Systems & Applications (SQL, Visual Basic, Data Structures), Business Economics, Financial Analytics, Auditing, Mathematics and Statistics, Taxation , Data-Driven Financial Decision Making
Key Skills Gained: Programming (SQL, Visual Basic), Data Structures, Financial Data Analysis
Certifications
📩 Contact Me ➝
smithsolanki33@gmail.com
Page updated
Google Sites
Report abuse