There should be a more intuitive tool to handle spreadsheet files in Excel and import them into the data model.
Currently we perform this procedure manually via script. We've included commands for CrossTable, Unpivot, etc., but it's not very intuitive for new users.
There should be a screen similar to that of QlikView with the addition of new functionalities to clean contents, columns, transposition, rotation, crosstable, renaming fields through treatments of their fieldname and etc.
I think these features can positively attract many users who constantly compare the ease that PowerBI has over Qlik in this requirement.
http://www.youtube.com/tensini