"I want to perform report rationalization for our enterprise reporting ecosystem. The environment includes SQL Server tables, stored procedures, SSIS packages, and SSRS reports stored in our code repository. Please analyze all this source code and metadata to:

• Extract metadata about data sources, transformations, and reports

• Build a data lineage and dependency graph showing how data flows from SQL tables through ETL to reports

• Identify reports that are similar or near-duplicate based on query logic, datasets, parameters, and output metrics

• Cluster reports by similarity and highlight redundancies

• Provide a summary report listing duplicate or overlapping reports with explanation of similarity criteria

• Visualize key dataset reuse and report dependency chains

You can treat this as a multi-step task with iterative refinement. Use retrieval-augmented generation techniques to incorporate contextual information from the entire codebase for accurate analysis. Output the findings in a structured format suitable for consumption by business and technical stakeholders."