Category Archives for "Tableau"

Tableau Prep – The Cleaning Step, Group and Replace

Introduction Data is like blood flowing through an organization and, just like blood quality is directly linked with the health of the body, organizations only function effectively when the quality of their data meets the minimum quality standards. In real life, data that is used for visualization is typically sourced from a variety of different […]

Tableau Prep Tutorial

Use the tutorials below to help you gain a deeper understanding on what Tableau Prep can do for your data, business and overall visuals. Follow each step in the tutorial of jump around to the tutorial that fits your needs.  Getting Started with Tableau Prep Go to the Tutorial Tableau Prep is a great tool. […]

Tableau Prep – The Profile Pane and Pivot Step

Introduction and Significance Exploring data is probably one of the first things a data analyst would do when dealing with a new data set. It is important to understand the profile or the characteristics of the data before you start analyzing and visualizing it. Case Study For this article, let’s use a hypothetical case study […]

Getting Started with Tableau Prep

Many data scientists have heard the line – “People spend 80% of their time prepping data and only 20% of their time analyzing it.” And now, as an overload of data becomes available, dealing with untidy data becomes excessively difficult. Cleaning data is known as one of the most tedious jobs in a data scientist’s […]

The Tableau Prep Interface and the Input Step

Welcome back to the articles on Tableau Prep. Today we’ll be discussing the interface of Tableau, how to use it, and the Input step In Tableau. The Start Screen and Connecting to Data When we open Tableau, we begin on the start screen. At the far right, we have the discover pane, which shows education […]

Waffle Chart in Tableau

Definition: Waffle chart is a 10 X 10 cell grid in which each cell represents 1 percentage point summing up to total 100%. Waffle charts can be represented with conditional formatting where cells are  highlighted with different colors based on the percentage value of that KPI. There are following used cases of Waffles chart: To […]

Pareto Chart in Tableau

Pareto chart is basically based on the theory of “80-20” phenomena, where it means that 80% of the output is being generated by the 20% of the input. In terms of retail data, we can also say like this that 80% of revenue is from 20% of customers. Pareto chart is a combination of both […]

EXCLUDE – LOD Deep Dive in Tableau

EXCLUDE: “EXCLUDE” level of detail expression is used to omit specified dimensions from the aggregations. Using “EXCLUDE”, a user can omit the lower level granularity dimension which is present in the view and can directly calculate the value at a higher granularity level. Tableau Training and Certification at Edureka “EXCLUDE” level of detail expression is […]

INCLUDE – LOD Deep Dive in Tableau

INCLUDE: As the name suggests, “INCLUDE” level of detail expression compute aggregations considering dimensions which are specified in the calculation and also take into consideration those dimensions which are present in the view. “INCLUDE” level of detail expression is useful when the user wants to calculate values at the lower level of granularity and then […]

FIXED LOD Calculation – Deep Dive in Tableau

FIXED: “FIXED” level of detail expression aggregates the value only at the dimensions which are specified by the user in the calculation. “FIXED” expression does not take into consideration those dimensions in the view. The difference between FIXED and INCLUDE/EXCLUDE is unlike INCLUDE/EXCLUDE, FIXED calculations are not relative to the dimensions in view. Example: Requirement: […]

1 2 3 5