Using Tableau Data Visualization for Business Intelligence

Introduction to Tableau

Points to consider before using Tableau Data Visualization

• You don't have to realize a lot for Data Visualization With Tableau. Yet, at the same time, a fundamental familiarity with all sorts of diagrams, for example, bar charts, line outlines, histograms, etc., are loved.
• It would also be valuable if you had some essential comprehension of the database of the executives (data types, joins, drill down, drill up, etc.).

Tableau has been considered as one of the leaders in Data Visualization as it provides the best cloud-based analytics solution along with all the BI capabilities your business need. Source: Best Analytics Tools For Data Visualization

What are the 5 main products offered by Tableau?

the 5 main products offered by Tableau are listed below:

1. Tableau Desktop
2. Tableau Reader
3. Tableau Server
4. Tableau Public
5. Tableau Online

every offer Data Visual Creation and choice depends on the sort.

Installation of Tableau

Tableau Desktop

• Free access for 14 days
• You get free access to the Desktop for a full year if you are a student or a teacher.
• Buy Tableau

Tableau Public

Tableau Online

Getting Started with Tableau Data Visualization

Steps to get started with Tableau for Data Visualization are described below:

Tableau Workspace

• The Tableau workspace is a compilation of worksheets, menu bar, toolbar, marks card, shelves, and a ton of different components about which we will learn in segments to come.
• Sheets can be worksheets, dashboards, or stories. The picture underneath features significant parts of the workspace.
• Be that a more significant commonality will be accomplished once we work with accurate information.

Connecting to a Data Source

• To start Data Visualization With Tableau, we have to interface Tableau with the information source. The scene is good, with a ton of information sources.
• The information sources upheld by Tableau Data Visualization show up on the left half of the initial screen. Some commonly utilized information sources are excellent text files, relational databases, or even a server.
• Likewise, one can interface with a cloud database source, such as Google Analytics, Amazon Redshift, etc.
• The dispatch screen of Tableau Desktop shows the accessible information sources that one can associate with as well. Data Visualization in Tableau is likewise subject to the form of Tableau since the paid adaptation offers more possibilities.
• You will get a Connect sheet on the left side screen that features accessible sources. Document types are recorded first, trailed by basic server types or the servers that have been, as of late, associated.
• You can open recently made exercise manuals Under the Open tab. Tableau Desktop additionally gives some example exercise manuals under Sample Workbooks.

Steps

1. Import the Data into the scene workspace from the PC.
2. Three sheets will become apparent within the Sheets Tab, especially Orders, People, and Returns. We will concentrate just on Orders information. Double-tap on the Orders Sheet, and it opens up only like a spreadsheet.
3. We watch the first three columns of information look somewhat changed and aren't in the ideal arrangement. Tableau Data Visualization we utilize Data Interpreter, likewise present under the Sheets Tab. By tapping on it, we get a pleasantly designed sheet.

Creating a View

• Dimension
• Measures
• Aggregation

Dimension

• They are personal information, for example, a name or date. Of course, Data Visualization With Tableau consequently characterizes information that contains subjective or precise cut data as a dimension, for instance, any field with content or date esteems.
• These fields, by and large, show up as section headers for columns of information, for example, Customer Name or Order Date, and characterize the degree of granularity that appears in the view.

Measures

• Measures are quantitative numerical information. Of course, Tableau treats any field containing this sort of data as a measure, such as deals, exchanges or benefits.
• Information named a measure can be collected depending on a given measurement, such as all-out deals (Measure) by area (Dimension).

Aggregation

• The column-level information moved up to a higher classification, for example, the aggregate sum of sales or total profit.

Steps

1. Go to the worksheet. Snap on the tab Sheet 1 at the base left of the scene workspace.
2. Under Dimensions at the bottom of the distribution datasheet, drag the order date to the column shelf. Dragging the Order Date to the sections shelf makes a segment for Orders in the dataset. An 'Abc' marker is visible under every section, which implies that content or numerical or content information can be dragged here. Then again, if we pulled Sales here, a cross-tab would be made to show the total sales for every year.
3. Likewise, drag the Sales field onto the Rows shelf from the Measures tab. Data Visualization in Tableau populates a graph with deals totaled as a total. Total aggregated sales for every year by request date are shown. Scene consistently fills a line diagram for a view incorporating time-field, which is now Order Date.

