3121: Space Planning Level II

Course Type

  • Instructor Led

Duration

  • 2 days

Target Audience

  • All users of Space Planning

Course Description

This Level 2 class teaches you all about the analysis features in Space Planning. You will learn how to import sales data into your planograms using 2 different methods, and then build the appropriate tables (reports), charts, highlights, labels, status bar, layouts, and formulas to evaluate your productivity. Attend this class to learn the ins and out of Space Planning’s analysis options to maximize profitability for your company while learning more tips and tricks along the way!

Course Notes

  • 8 lessons

Lesson Details

3121-01: Introduction to the Performance Object

Lesson Objectives

  • Explain where the performance object fits into the object hierarchy
  • Identify the difference between product and performance data

Lesson Exercises

  • Calculate the Number of Facings
  • Calculate the Number of Facings in a Table
  • Search the Help File for Performance Fields
30 Minutes ILT
3121-02: Import Data from Clipboard or Text File

Lesson Objectives

  • View product and performance data fields
  • Reset financial and inventory data
  • Change the project or planogram movement period
  • Import product and/or performance data from Excel
  • Edit and save the product and performance data across planograms

Lesson Exercises

  • View Product or Performance Fields (One Product at a Time)
  • View Product or Performance Fields (All Products at Once)
  • Specify Product or Performance data for Analysis
  • Reset Financial or Inventory Data
  • Import Product or Performance Data
  • Save and Load Import Settings
  • Set Project or Planogram Movement Period
  • Edit and Save the Performance Across Planograms.pst and Rename Field
1 Hour 30 Minutes ILT
3121-03: Update Performance Data via a Performance Library

Lesson Objectives

  • Create a performance library using Excel
  • Reset financial data
  • Reset financial data
  • Set project movement period

Lesson Exercises

  • Define the Name in Excel
  • Create the Performance Library in Space Planning
  • Configure the Performance Library- General tab
  • Configure the Performance Library - Field Mapping tab
  • Save the Performance Library
  • Reset Financial/Inventory Data
  • Set Project Movement Period
  • Update a Project from the Performance Library
2 Hours ILT
3121-04: View, Edit, and Analyze Data with Tables

Lesson Objectives

  • Create new tables to meet analysis needs
  • Edit existing tables to meet analysis needs
  • Edit Space Planning data via a table
  • Export table data to Excel
  • Customize the Open Table drop-down menu

Lesson Exercises

  • Edit Project Data via a Table
  • Indicate Table Cell Selection in Planogram Views Understanding the Space Planning Objects
  • Create a New Table
  • Add Rows and Columns
  • Create a Comparison Table
  • Edit Column Widths and Decimal Places
  • Add a Grand Total Row
  • Change Data Roll up and Alignment
  • Create Formulas in a Table
  • Change Column Headers
  • Change Data to Percentage
  • Utilize User Names
  • Add Extra Header Rows/Freeze Rows and Columns
  • Save a Table
  • Change Data Scope
  • Filter Table Data
  • Sort Table Record Data
  • Rename the Table and Save
  • Hide Rows & Columns
  • Adding a Subtotal Row
  • Changing Row Colors
  • Sorting the Table Sub-Total Data Exporting Table Data to Excel
  • Customizing the Table (Analysis) Menu
4 Hours ILT
3121-05: View and Analyze Data with Charts

Lesson Objectives

  • Create new charts to meet analysts needs
  • Edit existing charts to meet analysis needs
  • Describe different chart elements and formatting options
  • Export chart data to Excel and save picture of the chart
  • Customize the Open Chart drop-down menu

Lesson Exercises

  • Create a New Chart
  • Chart Type
  • Selecting the Chart Object, Chart Key, and Chart Data
  • Group by Key and Change Data Scope
  • Convert Data to a Percentage
  • Save a Chart
  • View/Export Chart Data
  • Edit a Chart
  • Show Top Groups Only and Sort Data
  • Customize Chart (Analysis) Menu
  • Save Picture
1 Hour 30 Minutes ILT
3121-06: View and Analyze Data with Highlights

Lesson Objectives

  • Create new highlights to meet analysis needs
  • Edit existing highlights to meet analysis needs
  • Describe the different highlight methods
  • Apply highlights to a table
  • Customize the Open Highlight drop-down menu

Lesson Exercises

  • Open a Highlight
  • Access the Highlight Properties
  • Edit an Existing Highlight: Group Method
  • Save a Highlight
  • Toggle a Highlight On/Off
  • Apply Highlight to All Opened Projects
  • Assign Colors and Names
  • Edit an Existing Highlight: Match with Filter Method
  • Apply Highlight Within Planogram, Project or All (Open) Projects
  • Edit an Existing Highlight- Spectrum Method (Heat Mapping)
  • Apply Filter to Other Methods
  • Edit an Existing Highlight- Quadrant Method
  • Load a Highlight to a Table
  • Customize Highlight (Analysis) Menu Review Questions
2 Hours 30 Minutes ILT
3121-07: View Data with Labels and Status Bar

Lesson Objectives

  • Create new labels from scratch to meet analysis needs
  • Copy and edit labels
  • Apply additional formula functions
  • Save or merge label files to share and refer in print layouts
  • Customize the Open Label drop-down
  • Edit the Status Bar

Lesson Exercises

  • Create and Show a Label
  • Toggle a Label On/Off
  • Save Selected Label Formats to a New Label File
  • Save All Label Formats to a New Label File
  • Copy Format to Create a Label
  • Open and Merge Label Files
  • Customize Highlight (Analysis) Menu
  • Edit the Status Bar Properties
1 Hour 30 Minutes ILT
3121-08: Create Print Layouts for Tables, Charts, Highlights, and Labels

Lesson Objectives

  • Create a print layout
  • Add tables, charts, highlights, and labels to a print layout
  • Assign print layouts to various JDA Space Planning objects
  • Edit default printing options

Lesson Exercises

  • Create a New Layout
  • Split the Layout Page
  • Specify Layout Area Types and Properties
  • Copy a Layout Page
  • Add a Table to a Layout Page
  • Add a Chart to a Layout Page
  • Add a Label to a Layout Page
  • Add a Highlight to a Layout Page
  • Preview a Layout
  • Save a Print Layout
  • Assign Layout Files
  • Print a PDF
2 Hours 30 Minutes ILT