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 hub or in an app.
Qlik Sense 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.
Adding data to Qlik Sense SaaS
Adding and managing your analytics data
Learn how to add datasets and connections to data sources in the hub and manage them from spaces.
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.
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
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.