Power BI Developer Needed for QC Sample Tracking Dashboard

Budget: 1000 USD Deadline: 14 days

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. Expand

Budget: 600 USD Deadline: 5 days

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?

Budget: 100 USD Deadline: 5 days

Hi Oleksi!

I'm a data analyst who can write a Python (Pandas) solution for you that will automatically clean your data and find typos. And then create a dashboard.

Here's an example of my work:
https://freelancehunt.com/showcase/work/parsing-vizualizatsiya-dannyih-dlya-kursov/2014208.html
https://freelancehunt.com/showcase/work/parsing-vizualizatsiya-dannyih-dlya-prodazhi/2014205.html

Price and deadline - negotiable

Budget: 25 USD Deadline: 1 day

Good day. I have experience in creating dashboards in Power BI. I can send examples of my work privately. Regarding the deadline and approach, we can discuss it when I see the file.

Budget: 950 USD Deadline: 7 days

Good evening
My name is Dmytro, from King Kong Lab. We have experience working with Power BI and building analytical systems based on Excel with complex business logic (statuses, dependencies, processes).
We can implement a full-fledged analytics system for you, not just a "visual":
we will build the correct data model based on your Excel (taking into account all connections and logic)
we will implement dashboards for statuses, progress, overdue tasks, and readiness
we will add convenient filters and drill-down for analysis (by supplier, product, laboratory, etc.)
we will create a management dashboard with KPIs
we will make the interface understandable for business users
We work through a deep understanding of the process so that the report does not just "show data," but actually helps in decision-making.
Approach:
first, analyze your Excel and the logic of the process
build the data model
create dashboards and verify with you
final optimization and handover
Timeline — approximately 5–10 days (depending on the complexity of the model)
We are ready to review the file and propose an optimal structure for the solution. Expand

Budget: 350 USD Deadline: 4 days

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! Expand

Budget: 600 USD Deadline: 7 days

I have over 5 years of experience in analytics (SQL, Power BI, Tableau), building dashboards and data models for business processes from scratch, including complex status logic and workflows. I can translate Excel logic into a proper data model and create understandable business dashboards with drill-downs and KPIs.

I have worked on similar tasks where the focus is not on visualization, but rather on the correct interpretation of the process.

I can quickly get involved, propose a model structure, and estimate timelines after reviewing the file. Feel free to reach out - we can discuss, and I will send examples of my work.