Qlik View Developer and Administrator

Qlik View Developer and Administrator

Course Description

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 – QlikNPrinting

  1. Nprinting Installation
  2. Creation of Reports 

 

Module 14 – 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 15 – QlikView Server 

  1. QlikView Server Installation
  2. Deployment of Application
  3. Scheduling a job for the application


Module 16 – Types of Licenses 

  1. Named CALS
  2. Documents CALS
  3. Session CALS
  4. Usage CALS


Module 17 – Access of Application 

  1. Access by access point
  2. Access by QlikView Desktop


Module 18 – Others 

  1. Sample Resume
  2. FAQs in Interview

Reach Us

Call or use the form to request a free initial consultation.

Office 1.05, 1st Floor, Building 2,Croxely Business Park, Watford, WD18 8YA

02035736917

enquiries@bsbitraining.co.uk

Leave A Message