Data Analyst | Excel VBA Specialist | Freelancing

Shirin Meggendorfer

Shirin Meggendorfer

πŸš€ Optimization of data processing in Supply Chain Management by integrating multiple Excel sheets into an automated master sheet.
πŸš€ Analysis and identification of relevant data points from existing Excel sheets, including inventory management, supplier data, and sales forecasts.
πŸš€ Utilization of Power Query to merge and transform this data into a central master sheet.
πŸš€Automation: Development of a macro for automatic data updates to ensure all information is current and accurate.
πŸš€ Conducting tests to ensure data integrity and adjusting the solution based on test results.
Like this project

Posted Sep 7, 2024

πŸš€ Optimized Supply Chain Management by automating data integration from Excel sheets into a master sheet using Power Query and macros for real-time updates.