Data Analytics, Big Data, CRM, Data Warehouse & Data Integration
One of the most common methods to enhance tables in Tableau is to highlight columns or rows. People usually choose for tables because they quickly display the information they need. But given that Tableau is not a classic tool for data analytics, but more for visualizing and exploring them, a table cannot be built simply by dragging and dropping dimensions and measures on rows and columns. Therefore, to build a visual experience on our analysis, we can improve tables by highlighting important data.
Ordering and grouping data is an essential element in every analysis. In order to understand different models, patterns or behaviors present in our data, we must identify the most appropriate way to represent them. Podium Bar chart is most often applied in cases where we need to analyze which were the most profitable products, the most productive employees or which are the categories that recorded the highest sales.
Dynamic titles in Tableau are a useful way to display in any analysis or dashboard what information we are currently viewing. Dynamic titles also have the role of providing clarity in our views and helping us to segment information visually. Basically, what dynamic titles do is customize what the end user sees. Thus, it will always know what information is displayed and what filters are applied.
Calculate distance in Tableau is a very useful starting point for departments that deal with optimizing routes for agents. Moreover, this type of calculation is used in geospatial analyzes to indicate the distances between several points and to make decisions regarding the costs necessary to cover them. Also, distance calculation in Tableau can be used in analyzes to determine the profitability, which is always closely related to the costs of our organization.
Tableau 2020.4 brings us many new features to help us capitalize on our data. With each new release, we as Tableau users enjoy new methods of scaling and improving our analytics. In the end, we can only say that data analysis with Tableau is more and more intuitive, helping us to ask the questions that matter, in the key moments of our organizations.
Custom color palettes are easy to create and are a good option to highlight the information we need. Also, custom color palettes represent an option of personalizing our analyzes considering the brand of our organization. Last but not least, they offer a visual experience as close as possible to what for the end user is a routine.
Top N% filter is a feature available in Tableau that allows users to filter and display a certain percentage of their data. To better understand how it works, let’s take an example. Suppose we want to display product categories and their sales value but showing only the first 75% of the recorded values. Instead of crowding filter area in Tableau, we can add a Top N% filter to automatically display the first 25%, 50% or 75% of the values we have in our data set.
Dynamic drop-down menus have similar functionality to the classic drop-down menus that we all use in our analysis. The difference that the dynamic ones offer is to create a connection between the menus so that their values will change depending on our first selection. Thus, users can select in the first menu the parameter they want to highlight, and the following menus will have only the values specific to the first.
Histograms represent a bar chart that displays the distribution of values in a data set on an axis. Each bar of the graph represents the range of a value. The bars that form the chart are also called bins or buckets, and their height is given by the frequency of the analyzed values. The higher a bar, the higher the value in that range and vice versa.
Sparklines are usually small, concentrated graphics that offer no context when used alone. Being condensed graphs, they are always used next to certain texts or are grouped to provide context for analysis and to display trends. Displaying KPIs using sparklines is a very useful technique for quickly communicating trends or patterns.
This year we thought to celebrate Halloween a little bit different and we chose the digital path to enjoy a few hours full of cheerfulness. Each of us built his own costume and we started a wonderful online party. Each […]
Drill Down Tables with Parameter Actions allow users to explore data on multiple levels of detail, depending on what they are looking for. The role of parameters in an analysis or dashboard is to provide interactivity to end users in exploring the data and information they are looking for. The use of parameters also offers flexibility in choosing the data to be viewed, data that are not available in the analyzed set.
Trellis Chart is often known as “Small Multiples”. The name Small Multiples comes from the fact that this type of analysis is represented by a group of graphs or small charts displayed in the same view. Small Multiples or Trellis Chart is actually a series of small charts along a grid. But what are the situations in which we choose to build it?
Displaying continuous week or day level data for multiple years is useful when we want to observe what was the evolution of sales or profit in a period that includes several years. This type of chart also helps end users understand how their business has operated over similar periods of time.
Displaying variances between dates adds ease in identifying our results when analyzing measures such as sales, profit or number of units sold. This type of graph helps end users to observe possible patterns or trends that occur in their data and that influence in one way or another the results of a certain period. At the same time, displaying variances between dates represents a starting point in identifying decisions that must be taken to achieve the set goals.
Bullet graph is a type of chart suitable for sales analysis, profit, or other measures. It is often used when we want to visualize measures value related to our goals, targets, or a past period. At the same time, the additional thresholds that can be added help end users to easily visualize where they are and the distance they still have to the set goal.
Tableau Software provides users with a wide variety of chart types and analyzes suitable for any sector or activity field. Regardless of the needs of users and the answers they are looking for, Tableau always offers solutions for visualizing and […]
When we talk about data analytics, we need to consider the information we have in our data set. All this information, and the data we have regarding our organization’s actions are often relevant in several situations or analyzes. Also, their […]
For retail, consumer goods or eCommerce companies, data analytics is a vital element. Profit margins, sales margins depending on product categories, inventory situation or number of customers are some of the metrics that must be followed for an in-depth analysis […]
For data analysts and business executives, dashboards, and data analyses must provide the information they need in a simple and concise manner. Their data and analysis should support organizations in making informed and well-argued decisions. Also, data should help companies […]
Data analysis has become in recent years one of the most advanced technological processes for identifying relevant conclusions in the information we have in our company. Data analysis and exploration have changed the way companies used the classic business intelligence […]
Today we all have access to data. Every day, data about our organization provides us with valuable information about our results, market trends or decisions that should be made in our company. KPIs, customer information or their behavior are just […]
Data analytics involves the process of exploring and visualizing data to extract meaningful information about organizations or any other type of data-generating actions. Most of the time, data analytics helps users in the decision-making process and correlation of existing and […]
Nowadays, data and information about our organizations are more and more common. Whether we are talking about data at the department level, group of employees or the entire organization, the data that all these groups generate is available at any […]
Data analysis helps us extract the information we need to make the right strategic decisions and to draw relevant conclusions about our actions. As always, we value our data and use the latest technologies for data processing and analysis. By […]
Any organization who wants to become a data driven company, must take decisions based on data. Data gives us confidence in our future actions, and enough arguments to support them. Our weekly skill pills articles are meant to encourage Tableau […]
Having access to data has recently become one of the most common requirements in organizations around the world. Data gives us real information about the activity of our company, but also answers to the most frequently asked questions such as […]
We often face different scenarios when it comes to data analysis. There are situations in which the volume of information is very large, and our analysis must include them all. The way we choose to display the data we are […]
For many of us, some of the analysis that can be created in Tableau Software may seem complicated or difficult to perform. As we have accustomed you every Friday through our Skill Pill article, we approach different types of analysis […]
Tableau Software is one of the most powerful tools when it comes to visualizing and understanding our data. Exploring and analyzing data gives us valuable information about our company, such as profit or sales evolution, marketing campaigns results or costs […]
In a previous article we discussed the importance of reference lines in Tableau and how they help users relate to situations in a particular dataset. As we said here, the reference lines are seen as horizontal or vertical lines located […]
There are times throughout the year when we need to keep up with the fluctuations of our organization in terms of sales or profits. For example, for companies from retail or eCommerce field, the winter holidays or Black Friday represent […]
Viewing and exploring data are among the most important tasks that company’s representatives should consider. We will not discuss here how important it is to analyze and understand data. At the end of each year, quarter or even month, companies […]
How can we visualize and understand the information that data provides us when we have the necessary tools to analyze it? But most importantly, how do we identify and build the right analytics to visualize the information we want? These […]
Analyzing data generated in an organization can be done in countless ways. But for visualizing data and transposing them in a form that is accessible and easy to understand, we need business intelligence tools. These must provide users all the […]
We always talk about how important our data is. In e period when companies are going through a transition in terms of work processes, data analysis provides support for making the right decisions. But often, the large volume of data […]
Today’s article is a little different from the ones we got used to every Friday. Today’s post we wanted to dedicate it to a special friend. In the following lines we invite you all to meet Timi 😊. Timi was […]
What we want to visualize, observe or analyze are the most common questions we ask ourselves when we are dealing with a set of data. Data provides the answer to absolutely any question related with the evolution of an organization […]
As a company, all the activities carried out in order to maximize and increase business profitability generate a huge volume of data. Data generated over time are analyzed and studied by each organization and department. This information have the role […]
Data is the most powerful information we need to take in consideration when we want to analyze the company’s evolution. Data-based information transpose into exact numbers the results obtained over time, whether we are talking about sales, profitability or costs. […]
We all know that the Roman Empire was one of the most powerful and greatest civilizations that existed in the history of our humanity. Throughout its existence, the Roman Empire subordinated its many territories which subsequently became national states in […]
We always want to have a centralized situation of data and information about our company. For example, depending on the field of activity and the areas in which the company operates, we’ll need analyzes that allows to see real-time information […]
When we think about developing a strong sales strategy, we need ways to visualize and process the company’s data, but also the environment in which we will carry out our activity. Any decision taken in order to expand the area […]
For companies whose field of activity is carried out in several locations around the globe or in several work points, a centralized analysis of all the data or their evolution over a period of time is required. Data analysts from […]
Tableau Software is one of the most appreciated data analysis tools in the world when we talk about an attractive and interactive way of visualizing our data. As a result, the data analysis created in Tableau Software helps users to […]
Large companies deals with a large volumes of information, coming from multiple data sources and data sets. To be able to visualize all data, the user should have at his disposal powerful analytical tools which provides the benefit of creating […]
On March 11, 2020 thee World Health Organization stepped forward and stated the situation generated by the new Covid 19 virus as a pandemic. The number of infection cases has increased considerably in the last period, especially in Europe, followed […]
In any organization expenses control represents a key factor for a proper functioning. Department managers and all those responsible with the company financial resources management and resources allocation, would want to have access at any time to the organization status […]
Having a tool for data and information display is a key resource for a company. Data accuracy and data analysis simplify the way in which strategic business decisions are made. We constantly need data analysis to quickly understand the trends […]
Change sort order with buttons in Tableau Software is helping every end user to easily sort ascending or descending attributes according to different criteria. Watch our video. In order to create a Highlight on Row and Column in Tableau, please follow these steps: […]
When we look at a chart there are certain elements that capture our eye, these are: Color Shape Position Length All these elements are easily recognizable by our brains because our eyes evolved to detect them in time and we […]