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.

QlikView & QlikSense: Build & Analyze Data Models

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues. Consultez les langues disponibles.

QlikView & QlikSense: Build & Analyze Data Models

Instructeur : EDUCBA

Inclus avec

5 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

5 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

Install, configure, and navigate QlikView and QlikSense.
Load, transform, and model ERP data for BI analysis.
Build secure dashboards and optimize QVD workflows.

Compétences que vous acquerrez

Catégorie : Project Implementation
Catégorie : Business Intelligence
Catégorie : Interactive Data Visualization
Catégorie : Business Workflow Analysis
Catégorie : Extract, Transform, Load
Catégorie : Data Import/Export
Catégorie : Data Modeling
Catégorie : Enterprise Resource Planning
Catégorie : Security Controls
Catégorie : Data Transformation
Catégorie : Data Processing
Catégorie : Dashboard Creation
Catégorie : Workflow Management
Catégorie : Data Integration
Catégorie : Data Wrangling
Catégorie : Data Store
Catégorie : Authorization (Computing)
Catégorie : Data Warehousing
Catégorie : Data Visualization Software

Outils que vous découvrirez

Catégorie : Microsoft Excel

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Évaluations

21 devoirs

Enseigné en Anglais

91% of learners achieved a positive career outcome

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Il y a 5 modules dans ce cours

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.

Détails du module

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.

Inclus

12 vidéos4 devoirs

12 vidéosTotal 83 minutes

Overview of Qlikview2 minutes
Installation of Qlikview8 minutes
Basic Navigation9 minutes
Use Sheet and Objects9 minutes
Use Scripting5 minutes
Data Loading Excel File9 minutes
Data Loading Excel File Continues9 minutes
Data Loading Text File7 minutes
Data Loading Xml File4 minutes
Data Loading Webpage File4 minutes
Data Loading Incremental Load6 minutes
Data Loading QVD File11 minutes

4 devoirsTotal 60 minutes

QlikView Overview and Setup10 minutes
Sheets, Objects, and Scripting10 minutes
Data Loading Essentials10 minutes
Getting Started with QlikView30 minutes

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.

Inclus

16 vidéos4 devoirs

16 vidéosTotal 119 minutes

QlikView Functions5 minutes
Use of Peek Function8 minutes
How to Use Range Sum7 minutes
How to use Barchart11 minutes
How to Works in Piechart9 minutes
Transformation Rotate5 minutes
Transformation Unwrap5 minutes
How to use Transformation Column7 minutes
Transformation Column Continues9 minutes
Transformation Fill9 minutes
Transformation Garbage6 minutes
Dimension and Measure10 minutes
Star Data Model9 minutes
How to use Concatenate5 minutes
Use Cross Table6 minutes
How to Build Dashboard7 minutes

4 devoirsTotal 60 minutes

Working with Functions10 minutes
Charts and Transformations10 minutes
Measures and Data Models10 minutes
QlikView Functions and Visualizations30 minutes

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.

Inclus

16 vidéos4 devoirs

16 vidéosTotal 132 minutes

Joins12 minutes
Use Keep Command9 minutes
Pivot Table7 minutes
Set Analysis12 minutes
Straight Table5 minutes
Mapping Table11 minutes
Master Calendar12 minutes
Synthetic Key5 minutes
Generating Data6 minutes
Generating Data Continues7 minutes
Circular Reference8 minutes
Inline Load5 minutes
Preceding Load5 minutes
Resident Load7 minutes
Actual and Target Sales using Stripped Bar Chart12 minutes
More on Actual and Target Sales9 minutes

4 devoirsTotal 60 minutes

Joins and Tables10 minutes
Calendar, Keys, and Data Relationships10 minutes
Specialized Loads and Sales Analysis10 minutes
Advanced Data Modeling in QlikView30 minutes

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.

Inclus

8 vidéos4 devoirs

8 vidéosTotal 66 minutes

Introduction to QlikView Security9 minutes
Lab Session7 minutes
Document,Column and Row-level7 minutes
Object Level Security10 minutes
Sheet Level Security10 minutes
QVD QlikView7 minutes
Lab Session on QVD9 minutes
Lab Session on QVD Continues6 minutes

4 devoirsTotal 60 minutes

Introduction to QlikView Security10 minutes
Object and Sheet-Level Security10 minutes
QVD Security and Labs10 minutes
Data Security in QlikView30 minutes

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.