Sarat Kumar Mukherjee

📊 From Raw Data to Real-Time Insights: A Power BI Transformation : 📊 My Project: E-commerce Sales Performance Dashboard: I’m excited to share my latest Power BI project, where I analyzed e-commerce sales data to identify key revenue drivers and operational challenges. 🚀 Key Insights from the Analysis: Revenue Overview: Total revenue reached $1,245.14M with over 15.69K orders. Top Performers: The Laptop category is the leading revenue driver at $389.99M , followed by Mobile. Specifically, the MacBook Air and OnePlus 9 are the top-selling products. Regional Strength: Maharashtra and Gujarat are the strongest markets, contributing $247.23M and $239.39M respectively. Efficiency Metrics: While the Avg Order Value is $112.85K , there is a significant 29.72% cancellation rate , leading to a $525.42M loss in potential revenue. Technical Highlights: Designed an interactive dashboard with slicers for time-based analysis (e.g., January view). Utilized line charts to track revenue trends throughout 2024, identifying a peak in July at $134.43M. Created clear visualizations for revenue distribution across Categories, States, and Products.

📈 Sales Performance Tracking: Turning Data into Strategy: I’ve just wrapped up a new Sales Performance Report focused on regional distribution and individual contributor impact for the year 2023. Key Business Insights: Total Revenue: Achieved 402M in total sales across 4 regions and 5 core products. Regional Dominance: The West region led the way, accounting for 27.53% ($111M) of total revenue. Product Trends: Mobiles and Laptops were the highest-volume products, with approximately 39K units sold each. Sales Excellence: Monitored the performance of 6 salespersons, including Kunal and Riya, to understand distribution efficiency. Real-Time Application: This analysis utilizes sample data to simulate a real-time retail scenario, demonstrating how seasonality—like the peak sales in January (37,705K) compared to the dip in August—dictates inventory and staffing needs. As someone who bridges Data Analysis and Graphic Design, I prioritized a clean, high-contrast UI to ensure stakeholders can instantly spot these trends.

📊 My First Project in Power BI : Optimizing E-commerce Performance with Data Intelligence I’m excited to share my latest Power BI dashboard, where I’ve analyzed a comprehensive e-commerce dataset to identify growth drivers and operational bottlenecks. 🚀 What the data tells us: Revenue Leaders: The Laptop category leads with $389.99M, driven by top sellers like the MacBook Air. Regional Strength: Maharashtra and Gujarat contribute nearly 40% of the total revenue, highlighting key market strongholds. The "Hidden" Loss: Despite a strong $1,245.14M in total revenue, I identified a 29.72% cancellation rate, which equates to $525.42M in lost potential. This is a primary area for operational improvement. Technical Spotlight: Built an end-to-end interactive dashboard with dynamic slicers for deep-dive category and time-series analysis. Visualized complex trends using line and bar charts to provide clear, actionable intelligence for stakeholders. As a data analyst, my goal is to go beyond reporting numbers and provide the "why" that helps businesses make smarter decisions. This is sample data but reflects real-time business scenarios where balancing high sales with low cancellation rates is vital for maximizing ROI.

👥 I’m thrilled to share my latest Power BI project: a Workforce Intelligence Dashboard focused on understanding attrition and optimizing employee satisfaction. 🚀 What this dashboard solves: Attrition Deep-Dive: Moving beyond "how many" left to "why" they left by correlating job satisfaction with specific roles. Financial Impact: Analyzing Attrition by Salary Slab to identify if compensation strategies align with retention goals. Lifecycle Insights: Tracking Attrition Trends by Experience to see if turnover is a "new hire" problem or a "tenured talent" challenge. Diversity & Demographics: Monitoring Age and Gender distribution across departments to maintain a healthy workforce balance. Technical Highlights: Developed a clean, executive-level UI focusing on high-level KPIs like Attrition Rate and Avg Experience. Utilized complex DAX to track real-time trends and demographic shifts. Integrated multi-dimensional filters (Department, Job Role) for granular data exploration. "This is sample data but reflects real-time business scenarios" where high turnover costs companies millions, and data-driven HR is the only way to protect the bottom line. I’d love to hear from my HR and Data colleagues—how are you using data to keep your top talent?

New Project: Driving Business Growth with Excel Sales Analytics Excel remains one of the most powerful tools in a data analyst's toolkit. I’ve just completed a Dynamic Sales Dashboard that transforms raw transactional data into a strategic roadmap for revenue growth. 🚀 What this dashboard reveals: Revenue Drivers: A deep dive into our $401.59M annual revenue, identifying Printers as the high-margin hero product. Territory Insights: Visualizing regional strengths, where the West region led the market with $110.55M in sales. Performance Tracking: Monitoring individual contributions, with Kunal setting the benchmark for the sales team at $74.2M. Seasonal Peaks: Pinpointing August and October as the highest-performing months to help stakeholders align marketing spend. Technical Spotlight: Used Power Query to clean and transform messy raw data into a structured format. Built dynamic Pivot Tables and used Slicers to allow users to filter by Region, Product, and Salesperson. Applied my Graphic Design background to create a clean, professional UI that ensures stakeholders see the "story" behind the numbers immediately. "This is sample data but reflects real-time business scenarios" where identifying top performers and regional trends is the difference between a flat year and a record-breaking one.

Designing engaging visuals that bring concepts to life, enhancing brand presence and messaging through innovative graphics.

Successfully pitched Byju's product offerings to prospective clients, demonstrating a deep understanding of product value. Facilitated informative parent meetings, addressing inquiries and effectively communicating product features. Collaborated with the marketing team to develop strategies aimed at enhancing lead generation and conversion.