QlikView Training for Developers

How To Take This Class

Live Instructor-Led Online Class

Cost: $1,125.00

  • Open enrollment class for individuals
  • Live class with an instructor
  • Free class retakes forever!
  • Six months of instructor email support
  • Hands-on exercises and student labs
  • Classes never cancelled due to low enrollment
  • Money-back guarantee

Onsite or Offsite Group Training

Cost: Based on number of students

  • For groups as small as 3 people
  • Class Held at our location or yours
  • Hands-on exercises and student labs
  • Customization at no extra charge
  • Six months of instructor email support
  • All-inclusive pricing
  • Money-back guarantee
Request Group Pricing Proposal

Course Duration

3 Days

What Students Receive

Each student will receive:
  • A printed 500+ page courseware manual for use during and after class containing numerous examples and hands-on exercises
  • A PC headset for communicating with the instructor and fellow students during the QlikView 11 Training Class
  • A course completion certificate upon successful completion of the QlikView 11 Training course
  • Six months of instructor email support
  • Free class retakes (forever!)

Course Description

Business Intelligence technologies are a must-have in every business to make informed decisions and keep up-to speed with the ever-evolving markets. QlikView’s disruptive technology makes it a key player and leader in the industry; with its flexibility and powerful analytics environment, building QlikView apps can be mastered by both business users as well as developers. In this QlikView Training course, students will learn QlikView development from a basic to a practitioner level using a step-by-step approach in a practical environment, and apply proven best practices on each topic. Throughout the course, students will complete hands-on exercises to build a real QlikView application based on actual data that will enable a company to make informed business decisions. The QlikView application will guide students to develop an application going from a simple proof of concept to creating a Data Model, adding a custom style, building a Dashboard and handling and manipulating the source data via script.

Course Objectives

After successful completion of this course, students will be able to:
  • Use techniques and best practices to transform data in QlikView via script
  • Load data from disparate sources to build an associative Data Model
  • Build robust data models and overcome common modeling challenges
  • Design data visualization objects to present performance measures with charts and tables
  • Use dimensions and expressions in QlikView objects
  • Utilize QlikView’s built-in aggregation functions to achieve complex calculations
  • Create Point In Time reporting and achieving complex calculations using Set Analysis
  • Use time-saving techniques for making your QlikView development more efficient

Course Audience

This course is designed for developers who are looking to learn a fast and easy way to develop business intelligence apps with QlikView. This course is also for power-users in a QlikView environment, who will learn quicker ways of working with QlikView. This course covers QlikView Desktop Personal Edition. Deployments to QlikView Server/Publisher are out of the scope of this course.

Course Prerequisites

Students should have some familiarity and/or experience with basic business intelligence terms and concepts.

