Oracle NetSuite launched the new SuiteAnalytics Workbooks solution in 2019.1 Release. This new solution provides users an intuitive, easy-to-use and consistent toolset to create, analyze and share business intelligence artifacts such as reports and charts mined from data maintained within your environment. Workbooks make it possible to investigate and visualize data natively within the NetSuite environment.
Benefits include identifying inter-dependencies and relationships in your business data, and reveals how changes over time impact your business. In the other words, it helps to illuminate the sources - or the “why” - that contribute to observable or predicted trends, helping to explain unexpected spikes or gaps. Workbooks also help users improve planning efforts by surfacing underlying data dependencies that may not be visible from higher level reports. This blog post,introduces and demonstrates the basics of SuiteAnalytics Workbooks with an example analytics task.
What is a Workbook and how should I build it?
You can think of a Workbook as your main user interface and data container where you define and visualize data analytics. Workbook consists of three main elements:
1) DataSet Builder
2) Pivot table creation tool
3) Charting and visualization
Workbooks also enable users to perform multi-level joins of record types without the need for deep data-model knowledge.
Creating a new Workbook is the starting point to interacting with NetSuite analytics functionality, You can enable SuiteAnalytics Workbooks in your account under Setup → Company → Enable Features: Analytics tab, "SuiteAnalytics Workbook". Once enabled, click the “Analytics” tab on your dashboard to create a new Workbook (or open saved one).
How can I use Workbook for investigative analytics?
Let’s look at an example of how Workbook empowers a Marketer.
As a marketing analyst, you have to analyze and report on which marketing campaigns have delivered the best quality leads for sales which is measured by the ratio of ‘closed won’ to ‘closed lost’ leads for a specific marketing source. You start by looking at the ratio of customers to prospects, then match the results with marketing campaign data.
Before Workbooks, getting data, analyzing it and getting insights would have been an arduous task likely requiring a data expert with a deep understanding of the record type data model who would then have to create multiple saved searches and reports and then export to spreadsheet for analysis.
With Workbooks it is a much simpler, intuitive and quicker process – selecting the right data and perform simple analysis.
You start by clicking on the “New Workbook” and select the main record type which is the “Customer” record. The customer record will provide you with the necessary data for your analysis. You can type-ahead to quickly find the record you need.
You now have the primary entity for analysis. On the next screen, you can get list of customers and all available properties. This is called the “Data” tab in the Workbook. You can use the search or simply browse the properties to find which property contains information about customer sales stage (lead, prospect, customer and closed-lost, closed-won). For your analysis, the best results are “Stage” and “Status”. You can select “Stage” and drag and drop it to the main Customer table allowing you to quickly validate the property content and decide whether to keep it or delete it from your data view.
At this stage, you have the customer name/id, sales status and stage which identifies “success” of the opportunity. You now need to find a property that would help you identify the marketing campaign which generated the lead. This is the “Lead Source” property associated with “Customer” record type. You can drag and drop it into the data view to see the values:
At this stage, it looks like a report in NetSuite where you can see rows with fields with all the required values. Without Workbooks functionality, you would have had to Export to Excel and continue the analysis in a spreadsheet. Workbooks includes the “Pivot” capability which will enable you to view how many closed-won vs. closed-lost you have for each marketing campaign/lead source. You click on the “Add Pivot" tab to start.
You are now in the main Workbook’s pivot interface and on the left-hand side you can see all the fields selected from in the “Data” tab in the previous step. The next step is quite intuitive – you use the Pivot User Interface and drag and drop the fields you want to see in columns and rows which you want to analyze. You start with “values” which is “Stage” because you want to see count of each stage per “Customer” and “Lead Source”. In rows you want to see all “Lead Sources” values and summarize the columns per “Stage” value and per “date created” – in this case the system automatically groups per year. Once the fields are added into the layout, you click on the “refresh” button to load the data. Here is an example report output:
You can quickly and easily view which campaign delivered the most customers and which campaign had biggest lead drop-off. You can also filter states by dragging and dropping items from fields into “add it as filter” drop zone. In this example, you will keep only customer-closed won, lead-dead, Prospect-Closed lost, Prospect-Purchasing values in the “Status” field.
You confirm that’s correct and hit the refresh button. The filter will appear on the top of the page.
To better visualize data, you can create a new chart by clicking on the “Add Chart” tab. The layout is like the “Pivot” interface. You now add “Lead Source” on the “x-axis” since to see summary from each “Status” per campaign. You then add “Status” into series (to be able to use series filtering to remove some from the chart) and finally add “Lead Source” as value which will summarize number of records per each campaign. You also change the type of the chart to the “Bar chart”. Here is the output:
The chart analyzes conversion of in-bound leads from all the campaigns in CRM and displays which campaign produced the best and the worst results. The entire operation took you about 5 minutes from start to finish using the Workbook with its pivot, charting and record-type selector capabilities. Workbooks can be saved and opened again with the entire content. You can add multiple pivots and charts into a single Workbook, but they all must use the same record type that’s defined in the first step of our example.