Qlikview Online Training
Qlikview is software that makes it possible to retrieve and assimilate data from different sources. Once loaded into the program, the data is presented in a way that is easy to understand and work with. Cheyat Technologies provides QlikView Online Training with a solid grounding in QlikView and helps in understanding, creating and analyzing reports. Along with Qlikview Online Training we undertake on project support also.
Qlikview 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
