_edited_edited.png)
Tableau is the powerful and fastest visualizing tool that is used in the Business Intelligence(BI) Industry. It simplifies the raw data into an understandable format. Analysis of the data becomes faster with Tableau. The visualizations can be created in the form of dashboards. The visualizations or diagrammatic representation of data can easily be understood by the employees of the organizations who are at different levels.
Tableau has 4 main products.
Tableau Prep: Tableau Prep is responsible for preparing data for analysis. This tool provides 3 coordinated views which provide us with a complete picture of data.
Tableau Desktop: Tableau Desktop is the place where the analysis happens. It has powerful drag and drops analytics which is very easy to use. Through the desktop, you get your data insights quickly.
Tableau Online: Tableau Online is a secure and scalable self-service analytics cloud tool. You can use it anywhere, anytime and it has eliminated the complexities of IT.
Tableau Server: From small to large enterprises, Tableau server is used for fulfilling their BI requirements. This is an on-premise solution. This tool can take data from anywhere and shared it across the organization through the desktop or mobile browsers.
What is data visualization?
Data visualization means the graphical representation of data or information. We can use visual objects like graphs, charts, bars, and a lot more. Data visualization tools provide an accessible way to see and understand the data easily.
WAFFLE CHART
A waffle chart is the best way to show percentage values.
Step 1: The first step to import the data file in to Tableau, I have used sample superstore data excel file.
Step 2: The first step to create the waffle chart is to get the excel file ready for the waffle. The excel file has the following three columns: Row, Column and Percentage . Following is the format of the excel file.
Import the excel file into tableau. Bring Rows and columns from measures to dimensions.
Step3: Bring the column variable to the column pane and the row variable to the row pane.
Step 4: Create a calculated field
Orders Database
1 West_profit = IF [Region] = 'West' THEN [Profit] END
2. Westprofit_Per= SUM([West_profit])/SUM([Profit])
Waffle data base
3. West Region Profit percentage = Orders (Sample - Superstore)].[Westprofit_Per]>SUM([Percentage])
Step4: Place the calculated field West Region Profit percentage on colors and Westprofit_Pe on Details can see the change of colors. (in colors can change any color)
Step 5: Select the order dataset and center of waffle chart select right click Select Annotate – mark label and insert the west profit field.
Step 5: On the details select west profits as percentage format (%).
FINDING TOP (10) AND BOTTOM (10) IN THE SAME SHEET
To Finding Top and Bottom 10 without creating a parameter in the same sheet it's a question most of us encountered in interview the solution is very easy and simple first need to create calculated fields:
1. INDEX = is INDEX()
The index function simply counts rows but there's more to it than meets the eye. The index function essentially counts rows in a dataset and it can be controlled we using a partition, a concept I cover in this video along with creative ways of using the index function to achieve interesting filtering results.
2. Last = Last()
the LAST() function returns a number indicating the distance in "rows" from the current "row" to the last "row" "in the partition" where each row is a mark created by the rows of query results that are generated by the dimensions in the view
3. Calculation1= INDEX()<= 10
OR
LAST()<=10 (Results are in Boolean)
Drag the customer names on row , sales on column and calculation on column by selecting descending can see the highest sales to lowest sales.
Keeping calculation1 field on filters self and selecting True vales
LOLIPOP CHART
A lollipop chart is a variation of a bar chart where the bar is replaced with a line and a dot at the end. Similarly to bar graphs, lollipop charts are used to make comparisons between different categories, as well as ranking or for showing trends over time. The most common use is when the bar charts have all similar heights and so the graph results in just a bit too much color. In this case, a lollipop chart would make for a more appealing data visualization.
Let us then see how to build step-by-step a lollipop chart on Tableau. Our goal is to create a graph showing sales and profits for each sales category from Sample Superstore data.
Step 1. Create the chart
Connect to the data source Orders – Superstore.
Drag the Subcategory on Column and Sales to Rows twice. This way you will get two separate Marks cards for Sales.
3. Select one chart sales as circles.
3. Right click on the second Sales tab in rows and select Dual axis also adjust the size of bar and circle shape look like lollipop.
Thank you.