Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You wouldn't have to use Excel, as QlikSense already has ETL (Extract, Transform, Load) capabilities. You can simply pull down your data, and then work it into a datamodel in QlikSense.
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.
Your qlik datamodel may be very, very different from your database model. I wouldn't worry about that in the slightest.