QlikView Business Analytics Training
Course Code: BN37
Course Objective
:After this course, participants will be able to understand
- Qlikview Interface
- Connect to Data Sourcess
- Data Visualisation
- Data Modeling
- QlikView Scripting
- Advanced Expression
- Set Analysis
- Security
Target Audience
- Data Scientists
- Data Analysts
- Digital Marketers
Course Outline
Day 1
- Overview of QlikView
- What is QlikView
- Exploring QlikView Interface
- QlikView Under the Hood
- Creating a QlikView App
- Preparing Workspace
- Creating a QlikView App
Day 2
- Data Sources
- Upload CSV and Excel file
- Connecting ODBC and OLEDB driver
- QVD and QVX file
- Data Modelling
- Dimensional Data Modelling
- Associative Data Modelling
- The Table Viewer Window
- Security
- Hidden Script
- Section Access
- Document Level Security
- Sheet-Level Security
Day 3
- Modify QlikView Appp
- Design Requirements
- Document Properties Windows
- The Sheet Properties Dialog
- Setting the Object Properties
- Working with List boxes
- MultiBox
- Current Selection Box
- Adding a Bookmark Objects
- Aligning and Resizing sheet Objects
- Creating and applying a default Colour Map
- Building Dashboard
- User Types
- DAR Principle
- Creating Analysis sheets
- Creating the new Dashboard sheets
- Creating a Reports Sheet
Day 4
- QlikView Scripting
- Script Editor
- Script Statements
- Manipulating Tables
- Conditional Functions
- Dealing with Different Data Type
- Debugging
- Data Modelling
- Data Consistency
- Reducing Storage Requirements
- Design Challenges while Data Modelling
- Changing the Source Table Structure
Day 5
- Advanced Expressions
- Variables
- Total Qualifier
- Aggr Functions
- Conditional Functions
- Set Analysis
- Whtat is Set Analysis
- iPoint in Time Reporting
- Comparative Analysis with alternate States
- Advanced Data Transformations
- Data Architecture
- Aggregating Data
- Sorting Tables
- Peek Functions
- Merging Forces
Register for this course
Date & Location