Skip to main content

Loading and modeling analytics data

ON THIS PAGE

Loading and modeling analytics data

Data management depends on how data is sourced and what level of related maintenance is required. You need to connect to a data source before you can create visualizations in a Qlik Sense app. Datasets can be:

  • Uploaded once and never modified.
  • Modified manually through Data manager.
  • Replaced or refreshed with net new changes.

Data connections in the Data load editor provide ways to manage data sources you commonly use whether they are databases, local files, or remote files. You might also want to 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.

Loading data

Loading and managing data from the cloud hub

Learn how to add data files and data connections directly in the cloud hub

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

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.