Prabhat tiwari
Supply Chain Data Analyst & Power BI Expert for Logistics
- 1
- Followers
Global Logistics Command Center & Real-Time Tracking Dashboard
0
25
E-Commerce Sales Performance Dashboard 🛒📊
​Designed and built an advanced, interactive E-Commerce analytics dashboard to track key online retail metrics, revenue growth, and regional sales distribution.
​Key Highlights:
​Financial Overview: Monitored Total Sales ($114K), Total Profit ($22.8K), and maintained a strong Profit Margin (20%).
​Regional & Category Filters: Integrated dynamic slicers for Categories and Regions (East, North, South, West) to drill down into specific market performance.
​Visual Trends: Visualized monthly profit distribution, yearly sales projections, and order quantities through clean pie charts, bar charts, and area graphs.
​Built to help e-commerce store owners uncover hidden trends, optimize inventory, and scale their online revenue effectively.
0
62
Executive Sales & Financial Performance Dashboard 📈💼
​Developed a dynamic Executive Dashboard to monitor core financial health, sales performance, and cost distribution across various product categories.
​Key Highlights:
​Financial Metrics: Tracked real-time Total Profit ($482K), Total Revenue ($964K), and Total Cost ($964K).
​Profit & Cost Analysis: Visualized profit distribution and cost trends across items like laptops, smartphones, and accessories.
​Category Breakdown: Utilized treemaps and donut charts for clear revenue segmentation by category and region.
​Designed to empower leadership with actionable insights for strategic decision-making and financial optimization.
0
62
​Data Cleaning & Formatting Portfolio 📊✨
​Showcasing an advanced data cleaning and text formatting pipeline designed to transform messy, unorganized raw data into clean, structured, and ready-to-use information.
​Key Highlights:
​Standardization: Converted irregular name formats (Mixed case/Spacing errors) into professional Proper Case (Full Name).
​Text Transformation: Implemented automated uppercase and lowercase formatting for systematic data uniformity.
​Error Reduction: Identified and highlighted duplicates and inconsistencies to ensure high data integrity.
​Clean data is the backbone of accurate analytics and reporting. This project highlights my expertise in data preparation using advanced Excel/Data techniques.
0
84