02035736917

Module 1 – Introduction to Qlikview
  1. What is Qlikview?
  2. Why Qlikview is most effective than other Traditional BI Tools?
  3. Qlikview Architecture
  4. Qlikview Products Overview-Qlikview Desktop, Server, Publisher and Access Points
  5. Qlikview Roles and Responsibilities
  6. What can you do with Qlikview ? The sum of Five Capabilities which make Qlikview Unique.
  7. Benefits of using Qlikview
  8. Installation of Qlikview Desktop

Module 2 – Scripting
  1. Script Menu Commands
  2. Edit Script Toolbar/Editor
  3. Variables
  4. Differences between ODBC and OLEDB
  5. Data Extraction from Various Databases
  6. Loading Different Data sources (Excel, Txt, CSV and MS Access Database)
  7. Script Editing
  8. Renaming of Fields
  9. Commenting Fields
  10. Executing Script
  11. Debugging, Tracing and Trouble shooting
  12. Data Modelling
  13. Types of Data modelling (Star and Snowflake Schema)
  14. Introduction to QVD
  15. Storing Data into QVD
  16. Benefits of QVD
  17. Synthetic keys
  18. Circular References
  19. Joins (Inner Join, Outer Join, Left Join and Right Join)
  20. Keep
  21. Concatenation
  22. Apply Map
  23. Cross Table

Module 3 – Master Calendar
  1. How to generate Master Calendar?
  2. Date and Time Functions

Module 4 – Types of Loads in Qlikview
  1. Preceding Load
  2. Resident Load
  3. Inline Load
  4. Binary Load
  5. Incremental load
  6. Buffer Load
  7. Generic Load

Module 5 – Functions and Expressions
  1. Qlikview Functions
  2. Set Analysis Expressions
  3. Advanced Calculations (YTD, MTD and QTD)
  4. Aggregation Functions
  5. SET and LET

Module 6 – Interacting with Qlikview Objects
  1. List Box
  2. Multi Box
  3. Table Box
  4. Current Selection Box
  5. Text Object
  6. Calendar/Slider Object
  7. Input Box
  8. Line/Arrow Object
  9. Button
  10. Statistics Box
  11. Bookmark Object
  12. Search Object

Module 7 – Interacting with Qlikview Charts with All Properties
  1. Bar Chart
  2. Line Chart
  3. Combo Chart
  4. Radar Chart
  5. Mekko Chart
  6. Grid Chart
  7. Scatter Chart
  8. Pie Chart
  9. Funnel Chart
  10. Block Chart
  11. Gauge Chart
  12. Straight Table
  13. Pivot Table
  14. Container Box

Module 8 – Advanced Designing
  1. Calculate Conditions in Charts
  2. Create Drill Down Groups
  3. Create Cyclic Groups
  4. Fast Change
  5. Trellis Chart
  6. Accumulation/No Accumulate
  7. Trend Lines
  8. Special Indicators

Module 9 – Set Analysis
  1. What is set analysis
  2. Why do we use it?
  3. How do we use it?
  4. Identifiers, Operators and Modifiers
  5. Examples

Module 10 – Interacting with Qlikview
  1. Sheet Properties
  2. Document Properties
  3. Conditional Display of Object and sheet
  4. Triggers
  5. Hidden Script

Module 11 – Security
  1. What is Security?
  2. Type of Implementation
  3. Security based on User ID
  4. Security based on NTNAME

Module 12 – Qlikview Best Practices

Module 13 – Creation of Qlikview Application (Live and Real Time)
  1. Technical Specifications
  2. Building Layout
  3. Creation of Dashboard and Reports
  4. Implementation of Security

Module 14 – Qlikview Server
  1. Qlikview Server Installation
  2. Deployment of Application
  3. Scheduling a job for the application

Module 15 – Types of Licenses
  1. Named CALS
  2. Documents CALS
  3. Session CALS
  4. Usage CALS

Module 16 – Access of Application
  1. Access by access point
  2. Access by Qlikview Desktop

Module 17 – Others
  1. Sample Resume
  2. FAQs in Interview