Курс от EDUCBABuild 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.
5 модулей · 98 учебных материалов

Преподаватель курса