QlikView, Tableau, and Spotfire Training (Free Data Warehousing Course)

BY
Intellipaat

Master the skills of data visualization and dashboard creation by getting a grasp of QlikView, Tableau, and Spotfire through the course by Intellipaat.

Mode

Online

Fees

₹ 30894

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Business Intelligence is a recent invention in technology for the benefit of businesses. There are multiple applications designed to transform, analyze, and read the previously stored data. Technological advancement in business intelligence is adopted by every organization wholeheartedly, the demands of professionals who have a firm understanding of the tools are increasing. QlikView, Tableau, and Spotfire are among the top business intelligence tools, and getting a firm understanding of the tools shall open gates of opportunities for learners. 

Intellipaat has offered a combo of the three business intelligence tools for the learners who are keen to gain a firm understanding of the tools and want to pursue their career in the domain. QlikView, Tableau, and Spotfire Training (Free Data Warehousing and ERwin Course)online course is available on the portal of Intellipaat and comprises self-paced videos and projects for the overall development of the learner. The candidate can avail of multiple benefits associated with the course and shall receive QlikView, Tableau, and Spotfire Training (Free Data Warehousing and ERwin Course) certification by Intellipaat after the completion of the course. The certification is recognized in prominent MNCs and corporate companies and thus it increases the chances for learners to secure a position in the company. 

The highlights

  • 100% online course 
  • 60 hours self-paced videos 
  • 120 hours project and exercises 
  • Certification 
  • Flexible schedule 
  • Job assistance

Program offerings

  • Online course
  • Self-paced videos
  • Project learning
  • Convenient learning
  • Video demonstration
  • Assessments
  • Certification
  • Job assistance
  • Collaborative learning

Course and certificate fees

Fees information
₹ 30,894

Intellipaat offers a self-paced learning mode for the learners to grab a firm understanding of Spotfire, Tableau, and QlikView. The learners should pay the QlikView, Tableau, and Spotfire Training(Free Data Warehousing and ERwin Course) certification fee at the time of registration. Besides, for the individual learners, the platform also offers course to the organization to upskill their employees through corporate learning mode. The fee structure for both modes is distinct. Refer to the table to get information on the detailed fee structure. 

Fee structure for QlikView, Tableau, and Spotfire Training (Free Data Warehousing Course)

Course name 

Fee in INR

QlikView, Tableau, and Spotfire Training(Free Data Warehousing Course) self-paced learning 

Rs. 30,894

QlikView, Tableau, and Spotfire Training(Free Data Warehousing Course) corporate learning

 -

certificate availability

Yes

certificate providing authority

Intellipaat

Who it is for

QlikView, Tableau, and Spotfire Training certification benefits BI experts, ETL developers. SQL developers, Database ArchitectsData analysts who want to upgrade their skills or learn new skills for getting a career hike. The course aims for providing basic to advanced knowledge of QlikView, Tableau, Spotfire. After completing the course, candidates shall become proficient in handling BI tools and shall be able to secure a position in a prominent company with the certification received from Intellipaat.

Eligibility criteria

There are no prerequisites for the QlikView, Tableau, and Spotfire Training but having an understanding of SQL and database shall prove to be an extra advantage while taking up QlikView, Tableau, and Spotfire Training(Free Data Warehousing and ERwin Course) classes. 

Certification Qualifying Details

The QlikView, Tableau, and Spotfire Training (Free Data Warehousing and ERwin Course) certification by Intellipaat is offered after the students have been able to complete the related assessments, and projects.

What you will learn

Tableau knowledge

