SuiteAnalytics: Advanced Searches Course Overview

suiteAnalytics: Advanced Searches training course is designed to master NetSuite Saved Searches. In this training class, you will learn how to calculate and transform your search results so you can get the business intelligence you need to make your company even more successful. In this training class, you will also learn how to build searches using complex parenthetical expressions, add joins to access data, and use functions and summary types to format date and numeric values. You will also learn how to incorporate formulas and SQL functions to translate values, calculate dates and numbers, generate matrix-style output, format dates and numbers, render results with embedded HTML, apply complex criteria, and more.

Target Audience:

NetSuite administrator, super user, business analyst, or software developer responsible for data analysis and want to learn how to use saved searches more effectively.

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1:
  • Expressions and Nested Expressions
  • Advanced Techniques with Searches
  • Embed HTML in Saved Searches
  • Add Formulas to a Search
  • Making Formulas Dynamic
  • Dates, Numbers and CASE Statements
  • Embed HTML in Formulas
  • Formulas in Search Criteria
  • Complex Analytics
  • Training On Demand Appendix – Using ODBC within Searches
Live Online Training (Duration : 16 Hours) Fee On Request
Group Training Date On Request
1-on-1 Training
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 32 hours is too long. We can offer Comfort Track for 16 hours

Course Prerequisites
  • Basic Computer Knowledge.
  • Enhance my search criteria by incorporating parenthetical expressions?
  • Use ‘Main Line is False’ in searches?
  • Use joins in searches to access other data elements?
  • Change the sorting behavior of maximum and minimum search values?
  • Work with column labels by adding HTML tags and line breaks?
  • Perform basic computations between two or more NetSuite fields?
  • Return list/record fields as hyperlinks to easily navigate to other records via the search results?
  • Make best use of many Oracle SQL functions: CASE, DECODE, TO_CHAR, UPPER, INSTR, SUBSTR, TO_NUMBER, NVL, NULLIF, ROUND, FLOOR, LAST_DAY, ADD_MONTHS, REGEXP_LIKE, RANK, DENSE_RANK, COUNT, AVG, MEDIAN, and others?

Request More Information

Add Name and Email Address of participant (If different from you)