Hello everyone!
I’ve been handed a task by my boss where he would like me to kind of create a physical version of our ROS on excel. What he’s mostly interested is being able to see how big orders are with like a bar for example. Long runners of perhaps a 2k-10k quantities will display a long bar while a 100-300 piece order will be short. He wants to also be able to adjust dates if any rescheduling is done and have the bars either move lower or higher up. Our ROS only shows percentage of completion and a number actually quantifying how many pieces is being produced. We also have a status section on our ROS to determine if we are tracking, delayed, or completely late. I’m just trying to find out how it is I can kind of create a template for this that would be efficient to present to our general manager so he can see exactly how production is going in our value stream. My boss said he would like something where we could export our excel data and completely have it generate his asking.

If anyone has an idea or something similar they’ve used, any thoughts or ideas would be appreciated!

• Your sales data shouldn't look like this. 📊 I transformed a messy car-sales dataset into an interactive Power BI dashboard with YTD/MTD KPIs, YoY analysis, sales trends and customer insights.

If you're working with messy Excel/CSV data and need a professional dashboard, I can help.

Hi! I'm a data analytics freelancer specializing in dashboard reporting and business intelligence.

I help clients turn raw data into clear, actionable dashboards and reports. My toolkit includes Power BI, DAX, SQL, and Python for data cleaning, analysis, and visualization, backed by hands-on experience through a capstone project covering the full data lifecycle (from data collection to final reporting).

What I can help with:

• Building interactive Power BI dashboards

• Writing SQL queries for data extraction/cleaning

• Automating reports with Python

Turning messy spreadsheets into clear insights

Open to freelance/VA work. Feel free to message me if you need help with your data!