Prabhat tiwari
Power BI Dashboard Developer | Excel & SQL Data Analyst
New to Contra
Prabhat is ready for their next project!
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
29
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
32
​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
35
​Logistics & Supply Chain Performance Dashboard 🚀
​Designed and developed a comprehensive Power BI dashboard to track real-time operational metrics, sales performance, and supply chain efficiency.
​Key Highlights:
​Financial Overview: Monitored total sales ($56K) and profit margins ($9K) instantly.
​Operational Tracking: Analyzed order volumes, lead times, and regional shipping statuses (Delivered vs. Delayed).
​Category & Monthly Insights: Tracked product category performance and monthly sales trends to drive data-backed decisions.
​This interactive solution eliminates blind spots in supply chain management, helping businesses optimize operations and improve delivery timelines.
0
44