How To Take This Class

Course Overview

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 Prerequisites

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

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.

What You'll Learn

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 Duration

2 Days

Course Outline

  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

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!)