Tableau Tutorial

Tableau Tutorial Tableau Tutorial Learn Data Visualization Using Tableau Back Home Categories Online Courses Mock Interviews Webinars NEW Community Write for Us Categories Artificial Intelligence AI vs Machine Learning vs Deep LearningMachine Learning AlgorithmsArtificial Intelligence TutorialWhat is Deep LearningDeep Learning TutorialInstall TensorFlowDeep Learning with PythonBackpropagationTensorFlow TutorialConvolutional Neural Network TutorialVIEW ALL BI and Visualization What is TableauTableau TutorialTableau Interview QuestionsWhat is InformaticaInformatica Interview QuestionsPower BI TutorialPower BI Interview QuestionsOLTP vs OLAPQlikView TutorialAdvanced Excel Formulas TutorialVIEW ALL Big Data What is HadoopHadoop ArchitectureHadoop TutorialHadoop Interview QuestionsHadoop EcosystemData Science vs Big Data vs Data AnalyticsWhat is Big DataMapReduce TutorialPig TutorialSpark TutorialSpark Interview QuestionsBig Data TutorialHive TutorialVIEW ALL Blockchain Blockchain TutorialWhat is BlockchainHyperledger FabricWhat Is EthereumEthereum TutorialB lockchain ApplicationsSolidity TutorialBlockchain ProgrammingHow Blockchain WorksVIEW ALL Cloud Computing What is AWSAWS TutorialAWS CertificationAzure Interview QuestionsAzure TutorialWhat Is Cloud ComputingWhat Is SalesforceIoT TutorialSalesforce TutorialSalesforce Interview QuestionsVIEW ALL Cyber Security Cloud SecurityWhat is CryptographyNmap TutorialSQL Injection AttacksHow To Install Kali LinuxHow to become an Ethical Hacker?Footprinting in Ethical HackingNetwork Scanning for Ethical HackingARP SpoofingApplication SecurityVIEW ALL Data Science Python Pandas TutorialWhat is Machine LearningMachine Learning TutorialMachine Learning ProjectsMachine Learning Interview QuestionsWhat Is Data ScienceSAS TutorialR TutorialData Science ProjectsHow to become a data scientistData Science Interview QuestionsData Scientist SalaryVIEW ALL Data Warehousing and ETL What is Data WarehouseDimension Table in Data WarehousingData Warehousing Interview QuestionsData warehouse architectureTalend T utorialTalend ETL ToolTalend Interview QuestionsFact Table and its TypesInformatica TransformationsInformatica TutorialVIEW ALL Databases What is MySQLMySQL Data TypesSQL JoinsSQL Data TypesWhat is MongoDBMongoDB Interview QuestionsMySQL TutorialSQL Interview QuestionsSQL CommandsMySQL Interview QuestionsVIEW ALL DevOps What is DevOpsDevOps vs AgileDevOps ToolsDevOps TutorialHow To Become A DevOps EngineerDevOps Interview QuestionsWhat Is DockerDocker TutorialDocker Interview QuestionsWhat Is ChefWhat Is KubernetesKubernetes TutorialVIEW ALL Front End Web Development What is JavaScript â€" All You Need To Know About JavaScriptJavaScript TutorialJavaScript Interview QuestionsJavaScript FrameworksAngular TutorialAngular Interview QuestionsWhat is REST API?React TutorialReact vs AngularjQuery TutorialNode TutorialReact Interview QuestionsVIEW ALL Mobile Development Android TutorialAndroid Interview QuestionsAndroid ArchitectureAndroid SQLite DatabaseProgramming Learn... Data Visualiza tion with Tableau (36 Blogs) Become a Certified Professional AWS Global Infrastructure Getting Started with Tableau What is Tableau? Visualizing Data Using TableauDo Magic With Tableau!Tableau vs QlikView â€" Which Data Visualization Tool To Choose?Power BI vs Tableau : Which One Would You Choose? Understanding Data Visualization with Tableau Tableau Tutorial â€" Learn Data Visualization Using TableauUnderstanding How And When To Use Different Tableau ChartsTableau Dashboard â€" Redefining Data VisualizationHow to create a Pareto Chart in Tableau?Functions in Tableau and How to Use ThemWhat are Sets in Tableau And How To Create ThemHow to Create and Use Parameters in TableauTop Tableau Tips and Tricks a Data Visualization Expert Must KnowEverything About Different Ways To Use Dual Axis Charts in Tableau Data Manipulation in Tableau How do LOD Expressions work in Tableau?Why Should You Blend When You Can Already Join In Tableau? Tableau Products All You Need To Pick The R ight Tableau Product!Step By Step Guide To Learn Tableau Public Tableau Careers How Much Would You Make As A Tableau Developer?Tableau Developer Salary : Everything You Need To KnowHow to Build an Impressive Tableau Developer Resume?5 Reasons to Learn Tableau â€" A Deep Dive into Tableau Career Opportunities!How to Become a Tableau Developer?Quick guide for Tableau Certification: Tableau Desktop 9 Qualified Associate Exam Tableau Interview Questions Top 50 Tableau Interview Questions You Must Prepare In 2020BI and Visualization Topics CoveredPentaho BI (9 Blogs)Microsoft BI (5 Blogs)Data Visualization with Tableau (34 Blogs)BI and Data Visualization with Qlikview (1 Blogs)SEE MORE Tableau Tutorial Learn Data Visualization Using Tableau Last updated on May 22,2019 74.1K Views Reshma Ahmed Reshma is a tech-savvy professional working as a Research Analyst at Edureka.... Reshma is a tech-savvy professional working as a Research Analyst at Edureka. She is a DevOps evangelist, a Cloud enthusiast, a Big Data Hadoop...3 Comments Bookmark 1 / 9 Blog from Understanding Data Visualization with Tableau Become a Certified Professional When you talk about Data Visualization, the first word that comes to your mind is Tableau. I am guessing thats why you might be here reading this Tableau tutorial because you have heard about the advantages of Tableau.The demand for Tableau certification training is at peak because of its increasing adoption in the market.This is my first blog in this Tableau Tutorial blog series which will explain how to get started with Tableau. Hope you will enjoy learning about Tableau with this Tableau Tutorial blog.Well you came to the right place. In this Tableau Tutorial, you will be learning the following topics:Importance Of Data VisualizationData Visualization ToolsWhy Tableau?What Is Tableau?Tableau Product FamilyUnderstanding More About TableauVisualizationsUse Case DatamaticsLet us first start this Tableau tutorial by understanding the concepts behind Data Visualization.Importance Of Data VisualizationData Visualization is one of the most important part of data analysis. It has always been important to present the data in an understandable and visually appealing format. Data visualization is one of the skills that Data Scientists have to master in order to communicate better with the end users.Data is the word here.Let me first give you an idea of the kind and amount of data that we are dealing with.According to SiliconAngle, there was 2.5 zetabytes of stored data world over in the year 2012 and it is set to hit more than 50 zetabytes mark by the end of 2017. To put things in perspective, this data has largely been produced by websites and cross platform transactions. Add to it the fact that there would be a total of 20 billion smart devices connected to the internet by the end of 2020 and the numbers can be baffling!Data visualization allows data scientists to converse with their end users. The outcome of da ta analysisis not immediately comprehensible to the people who do not directly deal with data. Data visualization bridges that gap and makes people appreciate the possibility of data analysis.Let us consider the following example to understand this:The following image shows the x and y co-ordinates of different points to be plotted on a graph. The numbers look almost the same, dont they? Maybe the lines will look similar after we plot each set on the graph.So, now take a look at the image below when we plot these points in our graph:You see how different they look like when you actually visualize it. It wasnt possible for us to figure out the nature of each line until we visualized it.Tableau Tutorial: Introduction To Data Visualization ToolsHere are the top 5 data visualization tools that are being used extensively in BI:TableauQlikviewDomoMicrosoft power BIExcelLet us know a little bit about all of them.Tableau:Basic version of Tableau data visualization tool is free which can per form regular tasks such as: Sales data analysis User density monitoring Consumer segmenting Tracking budgeting expense Categorizing and sub-categorizing dataExcel:You can actually do some pretty complex things with Excel, from heat maps of cells to scatter plots. As an entry-level tool, it can be a good way of quickly exploring data, or creating visualizations for internal use, but the limited default set of colors, lines and styles make it difficult to create graphics that would be usable in a professional publication or website.Microsoft Power BI:Microsoft Power BI is a cloud-based business intelligence and analytics service that provides a full overview of your most critical data.Connecting to all of your data sources, Power BI simplifies data evaluation and sharing with scalable dashboards, interactive reports, embedded visuals and more.Domo:Domo is designed to be available for all business users, regardless of technical expertise, to help them make better business decisions.Dom o recently launched Business Cloud, the worlds first open, self-service platform to run an entire organization. Business Cloud brings together the data, the people and the insights users need to find answers to critical business questions and make faster, better-informed decisions to improve performance.Qlikview:The QlikView business discovery platform is one of a few visual analytics tools offered by Qlik. QlikView cant create the same elegant visualizations that the other tools offer, but the softwares dynamic model means that you can quickly analyze your data in multiple dimensions. In addition, QlikView is able to work off of data in memory instead of off your disk, allowing for real-time operational BI environments (like monitoring financial transactions).QlikView is able to work with a wide variety of data sources, including SAP, Oracle, Salesforce.com and other legacy data files like Excel spreadsheets. Whats more, QlikView can combine these disparate data sources into a sing le visualization or dashboard.But now the big question is which tool should you go for? Well, I say go with Tableau. Take a look below to know why.Why Tableau?Below are some of the pros or features of Tableau which will spellbind you to start using it right away!Tableau Features:1. Apt visualizations:Tableau connects to many different data sources and can visualize larger data sets than Power BI can. Once in Tableau, a dashboard showsthe basics of the users data. The user can then drill down into data sets by downloading a worksheet. From there, they can apply various visualizations to the data.In Tableau, you select the data and switch between visualizationson the fly. Its easier to jump between visualizations in Tableau.Tableau visualizes data from the start, allowing you to see the significance right away. Tableau differentiates correlations using color, size, labels and shapes, giving you context as you drill down and explore on a granular level.2. Depth of discovery:The feature s of Tableau gives users ways to answer questions as they investigate data visualizations. The solution can show basic trends as predictions, use what if queries to adjust data hypothetically, and visualize components of data dynamically for comparisons.3. Implementation:Tableau provides a variety of implementation and consulting services. For enterprise-level deployment, theres a four-step process spanning weeks, and for smaller-scale deployments, there are quick-start options that can complete setup in a matter of hours.Tableau provides a variety of implementation and consulting services. For enterprise-level deployment, theres a four-step process:Phase 1 This phase involves IT planning, architecture consulting, pre-install checkup, server installation and verification, and validation of security configuration.Phase 2 Phase 2 involves working with data and data migration, including data modeling, data mining, data extraction, data sources and business workflow.Phase 3 In Phase 3, theres a two-day classroom training covering Tableau Fundamentals, hands-on advanced coaching, and building and formatting visualizations.Phase 4 This final phase helps companies expand Tableau usage across their business. It includes implementation workshops where topics such as evaluating action plans and defining measurable outcomes are discussed.4. Automation functionality:Tableau is a little more intuitive with creating processes and calculations. For example, when creating calculations in a tabular format, the formula can be typed once, stored as a field and applied to all rows referencing that source. This makes it easier to create and apply recurring processes. Tableaus flexibility also allows users to create custom formulas that arent available in most of the tools.5. Data source connectors:Tableau offers hundreds of native connectors to easily pull, cleanse and correlate data from practically any source without having to create custom code.Tableau extracts large data s ets from sources for quick, ad-hoc analysis using two different methods: Live Connection and In-memory. Both adapt to your local database and, based on the size and capacity, sync data quickly by extracting the relevant data to a query. It also has a general Open Database Connectivity (ODBC) connection for any connections that dont have a native connector provided.This is the reason, you can see an increasing demand graph for Tableau certification training.Tableau Product Family1. Tableau Desktop:It is a self service business analytics and data visualization that anyone can use. It translates pictures of data into optimized queries. With tableau desktop, you can directly connect to data from your data warehouse for live upto date data analysis. You can also perform queries without writing a single line of code. Import all your data into Tableaus data engine from multiple sources integrate altogether by combining multiple views in a interactive dashboard.2. Tableau Server:It is more of a enterprise level Tableau software. You can publish dashboards with Tableau Desktop and share them throughout the organization with web-based Tableau server. It leverages fast databases through live connections.3. Tableau Online:This is a hosted version of Tableau server which helps makes business intelligence faster and easier than before. You can publish Tableau dashboards with Tableau Desktop and share them with colleagues.4. Tableau Reader:Its a free desktop application that enables you to open and view visualizations that are built in Tableau Desktop. You can filter, drill down data but you cannot edit or perform any kind of interactions.5. Tableau Public:This is a free Tableau software which you can use to make visualizations with but you need to save your workbook or worksheets in the Tableau Server which can be viewed by anyone.Understanding TableauLet us start by taking a look at the datatypes that Tableau supports. Refer to the diagram below which shows all the compat ible data types of Tableau.The above diagram shows you the data types that Tableau supports with respective examples.Now, the data types that we are dealing with can also be categorized broadly into two categories and they are:MeasuresDimensionsRefer to the diagram below to understand the differences between Dimensions and Measures. In order to make it more understandable to you, A dimension is used to add more detail to describe your data.How To Use Tableau?You just need to follow the below 3-step mantra to use Tableau:Connect to dataPlay around with the UICreate visualizations1. Connect to dataThe first thing to do in Tableau is to connect to your data. There are mainly two types of connections-Connecting to your local file or connecting to a server.Tableau can connect to any local file or database such as- Excel Text File Access Statistical File, orOther Database file. Local connection gives the maximum speed of data processing.Tableau can connect to your data server too. It can connect to almost any type of data server. Below are some of the most popular databases that Tableau can connect: Tableau Server Google Analytics Google BigQuery Hortonworks Hadoop Hive MapR Hadoop Hive IBM DB2 IBM BigInsights IBM Netezza Microsoft SQL Server Microsoft Analysis Services Oracle Oracle Essbase MySQL PostgreSQL SAPWhile working on Tableau, data can have Live Connection where any change in the source data will be automatically updated in Tableau. On the other hand, data can be Extracted to Tableau repository so that any change made here will not affect the original source data.Data JoinsYou can also integrate different data-sets together to link up and produce better insights. There are different ways to join data-sets. Refer to the diagram below to understand them all.In the above diagram shows the four data-set join options available in Tableau.2. Play around with the UIThis is how the user interface looks like:UI- Show me the dataThis is the pane with which you can create visualizations. You can create different visualization in order to represent your dataset. The diagram below shows the show me data pane:Some visualizations might not be available at times because of incompatible dataset.Below are the most popular visualizations used widely in Tableau:Tree MapHeat MapNow lets explore few more options available in our UI.MenuThe menu bar in Tableau consists of various options to edit your visualization. Let me take you through them one by one.File menuThis Menu is used to create new Tableau workbook and open existing workbooks from both local system and Tableau server. The important features in this menu are:Workbook Locale to set the language to be used in the report.Paste Sheets to paste a sheet into the current workbook which is copied from another workbook.Export Packaged Workbook option is used to create a packaged workbook which will be shared with other users.Data MenuThis Menu is used to create new data source to fetch the data for ana lysis and visualization. It also allows you to replace or upgrade existing data source.The important features in this menu are as follows:New Data Source to see all the types of connections available and choose from it.Refresh All Extracts to refresh the data form source.Edit Relationships option is used to define the fields in more than one data source for linking.Worksheet menuThis Menu is used to create new worksheet along with various display features like showing the title and captions etc.The important features in this menu are as follows:Show summary to see the summary of the data used in the worksheet like count etc..Tooltip to show the tooltip when hovering above various data fields.Run Update option is used to update the worksheet data or filters used.Dashboard menuThis Menu is used to create a new dashboard along with various display features like showing the title and exporting the image etc..The important features in this menu are as follows:Format is used to set the la yout in terms of colours and sections of the dashboard.Actions to link the dashboard sheets to external URLS or other sheets.Export Image option is used to export an image of the Dashboard.Story MenuThis Menu is used to create a new story which has many sheets or dashboards with related data.The important features in this menu are as follows:Format is used to set the layout in terms of colours and sections of the story.Run Update to update the story with latest data form source.Export Image option is used to export an image of the story.Analysis MenuThis Menu is used for analyzing the data present in the sheet. Tableau provides many out of box features like calculating the percentage and doing a forecast etc..The important features in this menu are as follows:Forecast to show a forecast based on available data.Trend Lines to show the trend line for s series of data.Create calculated Field option is used to create additional fields based on certain calculation on existing fields.Map MenuThis Menu is used for building map views in Tableau. You can assign geographic roles to fields in your data.The important features in this menu are as follows:Map Layers to hide and show map layers, such as street names and country borders, and add data layers.Geocoding to create new geographic roles and assign them to the geographic fields in your data.Format MenuThis Menu is used for applying the various formatting options to enhance the look and feel of the dashboards created. It provides features like borders, colours, alignment of text etc..The important features in this menu are as follows:Borders to apply borders to fields displayed in the report.Title and caption to assign a Title and caption to the reports.Cell Size to customize the size of the cells displaying the data.Workbook Theme to apply theme to the entire workbook.Server MenuServer Menu is used to login to the Tableau server if you have access and publish your results to be used by others. It is also used to acc ess the workbooks published by others.The important features in this menu are as follows:Publish Workbook to publish the workbook in the server to be used by others.Publish Data source to publish the source data used in the workbook.Create User filters to create filters on the worksheet to be applied by various users when the access the report.3. Create VisualizationsAbove in this Tableau tutorial, you have seen the different The following table tells you how to choose the right visualization for your dataset out of many available options.Now, let us have a look at a case study to understand how Tableau can help in solving real-life business problems.Tableau Use Case DatamaticsDatamaticsis the subsidiary of worlds largest bank based on market capitalization, dealing in securities and stocks investments. It provides services in all major areas of investment like equity, IPO, derivatives, mutual funds, insurance etc.Business need:Being a part of an extremely dynamic industry, trackin g the slightest market development is of highest priority for the client. They needed a solution that could enable them to react quickly to the varying market trends. A solution that would be able to generate hassle-free, ad-hoc secured reports that could provide accurate data visualization.Challenges:Unable to react quickly to market developments and regulatory requirements The existing system had a high turnaround time which delayed the overall decision making process.Restricted and inflexible data visualization reports resulted in poor interpretation of data The system compromised on security aspects and had high IT support dependency Lack of effective versatility to do ad-hoc analyses from multiple viewpoints.Solution:Datamatics selected Tableau, a leading Data Visualization BI tool in the market. As per requirements gathered, various Dashboards and Reports were designed for various levels. Refer to the diagram below to understand how Datamatics made use of Tableau:Tableau was connected with the existing data bases of the organization. Unique and relevant visual dashboards reports were developed for people at different levels across the organization as well as to cater the day-to-day needs of different departments.Results:Time taken to generate analytical reports/MIS reduced to 1-2days with zero loss of data.Efficient integration of excel and other flat files based data with structured data to create deep versatile analytical insights. Easy and optimized data visualization options to slice dice the reports for more meaningful and comprehensive viewing.Enhanced security features with role based access. Maximum level of ease to distribute share the reports even amongst extended team members. Dependency on the IT team or external vendors for report generation was minimized.Easy installation and integration of the solution with the existing system reduced.Total Cost of Ownership for the client Boosted the identification of cross-selling and up-selling opp ortunities.This is how Tableau helped Datamatics and has been helping many other companies worldwide.I hope you have enjoyed reading this blog. I will be coming up with more blogs in the coming days on Tableau. You will be learning how to make proper insights, dashboards, contributing viz and many more.You can go ahead and check out this blog too in order to learn more.If you wish to master Tableau, Edureka has a curated course on Tableau Training Certification which covers various concepts of data visualization in depth, including conditional formatting, scripting, linking charts, dashboard integration, Tableau integration with R and more. It comes with 24*7 support to guide you throughout your learning period. New batches are starting soon.Got a question for us? Please mention it in the comments section and we will get back to you at the earliest.window._LQ_=window._LQ_||{}; lqQuizModal(window,document,{quizId:'2kmony',baseUrl:'https://quiz.leadquizzes.com/',trigger:'exit'},_LQ_ );Recommended videos for you Data Visualization-How to Make Sense of Data Watch Now Introduction to Pentaho BI Watch Now QlikView â€" Whats Your Business Question? Watch Now Visual Analytics with Tableau Watch NowRecommended blogs for you What is VLOOKUP in Excel and How to use it? Read Article How To Use Donut Charts in Tableau Read Article An Introduction to the Power Query Editor Read Article Introduction to OLAP in Pentaho Read Article What is the Tableau Server and its components? Read Article Introduction to Pentaho Data Integration Read Article How Much Would You Make As A Tableau Developer? Read Article Power BI Desktop: Visualize Data Like Never Before Read Article Tableau vs QlikView Which Data Visualization Tool To Choose? Read Article 5 Reasons to Learn Tableau A Deep Dive into Tableau Career Opportunities! Read Article How to Implement Context Filters in Tableau Read Article Pentaho Case Study Read Article Top 5 Business Intelligence Tools Read Article How to Become a Tableau Developer? Read Article Understanding How And When To Use Different Tableau Charts Read Article Quick guide for Tableau Certification: Tableau Desktop 9 Qualified Associate Exam Read Article All you Need to Know About Power BI Salary Read Article All You Need to Know About Power BI Visuals Read Article What is Informatica: A Beginner Tutorial of Informatica PowerCenter Read Article What is Power BI Getting Started with Microsoft Power BI Read Article Comments 3 Comments Trending Courses in BI and Visualization Tableau Training and Certification26k Enrolled LearnersWeekend/WeekdayLive Class Reviews 5 (10300)