Tableau Functions, Calculations, Filters, Unions & Joins

FunctionsCalculationsUnion JoinsFiltersWHO’S THIS FOR?This course is designed specifically for intermediates but freshers are also welcome who want to understand Tableau Functions, Calculations, Filters, Unions   Joins.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.Section 1:StarterLecture 1:Downlaod(Preview enabled)Lecture 2:InstallLecture 3:Visualize Data in workspaceSection 2:Joins IntroLecture 4:Join IntroSection 3:Joins UnionsLecture 5:Data Source Files Join Intro(Preview enabled)Lecture 6:Inner JoinLecture 7:Left JoinLecture 8:Right JoinLecture 9:Full JoinLecture 10:Inner Join in TableauLecture 11:Left Join in TableauLecture 12:Right Join In TableauLecture 13:Full Join In TableauLecture 14:UnionLecture 15:Union In TableauSection 4:FunctionLecture 16:Function IntroLecture 17:SUM()Lecture 18:MIN() MAX()Lecture 19:AVERAGE()Lecture 20:FLOOR()Lecture 21:CEILING()Lecture 22:COUNT()Lecture 23:UPPER()Lecture 24:LOWER()Lecture 25:RIGHT() Left ()Section 5:Functions CalculationsLecture 26:FunctionLecture 27:RANK()Lecture 28:Rank Dense ()Lecture 29:Quick Table CalculationsLecture 30:Running TotalLecture 31:DifferenceLecture 32:Percent DifferenceLecture 33:Percent of TotalLecture 34:Rank Part2Lecture 35:Moving Average Part 1.1Lecture 36:Moving Average Part 1.2Lecture 37:Moving Average Part 1.3_Lecture 38:Date Functions ()Lecture 39:Now() Today()Lecture 40:DateName and DatePart ()Lecture 41:Date Diff ()Lecture 42:Dateadd ()Lecture 43:Datetrunc()Lecture 44:MakeDate()Lecture 45:COUNT() vs CountD()(Preview enabled)Lecture 46:Mid()Lecture 47:Len()Lecture 48:Find ()Lecture 49:Mid() part 2Lecture 50:Trim()Lecture 51:Replace()(Preview enabled)Lecture 52:Rank_unique Part1Lecture 53:Rank_unique Part2Lecture 54:Rank_unique Part3Section 6:Function Calculations Part 2Lecture 55:round zero or round functionLecture 56:round 1 2 3 4Lecture 57:absolute()Lecture 58:Concatenate()Lecture 59:Replace()Lecture 60:Table AcrossLecture 61:Table DownLecture 62:Table Across Then DownSection 7:LOD Level of DetailsLecture 63:1Lecture 64:2Lecture 65:3Lecture 66:4Lecture 67:5_Lecture 68:6Lecture 69:7Lecture 70:8Lecture 71:9Section 8:IF Case FunctionsLecture 72:IF ()Lecture 73:IF () in Tableau(Preview enabled)Lecture 74:IF () ORLecture 75:IF () OR in TableauLecture 76:IF () ANDLecture 77:Nested IF ()Lecture 78:Case ()Lecture 79:Null() using ifLecture 80:Null() using if including OR ANDLecture 81:AND OR Part1Lecture 82:AND OR Part2Lecture 83:Viz 1Lecture 84:Viz 2Section 9:FiltrersLecture 85:FiltersLecture 86:Type of FiltersLecture 87:Data Source FiltersLecture 88:Quick FiltersLecture 89:Dimension and Dependent FiltersLecture 90:Meausure FiltersLecture 91:Context Filters Part1Lecture 92:Context Filters Part2Lecture 93:Context Filter Proper Details Part3Lecture 94:Date FilterLecture 95:Table AcrossLecture 96:Table DownLecture 97:Table Across Then DownLecture 98:FinalWho this course is for:To learn tableau Functions CalculationsTo Become a Tableau Developer.To Learn about Filters