NetSuite/SuiteAnalytics: Advanced Searches

SuiteAnalytics: Advanced Searches Certification Training 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.

SuiteAnalytics: Advanced Searches (16 Hours) Download Course Contents

Live Online Training
Group Training 750 Date On Request
1-on-1 Training (GTR) 850
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Buy Flexi For Only $99 (Online Training Re-imagined)

Course Modules

Module 1:
  • Expressions and Nested Expressions
  • Advanced Techniques with Searches
  • Embed HTML in Saved Searches
  • Add Formulas to a Search
Module 2:
  • 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
Download Course Contents

Request More Information

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?