COURSES UPDATE:
NEW JOB ORIENTED CAREER COURSES STARTING FROM 10th Aug 2019. ANY GRADUATE CAN DO THIS. GRAB THIS OPPORTUINITY NOW. WE WILL GIVE GUARANTEE OF YOUR JOB. | OTHER WEEKEND BATCH SCHEDULES |  HADOOP  (02:00:PM)  |    APPIUM And REST ASSURED  (05:00:PM)  |  AWS AND DEVOPS  (05:00:PM)  |  ADVANCED SELENIUM, JAVA AND DEVOPS PIPELINE  (04:00:PM)  |  ANGULAR 6  (10:00:AM)  |   LINUX SHELL SCRIPTING / ADMIN  (11:00:AM)  |  More Information Click Here..  
+91 7588262721 / 9665875790 / 9923488942 info@orilent.com / orilenttap@gmail.com


Lesson 1: Introduction to Qlikview And Qlikview Products
o    Introduction to the concepts of Business Intelligence, learning about QlikView, the unique features of QlikView that make it the market leader, comparison to other BI tools, the complete overview and architecture of QlikView, studying the various file types and extensions.
o    Learning about the various QlikView products, understanding about the QlikView Desktop, Server, Access Point, Publisher, the Management Console and NPrinting reporting platform.    

Lesson 2: Introduction to Data and Scripting, Loading Data From The DataBase
o    Understanding the data warehouse architecture, the concept of dimensional model, fact tables and dimensions, learning about Star and Snow Flake schema, QlikView data model comparison to other data models, understanding the data source files.
o    Learning about loading data from various databases, generating script, loading of text files, delimited text files, loading data from multiple data sources, various types of data loads like incremental, binary, resident, buffer, preceding, mapping load types, understanding how to load inline table, generic tables, media content and image inclusion, web page data loading, semantic load, various examples to simplify the concepts.

Lesson 3: Structuring the Script, Basic Data Model and Table Viewer, Data Relationships
o    Learning to create tabs in the scripts, debugging of scripts, inclusion of variables and comments in the scripts.
o    Understanding the basic data model of QlikView, learning to work with the Table Viewer, the System Table and System fields.
o    Introduction to the various data relationships – Join, Concatenation, Join, and the different options available in each.
    Lesson4: Data Modelling Considerations, Qlikview Data (QVD) Files, Creating a Master Calendar
o    The rules of data modeling in QlikView, introduction to circular references, synthetic key tables, resolving synthetic keys and circular references.
o    Understanding what is QVD file in QlikView, the way to create QVD file, the standard structure of a QVD file, its various components, the various types and uses of QVD files, learning what is optimized and unoptimized load.
o    Creating a master calendar in QlikView, extracting the highest and lowest data, deploying scripts to create variables, working with arbitrary date ranges.

Lesson 5:  Qlikview Security, Handling Null Values, Sheets and Sheet Objects, The List Box
o    Understanding the various concepts of QlikView security, defining the access controls, levels of access, maintaining the access control database, section access addition and other concepts.
o    The various types of null values in QlikView and the different methods to handling them.
o    Working with QlikView sheets and sheet objects, learning about the sheet basics, cross tables, the data transformation in QlikView, transposing a physical table.
o    Understanding a list box, most basic sheet object, the various actions in List Box, its properties, the example of a list box.    

Lesson 6: The Table Box, The Multi Box, The Button & Text Object, Charts
o    A sheet object that shows several fields simultaneously, learning to create a table box, sorting in table box, understanding table box formatting options, printing the data from table box, exporting to a text file.
o    Representation of value from multiple fields, learning to create a multibox, the various selection features, formatting and resizing of multiboxes.
o    Working with text and button objects, learning to create them, formatting, resizing, copying and moving of text objects, understanding of action scripts in button and text objects.
o    Learning the basics of QlikView Charts, graphical representation of numerical data, various types of charts like bar, pie, grid, funnel, combo, learning to create charts, selections in charts and exporting of charts.

Lesson 7: Multi Dimensional Charts, Pivot Tables, Gauges, The Other Sheet Objects
o    Introduction to multidimensional charts, setting up multiple expressions in straight table and pivot table, learning about straight table and pivot table, table box and deploying visual cues.
o    Learning about Gauge Chart in QlikView, the various types of Gauges, understanding how to build Gauges, the various types of Gauge Charts.
o    Introduction to the other sheet objects like Statistics Box, Slider/Calendar Object, Current Selections Box, Bookmark Object, Container Object, and Input Box.
    
