How do we upload the DevAnalytics excel extract to PowerBI once downloaded? Also what data needs to be massaged to use the BTI PowerBI standard template?
1) Use /BTR/DEVA_TRANS to download the data.
The download will be in txt file. It is CSV format. If you open it via Excel, it should already open in column seperated format.
2) Once data is opened using Excel, there is some manual massaging of the data required:
2.1 Add a secondary Column to distinguish the Transport and Task
Then manually Add either Transport or Task to each row based on the metric. The easiest way to do this is to filter on [Contains]="trans" in the Metric column. Anything with that is Transport. The rest are Task.
2.2Make sure the Value Column is rounded off from a reporting point of view as excel
doesn’t like the values from the extract in terms of percentages
2.3 Remove any unnecessary data that will not be used or ever reported on
**See an attachment example of the excel document with the fields needing to be massaged in yellow
3) Uploading the excel document data to PowerBI
-Click on Go to file ->chose option and settings-> go to data sources setting-> change
source of the file