Qlik Sense & Qlikview Training
Our primary aim is to help the users to use the product in the most effective way by accelerating the adaptation process of this program by transferring the technical information about the use of Qlik Business Intelligence Platform in the most comprehensive way.
Besides, it is one of our main objectives to ensure that the users are able to speak the same language as our consultant team and provide a solution-oriented approach by conveying the problems they face most accurately.
QlikView
QlikView End User
- Introduction to Qlikview
- In-Memory Analysis & Relational Query Techniques
- QlikView Architecture
- Create a new QlikView report
- Dimension and Expression concepts
- Creation and visualization of Column, Line, Pie and other chart types
- Creation of Hierarchical (DrillDown) and Cyclic Dimension
- Adding Straight and Pivot Tables
- Creating Gauge
- General features of objects
- Conditional calculation (IF)
- Button and Button Movements (Action)
- Conditional work of the graph
- Saving query filters with bookmark
- What-If Scenarios
- Developing formulas using set expressions
- Comparison of different states
QlikView Developer
- Preceeding Load
- IF function (conditional transactions)
- Is null function
- Use of ’where exists‘
- Qualify (Automatic change of column names)
- Multi-key creation and management of Syn Tables
- Convert tables to caster with Crosstable command
- Mapping with Mapping
- Combining Table Data (Concatenate)
- Decreasing tables (Drop Table)
- Add a Calendar Table
- Peek command
- Loop Creation (While, for next)
- Exporting and Importing Scripts
- Create a hidden script page
- Reduce Data (Reduce Data)
- Running a Partial Load of Scripts
- Limited Number of Loads
- Creation and Management of QVD Files
- Incremental Load Only
- Data and Page-Based Restriction to the User (Section Access)
Qlik Sense
Qlik Sense End User
- Qlik Sense Approach & Data Discovery
- Relational Query Techniques
- Search Techniques
- Creating a New Application
- Load data using an Excel data source
- Defining a Master Item by Creating Dimension and Dimension
- Alternative Dimension and Measure Usage
- Use of Visual Objects
- Bar Chart
- Line Chart
- Gauge
- Image & Text Object
- treemap
- KPI Object
- Table
- If Function
- Export (pdf, excel, image) of images to external environment
- Variable Usage
- Conditional display in graphics (Calculation Condition)
- Sorting methods in graphics
- Hierarchical (DrillDown) Size
- Map Object Usage
- Formulas and Functions
- Create Bookmark
- Creating and Presenting Data Storytelling
- Creating Advanced Formulas Using Set Expressions
Qlik Sense Developer
- Creating a Connection
- Introduction to Qlik Sense script
- Combination of SQL and QlikSense scripts
- Creating table links
- Resizing the table in memory (Resident)
- Join Operations (Inner, Outer ..)
- Preceeding Load
- IF function (conditional transactions)
- Is null function
- Use of ’where exists‘
- Qualify (Automatic change of column names)
- Multi-key creation and management of Syn Tables
- Convert tables to caster with Crosstable command
- Mapping with Mapping
- Combining Table Data (Concatenate)
- Decreasing tables (Drop Table)
- Add a Calendar Table
- Peek command
- Loop Creation (While, for next)
- Managing Debug Mode
- Limited Number of Loads
- Creation and Management of QVD Files
- Incremental Load Only
- Data-Based Restriction to a User (Section Access)
Qlik Sense Administration
- Create a User Directory Connector and Define Users to the Sense Platform
- Licensing Models (User Access & Login Access)
- User License Identification
- Creating a Stream (Folder)
- Importing & Managing Applications & Stream
- User-based authorization of streams
- Data Connections creation and user-based authorization
- Managing Authority Groups by Defining Custom Properties
- Security Rule Definition
- Task definition and automatic updating of Applications periodically
- Content Libraries management
- Importing Extension Objects to Qlik Platform