Understanding Insights and Recommendations

The executed assessment reports give detailed insights into the various components of assessment. The reports display recommendations or insights based on the input source. The following table briefs about the insights based on various source data.

Type of input workloads	Insights
EDW (DML scripts, stored procedures, scheduler scripts, Query execution logs)	Highlights: Recommendations about DML scripts that need to be migrated. File-level summary. Jobs summary. Procedure and statement type summary. Query analysis. Queries' complexity recommendations. Entities, Entity Type, and Table Type analysis. Optimization recommendations snapshot. Key resource utilization metrics highlighting the most resource-intensive application.
	Analysis: Files: Detailed analysis of source files. Jobs: Comprehensive report of jobs. Queries: Detailed query analysis. Entities: Detailed analysis of tables and views. Artifacts: Comprehensive artifact report. Application and Users: Resource Utilization Metrics for Applications and users.
	Optimization: Schema: Optimization metrics based on Partitioning, Bucketing, and Clustering strategy. Code: Optimization based on code. Orchestration: Identify parallel orchestration opportunities.
	Lineage: Identifies the complete dependency structure
	Recommendation: Summary: Summary of key resource utilization metric and recommendations for migrations to the target platform. Files: Recommend the most resource-intensive and expensive files for transformation. Jobs: Recommend the jobs for migration. Queries and Entities: Recommend the queries and entities for migration based on key resource utilization metrics. Applications: Based on the detailed analysis of the given workloads, provides recommendations for applications.
	Cost Estimation: Provides the cost estimation based on different transformation related activities.
ETL scripts	Highlights: Summary: Summary of various workflows and components. File Classification based on Complexity: Classification of ETL files based on detailed complexity assessment.
	Analysis: Source Analysis: Analysis of key data source utilization metrics. Entities: Detailed analysis of tables and views. Artifacts: Comprehensive artifact report.
	Lineage: Identifies the complete dependency structure
	Cost Estimation: Provides the cost estimation based on different transformation related activities.
Analytics scripts	Highlights: Summary: Summary of various procedural and statistical scripts with the amount of code analyzed successfully. Complexity: Classification of analytics files based on detailed complexity assessment.
	Analysis: Source Analysis: Macros, Proc SQLs, Data Steps, Procedural Constructs, etc. analysis of every SAS script.
	Lineage: Identifies the complete dependency structure.
	Cost Estimation: Provides the cost estimation based on different transformation related activities.
BI Report	Highlights: Highlights of the BI report and its inventory. Snapshot of valid and invalid dashboards along with physical databases. Snapshot of publisher model and reports. Summary of presentation, logical and physical tables along with their distribution across databases. Summary of columns, used and unused filters and agents with total report recipients. Snapshot of worksheets along with their complexity. Snapshot of different graphs and charts.
	Analysis: Files: Summary of physical, presentation, and logical tables along with variables and init blocks for every file. Dashboard: Comprehensive report of every dashboard. Reports: Detailed analysis of every report. Entities: Detailed analysis of presentation, logical, and physical tables along with missing tables. Publisher: Summary of groups and datasets for every publisher model and report. Agents: Detailed analysis of agents.
	Lineage: Identifies the complete dependency structure.