Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Qlik Sense Desktop - data loading

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!

Labels (2)
3 Replies
JustinDallas
Valued Contributor II

Re: Qlik Sense Desktop - data loading

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.

Partner
Partner

Re: Qlik Sense Desktop - data loading

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.

JustinDallas
Valued Contributor II

Re: Qlik Sense Desktop - data loading

Your qlik datamodel may be very, very different from your database model.  I wouldn't worry about that in the slightest.