
Closed
Posted
Paid on delivery
We are into creating a single truth for Materials Data for a Steel Manufacturer. Looking for a Data Analyst who can profile the Materials Data for Master Data Management Data to de-duplicate and identify redundant material codes. Data Analyst will be able to profile the Materials Data, i.e., create a data version which is consumable by MDM tools. Pivot Data, Slice and Dice, Visualization, Story Telling, Report Generation, combine data from different sources and generate insights. Excel, Power BI, Tableau skills are essential.
Project ID: 40541611
23 proposals
Remote project
Active 1 min ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average ₹24,070 INR for this job

Hi there, We understand the goal is to create a single truth for steel materials master data by profiling the dataset, identifying redundant material codes, and preparing an MDM-consumable version. We will structure the work around data profiling, duplicate detection logic, and a clean Excel workbook with pivot views plus a Power BI or Tableau summary for slice-and-dice analysis and reporting. Our initial assumption is that source extracts and the current material code rules are available for review. One point to confirm is whether the output should follow an existing MDM template or a new reconciliation format. Best Regards, 8veer
₹30,750 INR in 10 days
6.5
6.5

I am an Excel & VBA Automation Expert with an MBA and 10+ years of experience delivering smart solutions to global clients (eg. Decathlon, E&Y, Schindler). I’ve successfully completed 100+ projects (4.9★ rating), helping businesses save time, reduce errors, and boost efficiency. I can create excel based automated tool with clear visualization of the master data. You can update the data by simply uploading the master data file into this tool. it will clean and process the data for multiple validation checks and update the data in dashboard. Please have a look at my project portfolio to have a better understanding of my experience. Lets chat and discuss the details further. FREE Consultation before Project Starts I can deliver a fast, accurate, and customized solution for your requirements. Let’s discuss your project—I can start right away. Looking forward to working with you!
₹12,500 INR in 4 days
5.9
5.9

hi i have a lot of experience in power bi,vba etc with advance level of data analysis.i can help you in all such projects with attractive dashboard creation and visualization.
₹25,000 INR in 7 days
5.0
5.0

Hi, I'll start by profiling your materials dataset across key attributes — material codes, descriptions, units of measure, material groups, and source system identifiers — to surface duplicates, near-duplicates, and redundant codes that exist under different naming conventions but represent the same physical material. Steel environments typically carry accumulated cruft across plate grades, coil specifications, and alloy codes from multiple procurement cycles; I'll structure the deduplication logic to account for that domain-specific messiness rather than applying a generic matching approach. The profiled output will be structured into a clean, MDM-consumable format — standardised attribute columns, a golden record recommendation per duplicate cluster, and a clear disposition flag for each code (keep, merge, retire) that your MDM tool can ingest directly. From there I'll build a Power BI or Tableau dashboard covering materials data quality metrics — duplicate rates by material group, source system coverage gaps, and attribute completeness scores — with pivot-ready views, drill-down by plant or category, and a narrative summary your data governance team can use to prioritise remediation.
₹25,000 INR in 7 days
4.7
4.7

As a seasoned data analyst with extensive experience in data visualization, I am confident that I have the skills and background necessary to meet and exceed your expectations on this project. Not only am I well-versed in Excel, Power BI and Tableau (essential tools for the job), but my proficiency in deploying AI and ML models will enable me to not just create data versions consumable by MDM tools, but also leverage them to effectively pivot, slice & dice data and generate actionable insights for your material de-duplication needs. At first glance, your project aligns perfectly with my areas of expertise. From working with multinational steel manufacturers streamlining their manufacturing processes using AI systems, right through to fighting redundancy issues on relational databases; these are problems I consistently tackle head-on day in and day out. Finally, what sets me apart is my ability to bridge the gap between sophisticated technology solutions and conventional business challenges. I'm not just skilled at generating reports, I can effectively turn the sometimes overwhelming complexity of datasets into straightforward narratives-understandable by both technical and non-technical stakeholders. So if you're looking for an experienced data analyst who offers more than just technical skills, but the capacity to deliver real value through synthetic storytelling processes - then look no further!
₹25,000 INR in 7 days
4.2
4.2

