Qlikview Essentials

Harness the power of your data
Approved by Habanero Data
Qlikview
next available COURSE:
Duration :
5 Day/s
DURATION
5 Day/s
USD $
850
USD
$ 850
NGN ₦
400,000
NGN
₦ 400,000

Course Information

Everything you need to know

  • Course Syllabus
  • Your trainer
  • Key Information

Course Syllabus:

About the course: This 5 day intensive hands on course is ideal for beginners to QlikView. This course will provide a thorough introduction to QlikView through to more advanced topics such as advanced expressions, data transformations and data visualisation.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the QlikView.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Day 1

What is Qlikview?

  • Brief history and technical overview of Business Intelligence and Qlikview
  • The Qlikview Ecosystem
  • Qlikview Server
  • Qlikview Publisher
  • Qlikview Desktop

Getting Started with Qlikview

  • Download, install and open Qlikview
  • Getting Familiar with Qlikview Desktop Client
  • Features and components of Qlikview
  • Architecture
  • Report Interface
  • QVS, QVW and .log files
  • Sheet Objectst
  • Dimensions and Expressions
  • Presentation, Layout

Qlikview Basics

  • Download, install and open Qlikview
  • Start Qlikview 12
  • The Qlikview Start Page
  • Opening & Saving a document
  • Selections Stepping back or forward in list of selection
  • Locking and unlocking selections

 

Day 2

Overview of scripting

  • Introduction to scripting
  • Introduction to datasources
  • Text files, Excel, Access datasources
  • Connecting to your database

Data Modelling

  • Overview of the data model
  • Load and manipulate new data sources
  • Data load from Excel
  • Relationships in your data
  • Creating Inner Joins
  • Synthetic keys
  • Circular References
  • Qlikview Expressions
  • Qlikview Functions

Qlikview Data Files (QVD)

  • What is a QVD File?
  • Modes of QVD Files – Optimised and Unoptimised loads
  • Role of QVD File in Qlikview Architecture
  • How to create a QVD file
  • QVD File Loader script
  • Using QVD Files
  • Advantages of using QVD files

Master Data Calendar

  • What is a master data calendar?
  • How to create a master data calendar

Day 3

Qlikview Security

  • Understanding Qlikview security
  • Authentication and Authorization
  • Security Architecture
  • Security using Qlikview Publisher
  • Access Levels
  • Row Level Security

Qlikview Sheets and Object

  • What is a Qlikview Sheet
  • Navigating in a Qlikview Sheet
  • Qlikview Sheet and Object Association

Boxes

  • The List Box
  • Statistics Box
  • Multi Box
  • Table Box

Charts

  • Overview of Qlikview Charts
  • Bar Chart
  • Pie Chart
  • Combo Chart
  • Line Chart
  • Other Chart Types

Our international certified trainers are highly experienced QlikView practitioners who have real-world expertise. Our trainers will be able to give you the answers you need.

I – All course material including a copy of QlikView 11 for developers will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed QlikView

III – Lunches and refreshments are provided inclusive of the cost. Wi-fi and access to spaces to take private calls are also available.

IIII – Our training venue is based in Lagos (Specific venue will be emailed on confirmation of a place on the course)

For more information on our training, please enquire using the form above or call +2348103382376

Qlikview Essentials

Contact Our Team Today!








    What's Included

    Find out what’s included in the training programme.
    COURSE MANUALS
    REFRESHMENTS
    INSTRUCTOR

    Delivery Options

    Everything you need to know

    CLASS ROOM TRAINING
    ONLINE TRAINING
    ONSITE TRAINING

    Course Schedule

    Find out the next available dates

    Qlikview Essentials

    Available Dates

    Available Places

    Book or Enquire

    September 20, 2021

    Abuja, Accra, Addis Ababa, Freetown, Kigali, Lagos, Nairobi

    We are happy to help

    Call our team today on +2348103382376 or email training@habanerodata.net

    We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.