Machine Learning Enhanced Spreadsheet Data Cleansing Workflow

Create a Python data preprocessing pipeline that uses scikit-learn for anomaly detection and automatic data cleaning in large Excel datasets. Develop a workflow that can identify outliers, handle missing values through intelligent imputation, detect and correct data type inconsistencies, and generate a comprehensive data quality report. The solution should be configurable to different dataset structures and include visualization of data transformations.