Data Share House
We're excited to have Aaron Couron (left) in the Data Share House today. Aaron is an expert in Qlik products, and has shared with us some awesome tips on how to use Qlik in a better way. Aaron answered questions which we've received regarding Qlik products. Enjoy!
Which Qlik feature you find most useful?
The most useful Qlik feature for me is the associative data model itself. The ability to freely navigate and filter across the data model with the resulting aggregations calculating across the entire data model in real time is the core competency that sets Qlik apart from all other competitors.
Which Qlik feature you think users often do not use to its optimal potential?
The built in ETL scripting is very often misunderstood and/or completely overlooked. Many developers have the idea that they need a data warehouse or have to cleanse and prep their data in a SQL server before loading it into Qlik. That is not true. Using the ETL script and QVDs developers can create a transformed, scalable deployment completely in Qlik.
Share a recent trick of yours which you think is a great time saver for Qlik users?
When starting a new app, I immediately extract the tables I will need to QVD. I then develop from the QVDs rather than going to the original datasource, only flipping the switch back when I am done. This GREATLY speeds up development time and lightens your footprint on the original datasource.
3 reasons why you think Qlik is better than Tableau?
1. The Associative Data Model - Tableau has no concept of an associated data model. Linkages are completely manual.
2. Extensibility - Qlik Sense is completely extensible with published API’s for everything from Server Management to Visualization Design. Tableau is more or less a closed system.
3. ETL - Tableau has no ETL tools. To employ Tableau in any decent sized environment, you MUST have a system upstream to cleanse and prep your data. QlikView and Qlik Sense have built in ETL which saves the enterprise money.
What's your view on QlikSense? Do you already use it and how do you think it contributes to the toolest of the data analysts?
I use Qlik Sense extensively. It is awesome. It takes the base QlikView model and takes it to the next level. Qlik Sense is extensible. Qlik Sense is responsive by design. Qlik Sense is user enabled. It has taken the design of dashboards all the way to the analyst. The interface is easy and clean, and the visualizations are beautiful and useful.
Aaron's entertaining visual of data visualization history.
Humor is cleverly used throughout his blog to help the reader absorb the heavy content with ease.
What features/ improvements are you most excited about with Qlik's new versions?
I am not privy to the feature roadmap, but I am excited for the future. With the rich ecosystem growing around the platform and the recent acquisition of Idevio, I only see Qlik gaining steam and market. And LivingQlik will be there to document the progress.
Aaron is not afraid to experiment with Qlik View and Sense's features and creatively pushes the boundaries of what Qlik can deliver for your clients. If you are hungry for more tips, Aaron's blog (livingqlikview) features countless articles on the Qlik portfolio of products.