Lesson 8: Additional Editing in The Layout, Uses Of Expressions, The Settings Menu, Qlikview Functions, Adhoc Reports and Bookmarks
o    The additional editing like settings of type legend, title, fast change chart type, text in chart and reference lines, caption settings and drilldown, cyclic functionality.
o    Learning about the various expressions like chart attribute, colour, working with calculated fields, labels, and dynamic text in text objects, calculated fields and dimensions in list boxes and charts.
o    Learning about the settings menu in QlikView, the various options like user preferences, document properties and sheet properties.
o    The various QlikView functions like ApplyMap, Lookup, Previous, Value List, Interval Match, Class, Value Loop, Peek, Pick, Match, Wild Match, Statistical Functions,Range Functions, etc.
o    Learning about ad hoc report creation and editing, introduction to QlikView bookmarks, the various types of bookmarks, creating and managing bookmarks.

Lesson 9: Layout Themes, Extensions, Set Analysis
o    Understanding QlikView themes, creating, applying and working with dynamic themes.
o    Learning about QlikView extensions, visualizing of data with extensions, creating a simple HTML extension, HTML table, working with interactive extensions and external libraries with extensions.
o    Understanding set analysis, defining data values that are different from set definition, working with modifiers, identifiers, operators, example of expressions, indirect set analysis, YTD & MTD and rolling 12 months, various examples.    

Lesson 10:  Alternate States, What-IF Analysis, Server Installation & Deployment
o    Understanding alternate states for performing comparative analysis on sets of multiple data items, working with market basket analysis, examples of various alternate states.
o    Understanding what-if analysis in QlikView, working on creating variables, slider objects, assigning variables to sheet and slider objects.
o    The process of installation, various types of licenses, types of CALS, learn to deploy the application on the server, working with server bookmarks, annotations.

Lesson 11: Set Analysis, Alternate States
o    Understanding set analysis, defining data values that are different from set definition, working with modifiers, identifiers, operators, example of expressions, indirect set analysis, YTD & MTD and rolling 12 months, various examples.
o    Understanding alternate states for performing comparative analysis on sets of multiple data items, working with market basket analysis, examples of various alternate states.    

Lesson 12:  What-IF Analysis, Server Installation & Deployment
o    Understanding what-if analysis in QlikView, working on creating variables, slider objects, assigning variables to sheet and slider objects.
o    The process of installation, various types of licenses, types of CALS, learn to deploy the application on the server, working with server bookmarks, annotations.


 

Lesson 1: Introduction to Qlikview And Qlikview Products
o    Introduction to the concepts of Business Intelligence
o    learning about QlikView
o    the unique features of QlikView that make it the market leader, comparison to other BI tools
o    the complete overview and architecture of QlikView
o    studying the various file types and extensions.
o    Learning about the various QlikView products
o    understanding about the QlikView Desktop
o    Server, Access Point, Publisher, the Management Console and NPrinting reporting platform.    

Lesson 2: Introduction to Data and Scripting, Loading Data From The DataBase
o    Understanding the data warehouse architecture
o    the concept of dimensional model, fact tables and dimensions, learning about Star and Snow Flake schema, QlikView data model comparison to other data models, understanding the data source files.
o    Learning about loading data from various databases
o    generating script, loading of text files, delimited text files
o    loading data from multiple data sources, various types of data loads like incremental, binary, resident, buffer, preceding, mapping load types
o    understanding how to load inline table, generic tables
o    media content and image inclusion, web page data loading, semantic load, various examples to simplify the concepts.

Lesson 3: Structuring the Script, Basic Data Model and Table Viewer, Data Relationships
o    Learning to create tabs in the scripts
o    debugging of scripts
o    inclusion of variables and comments in the scripts.
o    Understanding the basic data model of QlikView
o    learning to work with the Table Viewer, the System Table and System fields.
o    Introduction to the various data relationships – Join, Concatenation, Join, and the different options available in each.
    
Lesson 4: Data Modelling Considerations, Qlikview Data (QVD) Files, Creating a Master Calendar
o    The rules of data modeling in QlikView
o    introduction to circular references
o    synthetic key tables
o    resolving synthetic keys and circular references.
o    Understanding what is QVD file in QlikView
o    the way to create QVD file
o    the standard structure of a QVD file, its various components
o    the various types and uses of QVD files
o    learning what is optimized and unoptimized load.
o    Creating a master calendar in QlikView
o    extracting the highest and lowest data, deploying scripts to create variables
o    working with arbitrary date ranges.

Lesson 5:  Qlikview Security, Handling Null Values, Sheets and Sheet Objects, The List Box
o    Understanding the various concepts of QlikView security, defining the access controls, levels of access, maintaining the access control database, section access addition and other concepts.
o    The various types of null values in QlikView and the different methods to handling them.
o    Working with QlikView sheets and sheet objects, learning about the sheet basics, cross tables, the data transformation in QlikView, transposing a physical table.
o    Understanding a list box, most basic sheet object, the various actions in List Box, its properties, the example of a list box.    

