In your role, you need to implement diagnostic analytics to understand the reasons behind high defect rates in a manufacturing company. The dataset includes 'ProductID', 'ProductionDate', 'Quantity', 'MachineID', and 'DefectRate'. Describe how you would use SQL queries and data visualization tools in Microsoft Fabric to identify key factors contributing to defects. Include the types of analyses you would perform and the visualizations that would best represent these findings.