QLICKVIEW

QLICKVIEW Course Overview

Online Guru Technologies’s QLICKVIEW training running with industry experts  according to industry requirements and demands.

This training helps you crack the interview and clear the certification as well.

Here you will get all class videos lifetime access.

Even after completion of course 24/7 support is provided for clearing interviews and certification.

By the end of the course a separate class is scheduled for interview questions and answers.

Online Guru Technologies will provide a platform to work for real time projects.

  • QlikView Overview and Walk – through (1hr)
    • How does QlikView differ from traditional BI?
    • Associative user experience.
    • Exploring data with QlikView.
    • Slicing and dicing your data.
    • Search
    • Bookmarking selections.
    • Cyclic Groups.
    • Drill down Groups.
  • Creating an app (1 hr)
    • The requirements
    • Constructing the data model
    • Loading the fact table
    • list-boxes
    • Associating tables
    • Creating the dashboard
    • Cyclic and drill-down groups

 

  • Data Sources (2 hrs)
    • Using ODBC and OLE DB drivers
    • Accessing custom data sources
    • Third-party custom connectors
    • Reading table files
    • Extracting data
    • Reloading the script
    • The resulting data model
    • The transformation step
    • Refining the input table
    • The resulting script
    • QVD and QVX files
    • QVD files
    • QVX files
    • Loading an Inline table
  • Data Modelling (2 hrs)
    • Dimensional data modelling
    • Back in the day
    • Relational databases and ER modelling
    • The star schema
    • The snowflake schema
    • Dimensional models in QlikView
    • The associative data model
    • Guidelines for table associations
    • How associations are created
    • Avoiding data model conflicts
    • The Table Viewer window
  • Designing (2 hrs)
    • Document Properties
    • Sheet Properties
    • Object Properties
    • Basic objects (Listbox, Multibox, Current Selection Box, Bookmarks)
    • Object Customizations
  • Building Dashboard (2 hrs)
    • Building Bar Charts, Line Chart, Multi Chart, Combo Box, Container, Scatter Chart, Button, Statistics Box
    • Linked Objects, Gauges, Text Object, Pie Chart.
    • Variables
    • Other Charts – Radar, Mekko, Grid, Funnel, Block, Trellis
  • Scripting (4 hrs)
    • Script Editor
    • Script Statements
    • Table Operations
    • Controlling script flow
    • Conditional Functions
    • Debugger
    • Code Standardization
    • Subroutines and Includes
    • Managing Environments & Connection Strings
  • Data Modelling – Best Practices (4 hrs)
    • Data Consistency
    • Reducing Storage requirements
    • Concatenating Facts and Link Tables
    • Master Calendar
  • Basic Data Transformation (2 hrs)
    • Changing Source Table Structure
    • Cleansing
    • Loading Cross Table
    • Expanding a hierarchy
  • Advanced Expressions (2 hrs)
    • Input box and Slider Objects
    • Total Qualifier
    • Aggr Function
    • Conditional Functions (If, Pick, Class Etc)

 

  • Set Analysis (Point in time reporting) (4 hrs)
    • Magic of Set Analysis
    • Point in time reporting
    • Comparative analysis with alternate states
  • Advanced Data Transformation (4 hrs)
    • Data Architecture
    • Peek Function
    • Slowly Changing Dimensions(SCD)
    • Use Case
    • Incremental Loads
  • Security (1 hr)
    • Section Access
    • Data reduction and omitting fields
    • Document and Sheet level security.
  • Advanced Topics (4 hrs)
    • Qlikview Publisher and Server
    • CALS
    • Access Point
    • Nprinting Report – Building and distribution
    • Introduction to Sense
    • Version Controlling
  • Get interview ready (10 hrs)
    • Tips and Tricks
    • Common Interview Questions
    • Minor Projects
    • One Major Project

Online Guru Technologies conducting QLICKVIEW demo Classes with Industry experts for clarifying doubts and knowing about course, for attending free demo session Click on the “Schedule Free Demo Session” and Fill the form. Our representative will call you back and they will fix demo session timings according to your convent timings

The Demo sessions are conducting every day 1 Hour Session, the demo session conducting by real-time working professionals.

Call us on +91 - 9886508358

Training class hours – 45


All classes recorded videos


Lifetime access videos


Project classes hours – 10


Everyday support

Related Courses

QLICKVIEW DEMO SESSIONS

7:00 AM-10:00AM - MON TO FRI


7:00 AM-10:00AM - SAT & SUN


CONTACT US


×
WhatsApp chat