Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
QlikView Data Analytics & BI Platform
Rating: 4.2 out of 5(8 ratings)
90 students

QlikView Data Analytics & BI Platform

QlikView is a self driven data visualization tool. Drive insight discovery with the data visualization app
Created byAmit Kumar
Last updated 10/2021
English
English [Auto],

What you'll learn

  • QlikView Business Intelligence Platform
  • Able to develop dashboard as per the business needs
  • Able to be expert in data analytics
  • The career path will be wider so that a student can achieve a successful position in IT industry

Course content

1 section • 20 lectures • 20h 7m total length

  • Introduction to QlikView and Overview of QlikView Desktop47:32

    QlikView enables end-to-end business intelligence with in-memory associative analytics, connecting multiple data sources, building front-end data models, and publishing interactive dashboards to an Access Point.

  • Data Extraction from SQL Server & Excel and Creating QVD57:14

    Learn to extract data from SQL Server and Excel, load it into QlikView, and create QVD files to support fast, reusable dashboards.

  • Prepare Data Model using QlikView1:04:17

    Create a data transformation layer in qlikview to load, cleanse, and join tables. Apply date dimensions and calculated fields while avoiding synthetic keys and circular references.

  • Data Modelling in QlikView, Join, Keep, Concatenation, inline Table1:01:15

    Explore data modelling in QlikView by loading tables, establishing associations, and using join, keep, concatenation, and inline table techniques to build in-memory data models.

  • Inline load, incremental load, buffer load, partial reload, binary load1:07:50

    Learn to leverage inline, incremental, buffer, partial, binary, and resident loads in QlikView to optimize data models, memory use, and selective data extraction.

  • Visualization, theme maker, DAR methodology58:36

    Explore data modeling in QlikView, using global variables for date and currency formatting, and apply the DAR methodology with the theme maker to design dashboards across the presentation layer.

  • Intro to Viz, List box, Multi box, Horizontal list box, Vertical list box etc.58:54

    Learn to design QlikView dashboards using list box, vertical and horizontal list boxes, and multi box, plus statistic and input boxes, with current selection, reset, and back controls.

  • Intro to Viz, Other controls, Master Calendar55:33

    Learn to create and customize viz objects in qlikview, including line charts, text boxes, and a master calendar; apply distinct, money, and global variables to drive dashboards.

  • Search object, bookmark, container, bas chart, line chart, combo chart, thrills1:01:19

    Explore search objects, bookmarks, and containers to manage selections in QlikView dashboards, and create bar, line, and combo charts with multi-dimensional analysis using expressions, sorting, and colors.

  • Radar chart, mekko chart, scatter chart, grid chart, pie chart, block chart.1:01:18

    Learn how to build and customize radar, mekko, scatter, grid, pie, and block charts in QlikView, including color, labeling, dimension limiting, sorting, and top-N selections.

  • Intro to Viz, Gauge Chart, Straight Table, Pivot Table, Mini Chart.1:01:21

    Explore how to visualize data in QlikView with mini charts, gauge charts, straight tables, and pivot tables, and learn to tailor dimensions, measures, and expressions for insightful analytics.

  • Intro to Viz, Drill down, Cyclic group, What if analysis, First change of chart59:13

    Explore how to build interactive dashboards in QlikView, using drill-downs, what-if analysis, cyclic groups, and chart switching to compare totals, GST-inclusive pricing, and multi-dimensional data across countries and cities.

  • QlikView PDF Report, Action and Triggers1:00:41

    Explore how to build a pdf report in QlikView, using invoice templates with a company logo, data tables, and headers, then configure print actions and triggers from a dashboard.

  • If else condition, wild match, optimized load, date functions, MTD, YTD etc.1:02:02

    Learn to build conditional expressions in QlikView with if-else, wild match, match, and variables, and use date functions for today, 60 days, 3 months, MTD and YTD, optimized load.

  • Nested if else condition, conditional coloring, Set Analysis, Bookmark1:03:19

    Explore nested if else logic, conditional coloring, set analysis, and bookmarks in QlikView to create conditional dimensions and color-coded insights.

  • Apply Map, Mapping Load, Hidden Script, Section Access, Section Application1:01:42

    Learn to use map and mapping load with a country master and mapping table, and secure your QlikView apps with hidden script, section access, and section application.

  • Data level Section access, Action and Triggers, Set variable, show-hide1:03:30

    Explore data level section access, object visibility, and show-hide techniques in QlikView, using actions, triggers, and set variables to tailor dashboards for different user groups.

  • Understanding Assignment and Understanding of Project1:00:37

    Translate client assignments into a project by gathering business requirements, system specifications, and a data dictionary, then define data models, integrate sources, and deliver QlikView dashboards.

  • Alternate State, Interview questions & Answers1:01:11

    Learn to create alternate states in QlikView for competitive analysis by isolating selections across charts and dashboards.

  • Development of Assignment project - Issue Tracking Dashboard1:00:34

    Develop an issue tracking dashboard in QlikView by translating a business requirements document into a prototype output, detailing open and resolved issues, top departments, and bug trends.

Requirements

  • Basic Knowledge on SQL
  • Basic knowledge on Data Warehousing
  • Basic knowledge on OOPs concept

Description

QlikView is a complete data analytics platform that sets the benchmark for a new generation of analytics. With its one-of-a-kind associative analytics engine, sophisticated AI, and high performance cloud platform, you can empower everyone in your organization to make better decisions daily, creating a truly data-driven enterprise.


QlikView is for all of us – executives, decision-makers, analysts... you. Enable any BI use case and let users freely search and explore to uncover insights they won’t find with query-based BI tools.


Insight Advisor, your AI assistant in QlikView, instantly raises the data literacy of every user through insight generation, task automation, and search & natural-language interaction.


Get the convenience of on-premise for the most demanding enterprises. Scale confidently with powerful data integration, open APIs, and flexible governance.


QlikView can easily combine, load, visualize, and explore your data, no matter how large (or small). Ask any question and follow your curiosity. Search, select, drill down, or zoom out to find your answer or instantly shift focus if something sparks your interest. Every chart, table, and object is interactive and instantly updates to the current context with each action. Smart visualizations reveal the shape of your data and pinpoint outliers. And get faster time to insight with assistance from Insight Advisor for chart creation, association recommendations, and data preparation.

Who this course is for:

  • Beginners
  • Business Analysts
  • Programmers
  • Project Managers
  • HR professionals
  • Accounts Processionals
  • MIS executices

Report abuse