Shiloh Classic

002 Working with Data Sets


Description
Shiloh’s Data Set Designer allows you to build queries used to provide data to other Shiloh modules such as a graph /chart/ map / pivot / gauge for use as a dashboard item, a Quick View, an Excel template report, for use in Shiloh Explorer, Forecasting, SSO Writer, and Store Fact Matrix. This is where you learn the power to truly leverage the capabilities of Shiloh. Anyone responsible for building or changing reports, Quick Views, Dashboards, or Data Sets for order writing, forecasting, or Store Fact Matrix will want to enroll in Working with Data Sets.

This course will take approximately two-and-a-half hours to complete.

Prerequisite: Shiloh Basic Training
Content
  • Building a Data Set The Basics (45 Min.)
  • Getting Started Working with Data Sets (12 min.)
  • Data Elements: Attributes & Measures (5 min.)
  • Terminology: Traited, Valid & Distinct (6 min.)
  • Data Set Builder Pane (25 min.)
  • Using Formulas and Calculations (18 min.)
  • Custom and System Groups (40 min.)
  • Copying, Saving, Importing and Saving a Data Set (10 min.)
  • Creating Summaries in Data Sets (10 min.)
  • Using Calendars (3 min.)
  • Pivot (5 min.)
  • Convert To (5 min.)
  • Tips for Working with Data Sets (5 min.)
  • Data Set Wizard - OPTIONAL (25 min.)
Completion rules
  • You must complete the units "Building a Data Set The Basics (45 Min.), Getting Started Working with Data Sets (12 min.), Data Elements: Attributes & Measures (5 min.), Terminology: Traited, Valid & Distinct (6 min.), Data Set Builder Pane (25 min.), Using Formulas and Calculations (18 min.), Custom and System Groups (40 min.), Copying, Saving, Importing and Saving a Data Set (10 min.), Creating Summaries in Data Sets (10 min.), Using Calendars (3 min.), Pivot (5 min.), Convert To (5 min.), Tips for Working with Data Sets (5 min.)"
  • Leads to a certification with a duration: Forever