Loading and modeling analytics data
You need to add data sources before you can create sheets and visualizations in a Qlik Sense app. Data sources can be added in the Analytics activity center or in a Qlik Sense app.
Qlik Cloud Analytics supports datasets and data connections. Datasets can be:
- Uploaded once and never modified.
- Replaced or refreshed with net new changes.
Data connections provide ways to access data sources you commonly use whether they are databases, local files, or remote files.
Once your data sources are added, you can load the data into an app and build your data model. You can take advantage of Insight Advisor’s analysis-based recommendations for associating tables and building data models, or you can create your own associations and joins. You can manage and modify the data from datasets and data connections once they are added in an app.
You can also load and add data to scripts. Scripts allow you to load, transform, and export data for use in analytics apps. For more information, see Working with scripts in the catalog.
Adding data to Qlik Cloud Analytics
Learn how to add datasets and connections to data sources and manage them from spaces.
Adding and managing your analytics data
Loading data
Loading data from the data catalog
Learn how to load data into your app from the datasets to which you have access.
Loading and managing data with Data Manager
Learn how to connect to, add, and manage data with Data Manager.
Loading and transforming data with scripting
Learn how to connect to and retrieve data from various data sources using data load scripts.
Collaboratively developing data load scripts in shared spaces
Learn how to co-develop app load scripts with other users.
Data sources
Whether your data is stored on-premises or in the cloud, you can quickly load it into SaaS editions of Qlik Sense.
Script syntax and chart functions
Learn how to use statements and functions in the script to load and transform data into your app.
Scripting for beginners
This tutorial introduces loading and manipulating data in Qlik Sense using scripting in the data load editor.
Next steps in scripting
This tutorial introduces advanced scripting concepts. This includes transforming data using cross-tables, cleaning data, and creating and loading data from Qlik data files (QVD).
Load, prepare, and associate data
Connecting to your data
Loading data from the data catalog
Learn how to load data into your app from existing datasets that you can acccess in the data catalog
Modeling data
Viewing and transforming the data model
Learn how to view and transform the data structure of an app.
Best practices for data modeling
Take a look at the best practices for data modeling.
Understanding your data with catalog tools
Learn how to improve your data efficiency while maintaining security and compliance standards.
Combining tables using forced concatenation
This step-by-step walkthrough shows how you can use forced concatenation to combine two similar data tables.
Incrementing data loads with the STORE command
This step-by-step example shows how to increment data loads using the Store command.
Managing data
Managing data security with Section Access
Learn how use section access to control the security of an application.
Managing big data with on-demand apps
Learn how to load and analyze big data sources in Qlik Sense using on-demand apps.
Managing data with dynamic views
Learn how to control the analytic sources and when data is refreshed in visualizations using dynamic views
Customizing logical models for Insight Advisor
Learn how to customize how Insight Advisor interprets your app data when generating insights from queries.
Customizing how Insight Advisor interprets data
This tutorial introduces how you can use business logic to customize how Insight Advisor interprets your data in search-based analytics.