atoolz

  Please download the dataset   Click for dataset You’re looking at your organization’s sales data, and you want to see the relative contribution of each product category and region to your total sales. To determine this, you’ll build a tree map. Good luck! Build a tree map showing Sales of each Category in each Region . From the Data pane: Drag Sales to Size on the Marks card. Drag Region to Color on the Marks card.  Drag Category to Detail on the Marks card.  If a tree map is not displayed, change the mark type to Automatic or Square .  Label your tree map with Sales , Category , and Region . From the Data pane: Drag Category to Label on the Marks card.  Drag Sales to Label on the Marks card. Drag Region to Label on the Marks card. Great work! You’ve built a tree map to compare the relative contribution of Regions and Categories for each Region to Sales . 

  Please download the dataset   Click for dataset You have sales data that you want to present using two pie charts, one showing sales by customer segment and one showing sales by region. Use two different methods to create your charts. Good luck! Create a pie chart that shows the four customer segments, and set it to fit the entire view. On the Marks card, click the drop-down list of marks and choose Pie . From the Data pane, drag Customer Segment to Color on the Marks card. On the toolbar, click the Fit drop-down menu, and change it to Entire View . Modify the pie chart to show a sales breakdown, and add labels to show sales totals. From the Data pane, drag Sales to Angle on the Marks card. From the Data pane, drag Sales to Label on the Marks card. Name the worksheet “Sales by Segment”, and create a second worksheet, titled “Sales by Region”. Double-click the worksheet tab, type Sales by Segment , and press Enter .  Next to the Sales by Segment tab, click...

  Please download the dataset   Click for dataset You've been asked to create a view for colleagues to show them the highest and lowest profit sub-categories of products across different markets and regions. Build a highlight table that shows specific profit values in your data set, so that the patterns and extreme highs and lows in the data are easy to spot, helping your team make actionable business decisions about the company’s products. As a bonus, include totals in the highlight table to show which sub-categories were the most and least profitable overall.  Good luck! Create a text table that shows market and regional profits by Category and Sub-category . From the Data pane, drag Market and Region to Columns , with Region to the right of Market . From the Data pane, drag Category and Sub-Category to Rows , with Sub-category to the right of Category . From the Data pane, drag Profit to the view, and drop it when the area showing Abc text is highlighted in...