1 / 16

Qlikview vs OLAP Presented By Quontra Solutions

Quontra Solutions offers Job oriented Qlikview online training with updated technologies. For more info about our Qlikview online training contact us directly. We are providing Qlikview online training to all students throughout worldwide by real time faculties. Our Qlikview training strengthens your skills and knowledge which will helps you to gain a competitive advantage in starting your career. Outclasses will help you to gain knowledge on real time scenario. It will be most use full to boost up your career. Our training sessions are designed in such a way that all the students can be convenient with the training schedules and course timings. Along with Training, we also conduct several mock interviews along with Job Placement Assistance. Attend Free Demo before joining the class. Our Features: • Real world projects to get practical based experience • Online tests to explore the resource learning • Experienced certified trainers as instructors • One to one personalized training with desktop access • Case studies and state of art library to access study material • Resume build assistance to win in interviews.

quontrasolutionsppts
Download Presentation

Qlikview vs OLAP Presented By Quontra Solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. VSOLAP Qlikview

  2. Star Scheme Salescampaigns Salesorganization Time Sales, profit,costs, keynumbers, etc. Geography heirarchy Products Other dimension

  3. User Interface SQL queries are generated graphically. Flexible, but neither fast nor user-friendly. Data Warehouse Relational OLAP

  4. User Interface Every click is a query. Fast, but not flexible. Limited number of dimensions. Hyper Cube Build the cube. Lots of Data. Slow. Everything must be predefined. Data Warehouse Multidimensional OLAP

  5. User Interface Every click is a query. Fast, but not flexible. Limited number of dimensions. Hyper Cube Drill-through when needed. Slow, and not user-friendly. Data Warehouse Hybrid OLAP

  6. User Interface Data Warehouse QlikView file Qlikview

  7. User Interface Relational database inside QlikView document. Data Warehouse is not required. Any data source will do. Data Warehouse QlikView file Qlikview

  8. User Interface Load the data… Data Source QlikView file Qlikview then work off-line!

  9. User Interface QlikView file Qlikview

  10. User Interface Every click is a query. Extremely fast, and very flexible. Click ! Qlikview The selection propagates through the relational database. The technology used is called AQL.

  11. Qlikview AQL™ The patented AQL technology performs its associations when a QlikView user makes a query through the point-and-click interface. As a value or several values (in a dimension) are selected, QlikView makes a split second association showing only values (in other dimensions and measures) associated with the current selection. Simultaneously, graphs and tables (holding one or several general expressions), are calculated to show the result of the current selection.

  12. User Interface Qlikview 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.

  13. Qlikview Summary • MOLAP • Limited number of dimensions • Not Flexible • ROLAP • Not User-friendly • HOLAP • A poor combination of the two above methods

  14. Qlikview Summary • Data warehouse not necessary • Unlimited number of dimensions • Possibility for several hypercubes talking to each other • Flexible • User-Friendly

  15. Thank You Attend Free Demo for Qlikview Call Us : 404-900-9988 Email:info@quontrasolutions.com

More Related