Qlik Sense SaaS: Excel (sheets) Import Wizard with Transformations
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.
NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.