Qlikview Online Training - unitedtrainings.com

United Trainings
Kolkata
3 Months


Course Summary

IT, Software & Hardware
3 Months
Online
Experienced

Course Description

United Trainings provide QlikView online training and Qlikview designer online training to candidates. QlikView is a business intelligence(BI) tool from Qliktech Company that visualizes data into rich graphics. It comprises of three components including Designer, Server, and Publisher.


Topics Covered

    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

See other jobs

Share Course on :
ArcSight ESM 6.9 Advanced Training
Learning Lynk Institute
Hyderabad
45

Pentaho DI Training
Ecorp Trainings Institute
Hyderabad
45