Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
QlikView Developer
Business Intelligence Training Overview

Developer is a must if you are building QlikView applications. Knowledge of the data model, creation ofthe proper data connections and scripting fundamentals are critical to creating QlikView applications that provide your organization with powerful business discovery tools. QlikView Developer provides you with an opportunity to learn by doing through a series of lectures and hands on exercises focused on developing QlikView applications. Developer course will prepare you to take your QlikView applications to the next level. The course concludes with a new business case where you can practice your skills in building a QlikView application from the beginning using identified key performance indicators.

Business Intelligence Training Prerequisites

QlikView Designer Course - Required
Basic Knowledge of DWH Concepts
Basics of any scripting language syntax


Business Intelligence Training Course duration

4 Days

Business Intelligence Training Course outline

1: Working with Data Sources

  • Using ODBC and OLE DB drivers
  • Accessing custom data sources
  • Extracting data-two hands-on examples
  • Extracting data from Excel, CSV
  • The resulting data model
  • Loading a table file
  • QVD and QVX files
  • Loading an Inline table
  • Hands on sessions
2: Data Modeling
  • Dimensional data modeling
  • Relational databases and ER modeling
  • Dimensional Modeling Schemas
  • Dimensional models in QlikView
  • How associations are created
  • Avoiding data model conflicts
  • The Table Viewer window
  • Hands on sessions
3: Qlikview Scripting Features
  • The Script Editor
  • Menu and toolbar
  • Script pane
  • Tool pane
  • Script statements
  • Synthetic keys
  • Synthetic Key tables
  • Composite keys
  • Manipulating tables
  • The Lookup Function
  • Concatenate Function
  • Joins
  • Conditional functions
  • Debugging script
  • organizing script
  • Re-using scripts
  • Hands on sessions
4: Data Transformation Basics
  • Changing the source table structure
  • Cleansing a dirty table
  • File contents
  • Working with the Transformation Step wizard
  • The final result
  • Expanding a hierarchy
  • Working with the Hierarchy Wizard
  • The tree-view list-box
  • Generic load
  • Loading a generic table into QlikView
  • Comparative analysis
  • A comparative analysis example
5: Advanced Expressions
  • Using variables
  • Creating a variable
  • Using variables in charts
  • Interactively changing a variable's value
  • Using variables based on expressions
  • Using variables to store expressions
  • Variable naming convention
  • The Dollar Sign Expansion syntax
  • The Aggr function
  • Using Aggr for nested aggregation
  • Conditional functions
  • The If function
  • String Functions
  • Subfield
  • Len
  • Index
  • MinString
  • MaxString
  • Subfieldcount
  • Hands on sessions
6: Set Creation with Point In Time Reporting
  • Set Analysis Basics
  • Dynamic record sets
  • More assignment operators
  • Set operators
  • Using element functions
  • Point In Time Reporting (Basics)
  • The challenge
  • Defining the set modifiers
  • Hands on sessions
7: Advanced Data Transformations
  • Data architecture
  • Two-stage architecture
  • Loading data already stored in QlikView
  • Cloning a QlikView data model
  • Loading from RAM
  • IntervalMatch Fucntion
  • Peek Fucntion
  • Hands on sessions
  • 7: Securing Workbooks
  • Access Control
  • Access Levels
  • Access Control Database
  • Inherited Access Restrictions
  • Hidden script
  • Adding Section access
  • Section access fields
  • Reduction fields
  • Initial data reduction
  • Omitting fields
  • Document-level security
  • Sheet-level security
8: Macros and Automation
  • Using Automation Macros
  • Internal Macro Interpreter
  • Getting hold of a QlikView Document
  • VB Script Functions
  • Using macros in QV document
Case study - An end - end mini real time project



Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved