BUS 310 3/24/25

Opening the Worksheet

• Start with the colored orange icon at the bottom left to create a new worksheet.

• Name the worksheet ‘Group and Sets’.

Setting Up Hierarchy

• Identify different datasets.

  • Look at categories and subcategories; drag subcategory on top of category for hierarchy.

  • Name can remain as category or subcategory.

• Drag the category into the rows section for display of sales categories like furniture, office supplies, technology.

Grouping Items

• Example: Combine chairs and tables.

  • Hover over the subcategory and select 'create group'.

  • Drag 'tables' into the group of 'chairs'.

• The group will show as ‘Chairs and Tables’ and can be renamed if desired.

Creating Sets

• Instead of categories, create a set for specific items, e.g., items starting with the letter 'A'.

  • Click on down arrow, create set, select relevant items, and name appropriately.

• Place the new set between categories and groups in hierarchy.

Analyzing Data

• To analyze sales and profits, locate sales data and drag into columns to visualize sales bars.

• To enhance visibility, drag the sales data to the 'labels' section for detailed amounts on the bars.

• Add profit data to the color marks card to highlight profit levels: darker colors for higher profits.

Showing Set Data

• Show set through the analytics options to filter and focus on specific profitable items.

• Adjust visualization based on the performance of selected items.

Creating New Worksheet for Analysis

• Establish a new worksheet for exploring profit across different states.

• Drag 'profit' into columns and 'state' into rows to visualize profits.

Setting Parameters for Profit

• Create parameters for high and moderate profits.

• Use these parameters in calculated fields to classify profits based on profitability thresholds (e.g., $70,000 for high and $15,000 for moderate).

Calculated Fields for Enhanced Analysis

• Create a calculated field for determining profit status (highly profitable, moderately profitable, not so profitable) based on set parameters.

• Use conditional statements to classify profits.

Sorting and Organizing Data

• Utilize sorting features to arrange data either alphabetically or by values.

• Implement manual sorting as necessary to prioritize data presentation.

Using Analytics and Adding Average Lines

• Incorporate average lines in visualizations to showcase performance benchmarks.

Saving Work

• Reminder to save as TWBX to ensure that both visualizations and data are saved for sharing.

Creating Tables

• Move measure names into the columns to create detailed tables representing quantitative data for each category based on sales and profits.

Forecasting

• Discuss and demonstrate how to forecast sales over time using historical data from order dates.

• Utilize the analytics tab for forecasting sales trends and cyclic behavior.

Conclusion

• Remind students to start thinking about projects and work collaboratively in groups for upcoming class discussions.

• Engage with remaining questions before moving on to the next session.