Business Intelligence with QlikView E-Learning
Order this unique E-Learning course Business Intelligence with QlikView online!
✔️ 1 year 24/7 access to rich interactive videos, speech, progress monitoring through reports and tests per chapter to immediately test your knowledge.
Why choose this course?
Business Intelligence (BI) is an essential tool for modern organizations to make data-driven decisions. QlikView is a powerful self-service BI solution that allows users to analyze, visualize and present data in real time. This course provides a comprehensive introduction to the functionalities of QlikView and helps you create and deliver BI documents that have a direct impact on business operations.
During this training you will learn how to:
- Can transform data into valuable insights.
- Perform real-time analysis with interactive dashboards and visualizations.
- Used QlikView tools to design, build and deliver BI documents.
- Apply best practices to provide users with an optimal self-service BI experience.
With practical examples and interactive exercises, this course is ideal for developing your QlikView skills and giving your organization a competitive advantage.
Who should participate?
This course is designed for:
- Data analysts who want to learn how to visualize and analyze data with QlikView.
- Business Intelligence Professionals who want to implement self-service BI solutions.
- IT professionals responsible for creating and managing BI documents.
- Project managers who are involved in data-driven projects and want to understand the value of real-time analytics.
- Business users who want to gain more insight into the capabilities of QlikView for self-service BI.
Getting Started
Course: 23 Minutes
- Course Introduction
- QlikView Introduction
- Installing QlikView
- Exploring the Interface and Customization
- Configuring User and Document Settings
Adding Objects
Course: 44 Minutes
- Connecting to a Data Source
- Consolidating Multiple Sources
- Creating a Table Box
- Creating a List Box and Multibox
- Creating an Input Box
- Adding the Statistics Box
- Creating Other Objects
- Using the Current Selections Window and Object
- Adding and Using a Search Object
- Sorting and Filtering Data
Managing Sheets
Course: 25 Minutes
- Managing Sheets
- Aligning and Managing Items on Sheets
- Configuring Sheet Properties
- Creating and Using Bookmarks
- Exporting Data
Creating Charts and Tables
Course: 39 Minutes
- Creating a Quick Chart
- Creating a Time Chart
- Creating a Statistics Chart
- Managing Chart Properties
- Creating a Pivot Table
- Using a Pivot Table
Practice: Using QlikView
Course: 10 Minutes
- Exercise: Using QlikView to View BI Data
QlikView Data Model
Course: 1 Hour, 19 Minutes
- Course Introduction
- Data Modeling in QlikView
- Using QlikView Script Editor
- Using QlikView Table Viewer
- Joining and Linking Tables
- Table Concatenation
- Synthetic Keys and Synthetic Tables
- Circular References
- Optimized QVD Loads
- Mapping Loads
- Entity Relationship Diagrams
- Transactional Table
Dimensional Modeling
Course: 1 Hour, 16 Minutes
- What is Dimensional Modeling
- Dimension Table
- Fact Table
- Null Values
- Displaying Null Values
- Manipulating Null Values
- Normalizing and Denormalizing Dimensions
- Conformed Dimensions
- Surrogate Keys
- Dimensional Design Process
Practice: QlikView Data Modeling Best Practices
Course: 4 Minutes
- Exercise: QlikView Data Modeling
QlikView Properties
Course: 29 Minutes
- Course Introduction
- QlikView Trigger on Sheet Level
- QlikView Macros
- QlikView Document Properties
- QlikView Object Properties
Practice: Using Macros and Triggers
Course: 6 Minutes
- Exercise: Use QlikView Macros and Triggers
Extract, Transform, and Load (ETL)
Course: 38 Minutes
- Course Introduction
- Extract, Transform, and Load (ETL)
- Extracting Data Using QlikView
- Transforming Data Using QlikView
- Loading Data Using QlikView
- Third-party ETL in QlikView
- Qlik Datamarket for QlikView
Data Governance
Course: 59 Minutes
- Concepts of Data Governance
- Implement Data Governance
- Data Governance Dashboard
- Managing Profiles
- What is Metadata?
- Add Descriptive Metadata to Field Names
- Add Tags and Comments to Fields
- Extracting Metadata
- Metadata Management
Practice: Using QlikView to Perform ETL and Implement Data Governance
Course: 8 Minutes
- Exercise: Use QlikView for ETL and Data Governance
QlikView Dashboards
Course: 39 Minutes
- Course Introduction
- Creating Dashboards
- Dashboard Functionality
- Dashboard, Analysis, and Reporting (DAR)
- Alternate and Inherited States
- Comparative Analysis
Practice: Using QlikView to Create a Dashboard
Course: 7 Minutes
- Exercise: Use QlikView to Create a Dashboard
Scripting
Course: 58 Minutes
- Course Introduction
- Scripting Best Practices
- Scripting in QlikView
- Table Files Wizard
- Script Logging
- TOTAL Qualifier
- Aggregate Functions
- Conditional Functions
- Operators
Designing
Course: 25 Minutes
- Designing Effective Visualizations
- Affordances
- Visualization and Analysis
- User-centered Designs
Security
Course: 40 Minutes
- Securing Your Application
- Section Access
- Access Control
- Hidden Script
- Types of Security
- Inherited Access Restrictions
- Encryption
Practice: Using QlikView
Course: 9 Minutes
- Exercise: Use Scripting in QlikView
Application Deployment
Course: 1 Hour, 7 Minutes
- Course Introduction
- Install Qlik Deployment Framework (QDF)
- Use Qlik Deployment Framework (QDF)
- QlikView Development Life Cycle
- QlikView Publisher
- QlikView Set Analysis
- Client Access Licenses (CALS)
- CAL Types
- QlikView Architecture
- QlikView Resource Usage
Performance and Scalability
Course: 43 Minutes
- Performance Tuning Techniques
- Test Data
- QlikView Data Storage
- Improving Performance
- Direct Discovery
- Load Testing with JMeter
- QlikView Scalability
- Scaling by Data and Users
- Scaling Applications and Application Design
Practice: Using QlikView
Course: 6 Minutes
- Exercise: Use QlikView to Deploy your Application
QlikView Server
Course: 1 Hour, 1 Minute
- Course Introduction
- Installing QlikView Server
- Single and Multiple Server Nodes
- Types of QlikView Servers
- Server Architecture
- Services and Reload Engine
- QlikView Logs
- Documents, Tasks and Distribution
- Platform Security - Authentication
- Platform Security - Authorization
Practice: Using QlikView Server
Course: 6 Minutes
- Exercise: Use QlikView Server
Get started with QlikView!
✔️ Master the tools to create powerful visualizations and dashboards.
✔️ Learn how to effectively analyze and present data for a wide range of business applications.
✔️ Test your knowledge after each chapter with targeted tests and practical assignments.
✔️ Receive a certificate of participation upon successful completion of the course.
Order your course now and discover how QlikView can help you deliver self-service BI solutions that make a difference!
