Projects Worked On
Projects Worked On
VistaWear is a fast-growing retail chain specializing in trendy clothing, footwear, and accessories, with stores across multiple U.S. cities. As the company expands, management recognizes the need to become more data-driven to support strategic decision-making.
While overall sales are increasing, leadership lacks visibility into customer behavior, store-level performance, and product profitability. Without these insights, it is difficult to identify top-performing locations, understand customer purchasing patterns, and optimize inventory and product offerings across regions.
This project aims to analyze VistaWear’s sales and customer data to uncover actionable insights that support growth, operational efficiency, and smarter merchandising decisions.
Check the report here
Tools: Excel and BI tools
CosmoMart Inc. is a global retail leader operating across multiple regions and serving a diverse customer base. As the company continues to scale, leadership recognizes the need for deeper visibility into sales performance, customer behavior, product profitability, and regional trends to remain competitive.
Despite having large volumes of sales data, decision-makers lack a consolidated view of which products, regions, and customer segments are driving profitability. This limits CosmoMart’s ability to optimize pricing, inventory allocation, and regional strategies.
This project analyzes CosmoMart’s sales data to uncover actionable insights that support data-driven decision-making, operational optimization, and sustainable profit growth.
Check out report below
Tools: Excel and BI tools
This interactive dashboard analyzes automotive sales performance from 2022 to 2023, providing insights into revenue growth, pricing dynamics, and customer demand patterns. It enables leadership to monitor overall sales health, compare manufacturer performance, and evaluate regional and product-level contributions to revenue.
Through detailed breakdowns by engine type, transmission, dealer region, and customer demographics, the dashboard uncovers key drivers of revenue and highlights opportunities to optimize pricing, inventory allocation, and market strategy. These insights support informed decision-making aimed at maximizing profitability and market penetration.
Tools: Excel and BI tools
This dashboard focuses on lead-to-enrollment conversion performance, providing visibility into how prospective learners progress from initial contact to successful enrollment. It tracks total enrollments across time, compares conversion outcomes by course category, country, and gender, and highlights the effectiveness of individual lead managers in driving enrollments.
By analyzing enrollment trends, feedback outcomes, and lead sources, the dashboard helps identify conversion bottlenecks, high-performing acquisition channels, and courses with the strongest conversion rates. These insights support data-driven improvements to lead management strategy, marketing channel allocation, and overall conversion efficiency.
Check out report below
Tools: Excel and BI tools
This interactive dashboard explores social media usage patterns among students across the globe and examines how digital habits relate to academic performance, sleep, and wellbeing. Built on data from 705 students across 110 countries, the dashboard provides a clear, data-driven view of student behavior in today’s digital environment.
The Overview dashboard presents high-level metrics such as total student records, geographic coverage, average sleep hours, and the percentage of students whose academics are affected by social media use. It also highlights platform preferences and academic level distribution, allowing stakeholders to quickly understand usage trends and overall impact.
Tools: Excel and BI tools
The Insights dashboard dives deeper into behavioral drivers by analyzing average daily usage hours, platform dominance, and how engagement intensity varies across academic levels. These breakdowns help uncover patterns linking excessive usage to academic strain and reduced sleep, offering valuable context beyond surface-level metrics.
Together, these dashboards support data-informed conversations around digital wellbeing, helping educators, policymakers, and institutions identify risk areas, prioritize interventions, and promote healthier technology use among students.
Check out report below
https://app.powerbi.com/links/QJpOkshavx?ctid=0801c8b7-f6a9-44a2-8891-282fd58fab33&pbi_source=linkShare
Tools: Excel and BI tools
This dashboard provides a high-level view of company performance across four major sales channels: In-Store, Online, Distributor, and Wholesale. It enables leadership to compare revenue, profit, profit margin, and order volume across channels to understand which business segments drive overall performance.
By visualizing sales trends over time and highlighting both top-selling and underperforming products, the dashboard helps identify growth opportunities, channel inefficiencies, and product-level risks. These insights support data-driven decisions around sales strategy, channel optimization, and product portfolio management.
Tools: Excel and Tableau Destop
This dashboard provides a high-level view of retail sales performance across key dimensions including time, product categories, payment methods, and customer locations. It enables decision-makers to quickly assess total spending, average pricing, transaction volume, and quantity sold to understand the key drivers of revenue.
By visualizing monthly spending trends, category-level performance, and transaction distribution across locations and payment methods, the dashboard highlights both revenue-generating segments and areas of underperformance. These patterns help uncover shifts in customer behavior, category demand, and payment preferences.
The insights from this dashboard support data-driven decisions related to pricing strategy, product mix optimization, payment channel adoption, and regional performance analysis. Helping businesses focus on opportunities that improve both sales efficiency and customer experience.
Check out report below
https://app.powerbi.com/links/tRqLgmhQ6O?ctid=0801c8b7-f6a9-44a2-8891-282fd58fab33&pbi_source=linkShare
Tools: Excel and Tableau Destop
This dashboard provides a high-level view of coffee shop performance across multiple locations, enabling stakeholders to quickly assess overall sales activity and store-level performance. It highlights key metrics such as total sales, transaction volume, and units sold, while monthly trend analysis reveals patterns in demand over time.
Location-level sales and top-performing product categories help identify high-performing stores and customer preferences, supporting decisions related to store optimization and product focus. Interactive location filters and a clean visual design allow users to explore performance dynamically and make timely, data-driven decisions.
Tools: Excel and PowerBI
This dashboard provides a comprehensive view of company sales performance across multiple dimensions, including product category, region, and customer segment. It enables stakeholders to evaluate total revenue, identify key revenue drivers, and understand how performance varies across markets and customer groups.
Monthly revenue trends reveal changes in demand over time, while comparisons of customer purchasing behavior by segment and shipping mode help uncover meaningful differences in buying patterns. Interactive year filters and clear visual design support focused analysis and strategic decision-making related to customer targeting, product mix, and regional performance.
Tools: Excel, Pivot Tables and BI tools
SQL FINDINGS (VISUAL WITH CARBON)
TASK: Rewarding High Performers. Find departments where the average satisfaction rate is above 50%, and display the department name along with that average.
RESULT: Computes the average employee satisfaction rating for every department and returns only those with values greater than or equal to 50%.
TASK: Salary vs. Project Performance. List employees who earn above the average company salary and have completed more than 20 projects..
RESULT: The query filters employees who earn above the average salary and have completed over 20 projects. These individuals represent high-impact contributors who combine strong compensation levels with proven productivity.
TASK: Company-Wide Data Consistency Check. Create a complete table that displays: EmployeeID, Employee Name, DepartmentID, FeedbackScore. Ensure the query shows all records from both tables, even if some employees don’t have performance data or some performance records don’t match any employee.
RESULT: This SQL statement retrieves employee details and performance feedback by executing a full join on UpdatedEmployeeList and EmployeePerformance. It ensures all records from both tables are included. Whether or not a matching employee ID exists. Providing a complete merged dataset for auditing or data reconciliation.
TASK: NexaTech wants to understand team output. For each department, show: •Department name, •Total number of employees, •Average productivity percent, •Average feedback score. Sort the results by the department with the highest productivity.
RESULT: Returns each department’s employee count, average productivity, and average feedback score, sorted by highest productivity.