Course Syllabus

  1. Meet QlikView
    • What is QlikView?
    • How does QlikView differ from traditional BI?
    • Associative user experience
    • Technology
    • Adoption path
    • Exploring data with QlikView
    • Getting QlikView
    • Navigating the document
    • Slicing and dicing your data
    • List-boxes
    • Selections in charts
    • Search
    • Bookmarking selections
    • Undoing selections
    • Changing the view
    • Cyclic Groups
    • Drill down Groups
    • Containers
    • But wait, there's more!
    • The technology and components behind QlikView
    • The way the data flows
    • When QlikView use expands
    • Create content
    • Reload, publish, and distribute content
    • Consume content
    • Hands-On Exercise: Meet HighCloud Airlines
  2. Seeing is Believing
    • What is a SiB?
    • Preparing the workspace
    • Setting up the folder structure
    • Creating the QlikView document
    • Creating the app
    • The requirements
    • Constructing the data model
    • What is a data model?
    • Loading the fact table
    • Playing with listboxes
    • Associating additional tables
    • Creating the dashboard tab
    • Creating and positioning the filters and user controls
    • Hands-On Exercise: Number of flights over time
    • One chart and multiple analyses with cyclic expressions
    • Adding a time drill-down group
    • Hands-On Exercise: Top 10 routes
  3. Data Sources
    • Using ODBC and OLE DB drivers
    • Installing the drivers
    • Accessing custom data sources
    • Third-party custom connectors
    • Reading table files
    • Extracting data—two hands-on examples
    • Extracting data from MS Access
    • Configuring the driver
    • Creating the OLE DB connection string
    • Querying the database
    • Reloading the script
    • The resulting data model
    • Loading a table file
    • Specifying the file attributes
    • The transformation step
    • Refining the input table
    • The resulting script
    • QVD and QVX files
    • QVD files
    • QVX files
    • Hands-On Exercise: Loading an Inline table
  4. Data Modeling
    • Dimensional data modeling
    • Back in the day
    • Relational databases and ER modeling
    • Dimensional modeling
    • The star schema
    • The snowflake schema
    • Creating the dimensional model
    • Dimensional models in QlikView
    • The associative data model
    • Guidelines for table associations
    • How associations are created
    • Avoiding data model conflicts
    • The Table Viewer window
    • Table information
    • Field information
    • Hands-On Exercise: Table preview
    • Table viewer menu
  5. Styling Up
    • Design requirements
    • The Document Properties window
    • The Sheet Properties dialog
    • Setting the object properties
    • Caption colors and style
    • Changing the caption colors
    • Setting the caption font
    • Setting the content font
    • Setting the global font
    • Propagating the object appearance
    • Setting the default Sheet Object Style
    • Hiding captions
    • Working with listboxes
    • Hands-On Exercise: Adding listboxes
    • The List Box Properties dialog
    • The General tab
    • The Expressions tab
    • The Sort tab
    • The Presentation tab
    • The Number tab
    • The Font tab
    • The Layout tab
    • The Caption tab
    • The Multi Box
    • The Current Selections Box
    • Making selections from the Current Selections Box
    • Adding a Bookmark Object
    • Aligning and resizing sheet objects
    • Selecting objects
    • Moving objects
    • Resizing objects
    • Resizing a Multi Box
    • Aligning sheet objects
    • Do a little house keeping
    • Hands-On Exercise: Creating and applying a default color map
    • Defining chart colors
    • Setting the default color map
  6. Building Dashboards
    • User types
    • Dashboard users
    • Analysts
    • Report users
    • Applying the DAR principle to Airline Operations
    • Document requirements
    • Creating the Analysis sheet
    • Hands On Exercise: Adding a new chart
    • Bar Chart
    • Additional bar chart properties
    • Expressions and the Edit Expression window
    • Expressions
    • The Edit Expression window
    • The Expression Overview window
    • Line Chart
    • Additional line chart properties
    • Combo Chart
    • Container
    • Scatter Chart
    • Button
    • Statistics box
    • Creating the new Dashboard sheet
    • Linked Objects
    • Gauges
    • Cloning the object for re-use
    • Hands-On Exercise: Adding Air Time %
    • More Gauge styles
    • Adding a Text object
    • Using a Text Object to display an image
    • Adding actions to a Text object
    • Adding a Pie chart
    • Dimension Limits
    • Adding the dimension value to the data point values
    • Hands-On Exercise: Creating the Reports sheet
    • Variables
    • The Expression Overview window in action
    • Copying sheets
    • KPIs per airline, origin, and destination country
    • Cyclic and Drill-down groups
    • Straight table
    • Not all expressions are numbers
    • Pivot tables
    • Auto minimize
    • The Report Editor window
    • Other charts
    • Radar Chart
    • Mekko Chart
    • Grid Chart
    • Funnel Chart
    • Block Chart
    • Trellis Chart
  7. Scripting
    • The Script Editor
    • Menu and toolbar
    • Script pane
    • Tool pane
    • Script statements
    • Building the aircraft dimension table
    • Loading the aircraft information
    • Adding the aircraft groups
    • Loading the second aircraft table
    • Making it all right
    • Manipulating tables
    • The JOIN statement
    • The KEEP statement
    • The CONCATENATE statement
    • The NOCONCATENATE statement
    • Using MAPPING tables
    • Adding comments
    • Storing tables
    • Hands On Exercise: Renaming tables and fields
    • Hands On Exercise: Deleting tables and fields
    • Setting variables
    • Controlling script flow
    • Conditional functions
    • Dealing with different data types
    • Strings
    • String operators
    • String functions
    • Numbers and numeric functions
    • Date and time functions
    • Debugging script
    • Syntax check
    • Saving logs to disk
    • The script debugger
    • Using breakpoints
    • Limited load
    • Tracing script
    • Standardizing and organizing script
    • Using tabs
    • Comments
    • Hands On Exercise: Adding an information tab
    • Script layout
    • Naming conventions
    • Table naming conventions
    • Field naming conventions
    • Re-using scripts
    • Subroutines
    • Including script files
    • Managing file locations and connection strings
  8. Data Modeling Best Practices
    • Data consistency
    • Dealing with dimensions without facts
    • An alternative approach
    • A solo exercise
    • Dealing with facts without dimensions
    • Reducing storage requirements
    • Using number-based key fields
    • Removing unused fields
    • Splitting high-cardinality fields
    • Design challenges of data modeling
    • Hands On Exercise: The Airline Employment statistics table
    • Concatenating fact tables
    • Structural asymmetry
    • Natural and forced concatenation
    • Concatenating the Employment Statistics table
    • Working with link tables
    • A link table example
    • Hands On Exercise: Creating a link table in the Airline Operations document
    • Finding a balance
    • The master calendar
    • A final note on data modeling
  9. Basic Data Transformation
    • Changing the source table structure
    • "Cleansing" a dirty table
    • File contents
    • Working with the Transformation Step wizard
    • The final result
    • Other transformation tricks
    • Hands On Exercise: Loading a Crosstable
    • A Crosstable example
    • Working with the Crosstable Wizard
    • A solo exercise
    • Expanding a hierarchy
    • A hierarchy example
    • Working with the Hierarchy Wizard
    • The tree-view list-box
    • Generic load
    • Hands On Exercise: Loading a generic table into QlikView