I have been using Qlik for many years and am trying to step back and think of ways that less technical users might be able to use the product. I have never used the Data Manager in QlikSense, but I thought it was supposed to be helpful in the initial stages of building a data model.
I approach a new reporting/analysis request and am looking at the database schema in SSMS. It occurs to me that rather than continue down this path, maybe I can use the data manager to load data and work more efficiently.
However, my tables are large...a simple report begins with a need to join two tables each has tens of millions of rows. I need to understand how to filter this and slice it down to a manageable set. I would do that in SSMS with a few select statements, select distinct, etc. until I figured out the join and some constraints so that when I first execute the query, I get results in a few seconds, etc.
I don't see a way to replicate this kind of process using the graphical tools until you have loaded up the full data set. I know there's a limit qualifier you can use in load script, but that's not going to help my desire for approaching this as a less technical analyst user. Am I missing something in my approach here? Seems like typing SQL commands is necessary to do this kind of data exploration.