Refining the View

Steps

1. The category is available under the Dimensions sheet. Drag it to the section's shelf and spot it alongside YEAR(Order Date). The Category ought to be set to one side of the Year. In doing as such, the view promptly changes to a bar graph type from a line. The graph shows the general Sales for each Product by year.

For Data Visualization using Tableau, about every data point (mark) in the view, float more than one of the bars to uncover a tooltip. The tooltip shows all our deals for that class. Here are some tips for office supplies for 2016. To add a name to the view, click Show tag labels in the tag. The bar diagram can be shown on a level plane rather than vertically as well—Snap Swap on the toolbar for the equivalent. The view above pleasantly shows sales by category, i.e., furniture, office supplies, and innovation. We can likewise deduce that furniture deals are becoming quicker than deals in office supplies aside from 2016. Therefore, focusing sales efforts on furniture instead of office supplies will be wise. In any case, furniture is a huge class and comprises a wide range of things. How might we recognize which furniture thing is contributing to the most excellent deals?

To assist us with addressing that question, we choose to see items by subcategory to see which things are the vast vendors. Suppose we need to take a gander at insights concerning just bookcases, chairs, furnishings, and tables for the Furniture classification. We will Double-snap or drag the Sub-Category measurement to the Columns shelf to begin Data Visualization With Tableau.

The sub-class is another discrete field. It further analyzes the Category and presents a bar for each sub-classification separated by class and year. However, it is a humongous measure of information to comprehend outwardly. In the following area, we will find out about channels, shading, and different approaches to make the view progressively comprehensible.

Emphasizing the Results

• In this section, we try to focus on individual results. Filters and bars are one way to pay more attention to the details that interest you.

Adding filters to the view

• Filters can be utilized to incorporate, or bar esteems in the view. Here we attempt to add two primary channels to the worksheet to simplify looking at product sales by sub-category for a particular year.

Steps

Adding colors to the view

Steps

Key Findings

Steps

• In the view, uncheck all crates except Bookcases, Tables, and Machines in the Sub-Category channel card. This uncovers a curious truth. While in specific years, Bookcases and Machines were productive. Notwithstanding, in 2016, Machines got unrewarding.
• Select All in the Sub-Category channel card to show all subcategories again. Drag the area onto the row shelf during the test and place one side of the "Sales" tab. We notice that machines in the South are announcing a higher negative benefit in general than in your different areas.
• Let us currently give a name to the sheet at the base left of the workspace, double-tap Sheet 1, and type Sales by Product and Region.
• To save the view, Data Visualization in Tableau permits us to copy our worksheet to proceed to another sheet from the last known point of interest.
• In your exercise manual, right-click the Sales by Product and Region sheet, select Duplicate, and rename the copied layer to Sales-South.
• The new worksheet moves the dimensions into the filter compartment and adds them as channels on the screen.

• In the Filter Region exchange box, clear all checkboxes aside from South, and afterward, click OK. Presently we can concentrate on deals and benefit in the South. We find that machine deals had a negative benefit in 2014 and again in 2016. We will explore this in the following area.
• In conclusion, remember to spare the outcomes by choosing File > Save As. Let us name our exercise manual Regional Sales and Profits.

Want to accelerate your adoption of Tableau to be more productive? Get expert advice from Business Intelligence Consulting.

Creating a Map View

Steps

1. Create a new worksheet.
2. Include State and Country under Datasheet to Detail on the Marks card. We acquire the map view.
3. Drag Region to the Filters shelf, and afterward channel down to South as it were. The guide sees currently zooms in toward the South locale, and an imprint speaks to each state.
4. Drag the Sales measure to the Color tab on the Marks card. We acquire a filled guide with the hues indicating the scope of deals in each state.
5. We can change the shading plan by clicking Color on the Marks card and choosing Edit Colors.
6. We can try different things with available palettes.
7. We see that Florida is playing out the best-concerning Sales. If we Hover over Florida, it shows a sum of 89,474 USD in deals when contrasted with South Carolina, which has just 8,482 USD in transactions. Let us measure the exhibition by Profit now since Profit is a superior marker to Sales alone.
8. Drag Profit to Color on the Marks card. We currently observe that Tennessee, North Carolina, and Florida have negative benefits, even though it showed up they were doing acceptably in Sales. When you add a map to the sheet as Profit Map

