QlikView Mastery: Comprehensive BI and ETL Training

Name: QlikView Mastery: Comprehensive BI and ETL Training
Rating: 4.3 (5 reviews)

Master QlikView for seamless BI and ETL solutions with comprehensive training and hands-on projects.

Created byEDUCBA Bridging the Gap

Last updated 6/2024

English

English [Auto],

What you'll learn

Comprehensive understanding of QlikView BI and ETL tools.
Installation and navigation through QlikView interfaces.
Data loading techniques from various sources like Excel, text files, XML, and web pages.
Advanced scripting and QlikView functions including Peek, Range Sum, and more.
Visualization creation using charts like Bar, Pie, and Pivot tables.
Data modeling concepts such as Star Schema and Concatenate.
Dashboard development and report generation.
Implementing security measures at document, object, and sheet levels.
Utilizing QVD files for efficient data handling and storage.
Hands-on project experience building an ERP system with QlikSense.

Course content

3 sections • 73 lectures • 9h 23m total length

Overview of Qlikview2:29
Explore QlikView, a versatile data visualization tool that retrieves and integrates data from SQL Server, Oracle, Excel, XML, text, and SAP, to reveal relationships and enable quick insights.
Installation of Qlikview8:06
Learn to install QlikView on your desktop, download the free personal edition, register, run a complete installation, and verify it via the Windows start menu.
Basic Navigation9:09
Learn basic navigation in Click View, including the start screen, recent and favorite items, and core menus such as file, edit, view, layout, and tools.
Use Sheet and Objects8:36
Navigate QlikView sheets and objects by adding, removing, and rearranging the default main sheet, and set sheet properties while creating list box and multi box objects connected to data sources.
Use Scripting5:16
Master QlikView scripting to control data loading options and transformation, using inbuilt functions and reusable subroutines via the script editor and load statements.
Data Loading Excel File8:31
Learn to load Excel data into QlikView with the new document wizard, set headers, save the file, and create bar and line charts to analyze state wise customer counts.
Data Loading Excel File Continues8:42
Load data from an Excel file into QlikView and visualize it in a table. Learn how to merge multiple Excel files, reload, and save across sessions.
Data Loading Text File6:36
Master the loading of delimited text file data into the click view by dragging and dropping, choosing separators, adjusting headers, enabling transformations, and reloading to view results.
Data Loading Xml File4:06
Learn to load xml file data into QlikView, identify fields and attributes, and create views with multi box, table, or chart.
Data Loading Webpage File4:26
Load web data into QlikView by using edit script and web files, fetch data from an internet URL, detect HTML structure, and reload to view city and country data.
Data Loading Incremental Load6:07
Learn how to perform incremental load by concatenating new Excel data into a QlikView dataset. Use the edit script and the concatenate keyword to merge primary and secondary files.
Data Loading QVD File11:24
Learn how QlikView data files (QVD) compress and store large data sets with the document layout, enabling fast loading, incremental updates, and multi-source data integration.
QlikView Functions5:27
Learn how to apply QlikView functions to in-memory data, explore function categories, use string and aggregate operations, and load, edit, and reload data to create table views.
Use of Peek Function8:20
Master the peak function in QlikView to access previous data for month-to-month analysis. Load Excel data, define month and sales volume, and compute differences with peak.
How to Use Range Sum7:07
Explore how to use the range sum function in QlikView to sum data within a range, using Peek for prior month values and a rolling approach for monthly totals.
How to use Barchart11:04
Learn to create bar charts in QlikView by loading Excel data, selecting single, double, and triple dimensions, and analyzing revenue across product lines and categories.
How to Works in Piechart9:17
Load data from Excel into QlikView and create a pie chart with the quick chart wizard. Visualize proportions across one or two dimensions.
Transformation Rotate4:35
apply the rotate transformation in QlikView to transpose rows to columns, explore left and right rotations, and enable transformation to load Excel data.
Transformation Unwrap5:24
Explore the unwrap transformation in QlikView, loading an Excel file, enabling transformation, and unwrapping data by conditional rules to reorganize columns and update the script.
How to use Transformation Column7:08
Learn how to perform column manipulation in QlikView by creating a new column from an existing one using criteria and transformation steps, including value-based and column-based comparisons.
Transformation Column Continues9:11
Explore column manipulation in QlikView: create new columns with conditional logic, compare columns, apply range and top five selections, delete rows, and load transformed data into a table box.
Transformation Fill8:51
Master the field transformation fill in QlikView to populate empty cells in a target column from adjacent data, using conditions and the transformation editor.
Transformation Garbage6:19
Learn to perform data transformation in QlikView by enabling the transformation step and removing unwanted rows with garbage transformation before loading into memory.
Dimension and Measure9:39
Learn dimension and measures in QlikView, including how dimensions like region or month and numeric measures like revenue drive analysis, and how to load data and build a straight table.
Star Data Model8:40
Explore star schema in QlikView, linking a central fact table to multiple dimension tables such as product, region, supplier, and time to enable faster queries with fewer joins.
How to use Concatenate4:51
Use concatenation in QlikView to append rows from one table to another, even with different column counts, by loading data in the edit script and using the concatenate keyword.
Use Cross Table5:47
Use cross tables in QlikView to transpose data, roll up multiple columns, and improve visualization. Load an Excel file, configure qualifier and attribute fields, and explore region-wise data.
How to Build Dashboard7:26
Build dashboards in QlikView by loading an Excel data file, using charts, tables, and list boxes on a single sheet to explore product categories and sales with in-memory associations.
Joins12:13
Explore four types of joins in QlikView, inner, left, right, and outer, by combining data from two datasets using edit script and load/reload workflows.
Use Keep Command8:48
Master the keep command in QlikView to combine two data sets in memory, using inner keep, left keep, and right keep, distinct from joins.
Pivot Table6:32
Learn to create and view pivot tables in QlikView by loading data, selecting embedded labels, configuring dimensions and measures with the Quick Chart Wizard, and expanding hierarchies.
Set Analysis11:49
Master set analysis in QlikView to keep certain sheet objects unassociated while filtering across others. Learn to create table boxes, list boxes, and charts.
Straight Table4:45
master straight table in QlikView to display data in sheet objects with sorting and background color, load, save, and reload to build a table box with promote and demote.
Mapping Table11:28
Master mapping tables in QlikView by loading region and product data, creating a lookup, and applying map to add the country column through an edit script.
Master Calendar12:12
Create a master calendar in QlikView to enrich data with month, week, quarter, and year fields, using load statements, edit script, and resident techniques to link to sales data.
Synthetic Key4:49
Explore synthetic keys in click view, which create an artificial key for common columns between tables; view them in the table viewer and determine when redesigning data model is needed.
Generating Data6:00
Learn to generate data in QlikView using auto generate function, creating date ranges from today to year end, plus weekday, year, and month fields for business intelligence and etl analysis.
Generating Data Continues7:17
Learn to generate date-based data in QlikView using auto generate. Apply where weekday filters for Thursday and Sunday, and build records with the rack number across a date range.
Circular Reference8:18
Identify and fix circular references in QlikView by detecting loops in the data model with the table viewer, then resolve them by renaming conflicting columns to break associations.
Inline Load5:25
Master inline load in QlikView by typing or pasting data in the data wizard; use the insert tab and edit script to load and view results in a table box.
Preceding Load4:47
Learn how to use preceding load in QlikView to derive region-wise total sales from a lower load in the same script, distinguishing it from resident load.
Resident Load7:05
Learn how to use resident load in QlikView to derive data from in-memory tables within the same script, enabling region-wise total sales analysis.
Actual and Target Sales using Stripped Bar Chart11:38
Identify whether a company meets its target by visualizing actual versus target with a stacked bar chart in QlikView, using inline data and a factor-based calculation of actual.
More on Actual and Target Sales9:05
Build actual versus target visuals in QlikView using under target, target, and over target expressions with a stacked bar chart. Analyze regional performance to spot under and over target outcomes.

