Business Intelligence
When you need to find information about your business, you have several tools available to you in NetSuite.
Workbook
Use SuiteAnalytics Workbook to create customized workbooks that combine datasets, tables, pivot tables, and charts using a single tool. With the SuiteAnalytics Workbook user interface, users with little knowledge of record schemas and query language can create complex workbooks and datasets with drag-and-drop editing. Workbook provides several options for formatting, filtering, and visualizing your data. For more information, see SuiteAnalytics Workbook Overview.
NetSuite Analytics Warehouse
With NetSuite Analytics Warehouse, you can go beyond what SuiteAnalytics Workbook offers and analyze your NetSuite data in new ways. Analytics Warehouse lets you analyze historical data from multiple sources to see how you can improve your business. You can blend your NetSuite data with data from other sources and analyze it with a wide range of visualizations. For more information, see NetSuite Analytics Warehouse Overview.
Dashboards
You can create unique dashboards to help your NetSuite users work efficiently. Dashboard content is shown in different portlets, or dynamic data display windows. Some portlets provide direct access to raw data, while others display critical business metrics, such as key performance indicators (KPIs), performance scorecards, trend graphs, chart-based workbooks, and report snapshots. You can also display data from website RSS feeds. For more information, see Dashboards Overview.
Searches
To find information in NetSuite, you can use a simple search to find instances of specific record types and filter the results by one or more field values.
If you or other users need to run the same search often, create a saved search. Saved searches support advanced search features such as formulas containing SQL expressions and joins to other records. You can search in the UI, or create searches with SuiteScript or SOAP web services.
For more information about performing searches, see the following topics:
-
N/search Module for SuiteScript 2.0
-
search for SOAP web services
Reports
NetSuite includes a variety of reporting capabilities to retrieve, present, and analyze real-time business results. You can run standard reports as is, or modify them by setting per-user preferences, selecting per-report viewing options, or defining custom reports in the Report Builder. For more information, see Reporting Overview and Working with Report Results.
Connect
If you want to use a third-party reporting tool, the SuiteAnalytics Connect Service provides a read-only method to get NetSuite data. Oracle NetSuite offers drivers so you can archive, analyze, and report on NetSuite data using a third-party tool or any custom-built application. The SuiteAnalytics Connect Browser lists all standard SuiteAnalytics Connect tables and columns, providing information about primary keys, foreign keys, and the related tables for the Netsuite.com data source. For more information, see SuiteAnalytics Connect and Working with the Connect Browser.