Hi, Materials master data deduplication for a steel manufacturer, this is squarely in my wheelhouse. I specialize in data profiling, MDM preparation, and building deduplication logic for complex industrial datasets. On the reporting side, I deliver in Excel, Power BI, and Tableau, whatever fits your team's workflow. A few things I'd handle out of the gate: - Profile your materials data and flag redundant/duplicate codes - Restructure the data into an MDM-ready format - Build visualizations and a report that makes the findings easy to act on - Integrate data across sources into a single clean view One quick question: what's the approximate volume of material records, and which ERP are you pulling from (SAP, Oracle, etc.)? Happy to discuss scope and pricing as soon as you're free.
₹13,000 INR in 7 days
3.6
3.6

Greetings, With a robust background in statistics and data science, complemented by a prolific academic writing portfolio, I am well-equipped to tackle complex data-driven challenges. My expertise is rooted in the successful completion of numerous PhD-level thesis projects, where I employed advanced statistical methodologies to extract meaningful insights from diverse datasets. My professional journey has been marked by collaborations with various companies, leading to projects that demanded high-level quantitative analysis and data interpretation. These projects enabled me to delve into trend analysis, temporal behaviour studies, and comparative assessments of data variables. I possess proficiency in a suite of analytical tools, including SPSS, R, Python, OpenCV, WEKA, Tableau, Power BI, and Excel. My skill set extends to sophisticated techniques such as image processing, machine learning, deep learning, artificial intelligence, natural language processing, hypothesis testing, forecasting, T-tests, and ANOVA, among others. I am eager to engage in discussions that leverage my comprehensive skill set to provide innovative solutions in AI and ML domains. Warm regards, Radhika
₹35,000 INR in 7 days
3.4
3.4

Hello! I can help you profile and standardize your materials data, identify duplicate and redundant material codes, and prepare a clean, MDM-ready dataset. I have strong experience in Excel, Power BI, and Tableau for data profiling, pivoting, and building insightful dashboards with clear storytelling. I will combine data from multiple sources, create structured reports, and deliver actionable insights for better master data governance. I ensure accuracy, consistency, and a reliable single source of truth for your materials data.
₹12,560 INR in 7 days
2.7
2.7

Mechanical Engineer + Data Scientist @SahyadriTech #SahyadriTech 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.
₹18,000 INR in 7 days
2.8
2.8

As a Microsoft Power Platform specialist with a sharp eye for data processing and visualization, I believe that my skills align perfectly with your project needs. Throughout my 4+ years of experience, I’ve been orchestrating data in meaningful ways for optimized business decisions, whether it’s through automating tasks via Power Apps and Power Automate or visualizing patterns with Power BI and Tableau. I understand that consolidating complicated materials data is not a simple task and requires a deep understanding of data profiling to help the MDM tools do the heavy lifting. My proficiency in Excel ensures efficient data pivoting, slicing, and dicing while giving you an all-inclusive view of the information at hand. What sets me apart as a freelancer is my ability to leverage advanced capabilities like Microsoft Copilot and AI Builder - skills that lend themselves perfectly to de-duplicating your material codes. With an AI model in place, keying tedious repetitive work can be delegated to automated processes in a secure manner ensuring their accountability through audit logs - an approach I have successfully used in similar projects before.
₹25,000 INR in 7 days
1.5
1.5

- I have hands-on experience analyzing, cleaning, and transforming large business datasets into structured, analysis-ready data for reporting and decision-making. - My expertise includes data profiling, de-duplication, data quality assessment, Power Query, Excel, SQL, Power BI, Tableau, and data modeling. - I can profile material master data, identify duplicate and redundant material codes, standardize attributes, and prepare clean datasets suitable for Master Data Management initiatives. - I have experience combining data from multiple sources, performing slice-and-dice analysis, creating PivotTables, and generating meaningful reports and visualizations for business stakeholders. - In a recent project, I developed a PHP API, integrated database data into Power BI, and created automated real-time dashboards for business performance monitoring. - My approach focuses on improving data quality through validation, profiling, duplicate detection, and business rule analysis while maintaining complete traceability. - Deliverables will include a clean MDM-ready dataset, profiling reports, dashboards, insights, and documentation explaining the cleansing and transformation process. - I focus on building scalable, reusable data preparation workflows that support long-term analytics and governance initiatives. Reference work is available in my profile.
₹14,000 INR in 4 days
1.0
1.0

