QlikView Training for Designers

How To Take This Class

Live Instructor-Led Online Class

Cost: $750.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

2 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 Training Class
  • A course completion certificate upon successful completion of the QlikView Training course
  • Six months of post-class 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 for Designers 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 and building a Dashboard.

Course Objectives

After successful completion of this course, students will be able to:
  • 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 designers and business analysts 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