The QlikView, Tableau, and Spotfire Training (Free Data Warehousing and ERwin Course) certification course is designed as per the specific needs of the industry. The course provides comprehensive knowledge of QlikView, Tableau, and Spotfire for inculcating basic and advanced skills in the learner. The course includes topics such as Tableau filters and graphs, QlikView objects and charts, Spotfire Workflow Automation services and frameworks. The course shall help the learner to land upon desirable job opportunities and proved to be an asset for the future company. After the completion of the course the learner shall become proficient and gain a firm understanding of the following topics: 

  • Introduction to Business Intelligence tools
  • Using QlikView to read data from tables
  • The architecture of QlikView, Tableau, and Spotfire tools
  • Creating data visualization using Tableau
  • Distinguishing chart-level and script-level functions
  • Working with Spotfire to create interactive dashboards
  • The technique of IronPython scripting
  • Using various computation tools and multivariate analysis
  • Data aggregation and data blending
  • Working on real-time projects for hands-on experience

The syllabus

Qlikview Course Content

Introduction to Qlikview
  • Introduction to the concepts of Business Intelligence, 
  • Learning about QlikView, 
  • The unique features of QlikView that make it the market leader,
  • Comparison to other BI tools, 
  • The complete overview and architecture of QlikView, 
  • Studying the various file types and extensions.
Qlikview Products
  • Learning about the various QlikView products, 
  • Understanding about the QlikView Desktop, Server, Access Point, Publisher, the Management Console and NPrinting reporting platform.
  • Hands-on Exercise 
Introduction to Data and Scripting
  • Understanding the data warehouse architecture, 
  • The concept of dimensional model, fact tables and dimensions,
  • Learning about Star and Snow Flake schema, 
  • QlikView data model comparison to other data models, 
  • Understanding the data source files.
  • Hands-on Exercise
Loading Data From The DataBase
  • Learning about loading data from various databases, 
  • Generating script, 
  • Loading of text files, 
  • Delimited text files, 
  • Loading data from multiple data sources, 
  • Various types of data loads like incremental, binary, resident, buffer, preceding, mapping load types, 
  • Understanding how to load inline-table, generic tables, 
  • Media content and image inclusion, 
  • Web page data loading, 
  • Semantic load, 
  • Various examples to simplify the concepts.
  • Hands-on Exercise
Structuring the Script
  • Learning to create tabs in the scripts, 
  • Debugging of scripts, 
  • Inclusion of variables and comments in the scripts.
  • Hands-on Exercise
Basic Data Model and Table Viewer
  • Understanding the basic data model of QlikView, 
  • Learning to work with the Table Viewer, 
  • The System Table and System fields.
  • Hands-on Exercise
Data Relationships
  • Introduction to the various data relationships – Join, Concatenation, Join, and the different options available in each.
  • Hands-on Exercise
Data Modelling Considerations
  • The rules of data modeling in QlikView, 
  • Introduction to circular references, 
  • Synthetic key tables,
  • Resolving synthetic keys and circular references.
  • Hands-on Exercise
Qlikview Data (QVD) Files
  • Understanding what is QVD file in QlikView,
  • The way to create QVD file, 
  • The standard structure of a QVD file, its various components,
  • The various types and uses of QVD files, 
  • Learning what is optimized and unoptimized load.
  • Hands-on Exercise
Creating a Master Calendar
  • Creating a master calendar in QlikView, 
  • Extracting the highest and lowest data, 
  • Deploying scripts to create variables, 
  • Working with arbitrary date ranges.
  • Hands-on Exercise
Qlikview Security
  • Understanding the various concepts of QlikView security, 
  • Defining the access controls, levels of access, maintaining the access control database, section access addition, and other concepts.
  • Hands-on Exercise
Handling Null Values
  • The various types of null values in QlikView and the different methods to handling them.
  • Hands-on Exercise
Sheets and Sheet Objects
  • Working with QlikView sheets and sheet objects, 
  • Learning about the sheet basics, crosstables, the data transformation in QlikView, 
  • Transposing a physical table.
  • Hands-on Exercise
The List Box
  • Understanding a list box, 
  • Most basic sheet object, 
  • The various actions in List Box, its properties, the example of a list box.
  • Hands-on Exercise