As an AI and Cloud Data Engineering Specialist, I'm uniquely qualified to tackle your enterprise's material data management needs. My comprehensive experience in the field coupled with my proficiency in key tools such as Excel, Power BI, and Tableau truly sets me apart from other freelancers. My core services like AI/ML Development, Cloud Data Engineering/Architecture, Real-Time Analytics and Business Intelligence, Advanced Analytics & Decision Support are all aligned with the requirements mentioned in your project description. Prioritizing tangible results above all else, my work emphasizes on delivering measurable business outcomes. In conclusion, my strategic vision for transforming data into valuable insights combined with my technical skills and experience make me the perfect choice to bring your Steel Manufacturing project to life. With this partnership, I can help you achieve a single truth for Materials Data and master your Master Data Management system to drive operational efficiency while reducing costs.
₹24,000 INR in 10 days
0.0
0.0

Hi there, I hope you're doing well. Your project to create a single source of truth for materials data is highly impactful, and I'd be happy to help profile, cleanse, de-duplicate, and analyze your data using Excel, Power BI, and Tableau to deliver meaningful insights and MDM-ready datasets. Let's have a quick chat to discuss more in detail. Which ERP or source systems will the materials data be extracted from? I am looking forward to hearing from you. Best, Sajid.
₹25,000 INR in 7 days
0.0
0.0

We recently wrapped up a project very similar to this, where we've helped someone achieve a goal like the one you are looking to achieve recently. We've built a data management system for manufacturing industries, ensuring seamless data integration and analysis. Understanding the need for clean, professional data management in manufacturing, we specialize in data profiling, visualization, and generating actionable insights to optimize processes efficiently. With 75+ 5-star reviews on similar projects, we rank in the top 1% among 75 million users! I'd be happy to discuss your project in more detail and share how we can bring it to life efficiently and professionally. Best case, we work together. Worst case, you get free advice that helps you move forward. Regards, Martinus.
₹24,400 INR in 7 days
0.0
0.0

I'm not going to tell you I am the best person for the job, I'll show you why. Your need for a Data Analyst to clean, profile, and integrate Materials Data aligns perfectly with my expertise in creating professional, user-friendly, and seamless data solutions. While I am new to Freelancer, I have tons of experience and have successfully completed various off-site projects. Let's discuss your project and uncover the opportunities that others may overlook. Regards, Warrick Van Eeden
₹16,900 INR in 7 days
0.0
0.0

Hello, I would be excited to help build a reliable "single source of truth" for your materials master data. With 4+ years of experience in Excel, Power BI, Tableau, and data analysis, I can clean, profile, and transform your material records into a structured dataset ready for Master Data Management (MDM). My approach includes: * Data profiling to identify duplicates, inconsistencies, and redundant material codes * Data cleansing and standardization for improved quality * Combining data from multiple sources into a unified dataset * Creating Pivot Tables, slicers, and detailed analytical reports * Developing interactive Power BI/Tableau dashboards with KPIs and visual insights * Delivering clear documentation so the solution is easy to maintain Deliverables: * Cleaned and standardized materials dataset * Duplicate and redundancy analysis report * Interactive dashboards and visualizations * Pivot reports and management summaries * Documentation explaining the workflow and reporting process I focus on accuracy, clear communication, and delivering practical insights that support better business decisions. I am available to start immediately and would be happy to review a sample dataset before beginning. Looking forward to working with you. Best regards, Shree
₹12,500 INR in 2 days
0.0
0.0

