02035736917



Module 1 - QlikSense Server Introduction and Installation

  1. QlikSense Server Architecture Introduction
  2. Install a Single Node Server
  3. Install a Multi Node Server
  4. Difference between Shared persistence and Synchronised persistence
  5. Explore the QMC
  6. Server Components
  7. License and allocation
  8. Add and Manage Users
  9. Configure User License Tokens
  10. Single sign-on concepts
  11. Apps Import, Export, Delete and Duplicate
  12. Streams
  13. Custom Properties
  14. Tasks
  15. Proxies and Virtual Proxies
  16. Schedulers
  17. Creating Load Balancing Rules
  18. Add and Manage Data Connections
  19. Add and Manage Extensions
  20. Monitor and Trouble Shoot
  21. Conclusion

Module 2 – QlikSense Security
  1. Creating Security Rules
  2. Learning about QlikSense App and its security features
  3. Providing QlikSense access to user sets
  4. QlikSense Security rule code
  5. Sheet Level Security

Module 3 – Starting QlikSense
  1. What is QlikSense?
  2. Qlikview vs. QlikSense
  3. Navigating in the User Interface

Module 4 – Data Modelling for QlikSense
  1. Creating Star and Snowflake schemas
  2. Loading Data with the Data Manager
  3. Data Load Editor
  4. Create and Maintain Data Connections
  5. Adding data from files and databases
  6. Understanding QVD layer
  7. Structuring the Script
  1. Joins
  2. Keep
  3. Concatenation
  4. Synthetic Keys
  5. Circular reference
  1. Advanced Calculations
  2. Master Calendar
  3. Loading data
  4. Debugging a data load
  5. Data Model Viewer
  6. Load Statements(Inline Load,Binary Load,Preceding Load)
  7. Cross Table
  8. Aggregation Functions
  9. Naming Conventions

Module 5 – Designing Visualizations
  1. Creating apps and Visualizations
  2. Structuring an app with Sheets
  3. Working with Master Items
  4. Different type of Visualizations
  5. When to use what type of Visualizations
  6. Dimensions and Measures in a Chart
  7. Settings and Properties of each Visualization
  8. Selections in a Visualization

Module 6 – Using Expressions in Visualizations
  1. Expressions, Functions and Variables
  2. Set Analysis
  3. Using Functions in Charts
  4. Using Variables in Expressions

Module 7 – Advanced Data Modelling
  1. Qlik Sense Star Schema
  2. Link Table
  3. Dimensions Table
  4. Master Calendar
  5. Optimizing data models
  6. Best Practices of Data Modelling

Module 8 – Collaborate in QlikSense
  1. Data Storytelling
  2. Book Marks
  3. Publishing
  4. Exporting and Printing
  5. Advanced Scripting and Chart Functions
  6. Qlik Tips and Techniques


Module 9 – Extensions and Mashups

  1. How to create Custom Extensions and Mashups ?
  2. What scenarios do we need to use extensions and Mashups ?

Module 10 – Qlik SAP Connector Installation and Configuration
  1. How to setup Qlik-SAP Connector
  2. Pre-requisites to set up SAP Connector
  3. SAP BW side configuration for Qlik- Connector
  4. Differences between SQL, BEx and Extractor connector?