Course conducted by a Certified Qlikview expert having 6 years of Qlikview industry experience. Very basic to very advanced topics covered. 100% success rates in job interview and certifications.

Topics Covered

30 Hours Qlikview training from a certified Qlikview Specialist aimed at aspiring Qlikview Designers/Developers Pre requisites for attending Qlikview Training 1. Good SQL basics 2. A flair for scripting Course Outline Installation and IDE Starting Qlikview Basic Layout and Navigation Sheet Basics Sheet Objects Creating Your Workspace Loading data into Qlikview Script editing Statements Area Script generation Creating a connection to the database Reading tables into Qlikview Resident Load Inline tables Auto generate tables Mapping load Bundle load Binary Load Buffer load Generic load Cross Table Variables Variables in Qlikview Dollar Expansion and Double dollar Expansion Let and Set Peek, Pick Expressions based on variables Expressions based on variables stored externally Alternate states Alternate states in comparison Alternate states used in isolation Usage of alternate states in conjunction with other Qlikview functions Modeling Synthetic key Circular references and how to avoid them Multiple fact tables and various ways to design it Degenerate dimensions Generic Key tables Column renaming Optimization techniques Time series with Qlikview Time series using As Of Tables Qlikview Security Section access based on inline data. Section access based external DB tables. Hidden Script. Section access based on NT User. Data reduction based on the user. Data Hiding based on the user. Tab Security using Section Access Front-end controls and charts List boxes List boxes based on expressions Various charts Scatter Box Plot Pivot Table Straight Table Straight Table with Bar representation Waterfall Chart Gauge chart Qlikview Debugging/Logging in Qlikview Qlikview Scripting Code reuse in Qlikview Qvd Usage with practical examples QVD creation and retrieval Incremental load using QVD Set analysis Basic Set analysis Exclusions using set analysis Set operations using Set analysis Set analysis with alternate states Complex expressions with set analysis Dynamic dimensions and Expressions Executive dashboard with completely dynamic expressions, dimensions and graph types TOTAL function in Qlikview Practical examples of TOTAL usage Qlikview functions String, Numeric and Date functions Only Function IntervalMatch Hierarchy in Qlikview VB Scripts Joins and keep Inner, Outer, Right outer, left outer, full outer inner, Outer, Right keep Qlikview Extensions Qlikview Publisher Reduction (Loop and Reduce) EDX Tasks Qlikview Licensing Document CAL Named CAL Qlikview Management Console Access point configuration Server log Governance dashboards Advanced Functions in Qlikview Advanced Topics As of Tables *And a lot more that is not listed here.

Who should attend

Aspiring QV developers Aspiring BI professionals Those who want to switch from traditional BI to the modern visualisation world

Pre-requisites

Good SQL basics Creativity

What you need to bring

Nothing

Key Takeaways

Lots and lots of training materials lab exercises video recordings for absence