Getting into the details

Steps

1. Copy the Profit Map worksheet and name it the Negative Profit Bar Chart.
2. Click Show Me on the Negative Profit Bar Chart worksheet. Show Me presents the number of manners by which a chart can be plotted between things referenced in the spreadsheet. I select the even bar alternative from Show and quickly update the view to level from vertical bars.
3. We can choose more than each bar in turn by mostly clicking and hauling the cursor over them. We need to concentrate just on the three states, i.e., Tennessee, North Carolina, and Florida. Henceforth, we will only choose the bars relating to them.

Creating Hierarchies

1. Layers in the video. Drag a field into the datasheet and drop it directly onto another area or right-click on the area and select it.
2. Drag additional fields in the chain of importance. Fields can likewise be re-requested in the pecking order by basically dragging them to another position. In the current Data Visualization using Tableau, we will make the accompanying progressions: Location, Order, and Product.

1. Right-click the inclusion set (country, state) on the filter shelf and select Add to context. We find that Concord(North Carolina) now shows up in see while Miami (Florida) has vanished. This bodes well at this point.
2. In any case, Jacksonville (North Carolina) is as yet present, which is mistaken. In the Rows shelf, click the molded symbol on the City tab. It will penetrate down to the Postal Code level. Right-click, the postal code for Jacksonville, NC, 28540, and afterward, select Exclude to reject Jacksonville physically.
3. Drag the Postal Code of the Rows shelf. This is the list view.

Key Findings

Steps

1. Drag Sub-Category to the Rows to additionally bore down.
2. So also, drag the Profit to Color on the Marks card. This empowers us to spot items with negative benefits rapidly.
3. Right-click the Order Date and select Show Filter. It appears that Machines, tables, and covers are performing inadequately. So what would it be advisable for us to do? One arrangement is to stop the offer of these items in Jacksonville, Concord, Burlington, Knoxville, and Memphis. How about we check if our choice is correct?
4. Let us head back to the recently made Profit Map sheet tab.
5. Presently, click on the Sub-Category field to choose the Show Filter choice.
6. Drag Profit to Measurements to the Label Marks tab
7. Click the order date again and choose Show Filters. From the channel, let us clean up the things that we believe add to negative benefits. In this way, uncheck the containers before Binders, Machines, and Tables separately. Presently we are just left with the benefit of making substances. This shows that elements like Binders, machines, and tables were causing misfortunes in certain zones, and we were directly in our discoveries.

Dashboard

Creating a Dashboard

1. Drag Sales in the South onto the empty dashboard.
2. Drag the profit overview into the dashboard and drop it in the "Sales" view in the "South" view. Both perspectives are visible twice. To have the option to introduce information in a way so others can comprehend it, we can mastermind the dashboard precisely as we would prefer.
3. On the Sales, South worksheet in the dashboard see, click under the Region and tidy up the Show Header. Rehash a similar procedure for the various headers. This assists with underscoring just what is required and conceals away the not-all-that-important data.
4. On the Profit Map, Hide the Title also and play out similar strides for the Sales South guide.
5. We can see that the Sub-Category channel card and Year of Order Date have been rehashed on the right side. Let us dispose of the extra by necessarily crossing them out. At last, click on the Year of Order Date. A drop-down bolt shows up and chooses the choice of Single Value (Slider). Presently let the enchantment unfurl. Examination by picking several years on the slider and the Sales additionally shift appropriately.
6. Drag the SUM(Profit) channel to the base of the dashboard beneath Sales in the South for a superior view

Conclusion

As we conclude Data Visualization With Tableau, our concise examination of information representation, the field is wealthy in potential applications in various orders; simultaneously, we should know about its practical and ethical complexities.

• Discover Data Visualization with Microsoft Power BI
• Explore here about Data Visualization Designs and its Types of Dashboard
• Explore here about 3D and Multidimensional Data Visualization Technique