028 3824 5819 traincert@tdt-tanduc.com
Tiếng ViệtEnglish

QlikView for Developers

QlikView for Developers

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.

This course will help you 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, we will build a QlikView app based on real data about Airline Operations that will help "HighCloud Airlines" make informed business decisions and analysis-guided strategies. HighCloud Airlines executives are evaluating if entering the US market is a good strategy and, if so, which line of business should they focus their investments on; they need QlikView to make the best decision.

The application will be evolving chapter by chapter, along with your skills, 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. We will meet the "HighCloud Airlines" requirement by using many different data visualization objects and time-saving techniques.

This course is aimed at developers and power users who want to learn how to develop Business Intelligence applications with QlikView. Developers who have already been using QlikView for some time may find that this course contains useful tips and best practices to make more effective use of QlikView.

·         Learn the techniques and best practices to transform data in QlikView via script

·         Loading data from disparate sources to build an associative Data Model

·         Building robust data models and overcoming common modeling challenges

·         Designing data visualization objects to present performance measures with charts and tables

·         Learn to use dimensions and expressions in QlikView objects

·         Utilise QlikView’s built-in aggregation functions to achieve complex calculations

·         Creating Point In Time reporting and achieving complex calculations using Set Analysis

·         Creating a consistent and interactive user interface

·         Ensuring your QlikView applications and data are protected

·         Constructing a data architecture that supports scalable QlikView deployments

  • Learn time-saving techniques for making your QlikView development more efficient

Module 1: Meet QlikView

·         What is QlikView?

·         Exploring data with QlikView

·         The technology and components behind QlikView

·         Meet HighCloud Airlines

·         Summary

Module 2: Seeing is Believing

·         What is a SiB?

·         Preparing the workspace

·         Creating the app

·         Summary

Module 3: Data Sources

·         Using ODBC and OLE DB drivers

·         Accessing custom data sources

·         Reading table files

·         Extracting data—two hands-on examples

·         QVD and QVX files

·         Loading an Inline table

·         Summary

Module 4: Data Modeling

·         Dimensional data modeling

·         The associative data model

·         The Table Viewer window

·         Summary

Module 5: Styling Up

·         Design requirements

·         The Document Properties window

·         The Sheet Properties dialog

·         Setting the object properties

·         Working with listboxes

·         The Multi Box

·         The Current Selections Box

·         Adding a Bookmark Object

·         Aligning and resizing sheet objects

·         Creating and applying a default color map

·         Summary

Module 6: Building Dashboards

·         User types

·         Applying the DAR principle to Airline Operations

·         Creating the Analysis sheet

·         Creating the new Dashboard sheet

·         Creating the Reports sheet

·         Other charts

·         Summary

Module 7: Scripting

·         The Script Editor

·         Script statements

·         Conditional functions

·         Dealing with different data types

·         Debugging script

·         Standardizing and organizing script

·         Re-using scripts

·         Managing file locations and connection strings

·         Summary

Module 8: Data Modeling Best Practices

·         Data consistency

·         Reducing storage requirements

·         Design challenges of data modeling

·         The master calendar

·         A final note on data modeling

·         Summary

Module 9: Basic Data Transformation

·         Changing the source table structure

·         Summary

Module 10: Advanced Expressions

·         Using variables

·         Using the TOTAL qualifier

·         The Aggr function

·         Conditional functions

·         A tip on copying expressions

·         Summary

Module 11: Set Analysis and Point In Time Reporting

·         The magic of Set Analysis

·         Point In Time Reporting

·         Comparative analysis with alternate states

·         Always validate

·         Summary

Module 12: Advanced Data Transformation

·         Data architecture

·         Loading data already stored in QlikView

·         Aggregating data

·         Sorting tables

·         The Peek function

·         Merging forces

·         Dealing with slowly changing dimensions

·         Ordering, peeking, and matching all at once

·         Incremental loads

·         Summary

Module 13: More on Visual Design and User Experience

·         Creating a consistent QlikView UI

·         Additional interactivity

·         Summary

Module 14: Security

·         Hidden script

·         Section access

·         Document-level security

·         Sheet-level security

·         Summary

Thời lượng: 04 ngày

Các khóa học liên quan
KH 2
KH 3
KH 5