Purchase Data Analysis BI Model
About Twin Engineers Pvt Ltd.
Twin Engineers Pvt. Ltd. is a company that offers services to manufacture machines for fluid filling, meter mix dosing and robotic dispensing. It essentially offers business to business (B2B) product catalogue for process automation. Twin engineers are mostly engaged in and specializes in automation solutions by assembling various specific utility machines for its customers. They have a catalogue of machines they can assemble but are not limited by it. Thay have capability to manufacture machine as per customer specifications and purpose at hand. The various products are assembled based on user requirement, specification, and client’s business process requirement.
Twin Engineers Pvt Ltd is a also known for its dynamic business model, specializing in the design and manufacture of customized machines tailored to specific customer requirements. Unlike businesses with standardized products and a fixed product catalog, Twin Engineers thrives on its ability to adapt and innovate, creating unique solutions for each client. This dynamic nature of operations presents several challenges and opportunities that Power BI can address effectively
Dynamic Product Requirements
Given that Twin Engineers does not have a standardized product catalog, each project involves a unique set of specifications and components. This variability necessitates a robust system for managing and analyzing data related to the design, manufacturing, and assembly of customized machines.
Power BI can help by:
1. Real-time Data Analysis:
Power BI provides real-time data analysis, allowing the company to monitor material requirements, and inventory levels dynamically. This ensures that the procurement of materials and components is precisely aligned with the specific needs of each project, reducing waste and optimizing resource utilization.
2. Custom Reports and Dashboards:
The ability to create customized reports and interactive dashboards enables Twin Engineers to track key performance indicators (KPIs) specific to each project. This can include metrics on design iterations, manufacturing timelines, cost estimations, and customer feedback, all of which are crucial for managing bespoke projects effectively.
Key Features of the Power BI Model:
1. Item Wise Shortage Report
Purpose: To identify and manage items that are in short supply, ensuring that production and operations are not disrupted due to inventory shortages.
Benefits:
Helps in proactive inventory management. Prevents production delays by ensuring critical items are stocked. Provides a comprehensive view of the supply chain status for better planning and decision making.
2. PO Register
Purpose: To keep track of all purchase orders (POs) issued by the Purchase Department.
Benefits:
Simplifies tracking and management of purchase orders.
Provides visibility into the procurement pipeline.
Helps in identifying and addressing delays or issues with specific POs.
3. Purchase Analysis Report
Purpose: To analyze purchasing patterns and trends, helping the Purchase Department to optimize procurement strategies.
Benefits:
Enables data driven decision making for procurement.
Helps in identifying cost saving opportunities.
Improves vendor management by highlighting top performing and underperforming vendors.
4. Top 25 Vendor Report
Purpose: To provide insights into the top 25 vendors based on various performance metrics.
Benefits:
Focuses on key vendor relationships.
Identifies best practices and areas for improvement in vendor management.
Supports strategic sourcing decisions by highlighting the most reliable and cost effective vendors.
5 RM Inventory Stock
Detailed features of report
Opening RM Stock:
Displays the initial stock at the beginning of the period. Provides a baseline for calculating stock movements.
GRR Received Quantity:
Shows the total quantity of goods received during the period. Helps in understanding the inflow of inventory.
Total RM Stock:
Combines opening stock and GRR received quantity to give a comprehensive view of total available stock.
Issued Quantity:
Captures the quantity of stock issued during the period. Essential for calculating closing stock and understanding outflows.
Closing RM Stock: Calculated as (Total RM Stock – Issued Quantity). Provides the final stock level at the end of the period. Developing this report in Power BI is essential for optimizing inventory management through accurate, real-time data visualization and analysis.
Technical Details
Platform: Power BI
Data Source: SQL Server
These reports collectively enhance the Purchase Department’s ability to manage materials effectively, address supply chain issues promptly, and make informed procurement decisions. The integration of Power BI with SQL Server ensures real time data accuracy and reliability, further empowering users with actionable insights.