BUSSINESS INTELLIGENCE - QLIK

Overview

Qlik enables your business users to discover insights within your data that can transform your business. Make business-driven data discoveries with guided analysis paths that are highly customizable and tightly governed, whether working at a desktop or on mobile devices. Proven by thousands of organizations worldwide, Qlik helps you drive faster response to changing business requirements, shorter time to value, and collaboration to spread greater insight across your organization.

Duration

Course Duration : 40 hrs. (Theory & Practical)
Training Options : Classroom /Online
Back end Language : .NET

PREREQUISITES

Basic knowledge in Data Warehousing DWH Concepts will help you to learn the tool easily

TOPICS COVERED
I. INTRODUCION

What is Qlik? Why Qlik?

  • Unique Features compared to Traditional BI Tools
  • Complete Data warehousing Basics
  • Qlik Products
II. PROOF OF CONCEPTS
  • Loading multiple data sources
  • Relational Databases
  • Data Source Files like Excel, CSV, and Txt etc.
  • Creating folder structure
III. STYLING UP
  • Properties of sheet objects, document, list boxes
  • Objects in Qlik
  • Front end Visual design
  • Setting background frames
  • Font, Colors, Image setting
IV. DATA MODELING
  • Introduction to Scripting
  • Function in Qlik
  • Creating calculated fields in script
  • Joins, keep, concatenate
V. CREATING DASHBOARD
  • Visualization for KPI's (Key Performance Indicator)
  • Charts in Qlik
VI. DATA TRANSFORMATION
  • Cleansing dirty data
  • Cross tab
  • Hierarchy
  • Generic function
VII. SECURITY
  • Document Level security
  • Sheet Level security