Excel Tables, Sparklines, Conditional Formatting, Excel Data Tables, Slicers, Introduction, Slicers to filter your table data, Pivot Tables, Creating Pivot Tables, Use multiple ways to filter data in Pivot Tables, Slicers in Pivot Tables, Power Pivot, Introduction to Power Pivot and it’s uses, Pivot Tables v/s Power Pivot Tables, Creating Power Pivot Tables, Tables & Charts Combination, Power Pivot Hierarchies, Power Pivot using Slicers

Flexible data aggregation using pivot tables and pivot charts to create Dashboards, Introduction to Dashboards, Types of Dashboards, Analytical Dashboards, Dynamic Dashboards with Live Data, Excel Charts for Dashboards, Pie Chart, Stacked Bar Chart, Scatter Chart, Bubble Chart, Stock Chart, Radar Chart, Data Filter in Pivot to get Subsets of data & Advance Charts, Dashboard Data & Formats, Waterfall Chart, Band Chart, Gantt chart, Thermometer Chart, Histogram, Pareto Chart, Funnel Chart, Box and Whisker Chart, Waffle Chart, Reporting Layouts using formulas to aggregate the data as an alternative to Pivot Tables, Power view visualisation, Combination of power view visualisation, Interactive Nature of Charts in Power View Visualizations, Slicers & Tiles in Power View

Data Gathering & Transformation from multiple sources, Combining Multiple worksheet, Get and Transform data, Concatenate Formatting, Discover and combine data in mashups, Append Data, Merging Data, Data Blending, Data model creation, Data Exploration, Analysis and Visualisation

Introduction to SQL, Fundamental of SQL

Joins, Functions

Practice & Doubt Session on SQL

Deployment Types, Planning 3 Node Hadoop Cluster, Installing Cloudera Manager, Installing Multi Node Hadoop Cluster Using Cloudera Manager, Hadoop Configuration in Cluster environment, Specifying the Hadoop Configuration, Performing Basic Administration Tasks Using Cloudera Manager

GETTING STARTED WITH TABLEAU, NAVIGATION IN TABLEAU, TABLEAU ‘SHOW ME’, TABLEAU ‘DATA SOURCES’, TABLEAU ‘CUSTOM DATA VIEW ’, TABLEAU ‘EXTRACTING DATA ’, TABLEAU ‘OPERATIONS APPLIED ON DATA FIELDS’

TABLEAU ‘EDITING METADATA’, DATA JOINS IN TABLEAU, DATA BLENDING IN TABLEAU, Union in data IN TABLEAU, WORKSHEETS IN TABLEAU

OPERATORS IN TABLEAU, STRING CALCULATIONS, NUMERIC CALCULATIONS, FUNCTIONS IN TABLEAU, TABLE CALCULATIONS IN TABLEAU

BASIC SORTING IN TABLEAU, BASIC FILTERS IN TABLEAU, QUICK FILTERS IN TABLEAU, CONTEXT FILTERS IN TABLEAU

ADVANCE CHARTS IN TABLEAU, ACTIONS IN TABLEAU, PARAMETERS IN TABLEAU

LEVEL OF DETAIL, LEVEL OF DETAIL (LOD) CALCULATIONS : INCLUDE, LEVEL OF DETAIL (LOD) CALCULATIONS : EXCLUDE, LEVEL OF DETAIL (LOD) CALCULATIONS : FIXED, LEVEL OF DETAIL (LOD) CALCULATIONS : USED CASE, DATES IN TABLEAU

DASHBOARD DESIGN, DASHBOARD DESIGN – PLAN, DASHBOARD DESIGN – LAYOUT, DASHBOARD DESIGN - INTERACTIVITY

A list of Orders returned by the Customers (in terms of refund), Top 10 Countries mapped on the World Map that had most of the refunds, Predict the refund for next 1 year category-wise, Actions to be Performed to Create the Dashboard, Create hierarchies and folders in the dataset provided, Generate a list of order returned from customers and compare it to the original sales, sort the visualization in ascending, Order in terms of returned order, for top 10 countries in terms of refunds, Map top 10 countries, with most of the refunds on the world map, Predict the returned sale with lowest and actual forecast of the data, Add a URL action to represent details of the countries, Finally publish your work to Tableau Server/ Online