Gourango Sutradhar
Portfolio
Executive Sales Performance Dashboard & Call Analytics
"Built an interactive executive sales performance dashboard in MS Excel tracking 18,300 total calls, 1,309 closed deals, and $706K+ in total revenue. Designed dynamic pivot tables, data bars, and slicers for real-time agent tracking and integrated a native map visualization for regional service level distribution across Bangladesh."
Beverage Sales & Regional Distribution Analytics
"Developed an interactive Power BI dashboard to analyze regional sales performance and consumer purchasing behavior, managing $8.2M in total revenue and 16.45M total units sold. Engineered a star-schema data model, implemented advanced DAX measures for time-intelligence, and created custom UI/UX with cross-filtering."
Global SuperStore End-to-End Analytics Case Study
"Performed an end-to-end data analytics workflow on the Global Super Store dataset (2011-2014) covering 1.43K orders and $12.64M in revenue. Utilized MS Excel for advanced feature engineering (logistics speed calculation, profit status classification, and multi-tier discount categorization). Built an optimized Star Schema data model and multi-page interactive Power BI dashboard suite to track executive KPIs, sales profitability, customer segments, and regional performance."
Sales Data Analytics & SQL Query Optimization Project
"Designed and executed an academic SQL data analytics project using a custom-created sales and products dataset. Built relational database schemas with primary and foreign keys, and implemented advanced SQL operations including multi-table joins, subqueries, nested aggregations, and HAVING clauses. Generated monthly sales summaries, analyzed regional and categorical performance, and optimized query performance using execution plans (EXPLAIN)."
E-Commerce Multi-Dimensional Sales Performance Dashboard
"Designed a comprehensive Tableau dashboard to evaluate e-commerce sales performance across 5,000 total orders, generating over $5.1M in revenue. Formulated calculated fields and interactive parameters for multi-dimensional filtering by product category, regional revenue, and customer payment preferences."
Enterprise HR Workforce Demographics & Attrition Intelligence Dashboard
"Designed a comprehensive Power BI dashboard to monitor workforce demographics across 1,47K total employees, tracking over $9.56M in total payroll distribution. Formulated advanced data transformations and dynamic KPI cards for multi-dimensional filtering by employee job satisfaction, departmental attrition rates, and compensation trends against tenure."
