Torque Inspection - Free Power Bi Template
TLDR;
The Torque Inspection Report serves as a valuable instrument for evaluating the effectiveness of torque maintenance procedures. By utilizing the asset history Excel file available through ALIS, seamless integration with Power BI enables the acquisition and analysis of torque data, facilitating enhanced efficiency in airport maintenance operations. Simply download the template provided and change the source file (asset history and obsevation files). Then you will be able to see your airport’s torque data in Power Bi. The template can be modified however you like and it’s FREE for all ALIS users!

What can you gain from this data?
The amount of bolts or assets torqued in the past
Optimization of maintenance regime
Safety improvement
Torque values and angle of rotation analysis
What do you need to get started?
Step-by-step guide on how to import torque data into Power Bi
Unzip the file. Open the Power Bi template file and click on Transform data under the Home tab

Select Asset History and click on the the small gear next to Source

Click Browse…

Find the Asset history excel file and click Open (see What do you need no.3 asset history)

Once you have chosen the file, click OK

If you find errors, see Common Errors
Repeat from step 2-4 but with Observation excel file. Select Observations and click the small gear next to the Source.

Click Browse

Choose a file with observation data. It’s important that your data includes both open and closed observations. (see What do you need no.4 observation)

Once you have chosen the correct file, click OK.

Close & Apply

The new datas should be shown in the visualization. Click publish to publish the report to the cloud.

If you find errors, see Common Errors.