Qlikview Online training India hyderabad|Qlikview training for Low cost-price

1
(No Transcript)
2
(No Transcript)
3
A Brief History of QlikTech

• Founded in Lund, Sweden in 1993 by Björn Berg and
  Staffan Gestrelius originally as a consultancy
• Originally called QuikView as in Quality,
  Understanding, Interaction, Knowledge
• Product was designed to mimic the way the brain
  works
• A key aspect was the colour-coding scheme whereby
  selected values are highlighted in green, linked
  values in white, and excluded values in
  highlighted grey
• First two versions were basically written in
  Excel using VLOOKUPs
• Håkan Wolgé was later hired as lead software
  engineer to re-architect/re-write QlikView from
  the ground up as an in-memory application
• Renamed as QlikView in 1996
• IPOed on Nasdaq in 2010 under symbol QLIK and
  had 7th best IPO of 2010
• Now has over 24,000 customers in 100 countries
  and employs over 1,000 people worldwide
• Market cap 2.5 billion

4
How Traditional BI tools works

• Traditional OLAP/cube technologies primarily
  provide the ability to drill up and down through
  dimension hierarchies, allowing the end-user to
  see pre-aggregated measures
• Dimensions and measures must be know a priori
• A small team is usually required to complete a BI
  project
• A data warehouse or data mart is usually required
  as a pre-requisite before OLAP cubes can be built
• This can often lie on the critical path of other
  data warehouse projects. Since data warehouse
  usage cannot be anticipated, a single version of
  the truth can often bog down development
• ETL is very slow to test, which in turn slows
  down development time
• If a detail drill down report (e.g. to see all
  point-of-sale records), a drill through query
  link is made to the operational data store to
  retrieve these data
• Introduces another point-of-failure
• Associations between dimensions are not computed
  only resulting measures (e.g. counts)

5
How QlikView works (contd)

• The secret sauce is An experienced QlikView
  can build and test a dashboard solution
  (including user acceptance testing) faster than
  any other BI tool I have evaluated
• This makes Agile BI possible
• Users and developers can remain focused on
  insights and outcomes
• The resulting dashboards are effectively
  by-products of the analysis process
• More flexible data model allows normalized data
  to be imported with fewer transformations
• ETL development is in-memory. ETL jobs can be
  tested orders of magnitude faster than
  traditional ETL tools
• All data is automatically profiled on import
• QlikView uses the word associative to
  distinguish itself from other BI vendors
• Associative is a tricky concept to explain, but
  most people will get it when they see it
• Associative puts emphasis on understanding how
  sets of data relate to one another
• All those tricky SQL queries involving NOT
  EXISTS or LEFT/RIGHT OUTER JOIN are but a
  mouse click away

6
How QlikView Works

• QlikView uses the word associative to
  distinguish itself from other BI vendors
• Associative is a tricky concept to explain, but
  most people will get it when they see it
• Associative puts emphasis on understanding how
  sets of data relate to one another
• All those tricky SQL queries involving NOT
  EXISTS or LEFT/RIGHT OUTER JOIN are but a
  mouse click away

7
Traditional BI workflow
8
QlikView workflow
9
What is Agile BI/Agile Analytics

• Fulfills the promise that Agile Software
  Development failed to
• Very little software development is truly green
  field/blue sky
• Functional requirements are inflexible
• Once a shared data architecture is in place,
  impact analysis must be performed, breaking the
  Agile methodology. Basically all Agile brings to
  the table is improved UX (User Experience), since
  presentation layers are the only thing that can
  quickly be modified without extensive impact
  analysis
• Agile BI is not about software. Its about
  business insights and business outcomes
• Dashboards are a by-product of Agile BI
• Agile BI iterations are typically bi-daily, with
  a single Agile BI developer/analyst performing
  all technical functions
• A separate warehouse is not required, a single
  version of the truth, and other data quality
  issues should not always be a roadblock
• Occasionally specialized tools are required (e.g.
  fuzzy matching, cluster discovery, etc.)

10
QlikView Demo Time
11
How Does QlikView Work Internally? (Contd)

• QlikView does not reveal the specifics of its
  inner workings. However, the following gives us
  clues
• From Curt Monashs DBMS2 blog The main
  ingredient of the performance secret sauce in
  QlikView is that selections are compiled straight
  into machine code. (QlikTech gave me the
  impression that this post is the first time that
  will be publicly revealed.)
