Duration
2 days
What you'll learn
- Build robust data models and overcome common modeling challenges
- Discover the techniques and best practices to transform data in QlikView via scripts
- Load data from disparate sources to build an associative Data Model
- Present performance measures with charts and tables
- Find out how to use dimensions and expressions in QlikView objects
Outline
Overview of QlikView
- Introducing QlikView
- Exploring Data with QlikView
- The Technology and the Components Behind QlikView
- What Is New in QlikView 12 for Developers?
Seeing is Believing
- Preparing the Workspace
- Preview
- Creating the App
- Creating the Dashboard Tab
Data Sources
- Using ODBC and OLEDB Drivers
- Preview
- Extracting Data – Two Hands-On Examples
- Loading a Table File
- Working with QVD and QVX Files
Styling up
- The Table Viewer Window
- Understanding and Changing the Sheet’s Properties
- Setting the Object Properties Working with Listboxes
- The Current Selection Box
- Aligning and Resizing Sheet Objects
- Creating and Applying a Default Color Map
Building Dashboards
- User Types
- Creating the Analysis Sheet
- Creating the New Dashboard
- Creating the Report Sheet
Scripting
- The Script Editor and Script Statements
- Manipulating Tables
- Dealing with Different Data types
- Debugging Script
- Standardizing and Organizing Script
- Re-Using Scripts
- Managing File Locations and Connection Strings
Programme scope, delivery arrangements and suitability are confirmed during enquiry.