
Closed
Posted
Paid on delivery
I have several Excel workbooks that capture our end-to-end manufacturing process and I need them turned into a single, insightful Power BI dashboard. The data covers production volumes, quality control metrics and supply-chain information, and I want all three areas displayed clearly in one place. Beyond simply visualising the numbers, I’m looking for useful analytics: trend analysis to spot shifts over time, KPI cards for quick health checks and comparative views that let me stack one line, shift or plant against another. You can assume the usual production KPIs (throughput, OEE, defect-rate %, on-time delivery) but feel free to suggest additional measures if they add value. Key requirements • Connect Power Query to multiple Excel files (local or OneDrive) and clean, merge and normalise the tables. • Build DAX measures for all KPIs plus week-over-week and month-over-month comparisons. • Design an interactive report with slicers for plant, line, product family and date range; visuals must load quickly and look good on both a shop-floor screen and in the Power BI Service. • Provide the finished .pbix file and a short hand-off note describing the data model, refresh settings and any custom calculations. If you’ve built manufacturing dashboards before and are comfortable with Excel-sourced models, this should be a straightforward project. Let me know your estimated turnaround time and any clarifying questions you have so we can get started right away.
Project ID: 40447735
29 proposals
Remote project
Active 3 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
29 freelancers are bidding on average ₹54,328 INR for this job

Hi, Your need for a consolidated Power BI manufacturing dashboard from multiple Excel workbooks fits perfectly with my experience in production and quality analytics. I’ve built similar dashboards with KPIs like throughput, defects, and on-time delivery, plus trend and plant/line-level comparisons. I will: Connect and clean all Excel sources via Power Query. Build a solid data model and DAX measures for your key KPIs. Design an interactive, fast, and user-friendly dashboard with relevant slicers. Estimated timeline: 5–7 days after requirements are finalized, within your posted budget range depending on data complexity and number of KPIs. Two quick questions: How many Excel files/tables and are their structures consistent? Do you need scheduled refresh in Power BI Service or is manual refresh fine for now? Happy to discuss details and start right away. Regards Solutionzhere
₹100,000 INR in 7 days
5.9
5.9

I am an expert statistician, Research Writer, and data analyst with more than eight years of experience. I have full command of Excel analysis, SPSS, STATA, R LANGUAGE, AND PYTHON. I am an expert in creating time series prediction models, working with survey data, conducting marketing analysis, building estimators, and medical analysis. I am a perfect match for your project share other details of the work so I can start working on your project. Will complete task on time.
₹37,500 INR in 2 days
5.6
5.6

With my extensive background in data analysis and visualization, I am well-prepared to turn your complex Excel workbooks into a coherent and insightful Power BI dashboard. Being skilled with Power Query, I can easily connect to and cleanse multiple Excel files, merging and normalizing the tables for seamless analysis. This coupled with my proficiency in DAX measures guarantees the generation of comprehensive KPIs and trend analysis capabilities as you require. In addition to these key skills, my experience working within manufacturing environments has granted me a deep understanding of the industry's KPIs and essential performance metrics such as throughput, OEE, defect-rate %, on-time delivery among others. This knowledge can be utilized to provide relevant business insights for your unique operational needs. Lastly, I pride myself in prompt project delivery while still maintaining uncompromising quality- this ensures that we get started promptly with no delays. You can expect unlimited revisions till you're 100% satisfied with the final product. Let's have a chat to further elucidate your requirements; shall we get to work?
₹37,500 INR in 1 day
5.2
5.2

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
₹37,500 INR in 1 day
5.0
5.0

Hi, Your project is a strong match for my experience with Power BI, Excel-based reporting, KPI modelling, and interactive analytics dashboards. I can help consolidate your manufacturing Excel workbooks into a clean, scalable Power BI solution covering production, quality control, and supply-chain performance in a single dashboard environment. What I can deliver: • Power Query integration across multiple Excel sources (local or OneDrive) • Data cleaning, normalization, and optimized data modelling • DAX measures for KPIs including OEE, throughput, defect %, on-time delivery, WoW and MoM comparisons • Interactive dashboards with slicers for plant, line, product family, and date filtering • Trend analysis, comparative views, and executive KPI cards • Performance-optimized visuals suitable for both Power BI Service and shop-floor displays • Final .pbix file with concise handoff/documentation notes I also have experience structuring dashboards for operational decision-making, so I can suggest additional KPIs and usability improvements where valuable. A few quick questions before starting: 1. Approximately how many Excel workbooks/tables are involved? 2. Are the source file structures standardized or different across plants/lines? 3. Will the dashboard require automated refresh through Power BI Service? I can begin immediately after reviewing sample files. Best regards, Deepanshu
₹50,000 INR in 7 days
3.7
3.7

