Skip to main content Skip to complementary content

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

Information noteIf your source data resides behind a firewall, you can securely access it using Qlik Data Gateway - Direct Access. For more information, see Qlik Data Gateway - Direct Access overview.

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.

Tutorial

Scripting for beginners

This tutorial introduces loading and manipulating data in Qlik Sense using scripting in the data load editor.

Tutorial

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).

Video (4 min)

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.

Walkthrough

Combining tables using forced concatenation

This step-by-step walkthrough shows how you can use forced concatenation to combine two similar data tables.

Walkthrough

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.

Tutorial

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.

Learn more

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!