Qlikview Online Training | qlikview training material | qlikview training videos

2. • Heritage • Founded in Sweden 1993 • Growing revenue 470.5 M$ in 2013-2014 • Offices in over 60 countries • Strong 33,000 customer base in over 100 countries • Over 1100 Partners worldwide. • Placed 3rd in Forbe’s list of Top 25 fastest growing companies. • • • • • • • Board Lars Björk, Chairman & CEO QlikTech William G. Sorenson, CFO Les Bonney, COO Anthony Deighton, CTO/SVP Products Paul Farmer, Chief People Officer Jonas Nachmanson, Chief Product Strategy Officer Organization • Management Team – Former executives from SAP, Siebel, Oracle, PA Consulting, Mactive, Intentia • Over 1500 employees worldwide. • Incorporated in the Pennsylvania, US • HQ in the Pennsylvania , US • R&D in Sweden Lead Investors

3. QlikView Overview One of the keys to QlikView's success is its unique, award-winning in-memory associative technology. In-memory analysis and reporting means one-click access to visually rich, interactive dashboards anyone can build quickly and modify easily. Few Key Features: • In-Memory Analysis and Reporting Driving Simplicity and Performance. • With an in-memory data model, QlikView allows data to be analyzed at both an aggregate and a detailed level without the time-consuming and costly step of building multi-dimensional OLAP cubes. • Since data is kept in-memory the response time of any calculation is lightning fast even on extremely large data sets analyzed by multiple concurrent users.

4. QlikView Overview

5. QlikView Overview • Single architecture for dashboards, analysis and reporting. QlikView is all about simplicity. • It provides all the features of traditional BI tools in a single architecture. • QlikView has ETL functions to extract, transform and load data from one or several data sources (e.g., ERP, text, Excel, and XML). • QlikView is click-driven and provides state-of-the-art visualization capabilities using dashboard-style gauges, graphs and tables. • QlikView is extremely fast to deploy. Most QlikView customers are live in less than 30 days. • Flexibility in analysis • The QlikView definition of an expression can model everything from a simplest total, to statistical and financial trends, to comparisons of an end users' viewpoint with benchmarks and indices particular to any given scenario. • Application dimension or measure modifications can be created in seconds, ensuring rapid response to the changing BI needs of an organization.

6. QlikView Overview • Fast to deploy • The QlikView platform integrates smoothly with an organization’s existing infrastructure making QlikView extremely fast to deploy. • Sophisticated analysis is made accessible through the most advanced web techniques providing the interactivity, flexibility, and speed for the QlikView user interface. • Easy-to-learn, easy-to-use. • Because of its color coded, point and-click user interface, QlikView is extremely intuitive and easy-to-learn for any employee. • Changes to QlikView applications are done in seconds, which makes it easy to respond quickly to the changing BI needs of an organization.

7. Patented In-Memory Associative Technology The power of simplicity What How • Associative • Thought driven • Natural • Freeing • Flexible • Collaborative • Personal • Empowering Memory & Processor Power In Memory • Fast • Light impact • Visually Interactive • Summary and Detail • Portable • Simple • Inexpensive • Integrative QlikView Real-time OLAP “Real-time processing” 64 Bit Traditional Cube OLAP “Pre-processing” Time Qliktech’s Value Proposition: 1/4 the time, 1/2 the cost, 2x the value

8. Representing QlikView Solutions By Function

9. A simplified view of a standard QlikView deployment containing the location of the various QlikView products as well as both data and application locations.

10. QlikView Platform Overview

11. Products Overview • QlikView Developer The QlikView Developer is a Windows-based desktop tool that designers and developers use to create: • a data extract and transformation model , and • to create the graphical user interface (or presentation layer) The QlikView Developer is also the environment where all user interface and user experience design is developed, everything from graphs and tables containing slices of data to multi-tab architectures to application of color scheme templates and company logos and so forth. • QlikView Server (QVS) • The QVS is a server-side product that contains the in-memory analytics engine and which handles all client/server communication between a QlikView client (namely desktop, IE plugin, AJAX or Mobile) and the server. • It includes a Management Console for providing Administrator access to control all aspects of the server deployments (including security, clustering, distribution etc.) and also includes a web server to provide front-end access to the documents within. The web server’s user portal is known as “AccessPoint”.

12. Products Overview QlikView Publisher QlikView Publisher is a member of the QlikView product family that manages content and access, by presenting the end-users with up-to-date information and letting you manage your QlikView documents in a powerful way. It is used as a distribution service to ‘reduce’ data and applications from source QVW files based on various rules (such as user authorization or data access) and to distribute these newly-created documents to the appropriate QlikView servers or as static reports via email

13. The Sum of Five Capabilities which make QlikView Unique What can YOU do with QlikView? • • • • • • • • Create flexible end user interface for DW View on relations between data Make presentations based on your data Create dynamic graphs and tables Perform statistical analysis Link descriptions and multimedia to data Set up your own expert system Create new tables and merge information from different sources Build your own BI system •

14. • QlikView and the IT Pro QlikView’s approach to BI allows for a self-service model for business users on the front end while maintaining strict data security and governance on the back end. Because of this approach, IT professionals—from enterprise architects to data analysts — can remain focused on their core competencies: data security, data and application provisioning, data governance and system maintenance. They no longer have to spend time writing and re-writing reports for business users. In a typical QlikView deployment, IT professionals focus on: • Managing data extracts and data and system security • Creating and maintaining source QlikView files (QVWs and QVDs) • Controlling data refresh and application distribution through QlikView Publisher • Administering QlikView deployments via the QlikView Management Console (part of QVS)

