Business Intelligence Masters Program

 Introduction to Data Warehouse & Business Intelligence

Learning Objectives - In this module, you will get an introduction of Data Warehousing and Business Intelligence with various ETL Tools and BI Tools with ERwin r9 Data Modeling. 

Topics - What is Data Warehousing?, Definitions by W.H. Inmon [Top-Down Design], Ralph Kimball [Bottom-Up Design], Inmon Vs Ralph Kimball, Data Warehousing Tools, Schema Modeling Tools, CA, ERwin, Dell Toad Data Modeler, Oracle Data Modeler, ETL Tools: Informatica Power Center, Talend DI Open Studio, IBM Data Stage, SAS, Data Warehousing categories. What is BI - Business Intelligence?, BI Definition, BI Tools, Classification of BI Tools.

 Data Warehouse Architecture

Learning Objectives - In this module, you will learn about the Data Warehouse Architecture which talks about the Various Source Systems i.e., Production Data into Relational, Flat File and various legacy system to Staging Area and finally into the Data Warehousing/Data Mart for presentation layer. 

Topics - Relational Vs Analytical. What are - OLTP, OLAP, OLAP categories - MOLAP, ROLAP, HOLAP, Data Warehouse Vs Data Mart, Dependent and Independent Data Mart, Data Warehouse Architecture, Source System, ETL Extraction, Transformation. What is a cube?, Benefits of cube?, How to create the cube?, How to deploy a cube?, How to create a report using a cube?

 Data Warehouse Dimension & Fact Tables

Learning Objectives - In this module, you will learn about different categories of Dimensional and Fact Type tables. Dimension - Slowly Changing Dimension concepts with Hierarchies and Level Attributes. Fact - Granularity for the fact data and also talks about the Measure Type. 

Topics - DIMENSION TABLE - What is a Dimension Table?, Dimension table categories, FACT TABLE - What is Fact Table?, Fact Table Granularity, Fact Table categories.

 Data Modeling

Learning Objectives - In this module, you will learn about What is Data Normalization and their 3 types of forms. Here you learn about the type of dimensional modeling, benefits, principles and characteristics 

Topics - What is Data Normalization?, Data Normalization Rules - 1NF, 2NF, 3NF, Data De-Normalization, Dimensional Modeling - What is DM?, Principles, Benefits, Type and Technique.

 Building Data Warehouse with ERwin

Learning Objectives - In this module you will see how we create a staging and target data warehouse and data marts from scratch to final. Decide the surrogate key, Dimension and Fact Tables. You also learn to generate the SQL scripts via ERwin r9. 

Topics - Source System Understanding, Future Data Requirement and Understanding, Designing and Developing Dimension Table, Designing and Developing Fact Table Designing and Developing ER Model With ERwin, Designing and Developing Entity Relationship Modeling.

 Introduction to Open Source ETL Tool Talend DI Open Studio 5.x

Learning Objectives - In this module, you will learn about the open source and commercial ETL Tools available into the market and it various comparisons. You will learn to create the flat file and relational target via Talend DI Open Studio 5.x using various Transformations. 

Topics - Open source ETL Talend DI Open Studio -Difference between Licensed and Open Source ETL Tools, What are Licensed and Open Source ETL Tools, Working with ETL Transformation in Talend Open DI Studio.

 Building ETL Project With Talend DI Open Studio 5.x

Learning Objectives - In this module, you will learn to create the actual business model and data integration jobs with management of various ETL items. You will learn how the actual ETL Projects work with BRD[Business Requirement Document] and TDD [Technical Design Document] and its uses. 

Topics - Building ETL Project Talend DI Open Studio, Understanding the Data Source System which will be a future Data Requirement, Identify Business Requirement Gathering, Building the ETL Talend Technical Design Document, Building an ETL Project.

 Introduction to Data Visualization BI Tool Tableau 9.x

Learning Objectives - In this module, you will learn about the Data Visualization Tools available in the market. You will learn to create reports and dashboards via Tableau 9.x using various functions. 