The Table Box
  • A sheet object that shows several fields simultaneously, 
  • Learning to create a table box, 
  • Sorting in table box, 
  • Understanding table box formatting options, 
  • Printing the data from table box, 
  • Exporting to a text file.
  • Hands-on Exercise
The Multi Box
  • Representation of value from multiple fields, 
  • Learning to create a multi-box,
  • The various selection features formatting and resizing of multi boxes.
  • Hands-on Exercise
The Button & Text Object
  • Working with text and button objects, learning to create them, formatting, resizing, copying, and moving of text objects, 
  • Understanding of action scripts in button and text objects.
  • Hands-on Exercise
Charts
  • Learning the basics of QlikView Charts, 
  • Graphical representation of numerical data, 
  • Various types of charts like bar, pie, grid, funnel, combo, 
  • Learning to create charts, 
  • Selections in charts and exporting of charts.
  • Hands-on Exercise
Multi Dimensional Charts, Pivot Tables
  • Introduction to multidimensional charts, 
  • Setting up multiple expressions in straight table and pivot table, 
  • Learning about straight table and pivot table, table box, and deploying visual cues.
  • Hands-on Exercise
Gauges
  • Learning about Gauge Chart in QlikView, 
  • The various types of Gauges, 
  • Understanding how to build Gauges, 
  • The various types of Gauge Charts.
  • Hands-on Exercise
The Other Sheet Objects
  • Introduction to the other sheet objects like Statistics Box, Slider/Calendar Object, Current Selections Box, Bookmark Object, Container Object, and Input Box.
  • Hands-on Exercise
Additional Editing in The Layout
  • The additional editing like settings of type legend, title, fast change chart type, text in chart and reference lines, caption settings and drilldown, cyclic functionality.
  • Hands-on Exercise
Uses Of Expressions
  • Learning about the various expressions like chart attribute, colour, working with calculated fields, labels, and dynamic text in text objects, calculated fields, and dimensions in list boxes and charts.
  • Hands-on Exercise
The Settings Menu
  • Learning about the settings menu in QlikView, 
  • The various options like user preferences, 
  • Document properties and sheet properties.
  • Hands-on Exercise
Qlikview Functions
  • The various QlikView functions like ApplyMap, Lookup, Previous, Value List, Interval Match, Class, Value Loop, Peek, Pick, Match, Wild Match, Statistical Functions, Range Functions, etc.
  • Hands-on Exercise
Adhoc Reports and Bookmarks
  • Learning about ad hoc report creation and editing, 
  • Introduction to QlikView bookmarks,
  • The various types of bookmarks, creating and managing bookmarks.
  • Hands-on Exercise
Layout Themes
  • Understanding QlikView themes, creating, applying, and working with dynamic themes.
  • Hands-on Exercise
Extensions
  • Learning about QlikView extensions, 
  • Visualizing of data with extensions, 
  • Creating a simple HTML extension,
  • HTML table, 
  • Working with interactive extensions and external libraries with extensions.
  • Hands-on Exercise
Set Analysis
  • Understanding set analysis, 
  • Defining data values that are different from the set definition, 
  • Working with modifiers, identifiers, operators, 
  • Example of expressions, 
  • Indirect set analysis, 
  • YTD & MTD and rolling 12 months, various examples.
  • Hands-on Exercise
Alternate States
  • Understanding alternate states for performing comparative analysis on sets of multiple data items, 
  • Working with market basket analysis, 
  • Examples of various alternate states.
  • Hands-on Exercise
What-IF Analysis
  • Understanding what-if analysis in QlikView, 
  • Working on creating variables, slider objects, assigning variables to sheet and slider objects.
  • Hands-on Exercise
Server Installation & Deployment
  • The process of installation, 
  • Various types of licenses, types of CALS, 
  • Learn to deploy the application on the server, 
  • Working with server bookmarks, annotations.
  • Hands-on Exercise

