Ultimate access to all questions.
You are required to integrate prescriptive analytics into a report for an e-commerce company aiming to optimize their inventory management. The dataset includes 'ProductID', 'StockLevel', 'SalesVolume', and 'LeadTime'. Describe how you would use optimization models in Microsoft Fabric to suggest the optimal stock levels for each product, considering factors like sales volume and lead time. Include the type of optimization model you would use and the data preprocessing steps necessary.