Tableau Advanced Charts, Calculations & Reporting Lifecycle & Tableau Worksheet

• • Tableau Advanced Charts, Calculations & Reporting Lifecycle
    • What is a bar chart & When to use a bar chart
    • How to create a bar chart?
    • Different type of bar chart- Vertical & Horizontal
    • Scattered Bar Chart
    • Formatting the bar chart
    • Reference Lines
    • What is a line chart?
    • Different type of line chart
    • Scattered line Chart
    • Formatting the line chart
    • Reference Lines
    • Filtering the line chart
    • The need for dual-axis chart & What is Pie chart
    • What are the calculated fields?
    • How to create calculated fields?
    • Understanding of reporting lifecycle
  • Tableau Worksheet
    • How to create a worksheet?
    • Worksheet Formatting
    • Renaming a Worksheet
    • Different Features and Functionalities in Worksheet
    • Overview of Different Charts
    • Working with Labels
    • Tooltip
    • Dimension & Measure and their differences
    • Converting Dimension to Measures and Vice Versa
    • How to convert one data type to others?
    • Introduction to Mapping in Tableau

Tableau Dashboard & Dashboard Action & Tableau Server

• • Tableau Dashboard & Dashboard Action
    • What is Tableau Dashboard?
    • How to create a Tableau Dashboard?
    • Adding worksheets in a dashboard
    • Fixed and Floating dashboard
    • Adding different attributes in Dashboards
    • Filters in dashboard
    • Parameters in dashboard
    • Formatting dashboards
    • Standards in Dashboards
    • Dashboard Branding
    • Making screen size & resolution compatible
    • What are dashboard actions?
    • Different kind of actions- URL, click, hover
    • Filters dashboards on clicking
    • Opening external URL from dashboard
  • Tableau Server
    • Sign up for Tableau Server
    • Create Projects and Accounts
    • Add user in Tableau server
    • Invite other users
    • How to publish reports on the tableau server?
    • Different features and settings
    • Managing report on server
    • How to send report emails through the server?
    • Sharing report links to others
    • Provide access to others
    • Embed the Tableau dashboard on other platforms
    • Using Tableau Server for monitoring functions
    • License level
    • User rights
    • Roles
    • Permissions precedence

Integration with R Programming, SQL, And Google Analytics

• • How to connect Tableau with R?
  • Run commands from Tableau with backend in R
  • Linear regression machine learning using Tableau and R
  • How to connect Tableau with SQL?
  • Make reports on SQL data in Tableau
  • How to connect Tableau with GA?
  • Creating reports in Tableau with GA data
  • Introduction to Business Intelligence tools
  • Real-time Projects & Case Study

Tableau Training Course Roadmap

