Login

OTP sent to

QlikView

Home > Courses > QlikView

QlikView

QlikView

Duration
45 Hours

Course Description


        QlikView is a business intelligence and data visualization tool that allows users to create interactive dashboards and applications for exploring and analyzing data. It's known for its associative engine, which enables users to freely explore relationships within data, and its ability to handle large datasets through data compression and direct connections to data sources. 

Course Outline For QlikView

1. Introduction to QlikView and business intelligence

  • Understanding Business Intelligence (BI) concepts, their importance, and the role of data analysis in organizations.
  • Introduction to QlikView, its unique features, architecture, and components.
  • Comparing QlikView to traditional BI tools and other BI tools.
  • Overview of QlikView file types (.qvw, .qvd, .qvs). 

2. Data loading and scripting

  • Connecting to Data Sources: Establishing connections to various data sources like databases (ODBC/OLE DB), Excel files, delimited files, XML files, and web files.
  • QlikView Scripting: Understanding the QlikView scripting language for data extraction, transformation, and loading.
  • Script Editor Features: Using the Script Editor to write, edit, debug, and manage scripts, including menus, commands, and options like commenting, indenting, and syntax checks.
  • Loading Techniques: Exploring different load types: inline load, resident load, binary load, mapping load, and incremental load.
  • Advanced Scripting: Working with script-level functions, expressions, variables, and parameters.
  • QVD Files: Understanding QVD file format, its uses for optimized data storage, and creating/managing QVDs. 

3. Data modeling and transformation

  • Data Warehousing Concepts: Understanding OLTP vs. OLAP, data warehouse architecture (staging, dimensions, facts), and schemas (star and snowflake).
  • Dimensional Modeling: Designing data models using dimensional modeling principles.
  • Data Transformation: Performing basic and advanced data transformations like renaming fields, applying script expressions, handling null values, changing date formats, concatenating tables, and resolving synthetic keys and circular references.
  • Table Viewer: Understanding and using the Table Viewer to visualize data model structure and relationships.
  • Master Calendar: Creating a master calendar for time-based analysis. 

4. QlikView development and user interface design

  • Sheet Objects: Creating and working with various sheet objects: list boxes, table boxes, multiboxes, input boxes, text objects, buttons, and charts.
  • Chart Types and Properties: Designing different types of charts (bar, pie, line, pivot, straight, gauge, radar, Mekko, block, funnel, scatter, grid, mini) and customizing their properties.
  • Dashboard Design: Creating interactive dashboards, implementing layout, and applying design best practices for user-centered workflows.
  • Expressions and Calculations: Working with chart-level and script-level functions and expressions.
  • Set Analysis: Understanding and applying Set Analysis for advanced filtering and calculations. 

5. QlikView server and administration

  • QlikView Server Architecture and Configuration: Understanding QlikView Server architecture, installation, configuration, and management.
  • QlikView Management Console (QMC): Using QMC for managing documents, tasks, users, and licenses.
  • QlikView Publisher: Understanding the Publisher's role in distributing documents, scheduling reloads, and handling looping and reduction.
  • Security Management: Implementing QlikView security features, including Section Access for data reduction, authentication, authorization, and managing user access.
  • Deployment and Administration: Deploying applications, managing licenses, and performing server administration tasks. 

6. Advanced topics and best practices

  • Performance Tuning: Optimizing data models, scripting, and applications for better performance.
  • Troubleshooting: Identifying and resolving common issues in QlikView applications.
  • Integration: Exploring integration with other tools and platforms (e.g., QlikView with Big Data Hadoop).
  • Real-Time Projects and Case Studies: Working on practical projects to apply learned skills and solve real-world BI challenges. 
Enquire Now