Are you ready to create a visually appealing and informative bar chart in Tableau? In this lesson, we will walk you through the process of building a bar chart that will provide valuable insights into the ratio between reviews left and the number of audiobook purchases for a given month. This key performance indicator (KPI) will help us understand whether audiobook buyers are leaving reviews. Let’s dive in!
Creating Calculated Fields
To begin, we need to create a few calculated fields. The first one we’ll create is called “Number of Ratings.” This field will count the number of ratings, rather than summing them up. By creating this field, we can easily use it in our analysis going forward.
Next, let’s change our data source to “Audiobook Sales.” Here, we will create a field called “Number of Purchases.” This field will contain the total number of audiobook sales made by the company. We can simply count the unique transaction ID code to obtain this information.
Lastly, we’ll create the calculated field for the ratio between reviews and purchases. Given that we have already created the “Number of Ratings” and “Number of Purchases” fields, this task is straightforward. We just need to divide the two figures to obtain the measure we want to plot.
Visualizing the Data
Now that we have our calculated fields, let’s add them to the rows of our visualization. The result is a visually appealing bar chart that provides meaningful insights. However, it may appear a bit too large. Don’t worry; we can easily adjust that.
Upon analyzing the chart, we notice that the ratio of ratings to new sales was significantly lower in November 2017 compared to the previous month, which was three times higher. This finding raises questions and demands further analysis by the company’s business intelligence team. Now, let’s quickly edit the title of the horizontal axis to “Month” for better clarity.
FAQs
Q: Can I create a bar chart in Tableau with multiple categories?
A: Yes, Tableau allows you to compare data across multiple categories by creating groups or hierarchies in your chart.
Q: How can I change the size of the bar chart in Tableau?
A: To adjust the size of the bar chart, you can simply drag the edges of the chart or use the sizing options in Tableau’s formatting toolbar.
Q: Can I export my Tableau bar chart as an image to use in presentations or reports?
A: Absolutely! Tableau provides various options to export your charts, including saving them as images or PDFs. Simply go to the “File” menu and select the “Export” option to choose your desired format.
Conclusion
Congratulations! You have successfully created a bar chart in Tableau to compare audiobook reviews and purchases. This visualization provides valuable insights into the ratio between these two metrics, allowing you to identify trends and patterns. Remember to save your work and stay tuned for our next lesson, where we will learn how to organize multiple charts into a dashboard. For more technology-related content, visit Techal.
