TABLEAU

Tableau introduction and overview Tableau Products:

  • Tableau Desktop
  • Tableau Server
  • Online
  • Mobile(IOS & Android)
  • Tableau Reader
  • Tableau Public

Tableau Desktop:

Connecting to data

  • Data Strategy
  • Joining multiple tables in tableau
  • Custom SQL
  • Publishing and Reusing data connections
  • Building extracts

Understanding tableau workspace

Show Me

Shelves, cards ,Marks and pills

Views

  • Creating a view
  • Marks
  • Size
  • Transparency
  • Highlighting
  • Date Aggregations
  • Building dashboards

Understanding charts

Visualization Types :

  • Cross tab
  • Maps
  • Heat Map
  • Tree map
  • Scatter plots
  • Bar charts
  • Pie Chart
  • Dual Axis
  • Blended Axis
  • Line Chart
  • Area Chart
  • Bubble charts
  • Donut Chart
  • Waterfall chart

Hierarchy

Drill down and drill across

Sorting

Formatting options

Sets

Creating Groups

Trend lines, Forecasting, reference lines and statistical analysis in tableau

Filters(Quick Filter, Global Filters, Normal Filters, Context Filters)

Actions

Working with parameters

Mapping

Calculations

Data Blending

Extracts

Creating Stories

How to Publish workbooks in tableau server

Tableau Server:

Preparation

Version:

Identifying the version of tableau server installation

Hardware Prerequisites:

  • CPU requirements
  • Hardware Requirements
  • RAM requirements

Licensing

  • Activating and updating license key
  • Core and user licensing
  • Offline activation

Administration:

  • Content administration
  • Site administration
  • User administration
  • Group Administration

Tableau Server Security Model:

  • Authentication
  • Authorization & Permissions
  • Assignments
  • Hands-on dev.
  • Interview Questions
  • Pick up a domain
  • Simulate a real time scenario
  • Requirement Gathering: Tech specs.
  • Documentation: Dashboard specs.
  • Creating views and dashboards
  • Publish to server

Data Warehouse Concepts:

  • Introduction of Data Warehouse
  • Need arise of DWH
  • OLTP V/S DWH
  • OLTP V/s OLAP
  • Data Warehouse /Data Marts Architecture
  • Staging/without Staging
  • Dimensions (Simple and Confirm)
  • Fact (Simple, fact less, coverage, confirm)
  • Warehouse Implementation Methods
  • STAR SCHEMA
  • SNOW FLAKE SCHEMA
  • Difference between STAR and SNOW FLAKE Schema.
  • Other terminologies Cleansing, Purging etc.
  • Database Modeling
  • Designing Methods
  • Logical Designing
  • Physical Designing
  • Introduction of Dimension Modeling
  • Difference between ER-Modeling and Dimension Modeling
  • Implementation of Dimension Model
  • Forward Engineering and Reverse Engineering
  • Introduction of various Database Components
  • OLAP ?OLAP/MOLAP/HOLAP

QlikView data structures:

  • Data structures in QlikView (AQL).
  • Sample Application walkthrough of QlikView
  • Architecture and components of QV
  • In-memory BI /OLAP
  • Loading data from multiple datasources:
  • Script editing
  • Menu Commands and Syntax
  • Handling DATA SOURCE FILES
  • The QWT (Access File example) primary data source
  • The QWT (Access File example with QVD Conversion) secondary data files
  • Script generation
  • Creating a connection to the database
  • Reading tables into QlikView
  • Big data Analytics
  • Connecting of Qlikview with Bigdata hadoop

ADVANCED SCRIPTING:

  • Condition on a field in a table
  • Aggregating Data in Script (Resident Load and Group Function, Order By etc)
  • Joining tables (Left, Right, Inner, Outer Joins)
  • Concatenation
  • Sheet Basics:
  • Sheet Objects
  • Text,list,chart,graph
  • Multidimensional,gauges,multibox
  • Calculation and expressions
  • Reporting formats
  • Server setup
  • Publisher
  • Alerts
  • Bookmark