Qliksense Fundamentals

What is Qlik Sense?

• Difference between Qlik Sense and Qlik view
• Tour around Qlik Sense Desktop
• Starting with Qlik Sense Desktop
• Opening an app with Qlik Sense
• Qlik Sense Architecture

Starting Qlik Sense

• Navigating the user interface
• Data Manager
• Data Load Editor
• Data Model Viewer
• Interacting with the user interface
• Creating apps and Visualisation
• Structing an app with Sheets

Designing Visualisations

• Expressions, Function and Variables
• Working with Expression Editor
• Using Functions in Charts
• Using Variables in Expressions
• Set Analysis and Set Expressions
• Working with Master Items

Managing Data

• Adding data from files and databases
• Loading data with data loads script
• Data Connections
• Various types of Data loads
• Profile Data with Qlik Sense
• Troubleshooting

Creating a Data Model

• Qlik Sense Data Architecture
• Creating Star and Snowflake schemas
• Use of Joins, Keeps, Concatenate etc
• Understanding of QVD layer
• Working on syntheic keys and circular references
• QlikSense Architecture

Advanced Data Modelling

• Qlik Sense Star Schema
• Link Table
• Dimensions Table
• Master Calendar
• Optimizing data models
• Best Practices for Data Modelling

Data Storytellings

• Publishing
• Exporting and Printing
• Advanced Scripting and Chart Functions
• Qlik Tips and Techniques

Qlik Sense Security

• Review of Qli Sense App and its security features
• Providing Qlik Sense access to user sets
• Qlik Sense Security rule code

Conclusion

• Summary