QlikView is the most flexible Business Intelligence platform for turning data into knowledge. Browse through the contents of the program.
| QlikView Course Contents |
| 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 |
| Describe Table-Fields, Name |
| QVD File-Qlikview Data File |
| How to create qvd file-By only Qlikview Desktop |
| 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 |
| load qvd file |
| Internal Table View |
| object-insert and object properties in dashboard |
| 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 |
| Add data from CSV and Excel |
| File Wizard: Transform – Basic Transformation in Qlikview |
| Fill Condition |
| Specify Row Condition |
| Unwrap Function |
| Rotate Function |
| Difference b/w Transpose and Left |
| Internal Table View |
| Dashboard Background-3 Regions |
| Chart Properties |
| List Box Properties |
| Tools-Alert |
| Sheet Properties |
| Objects-Current Selection Box, New Statistics Box, New Button Object |
| Connection String |
| Select Statement: Create select statement |
| Problem Discussion |
| Fact Table-Explain |
| Load Statement |
| Dashboard created based on 3 principles-DAR |
| Sheet Properties |
| Linked Objects |
| Object-Text Object-New Text Object-Text Object Properties |
| Market Share |
| Report-Report Editor, Report Setting |
| Different types of Chart-Radar Chart, Maco Chart, Grid Chart, Funnel Chart |
| Match Function |
| Scripting |
| Load-Aircraft Group, Aircraft Type |
| Editing in Script |
| Table-Aircraft Group Table, Aircraft Type Table |
| Security |
| Access types |
| Section types |
| Section Access Script |
| Different Ways to declare variable |
| Period Field |
| Create Aggregated Table |
| Transaction Table |
| Explain Table-Internal Match |
| How to load a cross table |
| Explain-Internal Table View |
| Load Inline Function: Inline Data Wizard |
| Explain Dimension, Metrics, Pivot Table |
| Use of temporary tables |
| Creation of new reports for users. |
| Explain flight type field. |
| Use of excluded values. |
| Discussion & Problem Solve |
| QMC-Qlikview Management Console |
| Qlikview Server |
| Document Distribution |
Techflames is an online training hub where we provide experienced tutors on any technology. We serve all the major time zones be it USA, UK, Canada, Australia, New Zealand, India, Saudi, Dubai..
