Qlik Sense Introduction & Installation
How Qlik Sense varies from QlikView? Need for self-service business intelligence/business analytics tools, Qlik Sense data discovery, intuitive tool for dynamic dashboards and personalized reports, installation of Qlik Sense & Qlik Sense Desktop.
Hands-on Exercise – Install Qlik Sense & Qlik Sense Desktop
Qlik Sense Features
Drag-and-drop visualization, Qlik Data indexing engine, Data Dimensions relationships, Connect to multiple data sources, creating your own dashboards, data visualization, Visual Analytics, ease of collaboration.
Hands-on Exercise – Connect to a database or load data from an excel file, Create a dashboard
Qlik Sense Data Model
Understand Data Modeling, best practices, turning data columns into rows, converting data rows into fields, hierarchical level data loading, loading new or updated data from database, using a common field to combine data from two tables, handling data inconsistencies.
Hands-on Exercise – Turn data columns into rows,Convert data rows into fields, Load the data in hierarchical level, Load new or updated data from database, Use a common field to combine data from two tables
Creating a Data Model
Qlik Sense Data Architecture, understanding QVD layer, converting QlikView files to Qlik Sense files, working on synthetic keys and circular references.
Hands-on Exercise – Convert QlikView files to Qlik Sense files, Resolve synthetic keys and circular references
Advanced Data Modeling
Qlik Sense Star Schema, Link Table, Dimensions Table, Master Calendar, QVD files, optimizing data modeling.
Hands-on Exercise – Create a Qlik Sense Star Schema, Create Link Table, Dimensions Table, Master Calendar, QVD files
Qlik Sense Enterprise
Qlik Sense Enterprise class tools, Qlik Sense custom app, embedding visuals, rapid development, powerful open APIs, enterprise-class architecture, Big Data integration, enterprise security and elastic scaling.
Qlik Sense Visualization
Learning about Qlik Sense Visualization tools, Chart & Map creation, rich data storytelling, sharing analysis visually with compelling Visualizations.
Hands-on Exercise – Create Chart & Map , Create a story around dataset, Share analysis
Understanding Set Analysis in Qlik Sense, the various parts of a set expression like Identifiers, Operators, Modifiers and Comparative Analysis.
Hands-on Exercise – Do Set Analysis in Qlik Sense, Use set expression like Identifiers, Operators, Modifiers and Comparative Analysis