Power BI Developer Needed for QC Sample Tracking Dashboard

Oleg M.

Hello! I am the project manager of Business Atlas. We have deep expertise in transferring business logic from Excel to Power BI, maintaining all relationships and statuses.
Our approach to your project:
1. The first step is to thoroughly analyze your Excel file and technical specifications.
2. The architecture of the data model in Power BI. This will ensure the fast operation of filters by suppliers, laboratories, and dates without errors in calculations.
3. We will set up the logic for tracking overdue items and readiness for release based on your existing statuses.
4. Visualization and KPIs
5. We will configure automatic data pulling from your source so that the report is always up-to-date without manual intervention.
Estimated indicators:
• Cost: $1,000 – $1,800 (fixed price for full implementation according to the technical specifications).
… • Deadline: 12–16 working days.
• Guarantee: 14 days of technical support
Recommendation: At the development stage, we also advise considering the possibility of automatic notifications in Telegram/Email, which we can implement through n8n.
What do you think about this systematic approach? Write to me privately — we will discuss the details and start working on your quality control dashboard.

Show original

Translate

Viacheslav S.

Good day, Oleksiy.
I understand the process is continuous?
Therefore, it is necessary to understand how you fill in the Excel?

Is there a new Excel for each new project?

Show original

Translate

Kyryl Shcherbyna

Hi!

I read your requirements carefully. You made a crucial point: this isn't just about UI design. You need a developer who can translate a complex, interconnected Excel workflow (Feedstock -> Lab -> Finished Goods -> Release) into a robust Power BI relational data model without losing the business logic.

I specialize in migrating operational Excel trackers into Power BI. I clearly understand how to map one-to-many relationships (e.g., one Sample ID linked to multiple lab requests or approval stages) and track status bottlenecks.

Here are the answers to your points:

1. My approach to building from an existing Excel workflow:
…
- Data Modeling (The Core): I won't just import flat Excel tabs. I will use Power Query to clean and transform your data into a proper Star Schema (Fact tables for sample movements/status changes, and Dimension tables for Suppliers, Products, Labs, Dates). This is the only way filters and drill-downs will work correctly across the whole dashboard.
- Logic Translation (DAX): I will convert your Excel logic (IF/VLOOKUPs) into dynamic DAX measures to accurately calculate bottlenecks, "dispatch readiness," and overdue days.
- UI/UX: I build clean, corporate-style interfaces. We will split it into 3 pages: Executive KPI Dashboard, Operational Flow (Lab progress/Overdue), and a Detailed Matrix for deep drill-downs.
2. Estimated Timeline & Cost: Because I use an optimized approach to data modeling and DAX generation, I can deliver this much faster than standard timelines:

- Timeline: 3 to 5 days (usually this takes 2-3 weeks, but I work extremely fast).
- Cost: 250 − 400 (we can fix the exact price once I take a quick look at the Excel file).
3. Comments & Recommendations: Since you are tracking overdue items and approvals , I highly recommend setting up Data-Driven Alerts (via Power BI Service or Power Automate). This way, the QA manager or lab tech will receive an automatic Email or Teams message the moment a sample becomes overdue, eliminating the need to constantly check the dashboard manually.

4. Examples of similar work: I have built multiple supply chain, manufacturing, and QA tracking dashboards that track items through various status gates (from raw material receipt to final QA release). I would be happy to jump on a quick 10-minute call to share my screen, show you my previous data models, and discuss your specific Excel structure.

Let me know when you are available for a quick chat!