К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
QlikView & QlikSense: Build & Analyze Data Models · LearnSpace
Назад в каталог
courseraАнализ данных

QlikView & QlikSense: Build & Analyze Data Models

Курс от EDUCBA
Уровень не указан≈ 16.2 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Data Import/ExportData Visualization SoftwareBusiness IntelligenceScriptingData TransformationAuthorization (Computing)Dashboard CreationRole-Based Access Control (RBAC)Data ModelingData IntegrationExtract, Transform, LoadInteractive Data VisualizationData StoreData ProcessingSecurity ControlsData WranglingData WarehousingMicrosoft ExcelEnterprise Resource PlanningProject Implementation

Программа курса

5 модулей · 98 учебных материалов

01Getting Started with QlikView18 материалов

QlikView Overview and Setup

Overview of QlikviewВидеоInstallation of QlikviewВидеоBasic NavigationВидеоQlikView Overview and SetupЗадание

Sheets, Objects, and Scripting

Учитесь у экспертов

EDUCBA

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

QlikView & QlikSense: Build & Analyze Data Models
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 16.2 ч

5 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский, Венгерский

Часть программы вашего университета
Use Sheet and ObjectsВидео
Use ScriptingВидео
Sheets, Objects, and ScriptingЗадание

Data Loading Essentials

Data Loading Excel FileВидеоData Loading Excel File ContinuesВидеоData Loading Text FileВидеоData Loading Xml FileВидеоData Loading Webpage FileВидеоData Loading Incremental LoadВидеоData Loading QVD FileВидеоData Loading EssentialsЗаданиеExploring Data Connections and Navigation in QlikViewDIALOGUEGetting Started with QlikViewЗаданиеPreparing and Loading Business Data in QlikViewDIALOGUE
02QlikView Functions and Visualizations20 материалов

Working with Functions

QlikView FunctionsВидеоUse of Peek FunctionВидеоHow to Use Range SumВидеоWorking with FunctionsЗадание

Charts and Transformations

How to use BarchartВидеоHow to Works in PiechartВидеоTransformation RotateВидеоTransformation UnwrapВидеоHow to use Transformation ColumnВидеоTransformation Column ContinuesВидеоTransformation FillВидеоTransformation GarbageВидеоCharts and TransformationsЗадание

Measures and Data Models

Dimension and MeasureВидеоStar Data ModelВидеоHow to use ConcatenateВидеоUse Cross TableВидеоHow to Build DashboardВидеоMeasures and Data ModelsЗаданиеQlikView Functions and Visualizations
03Advanced Data Modeling in QlikView20 материалов

Joins and Tables

JoinsВидеоUse Keep CommandВидеоPivot TableВидеоSet AnalysisВидеоStraight TableВидеоMapping TableВидеоJoins and TablesЗадание

Calendar, Keys, and Data Relationships

Master CalendarВидеоSynthetic KeyВидеоGenerating DataВидеоGenerating Data ContinuesВидеоCircular ReferenceВидеоCalendar, Keys, and Data RelationshipsЗадание

Specialized Loads and Sales Analysis

Inline LoadВидеоPreceding LoadВидеоResident LoadВидеоActual and Target Sales using Stripped Bar ChartВидеоMore on Actual and Target SalesВидеоSpecialized Loads and Sales AnalysisЗадание
04Data Security in QlikView12 материалов

Introduction to QlikView Security

Introduction to QlikView SecurityВидеоLab SessionВидеоDocument,Column and Row-levelВидеоIntroduction to QlikView SecurityЗадание

Object and Sheet-Level Security

Object Level SecurityВидеоSheet Level SecurityВидеоObject and Sheet-Level SecurityЗадание

QVD Security and Labs

QVD QlikViewВидеоLab Session on QVDВидеоLab Session on QVD ContinuesВидеоQVD Security and LabsЗаданиеData Security in QlikViewЗадание
05QlikSense ERP Project28 материалов

Project Introduction and Applications

Introduction to ProjectВидеоDashboard OverviewВидеоThree Deferent Application DetailВидеоApplication TablesВидеоProject Introduction and ApplicationsЗадание

Data Transformations I

Account ClassВидеоTraining TransformВидеоOrders TransformВидеоETA StatusВидеоEmployee Detail TransformВидеоData Transformations IЗадание

Data Transformations II

Transaction Detail TransformВидеоJournal Detail TransformВидеоInventory Details TransformВидеоInventoryВидеоMaster CalendarВидеоData Transformations IIЗадание

ERP Insights and Analysis

Development OverviewВидеоOrder ShippedВидеоInclude Null ValuesВидеоAccount BalancesВидеоCustomer by GenderВидеоProduct SheetВидеоEmployee was Sales
Задание
Advanced Data Modeling in QlikViewЗадание
Видео
Add ExpressionВидео
ERP Insights and AnalysisЗадание
QlikSense ERP ProjectЗадание
Securing and Optimizing an ERP Analytics Dashboard in QlikView and QlikSenseDIALOGUE