Introduction to QlikView Security9:21
Explore data security in QlikView with section access, admin and user roles, row and column level restrictions, and how to use inline or external tables alongside hidden scripts.
Lab Session6:57
Master QlikView security by implementing section access across document, column, row, object, and sheet levels, using a hidden script to define admin and user permissions and test document access.
Object Level Security9:37
Learn how to implement object level security in QlikView by configuring section access, mapping users to chart visibility, and using conditional show for two charts across three users.
Sheet Level Security10:11
Implement sheet level security in QlikView using section access to restrict two sheets for admin and two limited users, map access via a section matrix, and enable in document properties.
QVD QlikView7:03
Explore QlikView database files (QED) and learn how to create, store, and load data. Experience fast, compressed data access with incremental loads and multi-source consolidation.
Lab Session on QVD9:15
Load department and employee data from Excel into a QlikView app, create QED files with the store command, and use a left join to produce a single dept-emp dataset.
Lab Session on QVD Continues6:20
Create a QlikView app from QVD files, establish table associations with left joins, and use list boxes to filter departments and employees; compare full vs incremental loads.

Introduction to Project3:53
Create a dashboard on an ERP system using qlik sense to enable expert-level business analytics. Learn data modeling, SQL basics, and visualizations to craft insightful BI dashboards.
Dashboard Overview3:21
Explore the extract, transform, and load process in Qlik Sense, build a data model from raw data, and design an ERP dashboard with sales, products, customers, and supply chain KPIs.
Three Deferent Application Detail14:27
Build three-tier Qlik Sense applications: training_extract, training_transform, and training_dm, exploring extract, transform, and data model layers in the cloud with data connections, Google Drive authentication, and load data workflows.
Application Tables2:46
Create qubits from each Excel file, load source data, drop the memory table, and transform the raw QVD to build the transform layer.
Account Class2:01
Store local data as qvd files using the data files folder and data connections. Insert and comment scripts, then save account_class as qvd.
Training Transform3:10
Learn to build and transform data in the transform application, linking orders with order details to form a unified orders transform table and integrating product, employee, and inventory data.
Orders Transform7:08
Fetches orders and order details raw cubes to build the orders transform, deriving shipment status, ship days, shipped, and eta status via resident loads and a left join.
ETA Status9:20
Create eta status buckets from days to ship (1–2, 3–5, >5) and build orders_final via resident load; store as transform cubed and join product type, product, and supplier into product_details_transform.
Employee Detail Transform12:03
Explore building and transforming employee details in QlikView by creating and joining cubes, deriving age and years of service, and storing final transforms as cubed files.
Transaction Detail Transform4:54
Consolidate sales return, purchase order, receipt, bill, payment, and invoice data into a single transaction details transform table by aligning ids, standardizing dates, and concatenating cubes in the rocket layer.
Journal Detail Transform9:05
Join journal entry and journal entry type on id to create journal details transform, and concatenate inventory purchase, return, and sale before linking to inventory transaction and type.
Inventory Details Transform10:05
Learn to build an inventory details transform in QlikView by joining inventory master, transaction type, and order detail on ID and product ID, and resolve synthetic keys and circular references.
Inventory9:13
Learn to clean and model data in Qlik Sense by aliasing and renaming keys to remove synthetic keys and circular loops, merge fact tables, and create a master fiscal calendar.
Master Calendar10:52
Build a master calendar in QlikView from the transaction date using preceding loads, min/max dates, and auto generated dates, then add fiscal year, month, quarter, and week columns.
Development Overview10:08
demonstrates building a QlikView overview sheet with four filters for fiscal year, month, quarter, and product; creates current and previous year variables and KPIs for sales, customers, orders, and products.
Order Shipped8:45
Demonstrates building key performance indicators and visuals in QlikView: an orders shipped goal chart with set analysis, a donut balance by account type, and top five customers treemap using v_sales.
Include Null Values7:53
Master QlikView visuals by excluding null values, showing top five customers, and displaying sales in thousands; create a sales comparison line chart and a top ten products bar chart.
Account Balances7:16
Create a dashboard in QlikView using waterfall and pivot charts to display account balances by type (asset, equity, expense, liability, revenue) with filters for year, month, quarter, and product name.
Customer by Gender7:24
Product Sheet8:50
Build a Qlik Sense product sheet showing top five products by revenue, with drill-down from product type to product name and charts for sales, quantity, and map visuals.
Employee was Sales9:15
Create employee-wise sales visuals in QlikView masterclass by building a treemap of product type name and employee name, then charting sales by sales reps, average weekly sales revenue, and region performance.
Add Expression7:58
learn to create a cumulative sales bar chart in qlikview with a current year dimension and months, plus a supply chain dashboard of five kpis and an inventory table.

