Hi,
I am new to Qlik Sense and for training purposes I have an exercise to perform.
It is asked to switch from a relational DB model of an online selling platform to a dimensional DB model and then perform some aggregations through Qlik Dashboarding. I have a list of different CSV files containing data pulled out from different tables of the relational DB.
During my past training on BI tools and methodology I have widely explored the need to create a DWH with Fact and Dim tables and perform some ETL manipulation before loading data to the DWH.
Apparently the only tool to be used in this particular exercice is Qlik and no other references to ETL tools or SQL for a DWH setup. So my question is fairly simple. Is it possible with QlikSense to transform those relational csv files into a dimensional model before starting with analysis? I assume that QlikView has the same functionalities but as far as I understood this one is a little bit outdated and replaced by QlikSense.
Many thanks in advance
Rick