bi & analytics in action using qlikview

PowerPoint Presentation

BI & Analytics in Action using QlikViewWelcome to the webinar onPresented by

&

Contents1.Introduction to QlikView2.Why QlikView differs from traditional BI?3.QlikView Architecture4.Getting Started with QlikView5.QlikView Demo

Introduction To QlikView

QlikTech A New Kind of Software CompanyU.S.-based company, founded 1993 in Sweden25,000 customers in 100 countries1,400 global partners1,100+ employees across 28 offices in 23 countriesNASDAQ: QLIKChange Their World Grant and Philanthropic Programs

Customer Growth1,5002,2395,4367,30610,58513,02425,00018,000

Broad Base of 25,000 Customers

4QlikTech is a whole new kind of software company.

Our QlikView Business Discovery platform solves critical business problems for companies of all sizes, including some of the largest global enterprises.

It delivers true self-service BI that empowers business users and drives innovative decision making.

Its generating significant results for users worldwide.

The proof is that QlikView users are the most successful and satisfied in the industry.

Thats why QlikView has been adopted at more than 25,000 customers.

A lot of people ask us Why does QlikView have so much market traction and growth?

Its because we take a totally different approach to BI.

Think about Google.

They simplified the process of searching information for hundreds of millions of consumers.

Like Google, QlikView has simplified accessing and analyzing business information.

Mobile Devices

Search

Innovations Are Remaking Markets

BI

SIMPLICITY

SIMPLICITY

SIMPLICITY

PageRankSearch

iPhone/iPad

Business Discovery

QlikTech: Simplifying Analysis for EveryoneA wizard-driven application development environment with fully integrated Extract-Transform-Load (ETL) tools

Faster and more efficient than "pre-packaged" OLAP-based BI solution

A powerful Real-time Analysis engine that allows for unconstrained drill-down

A highly intuitive, easy-to-use user interface

Develop and deploy applications tailored to your specific business and data requirements

6

QlikView: Gartner BI Magic Quadrant LeaderConsolidating relevant data from multiple sources into a single applicationExploring the associations in your dataEnabling social decision making through secure, real-time collaborationVisualizing data with engaging, state-of-the-art graphicsSearching across all datadirectly and indirectly.

201120122013

Why QlikView differs from Traditional BI?

QlikViews Core Technology: The BasicsEasily consolidates multiple data sourcesLoads all data into memory (millions of rows)Massive (10-to-1) data compressionEnables real-time associative search and analysisConnectors to applications like SAP and Salesforce.com

QlikViews Associative Experience Puts Users in ControlRegionStateProductSales Person

IT DrivenLinear, pre-defined thinkingInsights missed in hidden dataMonths to changeData-centricUser DrivenUser decides where to startAll data, always visibleMinutes to changeInsight drivenTraditionalAssociative

Region

Product

StateSales Person

QlikView Shows You Whats Associated - and NotSelections: greenUnassociated: grayAssociated: white

QlikViews Core Technology: The Secret SauceMaintains associations in the data automaticallyCalculates aggregations on the fly as needed

DatabaseCustomerProductVendorKateShirtsCascadeJimPantsCascadeJimPantsDillonJoeSocksAcmeJoeShirtsAcme

QlikView File StructureHow Is The Data Stored? QlikView ApproachHow Does QlikView Do it?

QlikView extracts the requested data from the source and retains the metadata that describes the relationships between the various data elements. The data is fully normalized (i.e. each data value is only stored once), resulting in a memory requirement that is 5-15% of the original data sources size.The data is stored in its own file which resides in memory (RAM) during runtime. Why Is This Better?Increased performance because all calculations are done in memory without reading from disk

You do NOT have to predefine hierarchies (i.e. cubes)

You empower your end users to drive their analysis needs rather than your IT department

You rarely have to go back to the IT department to have your QlikView file rebuilt because it doesnt cover all your analysis needs

13

QlikView Shortens Cycle TimeSignificantlyQlikView

One Time

DailyRun TimeETL ScriptDefine DimensionsDefine MeasuresBuild ReportsBuild DashboardsExtract dataCalculate cubeRender UI

1 Day

1 Hour

Seconds

TraditionalOLAPOne Time

DailyRun TimeETL ScriptDefine DimensionsDefine MeasuresBuild ReportsBuild DashboardsExtract dataCalculate cubeRender UI

2 Months

4 Hours

SecondsData BoundProcess BoundMemory/ProcessorBound

QlikView File

QlikView in action User InterfaceData Warehouse

15Internal Use Only!

QlikView FileUser InterfaceData Source

Data Warehouse is not needed. Any data source will do.Relational database inside QlikView document.QlikView in action



1. Load the Data.

2. Every click is a query. Extremely fast, and very flexible.

then work off-line

Click !The selection propagates through the relational databaseQlikView in action



Any number of Virtual hypercubes (Pivot tables, Diagrams, Gauges etc.) can be put in the QlikView document.

These are calculated on demand, i.e. on every click.QlikView in action



AQLAQLAQLAQLAQLAQLAQLAQLAQLAQL is the patented techno-logy of how to quickly evaluate the data when a click is made.QlikView in action


The Evolving BI Landscape and ITs Changing RoleSTACK VENDOR BIManaged reportingIT ROLEData preparation and governance+Enable business users to create their own analysesIT ROLEData preparation and governance+Responsible for building all the analysesEND USERPre-calculated dashboardsBUSINESS USERSelf-service analysisCreate analysis relevant to specific business problemsChange analysis on the fly QLIKVIEW Dynamic dashboardsSearch live dataAny deviceOPERATIONAL DATA SOURCESIT DEPARTMENTREPORT-CENTRIC ARCHITECTURE(IT-driven, tightly controlled)BUSINESS DISCOVERY ARCHITECTURE(Business user-driven, self-service)

QlikView Architecture

QlikView architecture overview

Typical QlikView deployment

Getting Started

Getting Started with QlikViewDownload QlikView from http://www.qlikview.com/us/explore/experience/free-downloadThe community blogs, discussion forums are available on: http://community.qlikview.com/welcome

Join our 2 Day Fulltime Training Program on QlikView on 11 & 12 Jan 2014 (Sat/Sun) - Contact [email protected] or [email protected]

Q&A

Chart1150022395436730610585130241800025000

Series 1

Sheet1Series 1Series 2Series 320041,5002.4220052,2394.4220065,4361.8320077,3062.85200810,585200913,024201018,000201125,000