Hello, Your project aligns perfectly with my expertise in Power BI, SQL, Excel, and Data Analysis. Along with my analytics background, I have practical experience working in an engineering procurement and materials management environment using SAP ERP, where I gained exposure to material-related data and procurement processes. This domain knowledge enables me to better understand material master data, identify duplicate and redundant material codes, and improve data quality. I can profile your materials data, prepare a clean and standardized dataset suitable for Master Data Management (MDM) tools, and generate meaningful insights through pivot analysis, slice-and-dice reporting, interactive dashboards, and professional reports. By combining data from multiple sources, I will deliver a reliable, business-ready solution that supports informed decision-making. With my Power BI expertise and understanding of manufacturing data, I can develop intuitive dashboards that clearly communicate trends and insights while ensuring accuracy, usability, and performance. I am available to start immediately and would be happy to discuss your requirements in an interview. I look forward to the opportunity to contribute to your project. Best regards, Gowri K
₹18,000 INR in 6 days
0.0
0.0

With 18+ years of experience in Data Analysis, Power BI, Excel, Tableau, and Master Data Management (MDM), I can help profile your materials master data, identify duplicates and redundant material codes, and prepare high-quality data for MDM implementation. My expertise includes: Data profiling, cleansing, and deduplication Material master analysis and standardization Advanced Excel (Power Query, Pivot Tables), Power BI, and Tableau Data visualization, dashboards, and executive reporting Combining data from multiple sources to generate actionable business insights I can deliver accurate, well-documented analysis that supports a reliable "single source of truth" for your materials master data. I look forward to discussing your project.
₹75,000 INR in 7 days
0.0
0.0

Hi, I have 13+ years of experience in data analytics, BI, and data engineering, with strong expertise in Excel, Power BI, Tableau, SQL, and data profiling. I’ve worked on data quality, cleansing, deduplication, and creating trusted datasets from multiple source systems. This project aligns well with my experience. I can help profile your materials master data, identify duplicate and redundant material codes, prepare a clean dataset, and build reports that provide clear insights into data quality and consistency. I’m detail-oriented, communicate regularly, and always focus on delivering practical results. I’d be happy to discuss your current data sources and how I can help build a reliable single source of truth for your materials data. Looking forward to working with you.
₹35,000 INR in 14 days
0.0
0.0

Hi, Your Materials Master Data initiative is a strong match for my background in SAP MM, procurement data, Excel reporting, Power BI dashboards, and inventory analysis. I understand that duplicate or inconsistent material codes affect purchasing accuracy, inventory visibility, MRP planning, reporting, and overall data governance. I can help create a clean, analysis-ready material-data version that supports your MDM “single source of truth” objective. My approach will include: • Profiling material master data across codes, descriptions, categories, units, specifications, and related attributes • Identifying exact duplicates, near-duplicates, redundant codes, missing values, and inconsistent formats • Combining data from multiple sources into a structured, standardised dataset • Creating pivot reports, slicers, Power BI/Tableau dashboards, and visual data-quality summaries • Providing clear insights on duplicate trends, data gaps, cleanup priorities, and recommended actions • Documenting matching logic and assumptions for transparent MDM handover I bring 3+ years of experience in procurement operations, SAP MM-related data, supplier records, inventory reporting, Excel analysis, and management dashboards with my Master's degree Global Supply Chain Management and B.E in Mechanical Engineering. Although I am new to this platform, I am detail-oriented, proactive, and committed to delivering a well-documented output that your MDM team can use confidently.
₹12,500 INR in 5 days
0.0
0.0

Bengaluru, India
Member since Jun 26, 2026
$60-80 NZD
€12-18 EUR / hour
₹100-400 INR / hour
₹2000-10000 INR
₹600-1500 INR
₹12500-37500 INR
$15-25 USD / hour
₹750-1250 INR / hour
₹75000-150000 INR
$10-30 AUD
min ₹2500 INR / hour
$30-250 USD
$8-15 USD / hour
$1500-3000 USD
$30-250 USD
₹12500-37500 INR
$10-500 USD
₹750-1250 INR / hour
₹12500-37500 INR
₹12500-37500 INR