Qliksense Developer

Overview

Qlik Sense allows integrating different kind of data sources and configuring their visualizations, allowing them to follow a single discovery path through the data. This course will help participants to
    • Develop a Qlik Platform
    • Design Natural Analytics
    • Administrate Qlik Sense Server Cloud
Duration
6 Days

Pre-Requisites
  • Participants must have basic knowledge on DW/BI Concepts
  • Participants must have basic knowledge on ER Modelling Concepts
  • Participants must have basic knowledge on any scripting language
  • Participants must have basic knowledge on cloud applications

    • Course Outline

    • What is QlikView?
    • Exploring data with QlikView
    • Getting QlikView
    • QlikView Architecture
    • Navigating the document
    • Slicing and dicing your data
    • The technology and components behind
    • QlikView
    • The way the data flows
    • When QlikView use expands
    • Create content
    • Reload, publish, and distribute content
    • Consume content
    • Hands-on sessions on above topics
    • Preparing the workspace
    • Setting up the folder structure
    • Creating the QlikView document
    • Creating the app
    • The requirements
    • Constructing the data model
    • Loading the fact table
    • Playing with list boxes
    • Associating additional tables
    • Creating the dashboard tab
    • Hands-on sessions on above topics
    • Using ODBC and OLE DB drivers
    • Accessing custom data sources
    • Third-party custom connectors
    • Reading table files
    • Extracting data—two hands-on examples
    • Extracting data from MS Access
    • The resulting data model
    • Loading a table file
    • QVD and QVX files
    • Loading an Inline table
    • Hands-on sessions on above topics
    • Dimensional data modelling
    • Relational databases and ER modelling
    • The star schema
    • The snowflake schema
    • Dimensional models in QlikView
    • The associative data model
    • Guidelines for table associations
    • How associations are created
    • Avoiding data model conflicts
    • The Table Viewer window
    • Hands-on sessions on above topics
    • Design requirements
    • The Document Properties window
    • The Sheet Properties dialog
    • Setting the object properties
    • Caption colors and style
    • Propagating the object appearance
    • Setting the default Sheet Object Style
    • Hiding captions
    • Working with list boxes
    • The General tab
    • The Expressions tab
    • The Sort tab
    • The Presentation tab
    • The Number tab
    • The Font tab
    • The Layout tab
    • The Caption tab
    • The Multi Box
    • The Current Selections Box
    • Making selections from the Current Selections
    • Box
    • Adding a Bookmark Object
    • Aligning and resizing sheet objects
    • Selecting objects
    • Moving objects
    • Resizing objects
    • Resizing a Multi Box
    • Aligning sheet objects
    • Do a little housekeeping
    • Creating and applying a default color map
    • Defining chart colors
    • Setting the default color map
    • Hands-on sessions on above topics
    • User types
    • Dashboard users
    • Analysts
    • Report users
    • Creating the Analysis sheet
    • Creating the new Dashboard sheet
    • Creating the Reports sheet
    • Variables
    • Pivot tables
    • Auto minimize
    • The Report Editor window
    • Hands-on sessions on above topics
    • Other charts
    • Radar Chart
    • Mekko Chart
    • Grid Chart
    • Funnel Chart
    • Block Chart
    • Trellis Chart
    • The Script Editor
    • Menu and toolbar
    • Script pane
    • Tool Pane
    • Script statements
    • Manipulating tables
    • Conditional functions
    • Dealing with different data types
    • Debugging script
    • Standardizing and organizing the script
    • Re-using scripts
    • Managing file locations and connection strings
    • Hands-on sessions on above topics
    • Changing the source table structure
    • Cleansing a dirty table
    • File contents
    • Working with the Transformation Step wizard
    • The final result
    • Other transformation tricks
    • Loading a Crosstable
    • A Crosstable example
    • Working with the Crosstable Wizard
    • Expanding a hierarchy
    • Working with the Hierarchy Wizard
    • The tree-view list-box
    • Generic load
    • Loading a generic table into QlikView
    • Hands-on sessions on above topics
    • Using variables
    • Creating a variable
    • Using variables in charts
    • Interactively changing a variable's value
    • Using variables based on expressions
    • Using variables to store expressions
    • Variable naming convention
    • The Dollar Sign Expansion syntax
    • Using the TOTAL qualifier
    • The Aggr function
    • Using Aggr for nested aggregation
    • Conditional functions
    • The If function
    • The Class function
    • The Pick function
    • Hands-on sessions on above topics
    • Reporting
    • The magic of Set Analysis
    • Dynamic recordsets
    • More assignment operators
    • Set operators
    • Point In Time Reporting
    • The challenge
    • Defining the set modifiers
    • Storing set expressions into variables
    • Portable set expressions
    • Hands-on sessions on above topics
    • Data architecture
    • Two-stage architecture
    • Three-stage architecture
    • Setting up our environment
    • Loading data already stored in QlikView
    • Cloning a QlikView data model
    • Loading from RAM
    • Sorting tables
    • Ordering the Order-By fields
    • The Peek function
    • Merging forces
    • Hands-on sessions on above topics
    • Experience
    • Creating a consistent QlikView UI
    • Screen resolution
    • Background image
    • Themes
    • Additional interactivity
    • Triggers
    • Actions
    • Advanced search expressions
    • Dynamic bookmarks
    • Alerts
    • Conditionally showing and calculating objects
    • Hands-on sessions on above topics
    • Hidden script
    • Section access
    • Section access fields
    • Reduction fields
    • Initial data reduction
    • Omitting fields
    • Document-level security
    • Sheet-level security
    • Hands-on sessions on above topics
    • Using Automation Macros
    • Internal Macro Interpreter
    • Getting hold of a QlikView Document
    • VB Script Functions
    • Using macros in QV document
    • Hands-on sessions on above topics
    • Requirements Gathering
    • Build a Qlikview Data Model
    • Design Dashboard
    • Scripting Functionality of Dashboard

    Stay updated about us!