Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Decision - Making Context: Understanding what happened in the past is an important first step in harnessing the power of business analytics. Descriptive analytics answers

Decision-Making Context: Understanding what happened in the past is an important first step in harnessing the power of business analytics. Descriptive analytics answers the questions "What happened?" and "What is happening?" As discussed in the text, the type of data determines the best type of visualizations. In this lab, we analyze proportional data, with proportion defined as the number of observations in one category divided by the grand total of all observations. Using proportions is one of the primary methods of summarizing categorical data. One way to visualize proportional data is a tree map, which uses size and color to show the proportional size of values.
Slinte is a fictional brewery that sells six different beers. It has recently expanded the distribution of its products from one state to nine states, and now its business has begun stabilizing after the expansion. With that stability comes a need for better analysis.
Assume Slinte has hired you to help management better understand the company's sales data and provide input for its strategic decisions. Management wants to know total sales revenue for the period as well as the proportion of total sales revenue for each beer. In this lab, you will create a tree map for Slinte using Tableau to break down total sales revenue per product sold by Slinte. The type of beer is categorical data.
When you import data into Tableau, it automatically assigns a data type (such as name, date, r number) to each field. As part of the ETL (extract, load, and transform) process, these data types need to be verified and changed if necessary. Based on the data type, Tableau assigns a role to the field: either a dimension or a measure.
Measures are numeric fields that can be used for mathematical calculations.
Dimensions are non-numeric and used to categorize data. Dimensions include fields identified as string (text), dates, and geographic data types.
To create a tree map in Tableau, the visualization needs at least one measure and one dimension.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Time Database Systems Architecture And Techniques

Authors: Kam-Yiu Lam ,Tei-Wei Kuo

1st Edition

1475784023, 978-1475784022

More Books

Students also viewed these Databases questions