atoolz

  Please download the dataset   Click for dataset You’ve been asked to create a text table that shows the average sales for each product within your company’s three departments across four sales regions. This will help users determine which region has the highest average sales for each product within each category and sub-category. Good luck! Build a text table showing Sales by Region , Category , and Sub-Category .  Drag Category from the Data pane to Rows and then expand it to show Sub-Category . Drag Region from the Data pane to Columns . Drag Sales from the Data pane and drop it over the Abc placeholders in the view Add subtotals and grand totals. Click the Analysis menu, point to Totals , and click Show Row Grand Totals . Click the Analysis menu, point to Totals , and click Show Column Grand Totals . Click the Analysis menu, point to Totals , and click Add All Subtotals . Change the aggregation for Sales to Average and the subtotal and grand total labe...

  Please download the dataset  Click for dataset You’ve been asked to create a view for your company that compares average sales with average marketing expenses, broken down by product type, state, and area code, to see if there is a relationship. Build a scatter plot to answer this question: What is the relationship between average marketing expenses and average sales? Good luck! Create a scatter plot that compares total Sales with total Marketing expenses. From the Data pane Drag Sales to Rows . Drag Marketing to Columns . To show a greater level of detail, add Product Type , State , and Area Code to the view. From the Data pane, drag the following fields to Detail on the Marks card: Product Type State Area Code To make it easier to interpret the data, change the colors of the marks based on Product Type . From the Marks card, drag Product Type to Color . Change the view so it displays the averages for both measures. Right-click the SUM(Marketing) field on Column...

  Please download the dataset Click for dataset You’re preparing a report for management. They want to see how the sales forecast compares to actual sales. In this hands-on-activity, build a combined axis chart to answer the question: How does Budget Sales compare to actual Sales over the last few years. Good luck! Create a line chart for Budget Sales over a continuous range of time, by month, using the Date field. Drag Budget Sales to Rows . Drag Date to Columns . Point to Date on Columns and click the down-arrow. Click Month   May 2015 . Make the chart dual axis using the Sales field. From the Data pane, drag Sales to Rows , to the right of Budget Sales . Point to Sales , click the down-arrow, and click Dual Axis . Change the Budget Sales line graph to a bar graph and change the color of the Budget Sales bars to light gray and the Sales line to green . Click the Marks card for Budget Sales .  Click the drop-down menu and click Bar .  Click the Marks c...