Topics - Data Visualization BI Tool : Tableau 9.x-Introduction to Data Visualization with Tableau, Exploring Data Visualization with Tableau. What is Data Visualization?, Exporting Data and Working With Tableau.

 Building Data Visualization BI Project With Tableau 9.x

Learning Objectives - In this module, you will learn to create reports and dashboards via Tableau 9.x using various advance features and functions. You also need to understand the various current and new report requirement. 

Topics - Building Data Visualization BI Project With Tableau 9.x, BI Reporting Understanding, Report and Dashboard Template Document, Tableau Design and Development Database Source Connection.

 An Integrated Data Warehousing & BI Project

Learning Objectives - This is an integrated Data Warehousing and Business Intelligence Project which starts from User Source System and Business Requirement Gathering till end of Project Development with production support strategies developments. 

Topics - An Integrated Data Warehousing & BI Project, Developing a Data Warehouse and BI Project, Source System understanding today`s data that will be the future data requirement, Identify the Business Requirement Gathering, Report and Dashboard Template Document, Designing and Developing Models, Designing and Developing the Staging Area, Finalizing the Dimension Modeling Type, Designing and Developing Dimension Modeling.

 Teradata - An Overview

Learning Objectives - In this module, you will understand basic relational concepts and overview of Teradata such as its History, Comparison with other RDBMS, Architecture, Components (PE, BYNET, AMP), Interaction between components, Storage and Retrieval architecture, Connectivity with Mainframe and advanced architecture. 

Topics - Basic Relational Concepts, What is Teradata, Competitive advantages over other RDBMS, Teradata Architecture, Teradata Components, How components Interact with each other, How Data is stored and Retrieved, Connectivity with Mainframe and Network Applications, Tools & Utilities, Teradata Unified Data Architecture.

 Teradata Indexes and Join Strategies

Learning Objectives- In this module, you will learn about various indexing concepts in Teradata and how they affect storage and retrieval of data. You will understand the importance of Primary index and how it affects the storage of data, Use of secondary and Partition Primary index in fast retrieving data. You will also learn the hashing algorithm in detail and various join strategies used by Teradata to join tables. 

Topics - Difference between Primary Key and Primary Index, Primary Index and types, How primary index is used in data distribution and retrieval, Secondary index and its types, Data retrieval using secondary Index, Partition primary index and its types, Advantage of PPI , Join strategies, How data is redistributed for Join processing.

 Teradata SQL

Learning Objectives - In this module, you will learn about SQL commands used in Teradata. You will learn to create/alter/drop database objects and perform various SQL operations on the data stored in Teradata tables. 

Topics - Data types, DDL Statements (CREATE, ALTER, DROP) , DML Statements (Insert, Delete, Update), DCL Statements (Grant, Revoke), Order by, Group by, Distinct, SET Operators, Logical & Conditional Operators, String functions, Cast & Format functions, HELP and Show Functions, Date Functions, Built-In Functions, Aggregation, Joins (INNER and OUTER).

 Data Protection

Learning Objectives - In this module, you will learn about various data protection mechanism provided in Teradata. You will learn how AMP failure, Node failure, Transaction failure and Disk failures are handled. 

Topics - Transaction locks, Fallback tables, Clusters, Permanent Journal, Down AMP Recovery Journal, Transient Journal, Cliques, Hot Standby nodes, RAID 1 & RAID 5, Data Dictionary.

 SQL Advanced

Learning Objectives - In this module, you will learn more about SQL Commands in Teradata. You will learn how to use sub queries, using OLAP functions, Transaction modes and temporary tables. You will learn to understand Explain statement and collect statistics. 

Topics - Sub queries, Upsert, Case, Coalesce, Nullif, OLAP Functions, Rank & Row Number, Transaction Modes, Temporary Tables (Derived, Volatile and Global Temporary), Explain, Collect Statistics.

 Advanced Database objects and performance optimization

Learning Objectives - In this modules, you will learn about additional database objects such as views, Macros, Stored Procedure and Join Index. You will also explore common performance tuning options. 

Topics - Views, Macros, Stored Procedure, Join Index, Performance Tuning tips.

 Teradata Utilities - FastLoad, MultiLoad, BTEQ

Learning Objectives - In this module, you will learn about some of the Application utilities provided by Teradata. You will learn how FastLoad and MultiLoad are used to import data into Teradata. Also, you will understand using BTEQ to submit SQL queries. 

Topics - What is FastLoad, How FastLoad loads data, How to restart failed FastLoad jobs, What is MultiLoad and how MultiLoad works, Using MultiLoad to insert/update/delete data from Teradata tables , Using BTEQ to import/export data.

 Teradata Utilities - FastExport,TPT

Learning Objectives - In this module, you will learn about the FastExport and TPT utilities 

Topics - FastExport Exporting data from Teradata , TPT overview, TPT Export, TPT SQL Selector, TPT Load, TPT Update Comparison of Load/Unload Utilities.

 Informatica PowerCenter 10 - An Overview

Learning Objectives: In this module of Informatica Training, we will talk about the different Informatica Products available along with understanding the overview of Informatica PowerCenter Product, Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows, and Workflow Monitor. We will also discuss the installation of Informatica in this module. 

Topics:

• Informatica & Informatica Product Suite
• Informatica PowerCenter as ETL Tool
• Informatica PowerCenter Architecture
• Component-based development techniques

 Hands-On/Demo:

• Installation of the Product in Windows and using Oracle as Database
• Creation of the services and connecting the client to the server

 Data Integration and Data Warehousing Fundamentals

Learning Objectives: In this module of Informatica Certification Training, we will discuss different Data Integration Concepts. You will be introduced to the concepts - Data Profiling, Data Quality Management, ETL and ETL architecture, and Data Warehousing. 

 Topics:

• Data Integration Concepts
• Data Profile and Data Quality Management
• ETL and ETL architecture
• Brief on Data Warehousing

 Hands-On/Demo:

• Look through the properties of the services required
• Shutdown and start-up of the services from the Administration Console
• Creation and execution of a simple pass-through mapping.

 Informatica PowerCenter Transformations

Learning Objectives: In this module of Informatica Certification Training, you will learn about different development units of PowerCenter and how they can be used to create a simple mapping and transformations. 

 Topics:

• Visualize PowerCenter client tools
• Data Flow
• Create & execute mapping
• Transformations & their usage

 Hands-On/Demo:

• Use multiple transformations inside the mapping to resolve different use cases
• Look at the properties of the transformations to customize them

 Informatica PowerCenter Tasks & Workflows

Learning Objectives: In this module of Informatica Certification Training, you will learn about development units of Informatica PowerCenter (workflow manager & monitor) and how are they are used to create different tasks and workflow. 

 Topics:

• PowerCenter Workflow Manager
• Flow within a Workflow
• Reusability & Scheduling in Workflow Manager
• Components of Workflow Monitor
• Workflow Task and job handling

 Hands-On/Demo:

• Create tasks, workflow
• Configure workflow properties
• Schedule a workflow

 Advanced Transformations, Techniques & Reusability Features

Learning Objectives: Through this module of Informatica Certification Training, you will learn about Advanced Transformation techniques which will equip you to deal with advanced concepts of PowerCenter transformations like Java, XML etc. We will also discuss various Error Handling, Transaction Processing & Reusability features available in Informatica. 

 Topics:

• Advanced transformations (Java, SQL, Normalizer)
• XML File Processing & Transaction Processing
• Error handling features
• Cleaning the data (Advanced Functions, Regular Expressions)
• Reusability features

 Hands-On/Demo:

• Use of advanced transformations like XML Processing, Union etc.
• Use of inbuilt and custom functions to fulfill the data transformation needs.
• Reusable transformations, Sessions, Mapplets, etc.

 ETL Scenarios using Informatica

Learning Objectives: In this module of Informatica Training, we will discuss advanced ETL scenarios using Informatica. You will be introduced to the concepts - Error Handling, Partitioning, PushDown Optimization, Incremental Aggregation, Constraint Based Loading, Target Load Order Group, CDC (Change Data Capture) etc. We will also discuss creating Data Warehouses related processes like SCD, Fact and Dimension Loading. 

 Topics:

• Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
• Advanced techniques - Flat File, XML File
• Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)

 Hands-On/Demo:

• Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
• Advanced techniques - Flat File, XML File
• Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)

 Service & Support of Informatica PowerCenter Environment

Learning Objectives: In this module of Informatica Training, you will understand the features provided by Informatica to debug, troubleshoot & handle error to understand the inner workings and responsibilities of the operational role. Various PowerCenter recovery options and for tasks and workflows will be discussed along with the recommended best practices to the operations process. 

 Topics:

• PowerCenter Error
• Basic troubleshooting methodology
• Debugger
• Workflow and Session logs to diagnose errors
• Connection Errors & Network errors
• Recovery scenarios & mechanisms
• Configure workflow & sessions for recovery
• High Availability
• PowerCenter Environment

 Hands-On/Demo:

• Perform troubleshooting of Informatica errors
• Use of Debugger to debus a mapping
• Perform workflow and session recovery and related configuration needed for that

 Performance Tuning, Design Principles & Caches

Learning Objectives: This module of Informatica Certification Training, highlights the performance aspects of Informatica PowerCenter components and the efficient use of them. We will also discuss about the best practices suggested by Informatica for optimum performance of your ETL process. 

 Topics:

• Performance Tuning Methodology
• Mapping design tips & tricks
• Caching & Memory Optimization
• Partition & Pushdown Optimization
• Design Principles & Best Practices

 Hands-On/Demo:

• Identify the bottlenecks
• Different configurations needed to resolve the bottlenecks
• Learn tips and tricks to code efficient mappings
• Cache and DTM buffer memory configuration

 Informatica PowerCenter Repository Management

Learning Objectives: This module of Informatica Training will introduce you to the usage and components of PowerCenter repository manager. You will also learn to migrate and manage the repository effectively. 

 Topics:

• Repository Manager tool (functionalities, create and delete, migrate components)
• PowerCenter Repository Maintenance

Hands-On/Demo:

• Get acquainted with the repository manager tool and its functionalities
• Creation and editing of a Folder
• Copy Informatica objects
• Historical view of session and workflow statistics

 Informatica Administration & Security

Learning Objectives: This module of Informatica Certification Training, will give you an overview of the PowerCenter administration console, recognize and explain integration and repository service properties. We will also discuss about the command line utilities and use them to manage the domain and repository, start and control workflows. 

 Topics:

• Features of PowerCenter 10
• Overview of the PowerCenter Administration Console
• Integration and repository service properties
• Services in the Administration Console (services, handle locks)
• Users and groups

 Hands-On/Demo:

• Learn details of different components of Informatica Administration tool
• Create user, group, assign privileges to the users and groups
• Create Roles
• Looking at the service logs, taking export of the service logs
• Service maintenance from Administration console

 Command Line Utilities

Learning Objectives: This module of Informatica Certification Course deals with command line part of Informatica PowerCenter. You will learn to automate the tasks from the command line as well. 

 Topics:

• Infacmd, infasetup, pmcmd, pmrep
• Automate tasks via command-line programs

Hands-On/Demo:

• Use Infacmd, infasetup, pmcmd, pmrep to automate tasks via command-line programs

 Informatica 10 - Technical Architecture

Learning Objectives: This module of Informatica Certification Training will give you the detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular. 

 Topics:

• Informatica 10 Architecture
• Application services
• Buffer memory
• Connectivity among the tolls
• Connection Pooling

 Introduction to Data Warehousing and MSBI

Learning Objectives: In this module, you will understand the various concepts of Data Warehousing. You will learn why we perform ETL operations before loading data to the Data warehouse. You will get a brief introduction to Business Intelligence. 

Topics:

• Fundamental concepts of Data Warehousing
• Concepts of Dimensions, Measures, Metadata, Schemas
• Data Marts and Design approaches
• Normalization and Denormalization and Schema types
• Online Analytical Processing and Transactional Processing concepts
• OLAP Cube
• Types of Slowly Changing Dimensions
• Explain ETL process and various tasks involved in it
• Discuss Business Intelligence concepts
• How BI works with data-warehouse
• Describe MSBI as One stop Solution

 Hands On/Demo:

• Install SQL Server
• Install SQL Server Data Tools
• Create small ETL Tasks

 Skills:

• Understand Data Warehousing Concepts
• Understand ETL Concepts
• Understand Business Intelligence Concepts
• Install SQL server

 Introduction to SSIS

Learning Objectives: In this module, you will understand the need for an Integration tool and its significance in the industry. You will learn the importance of SSIS as an integration tool and get a high-level view of the overall architecture.

Topics:

• Understand the MSBI Architecture, Import and Export wizard
• Understand SSIS Architecture
• Control Flow & its Components (Tasks, Containers, Precedence Constraints)
• Data Flow & its Components (Source and Destination Connections, different types of Transformations)
• Scenarios by combining Control Flow and Data Flow components
• System Variables and User-defined variables

 Hands On/Demo:

• Create tasks and Control Flow task using SSIS
• Create a data flow task to aggregate the records
• Create a control flow task to create an index and run the tasks

 Skills:

• Understand SSIS Concepts
• Understand Control flow and Dataflow

 Transformations and Use-Cases

Learning Objectives: In this module, you will be able to differentiate between various transformations and understand their usage in various business use-cases. 

Topics:

• Data Conversion transformation
• Multicast transformation
• Union all transformation
• Conditional Split transformation
• Merge and Merge Join transformation
• Lookup transformation
• Cached Lookup transformation
• Foreach loop and use-cases
• Advancing Execute SQL Task with Object return type and type of Outputs usage
• Bulk-insert task
• Archival process using dynamic variables and FST

 Hands On/Demo:

• Conditional Split transformation
• Use Foreach loop to repeat Data Flow Task for multiple files
• Use Foreach loop and File System Task for Data Archival
• Use Slowly Changing Dimension to insert a new record and update a record

 Skills:

• Understand various transformations
• Understand their usage in business use-cases

 Transactions and Event Handling

Learning Objectives: In this module, you will understand how the objects of the core SSIS workflow work and interact with each other to help in security and other key functions.

Topics:

• Parameters, Event Handling
• Transaction Options, CheckPoints, Logging options, Log Provider
• Configure Error Output and OnError event
• Package Security: Package Protection Levels

 Hands On/Demo:

• Create Event Handling Task
• Parameterize a package

Skills:

• Understand Event Handling
• Understand Package Security in SSIS

 SSIS (Configuration, Deployment and Scheduling)

Learning Objectives: In this module, you will learn advanced SSIS programming features, which will help in handling custom requirements using .Net code. In addition, you will learn to configure and deploy SSIS projects.

Topics:

• Script Component, Package Configurations (5 types)
• Debugging & Troubleshooting
• Executing packages – DTExec and DTExecUI
• Package Deployment
• Package Scheduling using SQL Agent
• Understand Package Performance Tuning
• Learn SSIS Best Practices
• Package Performance Tuning
• SSIS Best Practices

 Hands On/Demo:

• Implement custom code using Script Task
• Create a control flow task consisting of a Script task to send email

Skills:

• Understand Custom Code
• Learn Package Configuration
• Understand Deployment Models

 SSAS Cube Design

Learning Objectives: This module will help you in understanding SQL Server Analysis Services Overview and its Architecture. It also covers various types of SSAS models along with designing dimensions and measure groups. You will also learn about SSAS Administration with prime focus on deployment and processing.

Topics:

• Introduction to SASS
• It’s Architecture
• Features of SSAS
• Modelling in SSAS
• Tabular Model and Multidimensional Model
• Data Sources, Data Source Views
• Identify the Fact and Dimensions
• Designing Dimensions
• Dimension Hierarchies
• Designing Measure Groups
• Attribute Relationships
• Storage Modes: MOLAP, ROLAP, HOLAP, Partitions

 Hands On/Demo:

• Create dimensions and hierarchies
• Define a cube
• Create Data Source and Data Source Views

 Skills:

• Understand SSAS Concepts
• Learn Data Modelling Concepts
• Design Dimension and Measure Groups
• Import Data in SSAS from various data sources

 SSAS Deployment and MDX, DAX

Learning Objectives: In this module, you will learn the basics of MDX & DAX and get to know the step by step approach of basic SSAS Performance Tuning and Troubleshooting. You will also learn the concepts of Ad-hoc Reporting and the creation of a report against SSAS as a data source. 

Topics:

• SSAS Deployment
• Methods of database deployment
• Named Calculations and Named queries
• Aggregation, KPIs, Actions, Perspectives, Translations
• Cube Processing
• Different Processing Options
• Explain MDX and DAX Queries
• Loading Data into DW using SSIS, MDX queries, DAX Queries
• Performance Optimization of cube and Dimension, Best Practices
• Schedule the Cube processing

 Hands On/Demo:

• Retrieve tabular data using DAX
• Schedule the Cube processing
• Retrieve data from a Cube using MDX query

 Skills:

• Understand SSAS Deployment and Cube Processing
• Learn MDX and DAX Queries
• Explain Performance Optimization

 SSRS Reporting

Learning Objectives: In this module, you will understand Reporting Services, its Architecture and how to configure it. You will also learn about the environment where reports are created and also about the server where the reports are deployed.

Topic:

• SSRS Features
• Reporting Services Architecture & Lifecycle
• Report Parameters and Multi-Valued
• Cascaded Parameters
• Types of Reports: Parameterized, Linked, Snapshot, Cached, Ad hoc, Clickthrough, Drillthrough, Subreports
• Creating Groups, Filters, Expressions Sort and Interactive Sort, Alternate Row Colors, Repeating Row Headers and Column Headers
• Describe Mobile report publisher
• Exporting Reports to different formats

 Hands On/Demo:

• Create grouping in table
• Use interactive sort on a table
• Create a report based on Annual Sales
• Export report as a PDF

 Skills:

• Understand SSRS Concepts
• Understand various types of Reports
• Export Reports to different Formats

 SSRS: Web Portal

Learning Objectives: In this module, you will learn about different kinds of reports and their functionalities along with best practices to be followed. You will also learn about various SSRS Administrative activities.

Topics:

• Web Portal
• Deploying Reports and Data Sources
• Securing Access to Reports (Role based Security)
• Aspects of security
• Data Source Security, Caching Report and Snapshot Report
• Report Subscriptions: Standard, Data-Driven
• Managing Subscriptions, Ad-Hoc Reporting with Report Builder
• Integration of Power BI with SSRS

 Hands On/Demo:

• Assign roles to a group or a user
• Create a Linked report
• Enable the users from various locations to access the same project
• Deploy and access the project using Web Portal

 Skills:

• Understand Web Portal
• Configure Data Source Security
• Develop SSRS report using MDX

 Integration of SSIS, SSAS and SSRS

Learning Objectives: In this module, you will understand how MSBI ecosystem components work together in a Business Intelligence environment to solve the Organizational data problems. This module covers end to end implementation from Data Retrieval --> Data Transformation --> Data Loading into DWH --> Data Modeling --> Report Delivery.

Topics:

• End to End Business Intelligence Business Scenario involving SSIS, SSAS, SSRS and MDX.
• MS BI Best Practices

Hands On/Demo:

• Case study to implement a scenario using SSIS, SSAS, SSRS and MDX

Skills:

• Implement scenarios using SSIS, SSAS and MDX

 Introduction to Data Visualization

Goal : Give a brief idea of data visualization and introduce Tableau 10

 Objectives:

• Identify the prerequisites, goal, objectives, methodology, material, and agenda for the course
• Discuss the basic of Data Visualization
• Get a brief idea about Tableau, establish connection with the dataset, perform Joins operation on the data set

Topics:

• Data Visualization
• Introducing Tableau 10.0
• Establishing Connection
• Joins and Union
• Data Blending

Hands On:

• Establishing connection with the files, Introducing important UI components (ShowMe, Fit Axes)
• Perform Cross Joins between the dataset

 Visual Analytics

Goal :  Learn to manage your dataset and analyze things visually with the help of Marks Card and “highlighting” feature.

 Objectives:

• Manage extracts and metadata (by creating hierarchy and folders)
• Describe what is Visual Analytics, why to use it, and it’s various scopes
• Explain aggregating and disaggregating data and how to implement data granularity using marks card on aggregated data
• Describe what is highlighting, with the help of a use-case
• Illustrate basic graphs including bar graph, line graph, pie chart, dual axis graph, and area graph with dual axis

Topics:

• Managing Extracts
• Managing Metadata
• Visual Analytics
• Data Granularity using Marks Card
• Highlighting
• Introduction to basic graphs

Hands On:

• Creating Extracts, Hierarchy, Folders
• All the features of Marks Card Shelve with use case provided
• Power of Highlighting in the visualization using the Use-case
• How to create basic graphs in Tableau10.x

 Visual Analytics in depth I

Goal :  This module presents to you the granular content of Visual analytics, covering various techniques to perform sorting, filtering and grouping on the dataset.

 Objectives:

• Perform sorting techniques including quicksort, using measures, using header and legend, and sorting using pill with the help of a use case.
• Master yourself into various filtering techniques such as Parametrized filtering, Quick Filter, Context Filter. Learn about various filtering option available with the help of use case and different scenarios.
• Illustrate grouping using data-window, visual grouping, and Calculated Grouping (Static and Dynamic).
• Illustrate some more graphical visualization including Heat Map, Circle Plot, Scatter Plot, and Tree Maps.

Topics:

• Sorting.
• Filtering.
• Grouping
• Graphical Visualization

Hands On:

• Quick Sort, Sorting using measure, Sorting using header and legends, sorting using pill(use-case).
• Filtering Use cases covering different options (General, Wildcard, Conditional).
• Interactive Filter, Quick Filter, Context Filter.
• Grouping using Data Window, Visual Grouping, Calculated Grouping (Static and Dynamic).

 Visual Analytics in depth II

Goal : This module presents to you Visual analytics in a more granular manner thereby letting you to dive deep into the content. It covers various advanced techniques of analyzing data including, forecasting, trend lines, reference lines, clustering, parametrized concepts, and creating sets.

 Objectives:

• Explain the basic concepts of sets followed by Creating sets using Marks Card, computation sets and combined sets
• Describe the concepts of forecasting with the help of Forecasting problem as a use-case
• Discuss the basic concept of clustering in Tableau
• Add Trend lines and reference line to your visualization
• Discuss about Parameter in depth using Sets and Filter

Topics:

• Sets
• Forecasting
• Clustering
• Trend Lines.
• Reference Lines.
• Parameters

Hands On:

• Create sets using marks card, Computation sets, and Combined sets
• Forecasting using Precise Range
• Methods of clustering
• Adding trend line and reference line (along with various options available for them)
• Parameter using sets and filter

 Dashboard and Stories

Goal : Learn all about Dashboards and Stories in Tableau.

 Objectives:

• Describe the basic concepts of Dashboard and its UI.
• Build a dashboard by adding sheets and object into it
• Modify the view and layout.
• Edit your dashboard, how it should appear on phones or tablets.
• Create an interactive dashboard using actions (filter, highlighting, URL).
• Create stories for your Visualization and Dashboards.

Topics:

• Introduction to Dashboard.
• Creating a Dashboard Layout.
• Designing Dashboard for Devices.
• Dashboard Interaction - Using Action.
• Introduction to Story Point.

Hands On:

• Creating Dashboard and learning its UI component.
• Changing the layout of the dashboard.
• Using Device Designer to create dashboard for devices.
• Create an interactive dashboard using actions (Filter, Highlight, URL).
• Creating story with dashboard.

 Mapping

Goal: This module helps you in understanding mapping in detail, editing unrecognized and ambiguous location, and creating customized geocoding. Learn about polygon map and Web Mapping Service, and finally, add background images with self-generated coordinates.

 Objectives:

• Map the coordinates on the map, plot geographic data, and use a layered view to get the street view of the area.
• Edit the ambiguous and unrecognized location plotted on the map.
• Customize territory on a polygon map.
• Connect to the WMS Server, use a WMS background map and saving it.
• Add a background image and generate its coordinate and plot the points.

Topics:

• Introduction to Maps.
• Editing Unrecognized Locations.
• Custom Geocoding.
• Polygon Maps.
• Web Mapping Services.
• Background Images.

Hands-On:

• Plot the coordinate points on the map, plotting the geographic data, Street View using the layered view.
• Editing Unrecognized and ambiguous location
• Custom Geocoding.
• Creating a custom territory, building a polygon map.
• Establishing a connection with the WMS Server a WMS background map and saving it.
• Adding a background image and generate coordinates and finally plotting points. 

 Calculation

Goal: This module will help you in creating basic calculations including string manipulation, basic arithmetic calculations, date math, logic statements and quick table calculations. Along with this, you will be also introduced to LOD expressions with the help of use cases.

 Objectives:

• Perform Calculations using various types of functions such as Number, String, Date, Logical, and Aggregate.
• In addition, you will get to know about Quick Table Calculation. 
• Cover the following LOD expressions – Fixed, Included, and Excluded.

Topics:

• Introduction to Calculation: Number Functions, String Functions, Date Functions, Logical Functions, Aggregate Functions.
• Introduction to Table Calculation.
• Introduction to LOD expression: Fixed LOD, Included LOD, Excluded LOD

Hands-On:

• All Functions (Number, String, Date, Logical, Aggregate)
• Table Calculation.
• LOD expressions.

 LOD Problem Sets & Hands on

Goal: This module will explain the scenarios where you can implement LOD expressions. This is showcased with the help of a set of problems.

 Objectives:

• Tackle complex scenarios by using LOD expressions.

Hands-On:

• Use Case I - Count Customer by Order.
• Use Case II - Profit per Business Day.
• Use Case III - Comparative Sales.
• Use Case IV - Profit Vs Target
• Use Case V - Finding the second order date.
• Use Case VI - Cohort Analysis

 Charts

Goal : Plot various types of Charts using Tableau 10 and have extensive hands-on on industry use cases.

 Topics :

• Box and Whisker`s Plots
• Gantt Charts
• Waterfall Charts
• Pareto Charts
• Control Charts
• Funnel Charts

Hands On:

• Extensive hands-on on the above topics

 Integrating Tableau with R and Hadoop

Goal: This module introduces you to the concept of Big Data, Hadoop, and R. You discuss the integration between Tableau and R and finally publish your workbook on Tableau Server.

 Objectives:

• You will know the basics of Big Data, Hadoop, and R.
• You will discuss the integration between Hadoop and R and will integrate R with Tableau.
• In addition, you will get to publish your workbook on Tableau Server.

Topics:

• Introduction to Big Data
• Introduction to Hadoop
• Introduction to R
• Integration among R and Hadoop
• Calculating measure using R
• Integrating Tableau with R 
• Integrated Visualization using Tableau

Hands-On:

• Installing Rserve package in R
• Integrating Tableau and R
• Publishing your workbook on Tableau Server.