Overview

WHO'S THIS FOR?This course is designed specifically for freshers and also for those who want to switch career from Excel to Tableau.Tableau is a leading data visualization tool used for data analysis and business intelligence. Gartner's Magic Quadrant classified Tableau as a leader for analytics and business intelligence.Advantages of TableauData visualization.Quickly Create Interactive visualizations.Ease of Implementation.Tableau can handle large amounts of data.Use of other scripting languages in Tableau.Mobile Support and Responsive Dashboard.Tableau Company Strategy.Scheduling or notification of reports.PROBLEMS YOU'VE EXPERIENCED WITH EXCEL IN THE PASTExcel becomes slow or crashes when you have lots of data, formatting and Charts inside a workbook.Mistakenly working on the wrong file you saved.It's so annoying to email multiple Excel files to the same people everyday.It takes hours to create a dashboard with multiple charts and formula functions.Some time Excel files are used to store the large amount data which is a very wrong decision because to update the data everyday on that file is a headache because it takes so much time to get open and then to get save.Note: Excel is also an Excellent Application. Yes Excel has some draw backs but it doesn't means its useless. Excel is also the Excellent tool to visualize and analyze the data.Learn how to use a TABLEAU Desktop (Data Visualization) most demanded tool in the industry today. Give your career a boost. With our online sessions, you will be amazed what you can achieved.Section 1: Booster1 Introduction 2 Download 3 Install 4 Tableau Extension5 Connect with Database 6 Tableau Live & Extract 7 View Tables 8 Data Types9 Tableau Work Sheet Interface 10 Data Types Symbol 11 Adding new Sheet 12 Product Category & Sales13 Dimensions & Measures 14 Visualize data in workspace15 Make Hierarchy 16 Grouping17 Auto Generated Fields 5 18 Auto Generated Fields in Tableau19 Records Per Dimension data or Item 20 Granularity 21 Granularity and Drill Down 22 Table into chart form 23 Color label 24 Color label for two different dimension 25 Map 26 Normal 27 Dynamic Filter 28 Date Filter 1 29 Date Filter 2 (Part1) 30 Date Filter 2 (Part2) 31 Date Filter 2 (Part 3)32 Date Filter 3 33 Relevant Filter Explained34 Relevant Filter in Tableau 35 Set36 Discrete vs Continuous37 Filtering 38 Keep only and ExcludeSection 2: Filters1 Filters 2 Type of Filters 3 Data Source Filters 4 Quick Filters 5 Dimension and Dependent Filters 6 Measure Filters 7 Context Filters Part1 8 Context Filters Part2 9 Context Filter Proper Details Part3 10 Date FilterSession 3: Charts1 Introduction to charts 2 Create a Chart 3 Swap the Dimension & Measures 4 Bubble Chart5 Pie Chart 6 Tree Map 7 Stacked Tree Map 8 Word Map Chart8 Word Map Chart9 Geographical Map10 Geographical Bubble Map Measure11 Geographical Bubble Map with size and color Measure12 Geographical Bubble Map (Unknown error)13 Geographical Map with color Dimension14 Geographical Map with Date as Year Filter15 Month Year Filter16 Month Year Filter Apply17 Bar chart18 Bar chart color Measure19 Bar chart size Measure20 Bar chart size and color Measure21 Bar chart with dual axis22 Bar Stacked chart part 1 23 Bar Stacked chart part 2 24 Reference line scope Entire table 25 Reference line scope per cell 26 Reference line scope per pan 27 Tree Map Stacked in Bar Chart 28 Bar Chart with Date as Month Year Filter. 29 Bubble Chart color label 30 Bubble Chart color label as second dimension 31 Bubble Chart with motion 32 Line Chart 33 Line chart dual axis 34 Line Chart size Measure 35 Line chart dual Measure Date as Month Year Filter 36 Funnel Chart 1 37 Funnel Chart 2 Intro38 Funnel Chart 2 Created 39 Scattered chart 40 Water Fall Chart 41 Parameter part 1 42 Parameter part 2 43 Parameter with Dynamic Reference line 44 Scatter plot and Many more Part145 Scatter plot and Many more Part2 46 Scatter plot and Many more Part3 Section 4: Union & Joins1 Intro Joins2 Inner Join3 Left Join4 Right Join5 Full Join6 Inner Join In Tableau7 Left Join in Tableau8 Right Join In Tableau9 Full Join In Tableau10 Union11 Union in Tableau12 Relation Like VlookupSection 5 : Function Base1 Function Intro2 Sum ()3 Min () & Max ()4 Average ()5 Floor ()6 Ceiling ()7 Count ()8 Upper ()9 Lower ()10 Right () & Left ()Section 6: Functions & Calculations Part11 Function Intro2 RANK() 3 RANK_DENSE()4 Rank Part 25 Rank_unique Part16 Rank_unique Part27 Rank_unique Part38 COUNT() vs CountD()9 Mid() 10 Len() 11 Find () 12 Mid() part 2 13 Trim() 14 Replace()15 Quick Table Calculations 16 Running Total 17 Difference 18 Percent Difference 19 Percent of Total 20 Moving Average Part 1 21 Moving Average Part 1 continuous 22 Date Functions () 24 Now() Today() 25 DateName and DatePart () 26 Date Diff () 27 Dateadd () 28 Datetrunc() 29 MakeDate() Section 7: Functions & Calculations Part 21 round zero or round function 2 round 1 2 3 4 3 absolute() 4 Concatenate() 5 Replace() 6 Table Across 7 Table Down 8 Table Across Then Down Section 8: Functions & Calculations Part 21 IF () 2 IF () in Tableau 3 IF () OR 4 IF () OR in Tableau 5 IF () AND 6 Nested IF () 7 Case () 8 Null() using if 9 Null() using if including OR AND 10 AND OR Part1 11 AND OR Part2

Skills

Reviews