342 exam 3 pt 2 study guide PDF

Preview

Summary

notes for the second part of 342 exam 3 - Tableau...

Description

Drag measures or dimensions to either side to change them to a dimension or measure. Change data type by right clicking on a field and select data type. Currency format: right click the field, default properties, number format, standard. Dimensions = rows, measures = columns Drag measure names over a vis to give a section a name, right click, edit alias. Total # of sales: sales invoice ID – count distinct Analytics: totals, choose either row or column based on what you want to total

•

Show Customers by Country –

•

How many Customers per Country?

•

What are the Sales Discounts, Gross Sales, Net Sales and Number of Sales by Customer Country?

•

Show gross sales by country as a Pie chart.

•

How many different Employee Titles are there and how many employees per title category (shown as a bar chart)?

•

How many different Employees per Employee Title by City (shown as a highlight table)?

•

What are the Gross and Net Sales $ and Discounts $ by Employee title (shown as a side by side bar graph)?

•

What are the freight charges by postal code to which each sale is shipped (rather than billed)?

•

What is the total net Sales per Product (show name and ID)? By product category?

•

What are the Net Sales by month (as a continuous line)?

•

•

What was each Employee’s discount total and count of sales in 2017 only (by Employee name)?

•

Show the net totals for all sales during each day in January 2016. Create a Line graphs and map time along the X axis (Columns input in Tableau) and amounts along the Y axis (Rows input in Tableau)

•

How many products are discontinued? Not discontinued?

•

How many of each discontinued product name does this company have on hand and how many are on order (shown as packed bubbles)?...