<br />
<b>Warning</b>:  Undefined array key "HTTP_X_WP_TEMPORARY" in <b>/data/0/3/0307764f-852e-4456-9a8c-0bee8b8610da/visualization.sk/sub/blog/wp-config.php</b> on line <b>68</b><br />
<br />
<b>Warning</b>:  Undefined array key "HTTP_X_WP_TEMPORARY" in <b>/data/0/3/0307764f-852e-4456-9a8c-0bee8b8610da/visualization.sk/sub/blog/wp-config.php</b> on line <b>69</b><br />
{"id":71,"date":"2021-02-28T11:13:43","date_gmt":"2021-02-28T11:13:43","guid":{"rendered":"https:\/\/blog.visualization.sk\/?p=71"},"modified":"2021-02-28T11:33:15","modified_gmt":"2021-02-28T11:33:15","slug":"tableau-overview-of-theory","status":"publish","type":"post","link":"https:\/\/blog.visualization.sk\/?p=71","title":{"rendered":"Tableau &#8211; Overview of Theory"},"content":{"rendered":"\n<p>Tableau is data visualization tool used in the business intelligence industry. <\/p>\n\n\n\n<h2>Basic concept <\/h2>\n\n\n\n<p>Tableau has these data types: number, string, geographic, date, date time, boolean. <\/p>\n\n\n\n<p><strong>Dimensions <\/strong>are a qualitative fields that describe categories of data. Independent values. The pane is created when you have multiple dimensions in a row or column. <\/p>\n\n\n\n<p><strong>Measures <\/strong>are a quantitative or numerical fields, that measure categories of data. Dependent values. <\/p>\n\n\n\n<p><strong>Measure Name <\/strong>is a dimension, that contains a label for each measure in the data source. <\/p>\n\n\n\n<p><strong>Measure Value <\/strong>is a measure that contains numerical values of each measure in the data source. <\/p>\n\n\n\n<p><strong>Latitude and Longitude <\/strong>are generated geo fields, and it is generated when data source contains geographic fields. <\/p>\n\n\n\n<p> <strong>Discrete fields <\/strong>&#8211; create headers\/labels, can be sorted, always represented in blue color. <\/p>\n\n\n\n<p><strong>Continuous fields <\/strong>&#8211; create axis, can&#8217;t be sorted, always represented in green color. <\/p>\n\n\n\n<p><strong>Aggregation <\/strong>&#8211; <strong>measures <\/strong>are aggregated by default, default aggregation is sum. Measures can have following aggregations: sum, average, median, count, count distinct, minimum, maximum, percentile, std.dev, std.dev (pop.), variance, variance (pop.). <\/p>\n\n\n\n<p><strong>Aggregation and granuality <\/strong>&#8211; <strong>dimensions <\/strong>break down the aggregated total into smaller totals by category. Dimension provides the granuality in a chart. <\/p>\n\n\n\n<p><strong>Aggregating the dimensions &#8211; <\/strong>minimum, maximum, count, count distinct. When you aggregate a dimension, it is created a new temporary measure column. <\/p>\n\n\n\n<p><strong>Ratio<\/strong> <strong>calculations <\/strong>for example &#8211; <strong>sum(profit)\/sum(sales)<\/strong> sums the profits and sales to whatever the granuality of the view is, and then compoutes the ratio at that aggregation.<strong> Profit\/Sales<\/strong> computes the profit ratio at the lowest level of granuality then sums the ratios to the requested aggregation of the view. <\/p>\n\n\n\n<h2>Basic Chart Types <\/h2>\n\n\n\n<p><strong>Bar chart &#8211; <\/strong>compare data across categories. Example &#8211; sales across different products. <\/p>\n\n\n\n<p><strong>Line Chart <\/strong>&#8211; shows trends in data over time. Example &#8211; Profit between 2012-2014 as per the order date. <\/p>\n\n\n\n<p><strong>Scatterplot <\/strong>&#8211; demonstrate the relationship between measures. Example- relationship between profit and sales. <\/p>\n\n\n\n<p><strong>Maps <\/strong>&#8211; two maps types &#8211; symbol maps and filled maps. The symbol maps use the symbols to represent a central point of a geographic region whereas in filled pam boundaries of a geographic region is filled with a color. <\/p>\n\n\n\n<p><strong>Combined Axis Chart &#8211; <\/strong>is created with one shared axis (X-axis) and two separete axes (Y-axes). Placing measures on the same axis allows you to build a view that compare these measures using one chart. <\/p>\n\n\n\n<p><strong>Dual Axis Chart &#8211; <\/strong>compars multiple measures in a graph. Dual axes are two independent axes. <\/p>\n\n\n\n<p><strong>Stacked Bar &#8211; <\/strong>is the bar chart with segmented bars. <\/p>\n\n\n\n<p><strong>Crosstab, Highlight table <\/strong>&#8211; crosstabs are also known as Text tables. A highlight table encodes a measure on Text and color on Marks card. <\/p>\n\n\n\n<p><strong>Histogram <\/strong>&#8211; shows the frequency of distribution. It displays the shape of the distribution. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tableau is data visualization tool used in the business intelligence industry. Basic concept Tableau has these data types: number, string, geographic, date, date time, boolean. Dimensions are a qualitative fields that describe categories of data. Independent values. The pane is created when you have multiple dimensions in a row or column. Measures are a quantitative [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[6],"_links":{"self":[{"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=\/wp\/v2\/posts\/71"}],"collection":[{"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=71"}],"version-history":[{"count":5,"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":76,"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions\/76"}],"wp:attachment":[{"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.visualization.sk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}