• Milestones that you will achieve with our Tableau Course Training

  Our Tableau Course is designed so effectively that hundreds of students have already passed the certification exam and are working with leading industries today. Tableau is a data visualization tool and acknowledged as a leader by Gartner for three years in a row. Tableau learning and training will make you an expert in data management, and you can understand and process data in multiple ways as needed by Companies.

  Here is what we cover in our online Tableau Course to make you a Tableau Expert. Each topic has been detailed with the sub-topic that we cover.

  Introduction of Data Visualization

  • What is Data Visualization?
  • Career opportunity in Data Visualization and Reporting
  • Different Data Visualization Tools and comparison
  • Skills needed to become Data Visualization Developer

  Tableau Overview

  • Why Tableau?
  • History of Tableau
  • Characteristics of Tableau
  • Different Products of Tableau and their use
  • Different Versions of Tableau
  • Tableau Desktop: Download and Installation
  • Licenses and Free Software
  • Overview to Tableau Server
  • Locating the files and uses on your system
  • Tableau Interface and terminology
  • Tableau Architecture and components.

  Data Connections in the Tableau

  • How to connect with Tableau Server?
  • About Join and its types
  • The right time for using Joins
  • How to enable right Outer Join?
  • About Data blending and when to use it?
  • Difference between Joining & Blending
  • How to write custom SQL Queries?
  • Data preparation for analysis

  Formatting and Annotations

  • Introduction
  • Custom Geocoding
  • Adding Caption/Title/ToolTips to Views
  • Formatting Axes, Windows, Mark Labels, Manipulations
  • Formatting Views with Labels and Annotations
  • Annotations

  Graphs/Charts/Bars

  • Working with Combined Axis, combined charts, page shelf
  • Understanding geocoding and geographic mapping in tableau
  • Describe text and highlight tables
  • Create Motion Charts
  • Using Bins and Histograms & Pie Charts
  • Compare Measures Using Bullet Charts
  • Advanced Chart Types
  • Creating and Using Pareto, Waterfall, Bars & Gantt Charts
  • Using box plots

  Filters and Types

  • About Filters
  • Filters on Dimensions & Measures
  • About Wild Card
  • Context Filters
  • Global Filters
  • Quick Filters
  • Defining Filters at Source & Custom SQL

  Creating and Using Parameters

  • About Parameters
  • How to create Parameters?
  • Exploring Parameter Controls
  • Using parameters
  • Show and Hide Sheets with Parameters Dynamically

  Groups and Sets

  • About Groups
  • Using Group
  • Editing Group
  • Limitations of groups
  • About Set and its Types
  • Using Sets

  Special Field Types

  • Special Field Types
  • Date Hierarchies
  • Drilling in the Time Hierarchy
  • Pivoting Date Parts on Shelves
  • Differentiate Between Discrete and Continuous Dates
  • Using Continuous and Discrete Dates
  • Custom Dates
  • How to create and use Custom Dates?
  • Define a Date Field on a Fiscal Year
  • Relative Date Filters
  • Importing Date Dimensions in Tableau from a Cube
  • Dates in Cube (Multidimensional) Data Sources
  • Dates in Cubes Vs. Relational Data Sources

  Calculations

  • Strings Date Logical and Arithmetic Calculation
  • Aggregation Options
  • Grand Totals and Subtotals
  • Quick Table Calculations
  • Automatic and Custom Split

  Dashboards

  • Dashboards
  • Building Dashboards & Best Practices
  • Interaction Exploring Dashboard Actions
  • Use of Running Actions
  • Using Dashboard Actions
  • Sharing your Work
  • How to Share your Reports?
  • Exporting Work

  Tableau Server

  • Install & configure the server
  • Setup server
  • Publishing,
  • Scheduling and Sharing Security
  • Authentication and Access
  • Roles and Responsibilities
  • Performance Monitoring and Tracking

  Integrate Tableau Server with Other

  • TABLEAU – R – INTEGRATION
  • R output as Input to Tableau
  • File-based Integration of R with Tableau
  • How to connect Tableau with SQL?
  • Creating reports on SQL data in Tableau

  Installing & Configuring Tableau Server

  • Single Server installation & configuration
  • Configuration information
  • Email alerts / subscriptions
  • Configuring security SSL, SAML.
  • Install and configure server exercise
  • Content administration
  • Log files administration
  • Monitoring and auditing
  • Performance recording
  • User and group administration
  • Data Server administration
  • Site administration
  • Security and Permissions in Tableau Server
  • Tabcmd & tabadmin

  Process Flows

  • Create a visualization in Tableau Desktop
  • Publish a visualization to Tableau Server
  • View a visualization in Tableau Server
  • Schedule an extract refresh
  • Publish an extract or data source
  • Add a user in Tableau Server

  Single Server Installation

  • Minimum requirements
  • Resolutions for common installation issues
  • Performing the installation
  • Managing product keys
  • Initial configuration

  Architecture and Component Functions

  • Gateway Server
  • Repository Service
  • Application Server
  • VizQL Server
  • Fast Data Engine
  • Backgrounder Service
  • Data Server

  SSIS Package Security and Upgrades

  • Encrypting SSIS Catalogs
  • Package Store and SSISDB
  • Comparing SSIS 2008 R2 & 2012 & 2014

  Sample Project

  • Project Business Requirement Document > Analysis of requirement
  • Databases Design/Schema Design
  • Kick off ETL
  • Business Validations
  • Business Transformations
  • Deployment in different environments like QA, Staging, and Production

  Report Design with Data Sets & Aggregates

  • Report Designer Usage and Scope
  • Enterprise and Ad-hoc Reports
  • Report Builder Usage and Scope
  • Working with multiple Datasets
  • Report Manager and Options
  • Configuring Dynamic DataSets
  • Report Delivery & Layout Planning

  Report Design with Data Sets & Aggregates

  • Report Designer Usage and Scope
  • Enterprise and Ad-hoc Reports
  • Report Builder Usage and Scope
  • Working with multiple Datasets
  • Report Manager and Options
  • Configuring Dynamic DataSets
  • Report Delivery & Layout Planning

  Sub Reports - Parameters & Filters

  • Create a New Project in SSRS 2014
  • Shared Data Source, Shared Dataset, Report
  • Embedded Data Source Embedded Data Sets
  • SSRS Table Report
  • Creating SSRS report using Wizard
  • How to add Groups in SSRS reports

  Sub Reports - Parameters & Filters

  • Format Fonts and Background Color of a Textbox in SSRS
  • Format Numbers in SSRS 2014
  • Repeat Headers on Each Page in SSRS
  • Report Models and parameters
  • Keep Headers Visible While Scrolling in SSRS
  • Filters at Tablix Level in SSRS
  • Report Designer Vs Report Builder
  • Report Server Configurations Tools
  • Report Migrations and Precautions
  • Cascading Parameters in SSRS 2014
  • Drill down reports in SSRS 2014

  SSRS Filers And Sorting Techniques

  • Using Report Builder Wizards
  • Map Reports with UI and Site Settings
  • Report Parts and Web Services

  Delivering SSRS Reports Usint Parameters

  • Report Parameters in SSRS 2014
  • Multi-Value Parameters in SSRS 2014
  • Multiple Parameters in SSRS 2014

  Managing Reports Using Procedures

  • How to pass stored procedures in SSRS 2014
  • SSRS Matrix Reports
  • SSRS Matrix Reports Using Wizard
  • Grouping in SSRS Matrix Reports
  • Drill down in SSRS Matrix Reports
  • Column Charts In SSRS

  SSRS Charts Techniques

  • Pie charts in SSRS 2014
  • Indicators in SSRS 2014
  • Formatting the Pie Chart
  • Gauges in SSRS 2014
  • Data bars in SSRS 2014

  SSRS Report Deployment Process

  • Sub reports in SSRS 2014
  • Deployment process for SSRS 2014

  Data warehouse Concepts

  • Data Warehousing - Overview
  • Data Warehouse Features
  • Types of Data Warehouse
  • Functions of Data Warehouse Tools and Utilities
  • Data Warehousing - Terminologies Metadata & Metadata Repository
  • Data Mart & Points to Remember About Data Marts
  • Data Warehousing - Delivery Process
  • Data Warehouse Models
  • Data Warehousing - Schemas

  SSAS Concepts

  • SSAS Data Source
  • STAR SCHEMA in SSAS EXAMPLE
  • SSAS Data Source View
  • SNOWFLAKE SCHEMA in SSAS
  • Add or Remove Tables from Data
  • EXAMPLE Source View in SSAS
  • Create Dimension in SSAS
  • Star schema and Snowflake Schema
  • Create OLAP Cube in SSAS in SSAS 2012
  • Sales Projects