Volumetric Info

This topic provides detailed information about the generated volumetric info sheet. The volumetric info sheet summarizes the aggregated inventory after analyzing the source files. For instance, if the source is EDW, it includes information about the total number of DML and DDL scripts, entities, queries, procedures, lines of code, and a lot more.

In This Topic:

EDW
ETL
Orchestration
BI
Analytics

EDW

The following table displays a brief summary on Volumetric Info and Complexity reports of various EDW sources such as Teradata, Oracle, etc.

Source	Folder Name	Report Name	Sheet Name	Column Name	Extensive Reports
Oracle	Source Inventory Analysis	Analysis Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Oracle	Source Inventory Analysis	Analysis Report.xlsx	Query Complexity Wise Query Count	Query Complexity	Other insightful reports
Teradata	Source Inventory Analysis	Analysis Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
	Source Inventory Analysis	Analysis Report.xlsx	Query Complexity Wise Query Count	Query Complexity
	Insights and Recommendations	Procedure.xlsx	Volumetric Info	Inventory Details
	Insights and Recommendations	Procedure.xlsx	Macros/ Packages Procedures Functions/ SQLs/ Package Cursor Queries	Complexity
	Insights and Recommendations	Procedure.xlsx	Complexity Summary	SQL Complexity 1/ Functions Complexity 1/ Procedures Complexity 1
SQL Server	Source Inventory Analysis	Analysis Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
SQL Server	Source Inventory Analysis	Analysis Report.xlsx	Query Complexity Wise Query Count	Query Complexity	Other insightful reports
Vertica	Source Inventory Analysis	Analysis Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Vertica	Source Inventory Analysis	Analysis Report.xlsx	Query Complexity Wise Query Count	Query Complexity	Other insightful reports
Netezza	Source Inventory Analysis	Analysis Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Netezza	Source Inventory Analysis	Analysis Report.xlsx	Query Complexity Wise Query Count	Query Complexity	Other insightful reports
Snowflake	Source Inventory Analysis	Analysis Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Snowflake	Source Inventory Analysis	Analysis Report.xlsx	Query Complexity Wise Query Count	Query Complexity	Other insightful reports
Azure Synapse	Source Inventory Analysis	Analysis Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Azure Synapse	Source Inventory Analysis	Analysis Report.xlsx	Query Complexity Wise Query Count	Query Complexity	Other insightful reports
Google BigQuery	Source Inventory Analysis	Analysis Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Google BigQuery	Source Inventory Analysis	Analysis Report.xlsx	Query Complexity Wise Query Count	Query Complexity	Other insightful reports
Redshift	Source Inventory Analysis	Analysis Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Redshift	Source Inventory Analysis	Analysis Report.xlsx	Query Complexity Wise Query Count	Query Complexity	Other insightful reports

ETL

The following table displays a brief summary on Volumetric Info and Complexity reports of various ETL sources such as Informatica, Ab Initio, DataStage, etc.

Source	Folder Name	Report Name	Sheet Name	Column Name	Extensive Reports
Informatica	Insights and Recommendations	Informatica Assessment.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Informatica	Insights and Recommendations	Informatica Assessment.xlsx	Workflow Summary	Complexity	Other insightful reports
DataStage	Insights and Recommendations	DataStage Assessment.xlsx	Volumetric Info	Inventory Details	Other insightful reports
DataStage	Insights and Recommendations	DataStage Assessment.xlsx	Job Summary	Complexity	Other insightful reports
Ab Initio	Insights and Recommendations	AbinitioCustomComplexityReport.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Ab Initio	Insights and Recommendations	AbinitioCustomComplexityReport.xlsx	Abinitio Complexity	Complexity	Other insightful reports
SSIS	Insights and Recommendations	SSIS Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
SSIS	Insights and Recommendations	SSIS Report.xlsx	File Summary	Complexity Level	Other insightful reports
Oracle Data Integrator	Insights and Recommendations	ODI Assessment.xlsx	Volumetric Info	Inventory Details	Other insightful reports
	Insights and Recommendations	ODI Assessment.xlsx	Procedure Details	Complexity
	Insights and Recommendations	ODI Assessment.xlsx	Mapping Details	Complexity
