Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Build end-to-end business intelligence skills with QlikView and QlikSense, from installation and data preparation to secure data modeling and ERP analysis. Designed for learners seeking practical BI, dashboard, and enterprise reporting skills, this course guides you through navigating QlikView, creating sheets and objects, writing load scripts, and importing data from Excel, text, XML, and QVD files. You’ll use functions such as Peek() and RangeSum(), transform datasets, and create dynamic bar and pie charts with dimensions and measures. You’ll construct star schemas, apply joins and keep commands, build straight and pivot tables, create master calendars, resolve synthetic keys and circular references, and perform Actual vs. Target sales analysis. You’ll also implement document-, sheet-, object-, and QVD-level security controls through practical labs. What makes this course distinctive is its progression from QlikView fundamentals to a project-based QlikSense ERP analysis. You’ll integrate and transform accounts, training, orders, ETA, journal, and inventory data, then create dashboards for account balances, customer demographics, inventory, and sales performance. Enroll to develop the technical and analytical skills needed to build secure data models, manage BI workflows, and turn enterprise data into actionable insights.

Syllabus

Getting Started with QlikView
- 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.
QlikView Functions and Visualizations
- 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.
Advanced Data Modeling in QlikView
- 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.
Data Security in QlikView
- 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.
QlikSense ERP Project
- 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.