Skip to content

JENARIKIT/SQL_PROJECT_WHEAT_FLOUR

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

56 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

This report utilizes SQL to analyze data pertaining to wheat flour production in the year 2023, encompassing the following metrics

pic

🔧 Tools Used: SQLite , Power BI , Looker Studio

🔸 Quantity of raw materials consumed
🔸 Number of products manufactured
🔸 Operational time
🔸 Production process downtime
🔸 OEE values
🔸 Performance values
🔸 Quality values
🔸 Availability values

Quantity of raw materials consumed:

Explanation ▶️ This metric measures the total amount of raw materials used in the production of wheat flour. It includes all the primary and auxiliary materials required for production.

Importance ▶️ Monitoring this helps in understanding resource utilization and efficiency. It can also aid in cost management and inventory control.

Number of products manufactured:

Explanation ▶️ This represents the total count of finished wheat flour products produced during the year.

Importance ▶️ This metric provides insight into production volume and can help in assessing the capacity and productivity of the manufacturing process.

Operational time:

Explanation ▶️ This is the total time during which the production equipment and processes are actively producing wheat flour.

Importance ▶️ Tracking operational time helps in evaluating the efficiency of the production process and can highlight areas for improvement in operations.

Production process downtime:

Explanation ▶️ This measures the total duration when the production process is halted or non-operational, due to maintenance, breakdowns, or other interruptions.

Importance ▶️ Understanding downtime is crucial for identifying bottlenecks, improving maintenance schedules, and enhancing overall productivity.

OEE (Overall Equipment Effectiveness) values:

Explanation ▶️ OEE is a comprehensive metric that combines availability, performance, and quality to measure the overall effectiveness of production equipment.

Importance ▶️ High OEE values indicate efficient, high-quality production with minimal downtime, making it a key performance indicator for manufacturing efficiency.

Performance values:

Explanation ▶️ This refers to the speed at which the production process operates relative to its designed capacity.

Importance ▶️ Performance values help in understanding how well the production process is performing compared to its potential, highlighting areas for speed and efficiency improvements.

Quality values:

Explanation ▶️ This metric assesses the proportion of good quality products produced without defects.

Importance ▶️ Maintaining high quality values ensures that the products meet the required standards and reduces the cost associated with rework or waste.

Availability values:

Explanation ▶️ Availability measures the proportion of time the production equipment is available for use compared to the planned production time.

Importance ▶️ High availability values indicate that the equipment is reliable and has minimal downtime, which is essential for maintaining continuous production.