Pentaho	Insights and Recommendations	Pentaho_Assessment_Complete_Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Pentaho	Insights and Recommendations	Pentaho_Assessment_Complete_Report.xlsx	Job Summary	Complexity Category	Other insightful reports
SnapLogic	Insights and Recommendations	Snaplogic Assessment Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
SnapLogic	Insights and Recommendations	Snaplogic Assessment Report.xlsx	Pipeline Summary	Complexity	Other insightful reports
Talend	Insights and Recommendations	Talend Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Talend	Insights and Recommendations	Talend Report.xlsx	Job Summary	COMPLEXITY	Other insightful reports
Informatica BDM	Insights and Recommendations	InformaticaBDMSummary.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Informatica BDM	Insights and Recommendations	InformaticaBDMSummary.xlsx	Mapping Summary, Workflow Summary	Complexity	Other insightful reports
Azure Data Factory	Insights and Recommendations	ADF Assessment Report.xlsx	Volumetric Info	Type	Other insightful reports
Azure Data Factory	Insights and Recommendations	ADF Assessment Report.xlsx	Pipeline Summary	Complexity	Other insightful reports
Matillion	Insights and Recommendations	Matillion_Assessment.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Matillion	Insights and Recommendations	Matillion_Assessment.xlsx	Job Level Assessment	Complexity	Other insightful reports

Orchestration

The following table displays a brief summary on Volumetric Info and Complexity reports of various Orchestration jobs such as AutoSys, Control-M and SQL Server.

Source	Folder Name	Report Name	Sheet Name	Column Name	Extensive Reports
AutoSys	Insights and Recommendations	AutoSys_Assessment_Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
AutoSys	Insights and Recommendations	AutoSys_Assessment_Report.xlsx	Box Summary, Job Summary	Complexity	Other insightful reports
Control-M	Insights and Recommendations	control_m_job_summary.csv	control_m_job_summary	TotalJobsCount	Other insightful reports
SQL Server	Insights and Recommendations	jobs_information.csv	jobs_information	job_name	Other insightful reports

The following table displays a brief summary on Volumetric Info and Complexity reports of various BI reports such as OBIEE, IBM Cognos, Tableau, etc.

Source	Folder Name	Report Name	Sheet Name	Column Name	Extensive Reports
OBIEE	Source Inventory Analysis	Obiee_report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
OBIEE	Source Inventory Analysis	Obiee_report.xlsx	Report Summary Sheet	Complexity Category	Other insightful reports
Tableau	Insights and Recommendations	Tableau Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Tableau	Insights and Recommendations	Tableau Report.xlsx	Summary	Complexity	Other insightful reports
IBM Cognos	Insights and Recommendations	Cognos Assessment Report.xlsx	Volumetric Info	Report Detail	Other insightful reports
IBM Cognos	Insights and Recommendations	Cognos Assessment Report.xlsx	Report Overview	Complexity	Other insightful reports
MicroStrategy	Insights and Recommendations	MSTR Assessment.xlsx	Volumetric Info	Volumetric Details	Other insightful reports
MicroStrategy	Insights and Recommendations	MSTR_COMPLEXITY.xlsx	DataSet_Complexity, Visual_Complexity	complexity	Other insightful reports
Power BI	Insights and Recommendations	PowerBi Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Power BI	Insights and Recommendations	PowerBi Report.xlsx	DataSet Summary, Visual Summary	Complexity
SSRS	Insights and Recommendations	SSRS Report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
SSRS	Insights and Recommendations	SSRS Report.xlsx	Visual Summary	Complexity	Other insightful reports
SAP BO	Insights and Recommendations	SAP_BO_Crystal_Report_Assessment.xlsx	Volumetric Info	Total Reports	Other insightful reports
SAP BO	Insights and Recommendations	SAP_BO_Crystal_Report_Assessment.xlsx	DataModel Summary	Complexity	Other insightful reports

Analytics

The following table displays a brief summary on Volumetric Info and Complexity reports of various Analytics sources such as SAS and Alteryx.

Source	Folder Name	Report Name	Sheet Name	Column Name	Extensive Reports
SAS	Insights and Recommendations	SAS Code Assessment.xlsx	Summary	Summary	Other insightful reports
SAS	Insights and Recommendations	SAS Code Assessment.xlsx	Complexity Measures	Complexity	Other insightful reports
Alteryx	Insights and Recommendations	alteryx_report.xlsx	Volumetric Info	Inventory Details	Other insightful reports
Alteryx	Insights and Recommendations	alteryx_report.xlsx	Workflow Summary	complexity	Other insightful reports