Lesson 6: The Table Box, The Multi Box, The Button & Text Object, Charts
o    A sheet object that shows several fields simultaneously
o    learning to create a table box
o    sorting in table box
o    understanding table box formatting options
o    printing the data from table box
o    exporting to a text file.
o    Representation of value from multiple fields
o    learning to create a multibox
o    the various selection features
o    formatting and resizing of multiboxes.
o    Working with text and button objects
o    learning to create them, formatting, resizing, copying and moving of text objects
o    understanding of action scripts in button and text objects.
o    Learning the basics of QlikView Charts
o    graphical representation of numerical data
o    various types of charts like bar, pie, grid, funnel, combo
o    learning to create charts
o    selections in charts and exporting of charts.

Lesson 7: Multi Dimensional Charts, Pivot Tables, Gauges, The Other Sheet Objects
o    Introduction to multidimensional charts
o    setting up multiple expressions in straight table and pivot table
o    learning about straight table and pivot table
o    table box and deploying visual cues.
o    Learning about Gauge Chart in QlikView
o    the various types of Gauges
o    understanding how to build Gauges
o    the various types of Gauge Charts.
o    Introduction to the other sheet objects like Statistics Box, Slider/Calendar Object, Current Selections Box, Bookmark Object, Container Object, and Input Box.
    
Lesson 8: Additional Editing in The Layout, Uses Of Expressions, The Settings Menu, Qlikview Functions, Adhoc Reports and Bookmarks
o    The additional editing like settings of type legend, title, fast change chart type
o    text in chart and reference lines, caption settings and drilldown, cyclic functionality.
o    Learning about the various expressions like chart attribute, colour, working with calculated fields, labels, and dynamic text in text objects, calculated fields and dimensions in list boxes and charts.
o    Learning about the settings menu in QlikView
o    the various options like user preferences
o    document properties and sheet properties.
o    The various QlikView functions like ApplyMap, Lookup, Previous, Value List, Interval Match, Class, Value Loop, Peek, Pick, Match, Wild Match, Statistical Functions,Range Functions, etc.
o    Learning about ad hoc report creation and editing
o    introduction to QlikView bookmarks
o    the various types of bookmarks
o    creating and managing bookmarks.

Lesson 9: Layout Themes, Extensions, Set Analysis
o    Understanding QlikView themes, creating, applying and working with dynamic themes.
o    Learning about QlikView extensions
o    visualizing of data with extensions
o    creating a simple HTML extension
o    HTML table, working with interactive extensions and external libraries with extensions.
o    Understanding set analysis
o    defining data values that are different from set definition, working with modifiers, identifiers
o    operators, example of expressions
o    indirect set analysis
o    YTD & MTD and rolling 12 months, various examples.    

Lesson 10:  Alternate States, What-IF Analysis, Server Installation & Deployment
o    Understanding alternate states for performing comparative analysis on sets of multiple data items
o    working with market basket analysis
o    examples of various alternate states.
o    Understanding what-if analysis in QlikView
o    working on creating variables, slider objects
o    assigning variables to sheet and slider objects.
o    The process of installation
o    various types of licenses
o    types of CALS
o    learn to deploy the application on the server
o    working with server bookmarks, annotations.

Lesson 11: Set Analysis, Alternate States
o    Understanding set analysis, defining data values that are different from set definition
o    working with modifiers, identifiers, operators, example of expressions, indirect set analysis, YTD & MTD and rolling 12 months, various examples.
o    Understanding alternate states for performing comparative analysis on sets of multiple data items
o    working with market basket analysis
o    examples

Lesson 1: Introduction to Qlikview And Qlikview Products, Introduction to Data and Scripting, Loading Data From The DataBase
o    Introduction to the concepts of Business Intelligence
o    learning about QlikView
o    the unique features of QlikView that make it the market leader, comparison to other BI tools
o    the complete overview and architecture of QlikView
o    studying the various file types and extensions.
o    Learning about the various QlikView products
o    understanding about the QlikView Desktop
o    Server, Access Point, Publisher, the Management Console and NPrinting reporting platform.
o    Understanding the data warehouse architecture
o    the concept of dimensional model, fact tables and dimensions, learning about Star and Snow Flake schema, QlikView data model comparison to other data models, understanding the data source files.
o    Learning about loading data from various databases
o    generating script, loading of text files, delimited text files
o    loading data from multiple data sources, various types of data loads like incremental, binary, resident, buffer, preceding, mapping load types
o    understanding how to load inline table, generic tables
o    media content and image inclusion, web page data loading, semantic load, various examples to simplify the concepts.    