Hi, Thank you for sharing the project details. I can help build an interactive Microsoft Power BI dashboard by connecting and transforming your Excel-based manufacturing data into clear production, quality, and supply-chain insights. The solution will include: • KPI dashboards for throughput, OEE, defect rate, and delivery performance • Trend and comparative analysis (week-over-week/month-over-month) • Interactive slicers for plant, line, product family, and date range • Fast-loading and presentation-ready visuals • Clean Power Query transformations and DAX measures Deliverables will include the .pbix file along with refresh and data model documentation. Estimated timeline: 5–7 business days. Looking forward to discussing this further. Best regards, Nidhi
₹56,250 INR in 7 days
3.5
3.5

As a detail-oriented and proactive data analyst, I believe I would be the ideal fit for your Manufacturing Power BI Dashboard project. My accounting background and commitment to providing clear, compliant, and tailored financial management align perfectly with your needs for visualizing and analyzing production volumes, quality control metrics, and supply-chain information. Moreover, my expertise in Excel and Power BI complements your requirement to connect Power Query to multiple Excel files, clean and merge data tables, as well as build comprehensive DAX measures for KPIs. Having dealt with large datasets throughout my career, I understand the significance of visualization in driving insights. My inclination towards detail is reflected in the provision of essential hand-off notes that will facilitate future navigation of the dashboard too. In summary, my well-rounded skillset amalgamates technical proficiency with a thorough analytical approach—a combination crucial for a project like yours demanding both number-crunching capabilities and strategic vision. As you strive for clarity and strategy from your data dashboard, allow me to augment your journey by turning your raw numbers into holistic insights that can nourish growth. Let's get started without delay—I assure you steadfastness, dependability and above all - peace of mind knowing your manufacturing analytics are an experienced Accountant's safekeeping!
₹56,250 INR in 3 days
3.4
3.4

A Warm Hello! Your requirement is a great fit for my experience with Excel-driven Power BI reporting and manufacturing analytics. I can help you transform the multiple workbooks into a clean, centralized Power BI dashboard covering production, quality control, and supply-chain performance with fast, interactive visuals. Key deliverables: Power Query setup to clean, merge, and normalize multiple Excel/OneDrive sources. DAX measures for KPIs like OEE, throughput, defect %, on-time delivery, plus WoW/MoM trend comparisons. Interactive dashboard with slicers for plant, line, product family, and date range. Comparative analytics between shifts, plants, and production lines. Optimized .pbix file with refresh configuration and hand-off documentation. I can also suggest additional insights such as downtime analysis, scrap trends, supplier performance, and production forecasting if useful for operations planning. Estimated turnaround: 16 to 18 days depending on workbook structure and data quality. A couple of quick questions: Approximately how many Excel files/tables are involved? Will the dashboard require scheduled cloud refresh in Power BI Service? Let's set up a quick call to discuss things better. Let's discuss it more in chat. Best Regards, Jemin Sagar
₹70,000 INR in 18 days
3.5
3.5

Hi, I went through your requirement and I can definitely help with this. I have experience building Power BI dashboards from Excel-based manufacturing and operational data, including KPI tracking, trend analysis, Power Query transformations, and DAX-based reporting. • Connect and merge multiple Excel workbooks using Power Query • Clean, normalize, and structure production, quality, and supply-chain data • Build DAX measures for KPIs like throughput, OEE, defect %, and on-time delivery • Week-over-week and month-over-month comparison analysis • Interactive dashboard with slicers for plant, line, product family, and date range • Optimized visuals for both Power BI Service and shop-floor display screens • Deliver complete .pbix file with documentation and refresh setup notes • 6+ years of experience with Power BI, Excel automation, and Microsoft reporting solutions I focus on building dashboards that are clean, fast, and genuinely useful for decision-making, not just visual reports. I can also suggest additional manufacturing KPIs if they add value to your process visibility. Please check my profile and previous work for reference. I’m available to start immediately and can provide regular progress updates throughout the project. Looking forward to working with you.
₹37,500 INR in 5 days
2.8
2.8

