Qlik View Developer and Administrator

Qlikview developer and administrator training course

Qlik View Developer and Administrator

Course Learning Path

  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
  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
  1. How to generate Master Calendar?
  2. Date and Time Functions
  1. Preceding Load
  2. Resident Load
  3. Inline Load
  4. Binary Load
  5. Incremental load
  6. Buffer Load
  7. Generic Load
  1. QlikView Functions
  2. Set Analysis Expressions
  3. Advanced Calculations (YTD, MTD and QTD)
  4. Aggregation Functions
  5. SET and LET
  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
  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
  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
  1. What is set analysis
  2. Why do we use it?
  3. How do we use it?
  4. Identifiers, Operators and Modifiers
  5. Examples
  1. Sheet Properties
  2. Document Properties
  3. Conditional Display of Object and sheet
  4. Triggers
  5. Hidden Script
  1. What is Security?
  2. Type of Implementation
  3. Security based on User ID
  4. Security based on NTNAME
  1. Nprinting Installation
  2. Creation of Reports 
  1. Technical Specifications
  2. Building Layout
  3. Creation of Dashboard and Reports
  4. Implementation of Security
  1. QlikView Server Installation
  2. Deployment of Application
  3. Scheduling a job for the application
  1. Named CALS
  2. Documents CALS
  3. Session CALS
  4. Usage CALS
  1. Access by access point
  2. Access by QlikView Desktop
  1. Sample Resume
  2. FAQs in Interview

Similar Courses

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

enquiries@bsbitraining.co.uk

    Leave A Message

    7 + 6 =