Course Learning Path
- Module 1 – Introduction to QlikView
- Module 2 – Scripting
- Module 3 – Master Calendar
- Module 4 – Types of Loads in QlikView
- Module 5 – Functions and Expressions
- Module 6 – Interacting with QlikView Objects
- Module 7 – Interacting with QlikView Charts with All Properties
- Module 8 – Advanced Designing
- Module 9 – Set Analysis
- Module 10 – Interacting with QlikView
- Module 11 – Security
- Module 12 – QlikView Best Practices
- Module 13 – QlikNPrinting
- Module 14 – Creation of QlikView Application (Live and Real Time)
- Module 15 – QlikView Server
- Module 16 – Types of Licenses
- Module 17 – Access of Application
- Module 18 – Others
- What is QlikView?
- Why QlikView is most effective than other Traditional BI Tools?
- QlikView Architecture
- QlikView Products Overview-QlikView Desktop, Server, Publisher and Access Points
- QlikView Roles and Responsibilities
- What can you do with QlikView? The sum of Five Capabilities which make QlikView Unique.
- Benefits of using QlikView
- Installation of QlikView Desktop
- Script Menu Commands
- Edit Script Toolbar/Editor
- Variables
- Differences between ODBC and OLEDB
- Data Extraction from Various Databases
- Loading Different Data sources (Excel, Txt, CSV and MS Access Database)
- Script Editing
- Renaming of Fields
- Commenting Fields
- Executing Script
- Debugging, Tracing and Trouble shooting
- Data Modelling
- Types of Data modelling (Star and Snowflake Schema)
- Introduction to QVD
- Storing Data into QVD
- Benefits of QVD
- Synthetic keys
- Circular References
- Joins (Inner Join, Outer Join, Left Join and Right Join)
- Keep
- Concatenation
- Apply Map
- Cross Table
- How to generate Master Calendar?
- Date and Time Functions
- Preceding Load
- Resident Load
- Inline Load
- Binary Load
- Incremental load
- Buffer Load
- Generic Load
- QlikView Functions
- Set Analysis Expressions
- Advanced Calculations (YTD, MTD and QTD)
- Aggregation Functions
- SET and LET
- List Box
- Multi Box
- Table Box
- Current Selection Box
- Text Object
- Calendar/Slider Object
- Input Box
- Line/Arrow Object
- Button
- Statistics Box
- Bookmark Object
- Search Object
- Bar Chart
- Line Chart
- Combo Chart
- Radar Chart
- Mekko Chart
- Grid Chart
- Scatter Chart
- Pie Chart
- Funnel Chart
- Block Chart
- Gauge Chart
- Straight Table
- Pivot Table
- Container Box
- Calculate Conditions in Charts
- Create Drill Down Groups
- Create Cyclic Groups
- Fast Change
- Trellis Chart
- Accumulation/No Accumulate
- Trend Lines
- Special Indicators
- What is set analysis
- Why do we use it?
- How do we use it?
- Identifiers, Operators and Modifiers
- Examples
- Sheet Properties
- Document Properties
- Conditional Display of Object and sheet
- Triggers
- Hidden Script
- What is Security?
- Type of Implementation
- Security based on User ID
- Security based on NTNAME
- Nprinting Installation
- Creation of Reports
- Technical Specifications
- Building Layout
- Creation of Dashboard and Reports
- Implementation of Security
- QlikView Server Installation
- Deployment of Application
- Scheduling a job for the application
- Named CALS
- Documents CALS
- Session CALS
- Usage CALS
- Access by access point
- Access by QlikView Desktop
- Sample Resume
- 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