15. • QlikView and the Business Analyst / BI Developer • The role of a business analyst or BI developer in a typical QlikView deployment primarily involves the use of QlikView Desktop. QlikView developers use this Windows desktop application to extract data from source systems, create data models, and transform the data. It is where they describe all metadata, create data storage layers (QVD layers), and lay out the user interface. • The BA or BI developer can also reuse existing extracted and pre-modeled data from the QVD layer by pulling “off-the-shelf” data from the QVD, when relevant for their application. • The BA or BI developer also wants to ensure that their QlikView business applications are using the most recent data and that QlikView apps are being distributed to the correct business user community. For this reason, BAs and BI developers typically work closely with IT pros who use QlikView Publisher on the back end to ensure data refresh rates and QlikView Server on the front end to ensure the applications are correctly distributed and meet the business’ needs.

16. • QlikView and the Business User • Business users interact with QlikView applications exclusively via the front end of a deployment, most typically using a browser on their desktop, laptop, or mobile device (such as an iPad). Users simply open their AccessPoint portal (or, in the case of integrated solutions, their organization’s own enterprise portal) and select the QlikView application they wish to use. • QlikView Server provides all client-server communication and is the engine that drives the in-memory associative experience. Once the user’s security credentials are verified, they then open and can begin working with the application, exploring and interacting with the data and asking and answering their own stream of questions in a self-service mode. Users can also collaborate with other users in the organization, sharing insights and exploring data together, in real time or asynchronously.

17. Benefits of using QlikView • Deliver the right information to the right people at the right time • QlikView Server and QlikView Publisher form the information hub of the enterprise, providing the right information to the right people at the right time. • Users easily and securely connect to QlikView to get the latest updated information at their fingertips. • Through automated, timely and secure distribution of personalized analysis and reporting, users have access only to the data and analysis to which they are authorized. Actionable analytics • QlikView offers the unique capability to input data directly into the in-memory data model, allowing users to perform what-if scenario analysis or to do budgeting and planning directly in QlikView. • QlikView also permits the display of close-to-real-time data feeds for spotting trends in frequently changing data. •

18. Benefits of using QlikView • End user collaboration for better business performance • QlikView quickly adapts to the needs of the users and not the other way around. It promotes user intelligence by allowing users to be curious and creative. • QlikView supports users working together to find insight from analysis and to share that insight across users. Applications, reports and specific graphs can be personalized for specific needs and shared between user groups through QlikView Server. Easy-to-scale deployments • QlikView provides a robust platform for business analysis not only within the enterprise, but also across its network of customers, distributors and suppliers - addressing solutions across a wide array of functional areas from sales and marketing to supply chain and operations to finance and human resources. • QlikView handles thousands of users and billions of records of data down to the transaction level with near instant query response time running on standard hardware. •

19. Benefits of using QlikView • Update analysis at the speed of light • In-memory analysis and reporting is changing the rules of the BI industry. Dealing with potentially billions of data records for ad-hoc analysis means high demands on the process for doing data loads and refresh. • QlikView does incremental loads by using QlikView Data (QVD) files which makes the process 10 – 100 times faster. This architecture decreases load times from hours to minutes. It also reduces the load on the underlying operational or warehouse systems. Deliver a single version of the truth • The QlikView Publisher and QlikView Server interfaces provide a detailed, alert supported real-time view of the QlikView installation and minimizes the time to action. • It also provides an easy way of seamlessly integrating native security with the QlikView platform. QlikView Publisher’s load-sharing capabilities allow for the distribution of tasks between locations. This guarantees that users always have access to the latest analysis ensuring a single version of the truth across the organization. •

20. Benefits of using QlikView • Multiple deployment options • The QlikView BI platform offers a rich variety of client deployment options from Windows clients, to Java, to zero-footprint AJAX based clients. Employees, suppliers, distributors and customers can connect to the QlikView Server using a standard web browser without losing the feature rich interactivity which characterizes QlikView. • Using the latest web technology techniques, the QlikView AJAX client provides a highly dynamic, interactive and fast deployable analysis environment leaving a zero-footprint. The QlikView Java client provides a pixel perfect alternative for reporting and analysis integration in Java-based portals or intranet solutions. QlikView also offers an ActiveX plug-in client for Microsoft Office integration.

21. Benefits of using QlikView • On-line and off-line analysis • For the traveling workforce, the off-line capabilities of QlikView are remarkable. After synchronizing QlikView application data in the office, users have full access to portable in- memory analysis and reporting delivering detailed information when on the road. Risk-Free • Evaluating QlikView is risk-free. • A fully functional first application can be up and running in a matter of hours. In fact, most customers are live with their first project in less than 30 days - proving how QlikView is simplifying analysis for everyone. •

22. • The QlikView Information hub QlikView Publisher and QlikView Server offer secure, automated and timely distribution of personalized analysis and reporting to any user who is authorized. • QlikView Publisher – for distribution • QlikView Publisher ensures that the right information reaches the right user at the right time. • As the use of business analysis spreads throughout the organization, controlling the distribution of analysis becomes increasingly important. QlikView Publisher allows for complete control of the distribution of a company’s QlikView applications, automating the data refresh process for QlikView application data. In addition, it ensures that applications are distributed to the users through QlikView AccessPoint. • QlikView Server – for security • QlikView Server is the central source of truth in an organization. • QlikView Server provides a simple way for organizations to ensure that everyone has access to the latest data and analysis regardless of their location. Regardless of the client chosen – Ajax zero-footprint, Windows, ActiveX plug-in, or Java – QlikView Server provides secure access to the latest version of each QlikView application.

23. Thank You!