News about:

Data Analytics, Big Data, CRM, Data Warehouse & Data Integration

How to create a Timeline Pareto Chart in Tableau?

May 14, 2021

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.

Multiple Select Parameters in Tableau btProvider Silver Partner

How to create parameter actions that drive the selection of more than one parameter – Skill Pill Video

May 7, 2021

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.

Customer Success Story: Superbet chooses Tableau and btProvider to implement a data-driven culture

April 27, 2021

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!

Stream Chart Tableau Software btProvider

How to create a Stream Chart with a flowing shape in Tableau -Skill Pill Video

April 23, 2021

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.

Swap views with parameters Tableau btProvider

How to swap views with parameters in Tableau – Skill Pill Video

April 16, 2021

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.

btProvider initiatives and academic partnerships with the Romanian university environment – Innovation and performance for education!

April 12, 2021

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.

Cycle Plot in Tableau btProvider

Cycle Plot and how to identify trends according to seasonality in Tableau – Skill Pill Video

April 9, 2021

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.

Tableau 2021.1

See what’s new in Tableau 2021.1

April 5, 2021

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.

Sort sheets using multiple measures in Tableau btProvider Partner

How to sort multiple sheets using different measures in Tableau – Skill Pill Video

April 2, 2021

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 tableau software btprovider

How to use Dynamic Measures with multiple number formats in Tableau.– Skill Pill Video

March 26, 2021

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.

kpis next to bars tableau btprovider

A new way for displaying KPIs next to Bars in Tableau – Skill Pill Video

March 19, 2021

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.

connected scatter plots tableau

How to create Connected Scatter Plots in Tableau – Skill Pill Video

March 12, 2021

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.

btProvidr Next Consult Romania

Next Consult SCE becomes official Salesforce Reseller for Romania

March 8, 2021

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 plot tableau software btprovider

How to create a Dot Matrix Plot in Tableau Software – Skill Pill Friday

March 5, 2021

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 Software btProvider

How to add Transparent Worksheets to your dashboards in Tableau – Skill Pill Video

February 26, 2021

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.

dynamic trellis chart tableau software

Dynamic Trellis Chart: How to compare a single measure across multiple different dimensions in Tableau – Skill Pill Video

February 19, 2021

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.

deviation icicle chart tableau btprovider

How to compare your progress towards the target in Tableau using a Deviation Icicle chart?

February 12, 2021

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.

Change date level using a parameter in Tableau btProvider

How to change date level in Tableau using a parameter – Skill Pill Video

February 5, 2021

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 in Tableau Software

Pearson Correlation Coefficient – How to find it in Tableau Software – Skill Pill Video

January 29, 2021

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.

How to use data to adapt in an ever-changing market

January 27, 2021

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.

Enhance Tables in Tableau Software btProvider

How to enhance your Tables in Tableau Software – Skill Pill Video

January 22, 2021

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.

podium bar chart tableau software btprovider

How to analyze KPIs’ positions or hierarchies in Tableau with a Podium Bar Chart – Skill Pill Video

January 15, 2021

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 Software btProvider

How to add Dynamic Titles in Tableau Software – Skill Pill Video

January 8, 2021

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 tableau software

How to calculate distance between two points on a map in Tableau Software – Skill Pill Video

December 18, 2020

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 btProvider

What’s new in Tableau 2020.4

December 16, 2020

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 palette tableau software

How to add custom color palette in Tableau Software – Skill Pill Video

December 11, 2020

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 tableau software btprovider

How to use Top N% Filter in Tableau Software – Skill Pill Video

December 4, 2020

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 tableau software btprovider

How to use a Dynamic Drop-Down Menu in your visualization in Tableau Software – Skill Pill Video

November 27, 2020

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.

Detailed Histogram in Tableau Software btProvider

How to build a Detailed Histogram in Tableau Software – Skill Pill Video

November 20, 2020

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 in Tableau Software btProvider

How to analyze KPIs using Sparklines in Tableau Software – Skill Pill Video

November 13, 2020

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.

Halloween Costume Contest 2020 – btProvider

November 12, 2020

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 in Tableau Software

How to create Drill Down Tables with Parameter Actions in Tableau – Skill Pill Video

November 6, 2020

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 in Tableau btProvider

Trellis Chart: How to analyze dimensions with a big number of values in Tableau – Skill Pill Video

October 30, 2020

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?

How to display continuous week or day level data for multiple years in Tableau Software – Skill Pill Video

October 23, 2020

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.

Display variances between dates in Tableau btProvider

How to display the variances between dates in Tableau Software – Skill Pill Video

October 16, 2020

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 Tableau btProvider

How to create a Bullet Graph in Tableau Software – Skill Pill Video

October 9, 2020

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.

Candlestick Chart in Tableau

How to analyze stock prices using Candlestick chart in Tableau – Skill Pill Video

October 2, 2020

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 […]

Animations in Tableau

Create Parameters with Animations in Tableau Software – Skill Pill Video

September 25, 2020

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 […]

Scatter Plot in Tableau - btProvider

How to add interactivity in a Scatter Plot visualization in Tableau – Skill Pill Video

September 18, 2020

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 […]

Combine two bar types in one chart Tableau

How to combine two bar types in one chart in Tableau Software – Skill Pill Video

September 11, 2020

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 […]

Drop Lines in Tableau Desktop btProvider

How to add more interactivity in your view using Drop Lines in Tableau – Skill Pill Friday

September 4, 2020

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 […]

Top N or Bottom N in Tableau

How to track your KPIs using Top N or Bottom N chart in Tableau – Skill Pill Video

August 28, 2020

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 […]

Trend Lines in Tableau Software

How to add Trend Lines in Tableau – Skill Pill Video

August 21, 2020

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 […]

Forescast in Tableau Software

Forecast in Tableau: How to predict future trends in the business environment? – Skill Pill Video

August 13, 2020

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 […]

Grand Total and Subtotals in Tableau

How to use Grand Total and Subtotals in Tableau – Skill Pill Video

August 7, 2020

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 […]

Colour Scale a Map using Set Actions in Tableau

How to customize a map using Colour Scale and Set Actions in Tableau Software – Skill Pill Video

July 31, 2020

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 […]

Show Hide Expand Hierarchy Labels Tableau Software btProvider

How to use Show / Hide Expand Hierarchy Labels in Tableau – Skill Pill Video

July 24, 2020

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 […]

Measure Names and Measure Values in Tableau Software

How to add Measure Names and Measure Values in Tableau Software – Skill Pill Video

July 17, 2020

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 […]

Unit Chart Tableau Software

How to create a Unit Chart in Tableau Software– Skill Pill Video

July 10, 2020

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 […]

Percent of Total in Tableau Software

How to calculate Percent of Total in Viz in Tooltip for a category, in Tableau Software? – Skill Pill Video

July 3, 2020

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 […]

Dynamic Reference Lines in Tableau Software

Why and when are we using Dynamic Reference Lines in Tableau Software – Skill Pill Video

June 26, 2020

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 […]