MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Qlikview, Tableau, Spotfire Training

Course Summary

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.


  • +

    Course 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 – Practice 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.Hands-on Exercise – 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.Hands-on Exercise – Load data from a database, Generat script, Load a delimited text file, Load data from excel file, Load inline table, generic tables, media content,Include image, Load a web page data
    Structuring the Script
    Learning to create tabs in the scripts, debugging of scripts, inclusion of variables and comments in the scripts.Hands-on Exercise – Create tabs in the scripts, debug a script, Include 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.Hands-on Exercise – 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.Hands-on Exercise – Use Join, Concatenation
    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 – Resolve 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.Hands-on Exercise – Create QVD file
    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 – Create a master calendar in QlikView, Extract the highest and lowest data, Deploy scripts to create variables, Work 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.Hands-on Exercise – Create the access controls rules, Create different levels of access, Access and Edit the access control database
    Handling Null Values
    The various types of null values in QlikView and the different methods to handling them.Hands-on Exercise – Handle null values in QlikView
    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.Hands-on Exercise – Perform a data transformation in QlikView, Transpose 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.Hands-on Exercise – Use a list box and assign actions to it
    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 – Create a sheet object that shows several fields simultaneously, Create a table box, Sort data in table box, Format data in a table box, Print the data of table box, Export data 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.Hands-on Exercise – Create a multibox, Select data using different criteria, Format and Resize a multiboxe
    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 – Create text and button objects, Format, Resize, Copy and Move text objects, Run 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.Hands-on Exercise – Plot charts like bar, pie, grid, funnel, combo, Make selections in charts and export 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.Hands-on Exercise – Plot multidimensional charts, Set up multiple expressions in straight table and pivot table, Deploy 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.Hands-on Exercise – Build Gauge chart in QlikView
    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 – Create 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.Hands-on Exercise – Set up type legend, title, captions
    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 – Create chart attributes, Assign colour, Work with calculated fields,Create dynamic text in text objects
    The Settings Menu
    Learning about the settings menu in QlikView, the various options like user preferences, document properties and sheet properties.Hands-on Exercise – Use settings menu in QlikView to set 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.Hands-on Exercise – Use functions ApplyMap, Lookup, Previous, Value List, Interval Match, Class, Value Loop, Peek, Pick, Match, Wild Match, Statistical Functions,Range Functions
    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 – Create ad hoc report, Edit the report, Create and manage bookmarks
    Layout Themes
    Understanding QlikView themes, creating, applying and working with dynamic themes.Hands-on Exercise – Create, apply and work 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.Hands-on Exercise – Use QlikView extension for data visualization, Create a simple HTML extension, Work with interactive 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.Hands-on Exercise – Work with modifiers, Identifiers, Operators, Expressions, Implement YTD & MTD and rolling 12 months
    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 – Perform comparative analysis on sets of multiple data items, Do market basket analysis
    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 – Do what-if analysis in QlikView
    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 – Deploy an app on the server

    Tableau Course Content

    Introduction to Data Visualization and Power of Tableau
    What is data visualization, Comparision and benefits against reading raw numbers, Real usage examples from various business domains, Some quick powerful examples using Tableau without going into the technical details of Tableau
    Architecture of Tableau
    Installation of Tableau Desktop, Architecture of Tableau, Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane etc), How to start with Tableau, Ways to share and exporting the work done in TableauHands-on Exercise – Play with the tableau desktop, interface to learn its user interface, Share an existing work, Export an existing work
    Working with Metadata & Data Blending
    Connection to Excels, PDFs and Cubes, Managing Metadata and Extracts, Data Preparation and dealing with NULL values, Data Joins (Inner, Left, Right, Outer) and Union, Cross Database joining, Data BlendingHands-on Exercise – Connect to an excel sheet and import data, Use metadata and extracts, Handle NULL values, Clean up the data before the actual use, Perform various join techniques, Perform data blending from more than one sources
    Creation of sets
    Marks, Highlighting, Sort and Group, Working with Sets (Creation of sets, Editing sets, IN/OUT, Sets in Hierarchies)Hands-on Exercise – Create and edit sets using Marks, Highlight desired items, Make groups, Applying sorting on result, Make hierachies in the created set
    Working with Filters
    Filters (Addition and Removal), Filtering continuous dates, dimensions, measures, Interactive FiltersHands-on Exercise – Add Filter on data set by date/dimensions/measures, Use interactive filter to views, Remove some filters to see the result
    Organizing Data and Visual Analytics
    Formatting Data (Labels, Annotations, Tooltips, Edit axes), Formatting Pane (Menu, Settings, Font, Alignment, Copy-Paste), Trend and Reference Lines, Forecasting, k-means Cluster Analysis in TableauHands-on Exercise – Apply labels, annotations, tooltips to graphs, Edit the attributes of axes, Set a reference line, Do k-means cluster analysis on a dataset
    Working with Mapping
    Coordinate points, Plotting Longitude and Latitude, Editing Unrecognized Locations, Custom Geocoding, Polygon Maps, WMS: Web Mapping Services, Background Image (Add Image, Plot Points on Image, Generate coordinates from Image)Hands-on Exercise – Plot latitude and longitude on geo map, Edit locations on the map, Create custom geocoding, Use images of a map and plot points on it, find coordinates in the image, Create a polygon map, Use WMS
    Working with Calculations & Expressions
    Calculation Syntax and Functions in Tableau, Types of Calculations (Table, String, Logic, Date, Number, Aggregate), LOD Expressions (concept and syntax), Aggregation and Replication with LOD Expressions, Nested LOD Expressions
    Working with Parameters
    Create Parameters, Parameters in Calculations, Using Parameters with Filters, Column Selection Parameters, Chart Selection ParametersHands-on Exercise – Create new parameters to apply on a filter, Pass parameters to filters to selet columns, Pass parameters to filters to select charts
    Charts and Graphs
    Dual Axes Graphs, Histogram (Single and Dual Axes), Box Plot, Pareto Chart, Motion Chart, Funnel Chart, Waterfall Chart, Tree Map, Heat Map, Market Basket analysisHands-on Exercise – Plot a histogram, heat map, tree map, funnel chart and others using the same data set, Do market basket analysis on a given dataset
    Dashboards and Stories
    Build and Format a Dashboard (Size, Views, Objects, Legends and Filters), Best Practices for Creative and Interactive Dashboards using Actions, Create Stories (Intro of Story Points, Creating and Updating Story Points, Adding Visuals in Stories, Annotations with Description)Hands-on Exercise – Create a dashboard view, Include objects, legends and filters, Make the dashboard interactive, Create and edit a story with visual effects, annotation, description
    Integration of Tableau with R and Hadoop
    Introduction to R Language, Applications and Use Cases of R, Deploying R on Tableau Platform, Learning R functions in Tableau, Integration with HadoopHands-on Exercise – Deploy R on tableau, Create a line graph using R interface, Connect tableau with Hadoop and extract data

    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 Projects

    Project 1 – QlikView Dashboard creation using 3 principles of DAR

    Objective – 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.

    Project 2

    Domain – Human ResourceObjective – To see the current values of salaries in one column and historical values in another cell in a mini chart that would contain a bar chart and a trend chart

    Project 3

    Domain – HealthcareObjective – Visual Mapping between Vaccination rate and Measles outbreak

    Tableau Projects
    Project 1 – Tableau Interactive DashboardData Set – SalesObjective – 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.
    Project 2Domain – Crime Statistics (Public Domain)Objective –The Project aims to show the types of crimes and their frequency that happen in the District of Columbia. Also to provide the details of the crimes like, the area/location and day of the week the crime has happenedProblem statement :Police departments are often called upon to put more “feet on the street” to prevent crime and keep order. But with limited resources, it’s impossible to be everywhere at once. This visualization shows where crimes take place by type and which day of the week. This kind of information gives local police more guidance on where they should deploy their crime prevention efforts.
    1. Map should be plotted at Block site address level
    2. Show the Offense, Location and Date of Crime occurrence.
    3. Show the Number of incidents and frequency in percentage for each type of crime happened(Offense)
    4. Show each incident happened every month by week and weekday and by offense type
    5. The dashboard should have Crime type and District filters which will be applicable to all three sheets in the dashboard
    6. An action from Map should filter out the other two sheets accordingly
    7. An action from tree map and bar chart should highlight the remaining two sheets according to the selection
    Project 3Domain – HealthcareObjective –Visual Mapping between Vaccination rate and Measles outbreakProblem statement :
    • Plot measles outbreaks depending on the coverage of population
    • Plot measles infection cases before 1st dose, between 1st and 2nd dose and after the 2nd dose of measles vaccination
    • Plot the correlation between immunity when vaccination coverage is high within schools
    • Plot correlation between poor urban areas which were not vaccinated at high rate and other areas which were vaccinated properly
    Lab Environment : Tableau Desktop (Better to use latest version which is 10.3 or any version later 10.0 will also have the impact)
    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.


Course Fee:
USD 542

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Open Source , Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url