• We can also look at their main patent, with Håkan
  Wolgé listed as the inventor. This is the first
  part of their first, and most important claim.
  Note, the final multi-dimensional cube

12
How Does QlikView Work Internally?

• At the centre of QlikView is a large
  Multi-Dimensional Cube Table, with one column
  for each table, and each row containing pointers
  back to the original tables row index
• Also uses a Global Symbol Table Value Tables
  and Data Tables
• The machine code most likely refers to bitmap
  indexes. QlikView heavily relies on bitmap
  indexes to perform its JOINs
• QlikView may have the best known solution to
  Kimballs Big JOIN problem (JOINing a billion
  dimensions with a trillion facts), since a single
  row is effectively being represented by a single
  bit
• Consider that a 64 rows can be JOINed in less
  than a clock cycle
• Intel and AMD now support Active Vector
  Extensions (AVX), which will allow 256 rows to
  be JOINed in less than a clock cycle
• Unclear if this architecture lends itself to
  map/reduce
• The embedded example shows in detail how the
  indexes work

13
Criticism of QlikView

• QlikView is the biggest threat to established BI
  vendors. Not surprisingly, there is more
  criticism directed to QlikView than any other
  product.
• Some criticism is valid, but most of it either
  misunderstands the product or distorts the truth
• Criticism 1 You cant fit very much data in
  memory
• Used to be true. When when 32-bit OSes were the
  norm, upper limit of 20 GB uncompressed data
• Now I can buy an HP Integrity Superdome 2 /w 4 TB
  RAM, and load 40 TB of uncompressed data about
  a years worth of call-detail-record data for a
  major Canadian telecom
• Criticism 2 QlikView forces you to rename
  foreign and/or primary key columns to be the same
• This is true, QlikView relies on Natural Joins.
  This is what you what you want as it leads to a
  more intuitive or Natural user experience. The
  effort to rename columns is negligible
• Criticism 3 QlikView stores data in proprietary
  files
• QlikView now supports an open QVX format with a
  published spec and SDK
• Third party tools (e.g. Expressor an ETL tool)
  integrate with the QVX format

14
Novel Features of QlikView (3rd party
visualization platform)

• 3rd party Visualization platform allows 3rd party
  developers to develop custome extensions

15
Novel Features of QlikView (3rd party
visualization platform)

• Associative Experience (already discussed)
• Advanced Excel transformations. Allows quick
  prep of Excel data. E.g. filling in merged cells
• AND/NOT selections (as opposed to OR)
• Semantic model support
• Define relationship and inverse relationship.
  E.g. locale all predecessors and successors
• Collaborative BI. Similar to two-way desktop
  sharing or Google Docs sharing.
• Can be done through web browser with no client
  plug-in required.
• Client-side data access
• Can access and analyze Google Analytics data via
  client browser, simplifying security
• Metadata can be imported and linked to attributes

16
QlikView Competition

• Only true competitor is Microsoft Power Pivot
• Available as free plug-in for Excel 2010 and can
  be deployed in SharePoint 2010
• Started as Project Gemini, which was announced 21
  months in advanced the farthest out for any MS
  project
• MS has done their best to mimic QlikViews
  associative experience
• Will now be rolling out Power View as part of
  SQLServer 2012 SSRS
• Other vendors have greatly simplified the
  cube/OLAP approach, and can be considered
  somewhat Agile, although they lack the
  Associative experience. Primarily
• Tableau
• TIBCO SpotFire
• Many vendors have jumped on the in memory
  bandwagon, but ultimately have just moved their
  existing cubes in memory effectively just
  speeding up user interaction, but offering
  nothing new in terms of user experience or
  development timelines
• Some big data analytical DB vendors (e.g. SAP
  HANA) are feigning competition with QlikView
  but none of these get to the last mile of user
  experience

17
QlikView blindspots

• Raw calculation engine has never been completely
  exposed
• It is possible to integrate QlikView server
  objects into other web applications (e.g.
  SharePoint)
• It is also possible use client-side JavaScript to
  extract data from charts
• However there is no pure data interface into
  QlikView, apart from the QVX interface, which is
  not the same

18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
Contact Information

• Website www.rvhtech.com
• Email Id info_at_rvhtech.com
• Contact No 918790137293