+44 20 3490 4211 | info@pradiconsulting.co.uk

Module 1 – Introduction to QlikView Overview

  • Patented In-Memory Associative Technology- What, How and The Power of simplicity
  • Representing Qlikview Solutions by Function
  • Architecture Overview- Diff b/w server and publisher
  • Qlikview Platform Overview
  • Products Overview-Qlikview Developer, Server and Publisher
  • What can you do with Qlikview? The sum of Five Capabilities which make Qlikview Unique.
  • 3 Kinds of Roles-Qlikview and the IT Pro, Qlikview and the Business Analyst/BI Developer, Qlikview and the Business User
  • Benefits of using Qlikview

Module 2 – How to create qvd file-By only Qlikview Desktop

  • Describe Table-Fields, Name
  • QVD File-Qlikview Data File
  • File Wizard: Options
  • File Wizard: Transforms
  • QVD only 90 MB, compress 90%, take GB of Data
  • Color in Qlikview and their relation to data Green-selected data, Gray-Non Associated, White-Associated. Power of Associativity
  • How Qlikview works

Module 3 – Object-Insert and Object Properties in Dashboard

  • Load qvd file
  • Internal Table View
  • New search object
  • Associated data, non-associated data
  • Clear the selection-automatically and manually both type
  • Sort data in list box properties
  • Document properties
  • Create bar chart-in chart y axes-expression axes, x axes-dimension axes, chart properties
  • Group- 2 types-Drill Down, Cyclic
  • Graph-Chart Properties
  • Setting-Variable overview-add variable
  • Input box properties
  • Load data from access database
  • Connections-2 types-ODBC, OLEDB
  • Use QlikView as reporting tool
  • Create select statement

Module 4 – File Wizard: Transform – Basic Transformation in Qlikview

  • Add data from CSV and Excel
  • File Wizard: Type
  • Quoting Types
  • Transformation Step
  • Conditional Delete
  • Fill Condition
  • Specify Row Condition
  • Unwrap Function
  • Rotate Function
  • Difference b/w Transpose and Left
  • File Wizard: Script
  • Inline Table-create inline table
  • Internal Table View
  • Dashboard Background-3 Regions
  • Document Properties-General, Opening, Sheets, Server, Scheduler, Variables, Security, Triggers, Groups, Tables, Sort, Presentation, Number, Scrambling, Extensions, Font, Layout, Caption
  • Chart Properties
  • Format Painter Tool
  • List Box Properties
  • User Preferences-General, Save, Editor, Design, Objects, Font, Expert, Printing, Mail, Locations, Security-Macro, License Tools-Alert
  • Sheet Properties
  • Expression Overview
  • Objects-Current Selection Box, New Statistics Box, New Button Object

Module 5 – Create Select Statement

  • Connection String
  • Select Statement: Create select statement
  • Problem Discussion
  • Fact Table-Explain
  • Load Statement

Module 6 – Dashboard Sheet

  • Dashboard created based on 3 principles-DAR
  • Analysis Sheet, Analysis Report
  • Sheet Properties
  • Object-Create Analysis Chart, Chart Properties, Minimize Chart
  • Object-Container-new container, container properties, container types
  • Linked Objects
  • List Box Properties
  • Different types of Chart – Scatter Chart, Bubble Chart, Gray Chart, Line Chart, Bar Chart, Pie Chart
  • Object-Text Object-New Text Object-Text Object Properties
  • Market Share
  • Dimension Limit Tab-new feature in version 11
  • New Input Box
  • Object-New Sheet Object-Bookmark Object
  • Report-Report Editor, Report Setting

Module 7 – Chart Properties & Scripting

  • Different types of Chart-Radar Chart, Maco Chart, Grid Chart, Funnel Chart
  • New Sheet Object-Chart-Block Chart
  • Load Statement-Load Inline-Inline Data Wizard
  • Match Function
  • Load-Aircraft Group, Aircraft Type
  • Load-Aircraft Base File
  • Editing in Script
  • Internal Table View
  • Table-Aircraft Group Table, Aircraft Type Table

Module 8 – Security & Access Types

  • Concept of Hidden Script, Create Hidden Script
  • Security Information-Section Access in Qlikview
  • Section types
  • Hidden Security, Types of Security
  • Inline Data Wizard, Load Inline Table
  • Section Access Script
  • Reduction in Data, Things to make Data Reduction work
  • Internal Table View
  • Best way to managing the section access & connection strings
  • Different Ways to declare variable
  • Master Calendar
  • Create singular master calendar table
  • Different ways to create master calendar, make a temp calendar
  • Period Field
  • Functions- DATE(), DATE#(), PEEK(), MonthStart(), AutoGenerate(), Quarter(), ceil(), Exists(), Aggregate, InternalMatch()
  • Create Aggregated Table
  • Transaction Table

Module 9 – Explain Table, Dimensions, Metrics & Pivot Table

  • Explain Table-Internal Match
  • How Qlikview Read Data from Table
  • Cross Table-3 Parameters-Qualifier Field, Attribute Field, Data Field
  • How to load a cross table
  • Explain-Internal Table View
  • Operational Metrics, List Box Color
  • Load Inline Function: Inline Data Wizard

Module 10 – Use of Temporary Tables & Explain Set Analysis its syntax and why it is used

  • Creation of new reports for users.
  • How to implement set analysis.
  • Explain making of line chart.
  • Explain set theory.
  • Use of flight domestic foreign carriers.
  • Explain flight type field.
  • Use of search string to find domestic values.
  • Use of excluded values.

Module 11 – Qlikview Server

  • Discussion & Problem Solve
  • QMC-Qlikview Management Console
  • Document Distribution