My Portfolios
Dashboards
Total Sales & Top Sellers Performance Dashboard
Interactive Excel dashboard showcasing total yearly sales, top seller performance, and sales vs. seller count.
Discount Code Usage Dashboard
Looker Studio dashboard analyzing discount code usage across multiple Shopify sites with sales data.
Student Graduation & GPA Analysis Dashboard
Excel dashboard tracking student graduation numbers, tier-wise distribution, and GPA performance.
Project Objectives & Events Dashboard
Access dashboard highlighting project objectives, tracking wildly important goals, and managing pending and upcoming events for effective project oversight.
Excel Projects
Product Comparison Metrics
Excel sheet comparing products across various metrics, offering a detailed side-by-side analysis for informed decision-making.
Research & Innovation in Switzerland Dashboard
Project scrapes economic data from public websites, compares indicators monthly, and analyzes results in an Excel dashboard for final year-wise insights.
Sales Incentive Calculator with VBA
Excel tool with VBA to calculate seller incentives, automating commission calculations and improving accuracy in performance-based rewards.
Sales Calculator with VBA
Excel VBA tool for calculating achievements and bonus percentages based on cases sold, automating sales performance evaluations.
Add/Edit Indicators Excel Input Form
Excel input form with VBA to select indicators from OECD links, automatically extract data, and update the sheet for seamless data management.
Analyze Indicators Selection Form
Excel form for selecting indicators, countries, and time periods (up to the current year), with analysis features to evaluate data comprehensively.
Excel Switchboard with Navigation
Excel switchboard featuring buttons for product entry, adding products for comparison, viewing added products, accessing the master sheet, and exporting comparison sheets to PDF.
Access Projects
Inventory Return Form
Access project for managing inventory returns, featuring a comprehensive form to track and process return transactions efficiently.
Excel Import/Export Tool
Access form for exporting selected fields to Excel and importing data from Excel, facilitating seamless data transfer and integration.
Supplier Delivery Details Form
Access form for capturing and managing detailed supplier delivery information, ensuring accurate tracking and documentation of shipments.
Showroom Dashboard Report
Access dashboard report displaying key metrics for sales representatives, including specifications to purchase, first and final appointments, and progress toward goals.
