BI Automation Level Indicator

This topic contains information about the logic used to calculate the automation level indicator for Tableau to target cloud platform conversion.

Tableau Conversion

Automation level indicator provides the extent of automation coverage for converting Tableau to target cloud platform.

Automation Level Indicator of each file = (((Successful Charts +(Partially Successful ChartsCharts With Todo Weightage))Charts Weightage + Successful Visual Objects (Sets, Groups, Parameters)Visual Objects (Sets, Groups, Parameters) Weightage + Successful CalculationsCalculations Weightage + Successful FiltersFilters Weightage + Successful ActionsActions Weightage + Successful SQLsCustom Sql Weightage + Successful DatamodelsDataModels WeightageIF(Relationships=0, 1, Relationships)) / (No. of ChartsCharts Weightage + Visual Objects (Sets, Groups, Parameters)Visual Objects (Sets, Groups, Parameters) Weightage + CalculationsCalculations Weightage + FiltersFilters Weightage + ActionsActions Weightage + Custom SQLsCustom Sql Weightage + DatamodelsDataModels Weightage*IF(Relationships=0, 1, Relationships))) * 100

where,

Successful Charts: Number of successfully converted charts.
Partially Successful Charts: Number of converted charts with ToDo message.
Charts With Todo Weightage: Default weightage assigned to a chart with ToDo message.
Charts Weightage: Default weightage assigned to a chart.
Successful Visual Objects (Sets, Groups, Parameters): Number of successfully converted visual objects such as sets, groups, parameters.
Visual Objects (Sets, Groups, Parameters) Weightage: Default weightage assigned to visual objects such as sets, groups, parameters.
Successful Calculations: Number of successfully converted calculations.
Calculations Weightage: Default weightage assigned to the calculations.
Successful Filters: Number of successfully converted filters.
Filters Weightage: Default weightage assigned to filters.
Successful Actions: Number of successfully converted actions.
Actions Weightage: Default weightage assigned to actions.
Successful SQLs: Number of successfully converted SQLs.
Custom Sql Weightage: Default weightage assigned to SQLs.
Successful Datamodels: Number of successfully converted datamodels.
Datamodels Weightage: Default weightage assigned to datamodels.
Relationships: Number of relationships in datamodel.
No of Charts: Total number of charts.
Visual Objects (Sets, Groups, Parameters): Total number of visual objects such as sets, groups, parameters.
Calculations: Total number of calculations.
Filters: Total number of filters.
Actions: Total number of actions.
Custom SQLs: Total number of custom SQLs.
Datamodels: Total number of datamodels.

Note:

The default weightage of Charts with ToDo message is 0.9 (configurable).
If the number of relationships in datamodel is zero, then you need to add 1 in the Relationships field.