Workstreams
involving my
PROJECT
POWER-BI
SQL
EXCEL
The “Eco-Friendly Sales Performance Metrics” dashboard provides a comprehensive overview of sales-related data. It includes analyses of total earnings and paid calls, highlights the top 5 consultants with sales revenue by month, and identifies highest, lowest, and average monthly revenues. It also offers insights into the percentage of paid and unpaid calls, training model fees by sales team, and enrolled courses by training level. Additionally, it showcases paid call duration statistics, advertising spend by channel, total sales by sales team, and top-performing consultants and training models. The dashboard allows for effective performance evaluation and decision-making within the Eco-Friendly sales team.
SQL
Cohort Analysis on Online Retail Data
This project involves performing cohort analysis on retail data using SQL queries. Through categorizing customers based on their first purchase month, insights into customer behavior, retention rates, revenue trends, and lifetime value are extracted to inform business strategies and decisions.
Projects
Explore insightful articles on analytic projects, offering expert tips, trends, and strategies for data-driven decision-making.
Power BI
Curated Bank Credit Card Choices
This project aimed to assist the bank in launching a new credit card line by analyzing data from 4000 customers across five cities. Focusing on online spending patterns and demographic information, the project utilized Power BI, Python, and Excel to provide comprehensive customer segmentation, uncover trends in spending and demographics, and create an interactive data-driven dashboard. Key findings included clear customer segmentation and actionable recommendations for personalized credit card features and targeted marketing strategies. Continuous data analysis was recommended to stay adaptive to market changes. The project’s success relied on effectively presenting the findings to stakeholders, especially Mr. Bashnir Rover’s team.
Power BI
Comprehensive Business Insights
Comprehensive Business Insights is a project focused on providing a 360-degree view of business operations. Through advanced data analytics and visualization tools, it offers detailed insights into market trends, consumer behavior, and operational efficiencies. Utilizing a combination of Power BI, Python scripting, and Excel, the project delivers comprehensive reports and interactive dashboards that enable informed decision-making. Key outcomes include strategic recommendations for business growth, optimization of resources, and enhanced market competitiveness. Continuous analysis ensures adaptability to evolving market dynamics, making Comprehensive Business Insights a crucial tool for proactive business management.
SQL
Impromptu Requests | Consumer Goods Domain
Welcome to the Atliq Hardwares! In the fast-paced world of consumer goods, where data-driven decisions are paramount, Atliq Hardwares, an industry leader in computer hardware production, has recognized the need for quick and informed decision-making. To meet this demand, they are expanding their data analytics team with the goal of hiring junior data analysts who possess both technical expertise and essential soft skills.
SQL
Insightful MySQL Data Analysis by Maven Analytics
In my ongoing “Advanced MySQL Data Analysis by Maven Analytics” course, I worked as an eCommerce Database Analyst for Maven Fuzzy Factory, an emerging online retailer. Our midterm project aimed to uncover actionable insights from the eCommerce database. Key findings included the vital role of Gsearch in driving growth, promising results from non-brand and brand campaigns, and the significance of mobile traffic. A/B testing revealed incremental revenue opportunities, and our website’s overall performance improved, as reflected in higher session-to-order conversion rates. This project emphasized the power of data analysis in informing strategic decisions, enhancing user experience, and driving business growth.
SQL
AIRBNB Outlier Detection and EDA
Analyzed Airbnb’s European booking dataset, revealing room type trends, pricing influences, and cleanliness’s impact on guest satisfaction. Outlier detection refined data, highlighting hygiene’s role. Data-driven insights empower hospitality for exceptional guest experiences.
SQL
Cohort Analysis on Online Retail Data
This project involves performing cohort analysis on retail data using SQL queries. Through categorizing customers based on their first purchase month, insights into customer behavior, retention rates, revenue trends, and lifetime value are extracted to inform business strategies and decisions.
Excel
Eco-Friendly Sales Performance | Excel Dashboard
The “Eco-Friendly Sales Performance Metrics” dashboard provides a comprehensive overview of sales-related data. It includes analyses of total earnings and paid calls, highlights the top 5 consultants with sales revenue by month, and identifies highest, lowest, and average monthly revenues. It also offers insights into the percentage of paid and unpaid calls, training model fees by sales team, and enrolled courses by training level. Additionally, it showcases paid call duration statistics, advertising spend by channel, total sales by sales team, and top-performing consultants and training models. The dashboard allows for effective performance evaluation and decision-making within the Eco-Friendly sales team.