Posts

Sales and Market Return Dashboard - Excel Project

Image
This dashboard serves as a comprehensive platform for the in-depth analysis of an organization's sales and product return data in the market. It is a valuable asset for manufacturing companies seeking a thorough understanding of their market return performance. The development of this dashboard is underpinned by advanced VBA and analysis tools, reflecting a meticulous attention to detail. The result is a highly customizable and feature-rich dashboard that stands out as an exceptional tool for in-depth market analysis . Download Project Files View project details video: Project Screenshots: Dashboard 1 Dashboard 2 Source File

Factory Delivery and Material Planning Report - Excel Project

Image
This project is designed as a comprehensive reporting system for an organization's delivery and material planning from raw source data file. This report has been meticulously crafted with the incorporation of powerful data analysis tools, such as Power Query, along with fundamental VBA techniques. It serves as an indispensable resource for organizations equipped with ERP software, enabling precise and efficient scheduling of product deliveries and material procurement. Download Project Files View project details video: Project Screenshots: Source File Selection Day Plan Short List Generator Month Plan PM Plan FG Stock Detail View Pipeline List Forecast PG List PM List Schedule List Power Query Window 1 Power Query Window 2 Source File 1 Source File 2 Source File 3 Source File 4 Source File 5 Source File 6 Source File 7 Source File 8

Attendance & OT Report - Excel Project

Image
This project makes organized and dynamic attendance report from unorganized data sources from HRIS software. This report has been meticulously crafted with the incorporation of powerful data analysis tools, such as Power Query, along with fundamental VBA techniques. It serves as an indispensable resource for organizations equipped with HRIS software, enabling precise and efficient control of employee attendance and management. Download Project Files View project details video: Project Screenshots: Main Report Mismatch Report Manual Input Manual Status Roster List Source Selection Power Query Window Source File 1 Source File 2