Tableau Course Content

Module 1 - Introduction to Data Visualization and The Power of Tableau
  • What is data visualization?
  • Comparison and benefits against reading raw numbers
  • Real use cases from various business domains
  • Some quick and powerful examples using Tableau without going into the technical details of Tableau
  • Installing Tableau
  • Tableau interface
Module 2 - Architecture of Tableau
  • Architecture of Tableau
  • The interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane, etc.)
  • Tableau field types
  • Saving and publishing a data source
  • Live vs extract connection
  • Various file types
  • The ways to share and export the work done in Tableau
Module 2 - Architecture of Tableau: Hands-on Exercise
  • Play with Tableau desktop
  • Learn about the interface
  • Share and export existing works
Module 3 - Charts and Graphs
  • Basic Charts
    • Histograms
    • Box plot
    • Motion
    • Pie
    • Bar
    • Line
    • Bubble
    • Bullet
    • Scatter
    • Tree
    • Heat maps
    • Maps
    • Text table
    • Highlighted table
  • Dual axes graphs
    • Pareto
    • funnel
    • Waterfall charts
    • Market basket analysis (MBA)
  • Hands-on Exercise:
    • Plot a histogram, tree map, heat map, funnel chart, and more using the given dataset
    • Perform market basket analysis (MBA) on the same dataset
Module 4 - Working with Metadata and Data Blending
  • Connecting to Data Source
  • Tableau data types
  • Connection to Excel
  • Cubes and PDFs
  • Management of metadata and extracts
  • Data preparation
  • Joins (Left, Right, Inner, and Outer) and Union
  • Dealing with NULL values, cross-database joining, data extraction, data blending, refresh extraction, incremental extraction, how to build extract, etc.
  • Advanced joins
    • cross-database joining
    • data blending
  • Hands-on Exercise:
    • Connect to Excel sheet to import data
    • Use metadata and extracts
    • Manage NULL values
    • Clean up data before using
    • Perform the join techniques
    • Execute data blending from multiple sources
Module 5 - Advanced Data Manipulations
  • Mark and highlight
  • Groups
  • Sets (creating and editing sets, IN/OUT)
    • Constant sets
    • Computed sets
    • Combined sets
  • Bins
  • Hierarchies
  • Folders
  • Sorting and Types
  • Using the Formatting pane to work with the menu, fonts, alignments, settings, etc.
  • Editing axes and annotations
  • Hands-on Exercise:
    • Use marks to create and edit sets
    • Highlight the desired items
    • Make Groups
    • Apply sorting on results
    • Make hierarchies among the created sets
Module 6 - Working with Filters
  • Filters (addition and removal)
  • Filtering continuous dates, dimensions, and measures
  • Filtering in Tableau
  • Types of filters
  • Filtering the order of operations
  • Hands-on Exercise:
    • Use the data set by date/dimensions/measures to add a filter
    • Use interactive filter to view the data
    • Customize/remove filters to view the result
Module 7 - Organizing Data and Visual Analytics
  • K-means cluster analysis
  • Trend and reference lines
  • Visual analytics in Tableau
  • Forecasting, confidence interval, reference lines, and bands
  • Hands-on Exercise:
    • Apply labels and tooltips to graphs, annotations, edit axes’ attributes
    • Set the reference line
    • Perform k-means cluster analysis on the given dataset
Module 8 - Working with Mapping
  • Working on coordinate points
  • Plotting longitude and latitude
  • Editing unrecognized locations
  • Customizing geocoding, polygon maps, WMS: web mapping services
  • Working on the background image, including add image
  • Plotting points on images and generating coordinates from them
  • Map visualization, custom territories
  • How to create map projects in Tableau
  • Creating dual axes maps, and editing locations
  • Hands-on Exercise:
    • Plot longitude and latitude on a geo map
    • Edit locations on the geo map
    • Custom geocoding
    • Use images of the map and plot points
    • Find coordinates
    • Create a polygon map
    • Use WMS
Module 9 - Working with Calculations and Expressions
  • Calculation syntax and functions in Tableau
  • Various types of calculations, including Table, String, Date, Aggregate, Logic, and Number
  • Quick table calculations
  • The creation of calculated fields
  • Quick LODs
Module 9 - Working with Calculations and Expressions: Levels of details: fixed level, lower level, and higher level
  • LOD expressions, including concept and syntax
  • Nested LOD expressions
  • Aggregation and replication with LOD expressions
Module 10 - Working with Parameters
  • Creating parameters
  • Parameters in calculations
  • Using parameters with filters
  • Column selection parameters
  • Chart selection parameters
  • How to use parameters in the filter session
  • How to use parameters in the reference line
  • Hands-on Exercise:
    • Creating new parameters to apply on a filter
    • Passing parameters to filters to select columns
    • Passing parameters to filters to select charts
Module 11 - Dashboards and Stories
  • What is a dashboard?
  • Building and formatting a dashboard using size, objects, views, filters, and legends
  • Best practices for making creative as well as interactive dashboards using the actions
  • Creating stories
    • Including the intro of story points
    • Creating as well as updating the story points
    • Adding catchy visuals to stories
  • Adding annotations with descriptions; dashboards and stories
  • Highlight actions, URL actions, and filter actions
  • Selecting and clearing values
  • Dashboard examples using Tableau workspace and Tableau interface
  • Hands-on Exercise:
    • Create a Tableau dashboard view, include legends, objects, and filters
    • Make the dashboard interactive
    • Use visual effects, annotations, and descriptions to create and edit a story
Module 12 - Tableau Prep
  • Introduction to Tableau Prep
  • How Tableau Prep helps quickly combine join, shape, and clean data for analysis
  • Creation of smart examples with Tableau Prep
  • Getting deeper insights into the data with the great visual experience
  • Making data preparation simpler and accessible
  • Integrating Tableau Prep with Tableau analytical workflow
Module 13 - Integration of Tableau with R
  • Introduction to the R language
  • Applications and use cases of R
  • Learning R functions in Tableau
  • The integration of Tableau with Hadoop
  • Hands-on Exercise:
    • Deploy R on Tableau
    • Create a line graph using R interface

Spotfire Course Content

TIBCO Spotfire Introduction
  • The basics of TIBCO Spotfire, 
  • Data visualization and analytics software, 
  • Various Spotfire features, 
  • Data Filtering, 
  • Data drill-down, 
  • Data loading, 
  • Data table format, 
  • A statistical representation of data, 
  • Web Player for analytics report, 
  • Importing data from Excel, 
  • Data types, 
  • Data visualization techniques, 
  • Spotfire Dashboard, 
  • Working with Bar Charts.
Spotfire Data Table & Data Sources
  • Working with Data Tables
  • Data sourcing
  • Fetching data from databases
  • Properties of Data Table
  • Relations in data table and column matching
  • Data table filters, settings and filter schemas
  • Calculated, Binned and Hierarchy Column creation.
Spotfire Data Visualization
  • Visualizing data to exploring, analyzing, and discovering insights,
  • Understanding the concepts of Coloring, Trellis Visualization, bar chart, combination chart, and line chart,
  • Working with Zoom Slider, Cross-table Visualization, Column Selectors.
Advanced Visualization & Analysis
  • In-depth understanding of Spotfire visualization techniques, 
  • Advanced color coding concepts, 
  • Analyzing data, working with tags, lists, bars, and data labels,
  • Understanding the various techniques of Pie charts, TreeMap, and Scatter plots
Spotfire Server Features
  • Importance of Spotfire Server for Deployment
  • Library and Information Services
  • Working with Spotfire Expressions, Labels, Charts, Schemas
  • Understanding of Heat Map, Dendograms.
Deep Dive into Data Analysis and Organization
  • The scope of Spotfire Professional
  • Data access
  • Visualization and analysis
  • Working with input filter
  • Property control dialogue for changing settings in visualization, custom expressions
  • Deploying Action control and Dynamic items
  • Spotfire Dashboard features, data filtering, filter schemas
  • Analysis techniques like Box plot, Pareto chart, and Combination chart.
Spotfire Administration
  • Spotfire installation, 
  • Administration and maintenance, 
  • Deploying information designs and information links and joins, 
  • Personalization, 
  • Working with Web Player DXP, 
  • Spotfire authorization, authentication, and security.
Predictive Analytics- Map Visualization
  • Map Visualization
  • Forcasting
  • Text Area Features
  • Upload and Store data to Library
  • Drag and Drop of Visualization
  • Application of Profiler.
Spotfire Visual Insights
  • Visual Appearance
  • Recommendations
  • Mark from Legend
  • Data Panel
  • Interacting Grouping of Categories
  • Data Connector
  • Data Profiler
  • Collaboration.

Admission details

To enroll in the QlikView, Tableau and Spotfire Training online course follow the steps mentioned below:

Step 1: Visit the Intellipaat portal or click on the link https://intellipaat.com/qlikview-tableau-spotfire-training/. 

Step 2: Click on the ‘Enroll Now’ Tab and add the QlikView, Tableau, and Spotfire Training course to the cart. 

Step 3: Go to the edit cart section and fill in the required details. 

Step 4: Pay the QlikView, Tableau, and Spotfire Training(Free Data Warehousing and ERwin Course) certification fee through online mode. 

Step 5: Start learning the BI tools as per the designed QlikView, Tableau, and Spotfire Training(Free Data Warehousing and ERwin Course) certification syllabus. 

How it helps

Intellipaat is one of the acclaimed platforms for comprehensive learning and practical training. The QlikView, Tableau, and Spotfire Training certification course is designed as per the demand of the current industry. The learners shall be trained in a way that they shall prove to be an asset to the company. The growing demand for skilled professionals who have a firm understanding of BI tools is increasing. Hence, the course can be career-defining for the learners. There are various benefits of QlikView, Tableau, and Spotfire Training (Free Data Warehousing and ERwin Course) certification, few are mentioned below. 

  • The course includes projects like
    • QlikView Dashboard creation with 3 principals of DAR
    • Creating a mini chart in the QlikView application
    • Healthcare 
    • Analysing global COVID-19 Data with interactive Tableau Dashboard. 
    • Tableau dashboard for analyzing UK bank customer Data 
    • Tableau dashboard for analyzing financial data
    • Tableau dashboard for understanding the agriculture data
    • IronPython 
  • Intellipaat offers  24*7 support by mentors to the candidates for solving their queries and doubts. 
  • The job assistance is the unique feature by Intellipaat that prepares candidates for interviews, and prepares an effective resume and thus creating an impactful profile of the candidate.
  • Peer assistance is another feature of Intellipaat that promotes collaborative learning. It is the group of candidates that have essential information on technical events and classes. 

FAQs

What is the duration of the QlikView, Tableau, and Spotfire Training(Free Data Warehousing and ERwin Course) online course?

The duration of the course is 180 hours, which comprises self-paced learning videos and project training. 

How many projects are associated with the course?

There are 8 projects that must be completed by the learner during the course. The details of the projects are mentioned in the article. 

How can the learner connect with mentors?

Intellipaat offers 24*7 mentor support, the candidate can raise their query either in the peer learning group or during the class. 

What is the benefit of peer learning?

The peer learning feature by Intellipaat promotes collaborative learning and interaction with the seniors and juniors. It is also the platform to share information about technical events to present the projects. 

What is the advantage of self-paced learning?

Self-paced learning allows learning at a convenient time and place for learners. 

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books