Lesson 2: Structuring the Script, Basic Data Model and Table Viewer, Data Relationships, Data Modelling Considerations, Qlikview Data (QVD) Files, Creating a Master Calendar
o    Learning to create tabs in the scripts
o    debugging of scripts
o    inclusion of variables and comments in the scripts.
o    Understanding the basic data model of QlikView
o    learning to work with the Table Viewer, the System Table and System fields.
o    Introduction to the various data relationships – Join, Concatenation, Join, and the different options available in each.
o    The rules of data modeling in QlikView
o    introduction to circular references
o    synthetic key tables
o    resolving synthetic keys and circular references.
o    Understanding what is QVD file in QlikView
o    the way to create QVD file
o    the standard structure of a QVD file, its various components
o    the various types and uses of QVD files
o    learning what is optimized and unoptimized load.
o    Creating a master calendar in QlikView
o    extracting the highest and lowest data, deploying scripts to create variables
o    working with arbitrary date ranges.

Lesson 3: Qlikview Security, Handling Null Values, Sheets and Sheet Objects, The List Box, The Table Box, The Multi Box, The Button & Text Object, Charts
o    Understanding the various concepts of QlikView security, defining the access controls, levels of access, maintaining the access control database, section access addition and other concepts.
o    The various types of null values in QlikView and the different methods to handling them.
o    Working with QlikView sheets and sheet objects, learning about the sheet basics, cross tables, the data transformation in QlikView, transposing a physical table.
o    Understanding a list box, most basic sheet object, the various actions in List Box, its properties, the example of a list box.
o    A sheet object that shows several fields simultaneously
o    learning to create a table box
o    sorting in table box
o    understanding table box formatting options
o    printing the data from table box
o    exporting to a text file.
o    Representation of value from multiple fields
o    learning to create a multibox
o    the various selection features
o    formatting and resizing of multiboxes.
o    Working with text and button objects
o    learning to create them, formatting, resizing, copying and moving of text objects
o    understanding of action scripts in button and text objects.
o    Learning the basics of QlikView Charts
o    graphical representation of numerical data
o    various types of charts like bar, pie, grid, funnel, combo
o    learning to create charts
o    selections in charts and exporting of charts.    

Lesson 4: Multi Dimensional Charts, Pivot Tables, Gauges, The Other Sheet Objects, Additional Editing in The Layout, Uses Of Expressions, The Settings Menu, Qlikview Functions, Adhoc Reports and Bookmarks
o    Introduction to multidimensional charts
o    setting up multiple expressions in straight table and pivot table
o    learning about straight table and pivot table
o    table box and deploying visual cues.
o    Learning about Gauge Chart in QlikView
o    the various types of Gauges
o    understanding how to build Gauges
o    the various types of Gauge Charts.
o    Introduction to the other sheet objects like Statistics Box, Slider/Calendar Object, Current Selections Box, Bookmark Object, Container Object, and Input Box.
o    The additional editing like settings of type legend, title, fast change chart type
o    text in chart and reference lines, caption settings and drilldown, cyclic functionality.
o    Learning about the various expressions like chart attribute, colour, working with calculated fields, labels, and dynamic text in text objects, calculated fields and dimensions in list boxes and charts.
o    Learning about the settings menu in QlikView
o    the various options like user preferences
o    document properties and sheet properties.
o    The various QlikView functions like ApplyMap, Lookup, Previous, Value List, Interval Match, Class, Value Loop, Peek, Pick, Match, Wild Match, Statistical Functions,Range Functions, etc.
o    Learning about ad hoc report creation and editing
o    introduction to QlikView bookmarks
o    the various types of bookmarks
o    creating and managing bookmarks.

Lesson 5:  Layout Themes, Extensions, Set Analysis, Alternate States, What-IF Analysis, Server Installation & Deployment
o    Understanding alternate states for performing comparative analysis on sets of multiple data items
o    working with market basket analysis
o    examples of various alternate states.
o    Understanding what-if analysis in QlikView
o    working on creating variables, slider objects
o    assigning variables to sheet and slider objects.
o    The process of installation
o    various types of licenses
o    types of CALS
o    learn to deploy the application on the server
o    working with server bookmarks, annotations.
o    Understanding QlikView themes, creating, applying and working with dynamic themes.
o    Learning about QlikView extensions
o    visualizing of data with extensions
o    creating a simple HTML extension
o    HTML table, working with interactive extensions and external libraries with extensions.
o    Understanding set analysis
o    defining data values that are different from set definition, working with modifiers, identifiers
o    operators, example of expressions
o    indirect set analysis
o    YTD & MTD and rolling 12 months, various examples.    

Lesson 6: Set Analysis, Alternate States, What-IF Analysis, Server Installation & Deployment
o    Understanding set analysis, defining data values that are different from set definition
o    working with modifiers, identifiers, operators, example of expressions, indirect set analysis, YTD & MTD and rolling 12 months, various examples.
o    Understanding alternate states for performing comparative analysis on sets of multiple data items
o    working with market basket analysis
o    examples of various alternate states.
o    Understanding what-if analysis in QlikView
o    working on creating variables
o   &nb