Requirements

Basic understanding of data analysis concepts.
Familiarity with databases and data formats (Excel, text files, XML).
Fundamental knowledge of business intelligence tools is helpful but not required.
Access to a computer with QlikView installed (for practical exercises).

Description

Course Introduction:

Welcome to the comprehensive course on "QlikView - The BI ETL Tool". This course is designed to equip you with essential skills in business intelligence (BI) and data management using QlikView. Whether you're a beginner or looking to refine your expertise, this course covers everything from the basics of QlikView installation and navigation to advanced data security and practical project implementations.

You will start by understanding the fundamentals of QlikView, including its installation process and basic navigation. From there, we will dive into data loading techniques from various sources such as Excel, text, XML, and webpages. You'll learn how to script and manipulate data effectively, using functions like Peek and Range Sum to create insightful visualizations such as bar charts and pie charts. Throughout the course, we'll explore advanced topics like transformation, set analysis, and the creation of interactive dashboards.

By the end of this course, you will have the knowledge and skills to confidently navigate QlikView's interface, manage and transform data efficiently, implement robust data security measures, and develop comprehensive BI solutions tailored to organizational needs.

Section 1: QlikView - The BI ETL Tool

Welcome to the "QlikView - The BI ETL Tool" course, where you'll dive into the powerful world of business intelligence and Extract, Transform, Load (ETL) processes using QlikView. This section begins with an overview of QlikView, guiding you through its installation and basic navigation. You'll learn to utilize sheets and objects effectively and delve into scripting for data manipulation. Data loading techniques are covered comprehensively, including Excel, text, XML, and webpage files, along with concepts like incremental and QVD file loading. The section also explores essential functions such as Peek and Range Sum, and demonstrates creating visualizations like bar charts and pie charts. Transformation techniques such as rotation and unwrapping are introduced, alongside dimension modeling, concatenation, and dashboard building. Advanced topics like set analysis, pivot tables, and master calendars are also covered, preparing you to harness QlikView's capabilities for insightful data analysis and visualization.

