QLIK ANALYTICS & VISUALIZATION
Learn withKapil pandey
20 modules
Certificate of completion
Lifetime access
Master Qlik for powerful data analytics and visualization
Overview
The QLIK ANALYTICS & VISUALIZATION course is designed to teach students how to effectively analyze data and create visually appealing and insightful visualizations using Qlik software. Students will learn advanced techniques for data visualization and analytics, enabling them to make informed decisions and derive valuable insights from large datasets. The course covers topics such as data modeling, dashboard design, interactive visualizations, and data storytelling.
Key Highlights
Advanced data analysis techniques
Interactive visualizations
Dashboard design
Data storytelling
What you will learn
Learn advanced data analysis techniques
Explore sophisticated methods for analyzing and interpreting complex datasets with Qlik software
Create stunning interactive visualizations
Master the art of creating dynamic and interactive visualizations to communicate data insights effectively
Design insightful dashboards
Learn how to design visually appealing and informative dashboards to showcase key metrics and KPIs
Master the art of data storytelling
Develop storytelling skills to effectively convey insights and trends discovered through data analysis
Modules
Day 1: Introduction to Qlik and Data Analytics
7 attachments • 31.27 mins
Introduction to Qlik
Why Qlik?
Exploring the Qlik Interface
Basic Workflow: From Loading Data to Creating Visualizations
Hands-on Exercise
Loading Data into Qlikview
QVD Creation in Qlikview
Day 2: Data Loading in Qlik
7 attachments • 38.44 mins
Connecting to Data Sources
Data Import Methods
Understanding Associations in Qlik
Hands-on Exercise
Qlikview UserPreferences _ Editing QVD Without QVW _ License update For Qlikview Desktop
Qlikview List Box, Qlikview List Box, Multi Box _ Slicing and Dicing Data in Qlikview
Connecting to a Data base from Qlikview _ OLEDB and ODBC Connection Setup In Qlikview
Day 3: Introduction to Qlik’s Data Model
8 attachments • 45.91 mins
Data Model Basics
Star and Snowflake Schemas
Managing Relationships
Understanding Synthetic Keys
Hands-on Exercise
Qlikview Statistics, Search, Qlikview Statistics, Search, Current Selection Objects _ Associative search in List Box
Cyclic, Cyclic, Drill Down Groups _ Visualising Data in Bar Chart _ Set reference
Chart Calculation Condition _ Conditional Enabling _ Chart Error Messages
Day 4: Data Transformation and Cleansing
7 attachments • 36.5 mins
Data Transformation Techniques
Field Renaming and Formatting
Handling Missing and Inconsistent Data
Hands-on Exercise
Joins In Qlikview _ Data Transformations _ Cross Table In Qlikview
Concatenation and Keep in Qlikview
Variables Intro _ Scope and Dropping_ Let Variables _ Conditional Enabling in Qlikview
Day 5: Introduction to Data Visualizations in Qlik
8 attachments
Choosing the Right Visualization
Creating Basic Visualizations
Adding Interactivity
Design Best Practices
Hands-on Exercise
Passing Parameters to variable _ using Variables like functions
Straight Table _ Custom Format Cell in Qlikview
Text Object _ Button Object _ Actions in Qlikview
Day 6: Set Analysis Basics
6 attachments
What is Set Analysis?
Basic Set Expressions
Working with Variables
Hands-on Exercise
Qlikview Nomenclature _ Hide Prefix_Suffix in Qlikview
Dealing with Synthetic Keys & Circular Reference in Qlikview
Day 7: Advanced Data Modeling
6 attachments
Advanced Joins and Concatenations
Resident Load
Mapping Tables
Hands-on Exercise
Pi Chart and Legends Limitations in Qlikview
ApplyMap() and Lookup() in Qlikview _ RowNo() vs RecNo() in Qlikview
Day 8: Functions and Expressions in Qlik
6 attachments • 1 mins
Mathematical Functions
Text Functions
Date Functions
Hands-on Exercise
Peek() and Previous() in Qlikview
Playing wisely with Colours in Qlikview _ Trellis and Help Text in Qlikview
Day 9: Creating Dashboards
7 attachments
Design Principles:
Combining Visualizations
Adding Filters and Selections
Drill-downs and Hierarchies
Hands-on Exercise
Qlikview Resident load, Preceding load and Binary load
Qlikview Buffer load, Partial load and Bundle Info load
Day 10: Advanced Chart Types and Visualization Techniques
6 attachments
Advanced Chart Types
Enhancing Visualizations
Working with Pivot Tables
Hands-on Exercise
Implementing Incremental load in Qlikview (1.Add_Insert)
Implementing Incremental load in Qlikview (2.Insert and Update)
Day 11: Advanced Scripting Techniques
7 attachments
Understanding Script Sections
Debugging and Troubleshooting
Using Loops and Iterations
Creating Reusable Script Components
Hands-on Exercise
Implementing Incremental load in Qlikview (3.Insert,Update and Delete)
Introduction to Set Analysis
Day 12: Security and Access Control in Qlik
6 attachments
Understanding Section Access
Implementing Row-Level Security
Data Reduction
Hands-on Exercise
Set Identifiers in Qlikview
Set Modifiers in Qlikview
Day 13: Advanced Set Analysis
6 attachments
Nested Set Expressions
Alternate States
Advanced KPIs
Hands-on Exercise
Set Operators in Qlikview
p() and e() function in Set Analysis
Day 14: GeoAnalytics in Qlik
7 attachments • 2 mins
Introduction to Qlik GeoAnalytics
Working with Map Charts
GeoCoding and Data Preparation
Creating Interactive Maps:
Hands-on Exercise
HidePrefix and HideSuffix in Qlikview
Include Vs MustInclude in Qlikview
Day 15: Data Integration and Real-Time Data
6 attachments
Connecting to External Databases
Using APIs to Load Data
Scheduling and Automating Data Refresh
Hands-on Exercise
Group By in Qlikview
Adhoc Reporting in Qlikview
Day 16: Machine Learning Integration
6 attachments • 1 mins
Overview of Machine Learning in Qlik
Using Predictive Analytics in Qlik
Creating Visualizations for Predictive Data
Hands-on Exercise
Master Calendar Creation in Qlikview
Creating Data Bins (Class() function) in Qlikview
Day 17: Qlik APIs and Extensions
6 attachments
Introduction to Qlik APIs
Creating Custom Extensions
Embedding Qlik Objects in Other Applications
Hands-on Exercise
Section Access (Row level_Column level_sheet level security) Implementation
Alternative States Use in Qlikview
Day 18: Performance Tuning and Optimization
6 attachments
Optimizing Data Models
Optimizing Visualizations
Monitoring Qlik Server Performance
Hands-on Exercise
Autonumber() function(How to use and Limitations) in Qlikview
Creating Themes in Qlikview
Day 19: Final Project
7 attachments
Problem Definition
Data Collection
Dashboard Creation
Presentation
Hands-on Project
Aggr() and Rank() functions in Qlikview
Dual() Function and its Significance in Qlikview
Day 20: Course Wrap-up and Review
4 attachments
Final Review
Guidance for Further Learning
FirstSortedValue() Function In Qlikview
FieldValue() and FieldValueCount() Functions in Qlikview
Certification
When you complete this course you receive a ‘Certificate of Completion’ signed and addressed personally by me.
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Learn withKapil pandey
Rate this Course
Free
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