From Pune Mechanical Engineer + Data Scientist Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
₹40,000 INR in 7 days
2.7
2.7

Hello, Yes, I’m confident I can build this manufacturing Power BI dashboard professionally and deliver a clean, interactive reporting solution from your Excel workbooks. I have experience working with Excel-sourced Power BI models, including Power Query transformations, data cleaning, table normalization, DAX calculations, KPI tracking, and dashboard design for business reporting. I can create a unified data model covering production, quality control, and supply-chain metrics with interactive slicers for plant, line, product family, and date filtering. I’m also comfortable building KPI measures such as throughput, OEE, defect rate, on-time delivery, and trend comparisons including week-over-week and month-over-month analysis. My focus is always on building fast, user-friendly dashboards with clear visuals, organized layouts, and easy drill-down capabilities so both technical and non-technical stakeholders can understand the insights quickly. I will also provide the completed .pbix file along with a short hand-off note explaining the refresh process, data model structure, and custom calculations used in the report. I’m available to start immediately and would be happy to review the source files and discuss any project-specific requirements before beginning. Looking forward to working with you.
₹55,000 INR in 5 days
2.0
2.0

Your dashboard, not a template. I'll connect all your Excel workbooks through Power Query, clean and merge the tables into a single star-schema model, then build the DAX measures you need: OEE, throughput, defect rate, on-time delivery, plus WoW/MoM comparisons baked in. The report will have three focused pages — Production, Quality, Supply Chain — with slicers for plant, line, product family and date range. Fast load times, clean layout that works on a shop-floor screen and in Power BI Service. To show you how I work: share one of your Excel files and I'll send back the cleaned Power Query model and a sample KPI card within 24 hours — no cost, no commitment. Delivery: 5–7 business days after receiving all files. Includes the .pbix and a hand-off note covering the data model, refresh settings and every custom measure. One question to get started: are the files stored locally or on OneDrive/SharePoint? That determines the refresh setup.
₹52,000 INR in 7 days
1.6
1.6

Hi there, I’m a senior Production engineer and have extensive experience in production management and Certified Lean Six Sigma Green Belt. You can see my portfolio. I’m ready to help you make: ✨ Automated data cleaning, merging, normalization, and refresh setup (local or OneDrive sources). ✨ Advanced DAX measures for KPIs including Throughput, OEE, Defect Rate, Scrap %, Downtime, On-Time Delivery, and production efficiency trends. ✨ Week-over-week and month-over-month analytics with comparative views across plants, lines, shifts, and product families. ✨ Interactive dashboards optimized for both shop-floor displays and Power BI Service performance. ✨ Professional visuals with KPI cards, trend analysis, drill-down capability, and dynamic slicers. ✨ Final organized .pbix file with hand-off documentation covering the data model, refresh configuration, and custom calculations. I’m excited to work with you on your project and deliver the best results possible. I’m waiting for your message.
₹38,000 INR in 4 days
0.0
0.0

I specialize in building manufacturing-focused Power BI dashboards that turn complex Excel-based production, quality and supply-chain data into clear, actionable insights. My process includes using Power Query to clean, merge and normalize multiple Excel/OneDrive sources, then creating optimized DAX measures for KPIs like throughput, OEE, defect rate, on-time delivery and WoW/MoM trend analysis. The dashboard will feature KPI cards, comparative plant/line analysis, drill-down visuals and interactive slicers, all designed for fast performance in both Power BI Service and shop-floor displays. You’ll receive a fully documented .pbix file along with refresh settings and hand-off notes for easy maintenance. After reviewing the workbook structure, I can provide a fast turnaround and would just need clarity on source count, data volume, refresh frequency and whether OEE metrics already exist or need to be calculated from raw data.
₹56,250 INR in 7 days
0.0
0.0

