Transcription

QlikView(Next Generation Business Intelligence)Course ContentPrivate and ConfidentialDocument TitleVersionDocument Ref. No.AuthorsReviewerQlikView - Course Content1.0ICL/CC/QlikView/2014KDMPDistribution Date01st June 2014 iClarity IT Services 2014Disclaimer:All rights reserved. No part of this document may be reproduced, stored in a retrieval system ortransmitted in any form or by any means, electronic, mechanical, recording, photocopying orotherwise outside of iClarity IT Services. (Hereinafter referred to as iClarity) without the priorpermission of iClarity.Office No. 1 / 2, Ground Floor Lavina Building, Ghantali Cross Road, Vishnu Nagar, Naupada, Thane - 400 602Phone: 91-22-25349532 Email: [email protected] Web: www.iclarity.in

TABLE OF CONTENTSQlikView for business-users . 3 QlikView Basics .3 Navigating in QlikView - General .3 Navigating in QlikView - Specific .3 QlikView Advanced .3 What You Will Learn .3QlikView for Developers - Basic . 4 Introduction to QlikView .4 QlikView architecture blocks .4 Scripting - Basics .4 Data modelling .4 QlikView Objects - Basics .4 Settings & Reports .4 Installing QlikView and Understanding Licensing Policy .4 QlikView Server .4 Exercise: Develop your own QlikView application .4QlikView for Developers - Advanced. 5 Scripting - Advanced .5 Data Modelling - Advanced.5 QlikView Objects - Advanced .5 Types of Loads - Advanced .5 Set Analysis - Advanced .5 QlikView Security - Advanced.5 What’s New? .5 Exercise: Enhance your own QlikView application .5iClarity IT Services(Private & Confidential)Page: 2 of 5

QlikView for business-users(Duration 4 hours Theory 4 hours Lab)Who should attend: Business users keen to analyze data on their own without IT team’s help QlikView Basics What is Business IntelligenceWhat is QlikViewHow is QlikView different fromTransactional systems (ERP)How is QlikView different fromtraditional BI toolsBrief overview of architecture and InMemory associations.QlikView Basicso QlikView terminologyo QlikView Chart types Navigating in QlikView - Specific Navigating in QlikView - General QlikView Selections: Understandingthe Green, Gray and WhiteUnderstanding Associative SearchStepping back or forward in the list ofselectionsLocking/Unlocking selectionsMaking multiple selectionsSearching valuesSend to Excel-Print PDFSetting bookmarksUnderstand Drilldown group andCyclic GroupsDifferent Modes of accessingQlikView: Desktop / Web: AJAX /Web: Plugin.Analyzingrelevantdashboards as exampleQlikView QlikView Advanced Access point detailsCollaborationo Session Sharing &o Annotations What You Will LearnBy the end of this training, you will be able to: Navigate and find your way around in a QlikView applicationRecognize the most common QlikView objects and how to interact with themMake selections in QlikViewSlice, dice and analyze data with little or no guidanceGet a fair understanding of QlikView as a productQlikview ExtensionsQlikview PublisherReduction (Loop and Reduce)EDX TasksGovernance dashboardsAs of TablesiClarity IT Services(Private & Confidential)Page: 3 of 5

QlikView for Developers - Basic(Duration 20 hours Theory 30 hours Lab)Prerequisites: Good SQL basics, flair for analyzing data and generating meaningful information Introduction to QlikView QlikView Objects - BasicsGeneral data warehousing conceptsWhat is Business IntelligenceSample QlikView demo Applicationo View from end-user perspectiveUnderstand the DAR methodology QlikView architecture blocks Developmento Load Scripto In-memory Data Modelo Platform engineo Clientso SecurityDeployment Scripting - Basics Script Editing - Toolbar/EditorLoading data into QlikViewo Inlineo ResidentLoad data from Excel, CSV andDatabaseWhat is a QVD file, how to create itWhy should you use QVD filesBeware of natural concatenation Data modelling Understand what are facts anddimensions in BI parlanceWhat is the difference between aStar and a Snowflake SchemaUnderstand QlikView associationsWhat are Synthetic keysWhat is a Circular Reference (looselycouple tables)Table Viewer (Internal & Source)What is a preceding loadiClarity IT ServicesUnderstand Human behavior andeffective ways of designing a UISheet Basicso List Boxo Table Boxo Multi Boxo Text Objectso Statistics Box Objectso Current Selection boxo Slider /Calendar BoxCreating Chartso Bar Charto Pie Charto Line Charto Pivot Chart/Straighto Bar Chart Settings & Reports Documents SettingsSheet PropertiesUser PreferencesCreating Reports Installing QlikView andUnderstanding Licensing Policy How to install QlikView and applylicensesNamed CalsDocuments Cals QlikView Server QlikView Management Consoleo Configuration and settingsQlikView Access Pointo Configuration and settings Exercise: Develop your ownQlikView application(Private & Confidential)Page: 4 of 5

QlikView for Developers - Advanced(Duration 20 hours Theory 30 hours Lab)Prerequisites: Good QlikView and SQL basics, aspiring QlikView developers and BI professionals whowant to switch from traditional BI to the modern visualization and data discovery world Scripting - Advanced Types of Loads - AdvancedUnderstand script best practicesAdding field tags, commentsUnderstand several script functions:- Join and keep - AGGR- Exists- Qualify- Peek- Auto Number- Dual- Interval Match- Apply Map- TotalStandard calendar generation scriptDebugging & Tracing and TroubleShooting Data Modelling - Advanced Handling multiple fact tablesWhat are Link TablesWhen to use Link TablesHow do I create Link TablesUnderstand Data islands Set Analysis - Advanced Container objectsVariables, Input boxButtons: Actions, TriggersConditional optionso Display condition on a charto Enablement of Dimensions andExpressionso Display of chartsEnabling Design View optionsiClarity IT ServicesMapping loadBundle loadBuffer loadGeneric loadHierarchy() loadPartial loadIncremental loadBinary LoadUsing Dollar ExpansionWhat is Set AnalysisParts of Set AnalysisUsing Set Analysis in expressions QlikView Security - Advanced QlikView Objects - Advanced Implementing section access togrant role based access to dataHidden ScriptData reduction based on user.Data Hiding based on user.Tab Security using Section AccessObject Security using SectionAccess What’s New? Comparative analysis using alternatestatesQlikView Direct discovery Exercise: Enhance your ownQlikView application(Private & Confidential)Page: 5 of 5