I built a full Inventory Command Center for a combat sports retailer — here's what's inside. W.U.E. (Weapons · Uniforms · Equipment) out of Grayson, GA needed a way to track 174 SKUs across three product categories in real time. So I built them one. Here's what the dashboard delivers: 📦 $832K in retail inventory tracked across Weapons, Uniforms & Equipment 💰 $500K gross margin with 60% overall margin visibility at a glance 🔄 Live stock status — IN STOCK, REORDER, and OUT OF STOCK flags per SKU 📊 Margin % by Category — instantly see which product lines are carrying the business 🎯 Brand-level breakdown — Century, Everlast, Fairtex, Drako, Adidas and more Built end-to-end in Power BI with a clean dimensional data model, DAX measures, and a dark navy UI designed for fast operational decisions.

🚀 Built an Automated Power BI Dashboard with Real-Time File Refresh Workflow

Recently, I worked on a complete Power BI automation project where I transformed messy raw CSV data into a fully interactive business dashboard.

This project included:

✅ Data Cleaning with Power Query ✅ Handling messy and mixed date formats ✅ Data transformation & automation ✅ KPI Dashboard Creation ✅ Sales & Revenue Analysis ✅ Dynamic Visualizations ✅ Folder-Based Automated Refresh System ✅ Bangladesh Regional Map Integration

The most exciting part of this project was the automation workflow.

Instead of manually rebuilding reports every time new data arrives, I configured Power BI to automatically detect updated files from a folder source. Once new CSV files are added, the dashboard can refresh and update business insights instantly.

During the project, I also solved several real-world data problems like:

inconsistent date formats

null values

mixed discount scales

data type issues

automation refresh errors

This project helped me strengthen my skills in: 📊 Power BI 📈 Data Visualization 🧹 Data Cleaning ⚡ Automation Workflow 📂 Power Query 🐍 Data Analytics

As a Data Analyst, I enjoy building dashboards that are not only visually appealing but also practical for real business decision-making.

If you need help with:

Power BI Dashboards

Data Cleaning

Automated Reporting

Business Insights

Excel & CSV Data Processing

feel free to connect with me or knock me anytime.

#PowerBI #DataAnalytics #BusinessIntelligence #Dashboard #DataVisualization #PowerQuery #Automation #DataCleaning #Analytics #DataAnalyst #DataScience #CSV #Excel #Reporting #BusinessAnalytics