I can build a complete end‑to‑end Power BI solution that consolidates your manufacturing, quality, and supply‑chain data into a single, clear, and insightful dashboard. I work extensively with multi‑Excel data models, Power Query transformations, and DAX measures for operational KPIs, including throughput, OEE, defect‑rate %, on‑time delivery, and trend analysis. I will connect Power Query to all your Excel files (local or OneDrive), clean and normalize the tables, and build a structured data model optimized for fast loading. From there, I’ll create DAX measures for all KPIs, including week‑over‑week and month‑over‑month comparisons, as well as any additional metrics that add value. I will also design the model to accommodate future data updates and evolving business requirements. The final report will include interactive slicers (plant, line, product family, date range), responsive visuals suitable for both shop‑floor screens and Power BI Service, and a clean layout focused on decision‑making. I will also provide the .pbix file and a short hand‑off note explaining the model, refresh settings, and custom calculations, so you can start using it immediately with minimal setup. Let me know your expected timeline, and I can start right away to ensure a smooth, prompt delivery that aligns with your schedule.
₹56,250 INR in 7 days
0.0
0.0

Hi, I’ve worked with Power BI reports and can add a clean Balance Sheet Overview page directly inside your existing PBIX. I understand you want this built natively in Power BI, using DAX measures so assets, liabilities, equity, and related totals remain dynamic with slicers and filters applied. My approach will be: review the current model and locate the balance-sheet category fields, create or refine the required DAX measures, add a readable overview page that works well in Desktop and Power BI Service, and make sure existing slicers/drill-through continue to work correctly. I’ll also include a short hand-off note documenting any new measures or logic added. I focus on keeping the model stable, so I will avoid unnecessary transformations and check that there are no broken relationships or performance regressions before returning the PBIX. I can start as soon as you share the file and can deliver quickly. A couple of quick questions before we begin: do you already have a chart-of-accounts or mapping for BS categories, and is there an unused report page you’d like me to repurpose?
₹56,250 INR in 7 days
0.0
0.0

I can help turn your manufacturing Excel workbooks into a single interactive Power BI dashboard with clear visibility across production, quality, and supply-chain performance. I have strong experience building Power BI dashboards from Excel data, including Power Query data cleaning/merging, DAX KPI development, trend analysis, and executive-ready dashboard design. I’ve delivered similar reporting solutions for operations and manufacturing, including KPIs like throughput, OEE, defect rate, on-time delivery, and plant-level comparisons. I can build a fast, user-friendly dashboard with slicers for plant, line, product family, and date, plus provide the .pbix file and handoff documentation for refresh and maintenance. Quick question: Are your Excel files already standardized across plants, or will some data normalization be needed first? I can start immediately and deliver quickly.
₹56,250 INR in 7 days
0.0
0.0

Hi, Hope you are doing well. I have gone through the requirement. I will be able to help you with your project. I have 10+ years of experience in Power BI development. Let me know good time to connect. Thanks!
₹50,000 INR in 7 days
0.0
0.0

Good afternoon, I read your project requirements and can absolutely build a high-performance, single-screen Power BI dashboard to unify your production, quality, and supply chain data. I have extensive experience modeling Excel data into optimized star schemas that refresh quickly and scale smoothly. I will configure Power Query to connect to your local or OneDrive files, establishing automated cleaning steps to handle merging and table normalization so the model never breaks during updates. I will build out core measures for Throughput, OEE, Defect Rate %, and On-Time Delivery (OTD), alongside explicit time-intelligence measures for Week-over-Week (WoW) and Month-over-Month (MoM) performance shifts. I will design a high-contrast, clean layout tailored to look crisp on a large shop-floor monitor while remaining highly functional in the Power BI Service. I will use clear plant, line, shift, and product family slicers to let you easily stack performance metrics side by side. You will receive the complete .pbix file alongside a concise technical hand-off document mapping the data model structure, refresh protocols, and key DAX formulas. Best Regards
₹37,500 INR in 4 days
0.0
0.0

Mahalunge, India
Member since Sep 17, 2021
€30-250 EUR
₹750-1250 INR / hour
₹1500-12500 INR
₹100-400 INR / hour
min ₹600 INR
$30-250 USD
₹12500-37500 INR
$30-250 USD
₹750-1250 INR / hour
$14-30 NZD
₹12500-37500 INR
₹12500-37500 INR
$10-11 USD
$30-250 USD
₹75000-150000 INR
$10-30 USD
₹1250-2500 INR / hour
₹600-1500 INR
₹1500-12500 INR
$2-8 CAD / hour