By completing this course, learners will be able to install and navigate QlikView, load and transform data from multiple sources, apply functions for advanced calculations, build dynamic visualizations, and design secure, well-structured data models. They will also gain hands-on experience in implementing security controls, optimizing QVD usage, and conducting ERP data analysis using QlikSense.
This course provides a complete journey from fundamentals to advanced techniques in QlikView and QlikSense, ensuring learners develop both technical skills and analytical thinking. With structured modules covering data preparation, functions, transformations, modeling, security, and a real-world ERP project, participants will gain the confidence to handle end-to-end BI workflows.
What makes this course unique is the combination of conceptual depth and project-based application. Learners not only master scripting, charts, and data models but also apply these skills to secure ERP data environments, enabling them to deliver actionable insights for enterprise decision-making. Whether aiming to enhance BI expertise or drive organizational reporting, this course offers a comprehensive, practical, and industry-aligned experience.
This module introduces learners to QlikView, covering installation, navigation, sheets, objects, and scripting basics. Learners will also explore core data loading techniques from Excel, text, XML, and QVD sources to build a strong foundation in data connectivity and preparation.
Das ist alles enthalten
12 Videos4 Aufgaben
Infos zu Modulinhalt anzeigen
12 Videos•Insgesamt 83 Minuten
Overview of Qlikview•2 Minuten
Installation of Qlikview•8 Minuten
Basic Navigation•9 Minuten
Use Sheet and Objects•9 Minuten
Use Scripting•5 Minuten
Data Loading Excel File•9 Minuten
Data Loading Excel File Continues•9 Minuten
Data Loading Text File•7 Minuten
Data Loading Xml File•4 Minuten
Data Loading Webpage File•4 Minuten
Data Loading Incremental Load•6 Minuten
Data Loading QVD File•11 Minuten
4 Aufgaben•Insgesamt 60 Minuten
QlikView Overview and Setup•10 Minuten
Sheets, Objects, and Scripting•10 Minuten
Data Loading Essentials•10 Minuten
Getting Started with QlikView•30 Minuten
QlikView Functions and Visualizations
Modul 2•3 Stunden abzuschließen
Moduldetails
This module focuses on QlikView’s functional capabilities and visualization tools. Learners will gain hands-on experience with functions like Peek() and RangeSum(), explore transformations, and build engaging bar and pie charts while mastering the use of dimensions and measures in dashboards.
Das ist alles enthalten
16 Videos4 Aufgaben
Infos zu Modulinhalt anzeigen
16 Videos•Insgesamt 119 Minuten
QlikView Functions•5 Minuten
Use of Peek Function•8 Minuten
How to Use Range Sum•7 Minuten
How to use Barchart•11 Minuten
How to Works in Piechart•9 Minuten
Transformation Rotate•5 Minuten
Transformation Unwrap•5 Minuten
How to use Transformation Column•7 Minuten
Transformation Column Continues•9 Minuten
Transformation Fill•9 Minuten
Transformation Garbage•6 Minuten
Dimension and Measure•10 Minuten
Star Data Model•9 Minuten
How to use Concatenate•5 Minuten
Use Cross Table•6 Minuten
How to Build Dashboard•7 Minuten
4 Aufgaben•Insgesamt 60 Minuten
Working with Functions•10 Minuten
Charts and Transformations•10 Minuten
Measures and Data Models•10 Minuten
QlikView Functions and Visualizations•30 Minuten
Advanced Data Modeling in QlikView
Modul 3•3 Stunden abzuschließen
Moduldetails
This module dives into advanced modeling concepts including joins, keep, straight and pivot tables, master calendar creation, synthetic keys, circular references, and specialized load methods. Learners will also practice applying these techniques in Actual vs. Target sales analysis.
Das ist alles enthalten
16 Videos4 Aufgaben
Infos zu Modulinhalt anzeigen
16 Videos•Insgesamt 132 Minuten
Joins•12 Minuten
Use Keep Command•9 Minuten
Pivot Table•7 Minuten
Set Analysis•12 Minuten
Straight Table•5 Minuten
Mapping Table•11 Minuten
Master Calendar•12 Minuten
Synthetic Key•5 Minuten
Generating Data•6 Minuten
Generating Data Continues•7 Minuten
Circular Reference•8 Minuten
Inline Load•5 Minuten
Preceding Load•5 Minuten
Resident Load•7 Minuten
Actual and Target Sales using Stripped Bar Chart•12 Minuten
More on Actual and Target Sales•9 Minuten
4 Aufgaben•Insgesamt 60 Minuten
Joins and Tables•10 Minuten
Calendar, Keys, and Data Relationships•10 Minuten
Specialized Loads and Sales Analysis•10 Minuten
Advanced Data Modeling in QlikView•30 Minuten
Data Security in QlikView
Modul 4•2 Stunden abzuschließen
Moduldetails
This module emphasizes security concepts, covering document, object, and sheet-level access control along with QVD security practices. Learners will participate in labs to apply access restrictions and safeguard sensitive data effectively.
Das ist alles enthalten
8 Videos4 Aufgaben
Infos zu Modulinhalt anzeigen
8 Videos•Insgesamt 66 Minuten
Introduction to QlikView Security•9 Minuten
Lab Session•7 Minuten
Document,Column and Row-level•7 Minuten
Object Level Security•10 Minuten
Sheet Level Security•10 Minuten
QVD QlikView•7 Minuten
Lab Session on QVD•9 Minuten
Lab Session on QVD Continues•6 Minuten
4 Aufgaben•Insgesamt 60 Minuten
Introduction to QlikView Security•10 Minuten
Object and Sheet-Level Security•10 Minuten
QVD Security and Labs•10 Minuten
Data Security in QlikView•30 Minuten
QlikSense ERP Project
Modul 5•5 Stunden abzuschließen
Moduldetails
This project-based module applies QlikSense to ERP system data. Learners will integrate application tables, perform multiple transformations, and generate actionable dashboards for accounts, orders, inventory, and customer analysis to derive enterprise-wide insights.
Welcome to EDUCBA, a place where knowledge is limitless! We provide a wide selection of instructive and engaging programmes designed to empower students of all ages and experiences. From the convenience of your home, start a revolutionary educational experience with our cutting-edge technologies courses and experienced instructors.
OK
Warum entscheiden sich Menschen für Coursera für ihre Karriere?
Felipe M.
Lernender seit 2018
„Es ist eine großartige Erfahrung, in meinem eigenen Tempo zu lernen. Ich kann lernen, wenn ich Zeit und Nerven dazu habe.“
Jennifer J.
Lernender seit 2020
„Bei einem spannenden neuen Projekt konnte ich die neuen Kenntnisse und Kompetenzen aus den Kursen direkt bei der Arbeit anwenden.“
Larry W.
Lernender seit 2021
„Wenn mir Kurse zu Themen fehlen, die meine Universität nicht anbietet, ist Coursera mit die beste Alternative.“
Chaitanya A.
„Man lernt nicht nur, um bei der Arbeit besser zu werden. Es geht noch um viel mehr. Bei Coursera kann ich ohne Grenzen lernen.“
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.