Satyagopal Pakki's Work | ContraWork by Satyagopal Pakki
Satyagopal Pakki

Satyagopal Pakki

Tableau | Power BI | Python | Data Analyst

    3
    Followers
Followed by GALLERY L, Imad K, and bhavneet k

Visakhapatnam, India

WorkPostsServicesAbout

Visakhapatnam, India

Cover image for šŸ“Š Excel to Power BI
šŸ“Š Excel to Power BI Migration | Sales KPI Dashboard | $1.24M Revenue Client was managing everything in Excel sheets - manual & time-consuming. What I Did: āœ“ Migrated 5 Excel sheets to Power BI with automated refresh āœ“ Built 4 Key KPIs: Revenue $1.24M, Profit $312K, Conversion 4.8%, Active Customers 3,215 āœ“ Added YoY growth tracking & monthly trends āœ“ Created Region & Product Category breakdowns Tools: Power BI, Power Query, DAX, Excel Result: Client saved 8 hrs/week, now gets live dashboard at 6 AM daily. Used by sales team for daily decisions.
0
222
Cover image for šŸ›’ E-commerce & Financial Dashboard
šŸ›’ E-commerce & Financial Dashboard | Power BI | $2.34M Revenue Built an end-to-end E-commerce analytics dashboard to track sales, profit & inventory. šŸ”¹ Problem: Client had no visibility on which products/channels are profitable šŸ”¹ Solution: Built automated dashboard with live inventory alerts Features Built: āœ“ Total Revenue $2.34M (+12.4% YoY), Profit $420K, Margin 17.9% āœ“ Revenue & Profit Trend (Oct 2023 - Sep 2024) āœ“ Sales by Product Category - Electronics $842K top āœ“ Profit by Channel - Online 52% share āœ“ Inventory Metrics: 12,450 units, Low stock alert (23 items), Stock Turnover 4.2x āœ“ Top 5 Products table with Stock levels Tools Used: Power BI, DAX, Power Query, Excel, Inventory Management Result: Client identified best-selling products and reduced out-of-stock by 35%. Automated daily refresh at 06:00 UTC. This dashboard is used by the Founder daily to take decisions.
0
110
Cover image for šŸ“Š Sales KPI Dashboard -
šŸ“Š Sales KPI Dashboard - Power BI | $4.82M Revenue Tracking Built a CEO-level Sales KPI Dashboard to automate manual Excel reporting. šŸ”¹ Problem: Client was spending 8+ hours weekly on Excel reports šŸ”¹ Solution: Built automated Power BI dashboard with DAX measures Features Built: āœ“ Total Sales, Profit, Orders KPIs with YoY growth āœ“ Sales Revenue Trend (Monthly) āœ“ Sales by Region - Interactive US Map āœ“ Sales by Category & Top Products breakdown āœ“ 22% Profit Margin tracking Tools Used: Power BI, Excel, DAX, Power Query Result: Reduced reporting time from 8 hours to 10 mins. CEO can now take decisions in real-time. Live Dashboard: Fully interactive with filters by Date, Region, Category
0
60
Cover image for Sales Dashboard - Excel to
Sales Dashboard - Excel to Tableau in 48 Hours
3
430