Qlikview online training course content

Course Content – Qlikview online training

 

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