Section 2: Data Security in QlikView Documents

In this section, you'll focus on ensuring data security within QlikView documents. Starting with an introduction to QlikView security principles, you'll explore document, column, and row-level security through practical lab sessions. Object and sheet-level security mechanisms are detailed to manage access effectively. Additionally, the section covers the use of QVD (QlikView Data) files for efficient data storage and management, with hands-on labs to reinforce learning and application of security concepts.

Section 3: Project on ERP System using QlikSense

Transitioning to practical application, this section introduces a project on integrating QlikSense with an ERP system. You'll gain insights into dashboard creation, application tables, and various data transformations such as orders, employee details, and inventory management. Key functionalities like master calendar setup, order processing, and customer analytics are explored in depth. The section culminates in advanced topics including handling null values, financial balances, and detailed product analysis, equipping you with the skills to implement comprehensive ERP solutions using QlikSense.

Course Conclusion:

Throughout this journey, you gain a deep understanding of QlikView's capabilities in business intelligence and ETL processes. Starting with the basics of installation and navigation, you progress through advanced topics including data loading, scripting, visualization, and data security.

You now possess the skills to handle various data sources, transform data effectively using QlikView's scripting language, and create meaningful insights through interactive dashboards and visualizations. Whether you plan to apply these skills in your current role or seek new opportunities in BI and data analytics, this course has equipped you with valuable expertise.

Remember, mastering QlikView is an ongoing journey. Continue to explore and apply what you've learned, stay updated with new features and best practices, and leverage your newfound skills to drive data-driven decisions and innovations within your organization.

Best wishes for your future endeavors in the dynamic field of business intelligence with QlikView!

Who this course is for:

Beginners who want to learn QlikView from scratch.
Data analysts looking to enhance their skills in business intelligence and data visualization.
Business professionals aiming to leverage QlikView for data-driven decision-making.
IT professionals interested in understanding and implementing QlikView solutions.
Anyone interested in exploring a career in business intelligence or data analytics.

QlikView Mastery: Comprehensive BI and ETL Training

What you'll learn

Explore related topics

Course content

QlikView - The BI ETL Tool44 lectures • 5hr 35min

Data Security in QlikView Documents7 lectures • 59min

Project on ERP System using QlikSense22 lectures • 2hr 50min

Requirements

Description

Who this course is for: