- Combo Offers (48)
- Big Data (48)
- Data Science (11)
- Business Intelligence (43)
- Salesforce (2)
- Cloud Computing (3)
- Mobile Development (2)
- Digital Marketing (5)
- DataBase (8)
- Programming (13)
- Testing (5)
- Project Management (9)
- Website Development (5)
Home / Business Intelligence / Qlikview, Tableau, Spotfire Training
Qlikview, Tableau, Spotfire Training
(Free DWH & Erwin)Our QlikView, Tableau, Spotfire master program will let you gain proficiency in these three business intelligence tools. You will work on real life industry projects in data visualization, interactive dashboard, multivariate analysis, data aggregation, blending and reporting.
About Course
Master data visualization and dashboard creation by learning QlikView, Tableau and Spotfire at one time
This is a Combo Training Course that provides a great opportunity to learn some of the top Business Intelligence tools available in the market today. It has been designed taking into consideration the specific needs of the industry. Work among other things with QlikView Objects and Charts, Tableau Filters and Graphs, Spotfire Workflow Automation services and Frameworks.
What you will learn in this Training Course?
- Introduction to Business Intelligence tools
- Architecture of QlikView, Tableau and Spotfire tools
- Use QlikView to read data from Tables
- Create data visualization using Tableau
- Work with Spotfire to create interactive dashboards
- Distinguish Chart level and Script level functions
- Study the technique of IronPython scripting
- Understand data aggregation and data blending
- Use various computation tools and multivariate analysis
- Work on real-time project for hands-on experience.
Who should take this Training Course?
- Business Intelligence Professionals and ETL Developers
- SQL Developers, Database Architects and Mainframe Professionals
- Analytics and Testing professionals
What are the prerequisites for taking this Training Course?
Why should you take this Training Course?
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.
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.
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.
Structuring the Script
Learning to create tabs in the scripts, debugging of scripts, inclusion of variables and comments in the scripts.
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.
Data Relationships
Introduction to the various data relationships – Join, Concatenation, Join, and the different options available in each.
Data Modelling Considerations
The rules of data modeling in QlikView, introduction to circular references, synthetic key tables, resolving synthetic keys and circular references.
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.
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.
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.
Handling Null Values
The various types of null values in QlikView and the different methods to handling them.
Sheets and Sheet Objects
Working with QlikView sheets and sheet objects, learning about the sheet basics, cross tables, the data transformation in QlikView, transposing a physical table.
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.
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.
The Multi Box
Representation of value from multiple fields, learning to create a multibox, the various selection features, formatting and resizing of multiboxes.
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.
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.
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.
Gauges
Learning about Gauge Chart in QlikView, the various types of Gauges, understanding how to build Gauges, the various types of Gauge Charts.
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.
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.
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.
The Settings Menu
Learning about the settings menu in QlikView, the various options like user preferences, document properties and sheet properties.
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.
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.
Layout Themes
Understanding QlikView themes, creating, applying and working with dynamic themes.
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.
Set Analysis
Understanding set analysis, defining data values that are different from set definition, working with modifiers, identifiers, operators, example of expressions, indirect set analysis, YTD & MTD and rolling 12 months, various examples.
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.
What-IF Analysis
Understanding what-if analysis in QlikView, working on creating variables, slider objects, assigning variables to sheet and slider objects.
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.
Tableau Course Content
Introduction to Tableau
Overview of Tableau, data visualization and analytics, elements of the Tableau dashboard, understanding the significance of Tableau Desktop and Tableau Server, extensively work with data visualization using line, bar, area, stacked bar, and multi line charts, connecting with Excel data.
Deep dive into Tableau Graphs
Various data representation techniques, like Tables, Graphs and Maps understanding the basics of Tree Map, Histogram, Filled Map, Symbol Map, Pie Chart, Trend Lines, Normal Tables and Multi measure Tables.
Tableau Table Joins
Understanding the conditions and methodology for joining Tables, knowledge of Multi Table Joins.
Working with Metadata
Working with Table, creation of Calculated Fields, duplicating and renaming columns, conversion of data types, default aggregation.
Hierarchy & Groups
Tableau Hierarchy creation, Static Group creation, deploying functions for Group creation.
Tableau Sorting
The various options of Sorting in Tableau, sorting of Multi-dimensional graph, deploying combined fields and setting sorting priorities.
Dual Axis Graphs
Working with Dual Line Charts, Multiline Chart, Donut Chart, Pie Chart, working with Measure Name and Measure Values.
Histogram
Learning about the different type of Single Axis Histogram, Dual Axis Histogram.
Pareto Chart
Understanding how to design and work with Pareto Chart
Motion Chart
Deploying Motion Chart for data that changes over time using x and y axes
Box Plot
Representation of numerical data through quartiles using Box Plot
Funnel Chart
Working with Funnel Chart for data that progressively reduces with each stage.
Waterfall Chart
Deploying Waterfall Chart for understanding the cumulative effect of sequential values.
Sets
Understanding the concept of Set which is an entity whose composition is based on a computed condition.
String Calculated Fields
Learning how to perform various operations on Strings like concatenation, manipulation and analyzing with String Calculated Fields
Date Calculated Fields
Working with Date Calculated Fields for performing operations like parsing, modifying and analyzing.
Tableau Parameters
Learning to use the dynamic values or parameters including What if Analysis, Column Selection Parameters, Chart Selection Parameters
Tableau Actions
Tableau lets you add interactivity and context to your data using Filter Actions, URL Actions.
Dashboard Creation
Working with the Tableau Dashboard and understanding the various concepts like Formatting, Containers, Navigations and Actions.
Tableau Architecture
Understanding the basic Architecture of Tableau, learning about Tableau Desktop features, Tableu Server, working of Tableau and the various Tableau Products.
Tableau Products, Tableau public Features, Tableau Desktop personal features, Tableau Desktop professional feature, Tableau Server Feature, Tableau File System, Tableau Working, Tableau Server Architecture
Connection Type
Tableau Connections –Live Connection and Data Extract Connection, Comparing the two Live And Extract connection
Sharing Dashboard
Learning to work on Tableau by sharing the dashboard with offline users.
Data Blending
Methods to work with data from disparate sources, defining the relationship between the data and combining it in the optimal way.
Dashboard Filter
Working with various Tableau Filter options, understanding the Filter Dimensions and ways to make the Filter Global.
Filter Deployment
Taking the various data sources and implementing to blend the graphs, using Global Fliter for blending graphs.
Tableau LOD Expression
Tableau Level of Detail Expressions for combining aggregate and non-aggregate data, converting aggregate to non-aggregate data in Tableau 9.X
MapBox Integration
Integrating MapBox on Tableau for deploying Maps into Tableau Visualization
Table Calculation
Understanding Tableau Table Calculation, familiarizing with Graph and View, learning about Context filter.
Aggregating Data
Understanding the concept of aggregating data in Tableau, defining Table Calculation, working with Drop Lines, Mark Labels, FORMAT function, working with String, Date and Logical Function, data disaggregating, forecasting.
LOD Expression Function
Deploying the Exclude function in LOD
Integration of Tableau and R
Introduction to R Statistical computing, the various applications and use cases of R language, deploying R on the Tableau platform, learning the R functions in Tableau, the concept of Outliers in tableau,
K-means in Tableau
Learning how to deploy K-means clustering in order to group and parse data in Tableau.
Tableau StoryTelling
The art of telling stories with Tableau, the importance of story point and determining when to deploy Tableau Storytelling
Storytelling on Graph
Converting the data available on a Graph into a Visual Storytelling endeavour.
Clustering and Advanced Bar charts in Tableau 10
You will learn to create clustering, understanding how it works for scatter plots, text tables and maps, creation of custom territories, mastering the art of advanced bar charts in Tableau 10.This video explains about clustering, creating custom territories and Advanced Bar charts in Tableau 10.
Multiple data source filters & advanced maps
Understanding the various Tableau 10 features like Highlighter, deploying multiple data sources for creation of filter and advanced mapping functionalities.
Beautify by design in Tableau 10
Introduction to the various new features of Tableau 10, working with Device Designer, New Device Interface, Color palette and more.
Data breakthrough in Tableau 10
Understanding new data breakthrough in Tableau 10, new features of data sources, integrating multiple data sources for deriving insights.
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, 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, and 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 Chart, Tree Map and Scatter Plot.
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, deloying 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.
Qlikview Project
Project – QlikView Dashboard creation using 3 principles of DAR
Topics – This project involves understanding the concepts of the QlikView Dashboard, Analysis, Reporting (DAR) methodology to creating and building of QlikView applications. This way you can reuse your earlier QlikView Worksheets with minimal changes thus saving you time and effort. You will have hands-on experience in designing the Dashboard, creating Analysis Page and ultimately develop the QlikView Reports with DAR implementation. You will learn about the business overview, deploying user-driven controls for data filters and reporting of specific details in this QlikView Dashboard project.
Tableau Project
Project – Tableau Interactive Dashboard
Data Set – Sales
Topics – This project is involved with working on a Tableau dashboard for sales data. You will gain in-depth experience in working with dashboard objects, learn about visualizing data, highlight action, and dashboard shortcuts. With a few clicks you will be able to combine multiple data sources, add filters and drill down specific information. You will be proficient in creating real time visualizations that are interactive within minutes.
Upon completion of this project you will understand how to create a single point of access for all your sales data, ways of dissecting and analyzing sales from multiple angles, coming up with a sales strategy for improved business revenues.
Spotfire Project
Project – IronPython
Data – Sales
Topics – This project is involved with creating IronPython script for Spotfire platform. You will start with the basics of implementing the IronPython scripting like importing classes for the visualization. In this sales project you will learn about the various operations and tools in IronPython scripting, creating data forms, collaboration platforms in Spotfire, framework for workflow, automating services all using the IronPython scripting.
Introduction to Spotfire
Data Visualization in Spotfire
Introduction to Tableau
Qlikview Tutorial
Qlikview Desktop Training
Tableau Project
View previous class recording
Intellipaat is a pioneer of Business Intelligence training. This industry-designed combo BI training includes some of the top BI tools like QlikView, Tableau and Spotfire. This Intellipaat training gives you an unprecedented opportunity to master the best combination of QlikView Charts, Tableau visualizations, Spotfire dashboard in order to become a BI professional unlike any.
The entire course content is designed towards clearing the following exams: QlikView Developer Certification, Tableau Desktop Qualified Associate Certification, Spotfire Knowledge Assessment Exam.
This is a completely career-oriented training designed by industry experts. Your training program includes real time projects, step-by-step assignments to evaluate your progress and specially designed quizzes for clearing the requisite certification exams.
Intellipaat also offers lifetime access to videos, course materials, 24/7 Support, and course material upgrades to latest version at no extra fees. Hence it is clearly a one-time investment.
Intellipaat basically offers the self-paced training and online instructor-led training. Apart from that we also provide corporate training for enterprises. All our trainers come with over 12 years of industry experience in relevant technologies and also they are subject matter experts working as consultants. You can check about the quality of our trainers in the sample videos provided.
If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers. The best part is that you can contact Intellipaat even after completion of training to get support and assistance. There is also no limit on the number of queries you can raise when it comes to doubt clearance and query resolution.
The Intellipaat self-paced training is for people who want to learn at their own leisurely pace. As part of this program we provide you with one-on-one sessions, doubt clearance over email, 24/7 Live Support, lifetime LMS and upgrade to the latest version at no extra cost. The prices of self-paced training can be 75% lesser than online training. While studying should you face any unexpected challenges then we shall arrange a Virtual LIVE session with the trainer.
We provide you with the opportunity to work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready. These projects could be in exciting and challenging fields like banking, insurance, retail, social networking, ecommerce, marketing, sales, high technology and so on. The Intellipaat projects are equivalent to six months of relevant experience in the corporate world.
Yes, Intellipaat does provide you with placement assistance. We have tie-ups with 80+ organizations including Ericsson, Cisco, Cognizant, TCS, among others that are looking for skilled & quality professionals and we would be happy to assist you with the process of preparing yourself for the interview and the job.
Yes, if you would want to upgrade from the self-paced training to instructor-led training then you can easily do so by paying the difference of the fees amount and joining the next batch of classes which shall be separately notified to you.
Upon successful completion of training you have to take a set of quizzes, complete the projects and upon review and on scoring over 60% marks in the qualifying quiz the official Intellipaat verified certificate is awarded.The Intellipaat Certification is a seal of approval and is highly recognized in 80+ corporations around the world including many in the Fortune 500 list of companies.
This course is designed to clear the following:
- QlikView Developer Certification
- Tableau Desktop Qualified Associate Certification
- Spotfire Knowledge Assessment Exam
The entire training course content is in line with respective certification program and helps you clear the requisite certification exam with ease and get the best jobs in the top MNCs.
As part of this training you will be working on real time projects and assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.
At the end of this training program there will be quizzes that perfectly reflect the type of questions asked in the respective certification exams and helps you score better marks in certification exam.
Intellipaat Course Completion certificate will be awarded on the completion of Project work (on expert review)and upon scoring of at least 60% marks in the quiz. Intellipaat certification is well recognized in top 80+ MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
$542 | 30894
You will get Lifetime access to high quality interactive tutorials along with life time access to complete Course Material .There will be 24/7 access to video tutorials with email support. If you stuck in any unexpected problem we will provide online interactive sessions with trainer for issue resolving.
We provide 24X7 support by email for issues or doubts clearance for Self-paced training.
In online Instructor led training, trainer will be available to help you out with your queries regarding the course. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.
This course is designed for clearing QlikView Developer Certification conducted by Qlik ,Tableau Desktop Qualified Associate Certification conducted by Tableau software and Spotfire Knowledge Assessment Exam conducted by TIBCO .
At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate.
Disclaimer
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org
Sales Offer
- To avail this offer, enroll before 20th September 2017.
- This offer cannot be combined with any other offer.
- This offer is valid on selected courses only.
- Please use coupon codes mentioned below to avail the offer
Well Explained Material
Everything is so well explained. I liked the format and the material.By far, the best online training I have ever attended. Never seen such amazing trainers with excellent knowledge and answering capabilities.
Easily Understandable
Never thought learning Tableau was this easy. Great examples and assignments.
Great Course
One of the most intresting, valuable and enjoyable course i ever have. Excellent material and good tutoring. Highly recommended.
Classic Solution
it is step by step approach to help each problem related to this training.. I m quite impacted by intellipaat.. Thanks to the trainer also who made the tutorials so simple..good job
Good Training
This is excellent course to Understand QlikView Tableau Spotfire main components and Architecture whole course is so well designed and covers all different flavors of QlikView Tableau Spotfire .