Data Analytics, Big Data, CRM, Data Warehouse & Data Integration
Negative Space Bar Charts are perfect to use when you want to add some color to your dashboards or create an impressive cover for a presentation.
Data will always have a story to tell, that’s why it is essential to understand its unique language and use the right tool. Learn how to create a Sunburst Graph in Tableau.
If rankings are your top priority right now and you need to communicate the changes between them, then creating a Bump Chart is the best solution.
Do you need a possibility to visualize parameters from different years and to compare their evolution? A quick solution, but also creative and easy to execute is to make a combination between a Bar Chart and Candlestick Chart.
If you want to compare the data from your sheets, but you have too many categories displayed and you need a single view, then the solution will be to split a long bar chart into smaller bar charts. Tableau can help you see the bigger picture of your listed information, more simply.
In any business, especially in the sales departments, it is important to periodically follow the numbers and the sales results to make comparisons with the past events and also to be able to make predictions for the future. All these enable specialists to build more realistic strategies, and set more powerful objectives for the following periods and projects.
In Tableau, we use parameters when we are not sure which value we want to display or when we need to create a value that is not normally found in our dataset. And while most data analysis tools allow you to build graphs and reports using only static values, Tableau offers users countless opportunities to add interactivity to the data and to the way it is displayed in final analysis. In today’s post we will discuss ways to create multiple select parameters in Tableau and we will see how we can apply these methods in our analysis.
The Best Sports betting Operator in Central and Eastern Europe! The only Romanian company part of the Top 30 gambling companies worldwide! Over 1000 betting shops across Romania and Poland. This is Superbet in Romania – the market leader in the Betting & Gaming industry and the company with the most noticeable growth in Central and Eastern Europe. Superbet is on a mission to excite the world!
A Stream Chart is frequently used when we want to observe the evolution of volumes in our data, from several categories. This chart is built around an axis, so that displaying volumes and their evolution will be made above or below the axis. To better understand how a Stream Chart works, we can imagine that we want to see how sales have evolved over a period in certain regions. Another example that we can consider can be given by analyzing the number of orders, in a period, on a certain segment of customers.
Tableau features always allow us to display in a dashboard or in a graph the information we need. As we have shown many times in our posts, Tableau gives its users the flexibility they need to explore and visualize data in different ways. In today’s post we will show you how you can swap views with parameters in the same dashboard. We’ll see how we can explore data at different levels in the same view.
Students from Faculty of Economics and Business Administration – Hungarian Institute at Babes-Bolyai University in Cluj-Napoca joined multiple hands-on seminars held by btProvider consultants for Digital Marketing and Sales Management and Promotion programs.
A Cycle Plot is used when we want to visualize how a trend, or a cycle correlated with the day-of-the-week or the month-of-the-year evolved. A Cycle Plot is made to capture visually how certain values have advanced over a period. This type of chart is especially useful for identifying certain intervals or periods in which the best results are recorded. For example, we will use a Cycle Plot if we need to know which were the most profitable time slots on Fridays, Saturdays, and Sundays, when our store had the highest number of visitors.
The first version released by Tableau this year is here! Tableau 2020.1 brings users new features designed to help us explore and make decisions based on accurate data, in a faster way. With the acquisition of Tableau by Salesforce, users from all over the world have been looking forward to the integrations and new features that will bring the two great products even closer.
Sorting multiple sheets using different measures may seem simple, but at the same time complex. It all depends on how we want to build the visualization and the features we use. In this case, the best way to sort different measures is to use parameters and a single calculated field. The final view gives us the opportunity to select how we want to sort or classify certain dimensions, depending on the measures or values that interest us and that are significant to us.
Dynamic measures are often used in Tableau in cases where we want to visualize a certain size depending on other measures. For example, we can analyze product categories according to sales, profit or other measures that interest us. In order not to build every time another graph or dashboard in which to visualize the dimensions according to several measures, we can use dynamic measures built with the help of a parameter.
Who doesn’t have KPIs for their business? Is there anyone who doesn’t look at his KPIs on a daily basis? I do not think it’s possible. KPIs are most likely among the first things that come to mind when we think about data analysis. And that’s just because, in one form or another, there is no activity within an organization that does not require tracking KPIs and targets. In today’s post we will discuss how to display KPIs next to bars in Tableau Desktop.
A connected scatter plot allows us to visualize more easily the path followed by dots or bubbles. This path starts from the first value of a measure or other KPI and ends at its last value. A connected scatter plot helps us to easily identify several values, trends or outliers depending on the order in which they were recorded.
Romania Bucharest, 8 March 2021 Next Consult SCE becomes official salesforce.com Reseller for Romania. At the same time, btProvider, a recognized company in the field of Data Analytics and Big Data announces a joint venture with Next Consult through the […]
Dot Matrix Pot is a chart that helps us observe and visualize the frequency of certain data. Specifically, a Dot Matrix Pot provides an overview of how data is distributed or divided according to a certain dimension. These types of graphs practically divide data into two or more categories, grouping them in a matrix.
Transparent worksheets in Tableau can be applied to worksheets in dashboards. The most important thing to remember is that these transparent worksheets allow users to add different layers, one on top of the other, such as: graphics over a certain image, graphics over a map or graphics over graphics. Basically, this feature offers more freedom to users in terms of designing graphs or analyzes with a higher impact.
If you would like to find out how to create a trellis chart, but also other information about this type of graphic, you can find out more here. Basically, a trellis chart is a group of smaller charts placed in the same view. You can often find it under the name “Small Multiples”. In a trellis chart we notice a repetition of graphs on a grid. A dynamic trellis chart is identical to what we mentioned before, the difference being given by certain parameters built to add interactivity to the final view.
A deviation Icicle chart is often used to analyze actual values (achieved performance) in relation to expected values (set targets). This type of chart is useful when we want to identify and visualize how high or low the current values are, compared to those expected. A deviation Icicle chart helps us extract more perspectives on progress and performance, as opposed to a bullet chart or a simple bar chart with reference lines. Often reference lines or a divergent line / bar chart make it difficult for important information, such as periods when current values were above or below the target, to be observed.
We need a dynamic method by which we can change date level. From years to months, from months to weeks or from weeks to days. We need a quick method that allows us to change date level depending on the level of data we want to analyze. The ability to create a parameter in Tableau that allows us to change date level is one of the most dynamic options to compare performance at level of weeks, days, months, etc. Second, it offers more flexibility to end user in terms of date granularity and the time on which it will explore his data.
Pearson correlation coefficient is often used to measure statistical relationship and association between certain data. The result offered by this coefficient can be negative or positive. When Pearson correlation coefficient has a positive value, it means that each increase of one of the analyzed variables is also an increase of the other correlated variable. A negative value tells us that each increase of one variable, is a decrease of the other. Calculating Pearson correlation coefficient can be done in Tableau Software, and below we will show you how.
COVID-19 has dramatically changed the way we work. It is more critical than ever for leaders to put data at the center of their decision-making—for internal decisions that affect employees and external decisions that propel their business forward.
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 […]