Home > Qlickview Online Training

Qlickview Online Training

Qlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online TrainingQlickview Online Training

Qlickview Online Training Course content

INTRODUCTION to QLIKVIEW

  • BI Concepts
  • What is QlikView? Why Market Leader in BI Platform?
  • Unique Features compared to Traditional BI Tools
  • QlikView Overview & Architecture
  • File Types & Extensions

QLIKVIEW PRODUCTS

  • Desktop
  • Server
  • Publisher
  • Access Point
  • QlikView Management Console
  • N Printing

INTRODUCTION TO DATA AND SCRIPTING

  • Data Warehouse Architecture
  • Dimensional Model
  • Dimension and Fact Tables
  • Star and Snow Flake Schemas
  • Comparing Data Models to QlikView Data Model
  • Data Source Files
  • Quiz

LOADING DATA FROM THE DATABASE

  • Script Generation
  • Loading a text file, delimited text files into QlikView
  • Load data from multiple data sources
  • Loading Inline Table
  • Resident Load
  • Incremental Load
  • Binary Load
  • Buffer Load [Add , Replace]
  • Preceding Load
  • Mapping Load
  • Loading Generic Tables [Generic Load]
  • Including Images and Media content [Bundle Info]
  • Partial Reload
  • Loading Data from Web Pages
  • Semantic Load
  • Examples for all
  • Key Takeaways
  • Quiz

STRUCTURING THE SCRIPT

  • Creating Tabs in the Script
  • Script Debugging
  • Comments & Variables in the Script

BASIC DATA MODEL AND TABLE VIEWER

  • The Table Viewer
  • The System Table
  • System fields

DATA RELATIONSHIPS

  • Joins
  • Keep
  • Concatenation
  • Types of Joins, Keep & Concatenation.

DATA MODELLING CONSIDERATIONS

  • Synthetic key tables
  • Circular references
  • Causes of Circular references
  • Ways to Resolve Synthetic Keys and Circular references

QLIKVIEW DATA (QVD) FILES

  • Creating QVD files
  • QVD file format
  • Types & Use of QVD files
  • Structure of QVD
  • Optimized and UnOptimized Load
  • Key Takeaways
  • Quiz

CREATING A MASTER CALENDAR

  • Getting the Highest and Lowest date from the Orders table
  • Creating Variables in the script
  • Creating the Master Calendar
  • Arbitrary Date ranges

QLIKVIEW SECURITY

  • Access control
  • Access levels
  • Access control database
  • Hidden script
  • Adding Section Access
  • Quiz

HANDLING NULL VALUES

QLIKVIEW VISUALIZATION

SHEETS AND SHEET OBJECTS

  • Sheet Basics
  • Sheet Objects
  • Cross Tables
  • Transformation Steps, Transpose

THE LIST BOX

  • Creating a List Box
  • List Box in Action
  • Properties of the List Box
  • Examples - List Boxes
  • AND=MODE in a list box

THE TABLE BOX

  • Creating a Table Box
  • Selections in Table Boxes
  • Sorting in Table Boxes
  • More Table Box formatting options
  • Printing data from a table box
  • Exporting data from a table box to a text file
  • Exercises

THE MULTI BOX

  • Creating a Multi Box
  • Selections in Multi Boxes
  • Resizing Multi Boxes
  • Formatting Multi Boxes
  • Exercises

THE BUTTON & TEXT OBJECT

  • Creating Text Objects
  • Creating Button Objects
  • Formatting, Resizing, Copying and Moving Text Objects
  • Action Scripts in the Button & Text Objects

CHARTS

  • Chart Basics
  • Creating a Chart (Bar, Pie, Line etc…)
  • Selections in Charts
  • Common Chart Types
  • Exporting charts
  • References in charts
  • Exercises

MULTI DIMENSIONAL CHARTS, PIVOT TABLES

  • Straight Table with Multiple Expressions
  • Pivot Tables with Multiple Dimensions
  • More about Pivot Tables and Straight Tables and Table Box.
  • Using Visual Cues

GAUGES

  • Why Use a Gauge Chart?
  • Types of Gauges
  • Building Gauges
  • Examples for all types of Gauge Charts

THE OTHER SHEET OBJECTS

  • The Statistics Box
  • The Current Selections Box
  • The Slider/Calendar Object
  • The Bookmark Object
  • The Containter Object
  • The Input Box

ADDITIONAL EDITING IN THE LAYOUT

  • Title Settings
  • Fast Change Chart Type
  • Legend Settings
  • Reference Lines / Text in Chart
  • Advanced Caption Settings
  • Cyclic & Drilldown Functionality

USES OF EXPRESSIONS

  • Calculated Labels and Dynamic Text in Text Objects
  • Conditional Functions
  • Chart Attribute Expressions
  • Color Expressions
  • Calculated Fields in List Boxes
  • Calculated Dimensions in Charts

THE SETTINGS MENU

  • User Preferences
  • Document Properties
  • Sheet Properties
  • Key Takeaways
  • Quiz

QLIKVIEW FUNCTIONS

  • All Mandated functions like,
  • ApplyMap, Lookup
  • Interval Match, Class, Value List, Value Loop
  • Peek, Pick, Previous, Match, Wild Match, etc.
  • Statistical Functions,
  • Range Functions, etc.

ADHOC REPORTS AND BOOKMARKS

  • Creating and editing Adhoc reports
  • Introduction – Bookmarks
  • Bookmark Types
  • Managing Bookmarks
  • Creating Bookmarks

LAYOUT THEMES

  • Creating a theme
  • Applying a theme
  • Dynamic Themes
  • Examples

EXTENSIONS

  • Creating a Simple HTML Extension
  • Creating a Simple HTML Table
  • Creating an interactive Extension
  • Using External Libraries with Extensions
  • Key Takeaways
  • Quiz

SET ANALYSIS

  • Purpose of Set Analysis
  • Identifiers, Operators, Modifiers
  • Example Expressions
  • YTD and MTD
  • Rolling 12 Months
  • Indirect Set Analysis
  • Examples for all

ALTERNATE STATES

  • Comparative Analysis
  • Market Basket Analysis
  • Examples for all

WHAT-IF ANALYSIS

  • Creating Variables
  • Creating Slider Object
  • Assigning variable to Sheet Object and Slider Object
  • Examples

SERVER INSTALLATION & DEPLOYMENT

  • Installation
  • Types of Licenses
  • Types of CALS
  • Deploying the application in server
  • Server Bookmarks
  • Annotations
  • Key Takeaways
  • Quiz
Shop No 1, Kasturi Apartments,
Sindhubhavan Road, Brundavan Colony, Vijayawada - 520010
+91-91009-98433/34
24 x 7 Call Support
trainings@cheyat.com
Email support
TOP