Hi, I am new to Qlik so I apologize if this question seems rudimentary. I have data that has multiple dimensions (year, account, region, sales person, etc) and facts (2 - think sales amount and costs) that are being pulled from a database. What would be the best way to import this data. I read on star schemas effort and also completely flattening my data and importing as an excel but that will be too tedious as the data is ever changing. Any thoughts are appreciated!
Thanks. Please correct me if I am wrong but I can make create relationships from one table to another using Qlik's ETL built in tool. I did some reading and it seems that Qlik uses associations which doesn't necessarily translate to a relational database type structure.