NetSuite Analytics Warehouse is a powerful tool that has revolutionized how your NetSuite data can be leveraged. In the modern business environment data is king and businesses need a reliable and efficient solution for managing it.
NetSuite Analytics Warehouse is a new platform that allows businesses to consolidate and analyze large amounts of data from both NetSuite and external sources. This provides valuable insights that can help them make more informed business decisions.
It allows businesses to store, manage, and analyze data from various sources in a single, unified platform. This allows them to quickly identify trends across comprehensive business data, track key performance indicators, and gain valuable insights into operations.
If your organization is using NetSuite and data is important to you then Analytics Warehouse is an absolutely essential tool.
Let’s take a look at why.
What is NetSuite Analytics Warehouse
The Analytics Warehouse is a data storage and analysis system that connects to NetSuite as well as a host of other common business systems.
It is one of the very few NetSuite products that sits outside the main system and requires its own login. Although this sounds like an immediate downside I think that in this scenario it makes a lot of sense.
The NetSuite Analytics Warehouse has a very particular target user – the data analyst. The architecture and interfaces of the system are geared more towards an analytical role; more so than any area of NetSuite. Keeping it separate to your general NetSuite instance allows it to operate in the most efficient way for its specific purpose. It also gives a platform for the functionality to shine through even when you are using it for third party (non NetSuite) system data.
Loading Data to NetSuite Analytics Warehouse
Before doing any analysis you first need to load your data. Although you can use the Analytics Warehouse for countless different data sources, it is ‘Built for NetSuite’. This means there are a few predefined functional areas (data groups) that you can sync up almost immediately.
It doesn’t, however, sync everything. This is a little disappointing and I hope in the future they expand the number of functional areas that are available as standard. In the mean time however you can still get the rest of your data synced by manually setting up the Oracle NetSuite connector.
Connectors are how you import data from third party sources. As well as Oracle NetSuite there are about 25 other pre built connectors to systems including Google Analytics, Shopify and Salesforce.
Lastly you can import static data via CSV. Loading CSV data is obviously less accurate over time but a simple solution if you are using a unique piece of software for fairly slow moving data that can be updated at infrequent intervals.
One thing to note about the pre defined functional areas is that although they may take a few hours to sync the first time round, the human effort required as minimal. With this solution a business could really start building datasets on day 1. That’s something many alternative systems can’t claim.
NetSuite Analytics Warehouse Data Visualizations
Once you have created datasets from your raw, imported data, you will want to start analyzing. For this you will need to create a workbook.
The workbook functionality is not that different to Analytics Workbooks in SuiteAnalytics to begin with. You must select a dataset to draw your data from. Then drag and drop object names from the left hand pane to the sections in the middle pane to populate your chart.
There are 40+ predefined visualizations you can choose from
One of the best parts of the Workbooks feature is that you can combine multiple visualizations and create an interactive presentation. By clicking on one parent data point, subsequent visualizations will narrow their results down.
You can add highlighting rules, filters and communicate with colleagues through a comments section. You can even generate a written explanation of the results in case it’s all a bit too much to take in.
How does Analytics Warehouse differ to SuiteAnalytics?
NetSuite native reporting and querying tools include the following.
- Saved Searches.
- SuiteAnalytics Workbooks.
Saved Searches can be really powerful, especially when built with SQL where the standard UI isn’t advanced enough. You can start to learn the basics of saved search formula here. If you are interested in some more advanced formula to 10x your searches download my free guide.
Reports aren’t as flexible as saved searches but do allow for some more appealing presentation. The formatting options for reports make them perfect for things like financial statements that require header sections, subtotals and formula rows.
SuiteAnalytics Workbooks are then the most visually appealing of the lot. With Datasets and workbooks, users can create charts and tables that can be viewed alone or presented on a dashboard.
One thing that is consistent across all the above features is that they are accessible and fairly straight forward to use. Most users can put the time in and become proficient at generating outputs for themselves or to present to management.
Even a senior manager who rarely logs in to the system can remember how to customize a report and add a column.
This is where NetSuite Analytics Warehouse differs.
NetSuite Analytics Warehouse is not designed to be used by management or occasional departmental users. The clue is in the name. This system is really designed for Data Analysts.
The volumes of data that can be sorted and the insights that can be extracted really need a professional analyst to work with them. Once you start splicing together three or four different systems worth of data, an untrained user will be overwhelmed. If you really want to get the most useful outputs you will want to have a dedicated analyst working in this system.
The other differentiating aspect of the Analytics Warehouse is the range of visualizations and their malleability. With the right person behind the wheel some amazing presentations can be created and decks of on theme KPIs can be saved for tracking performance quickly. It’s a fantastic tool to create aids for management packs or performance meetings.
NetSuite Analytics Warehouse Pricing
NetSuite aren’t known to be big fans of publishing their pricing. I do know what they are charging for the Analytics Warehouse system but I will respect their wishes and not spill the beans.
What I will say, though, is that for what you get, it is really not too badly priced at all. This is not a product for every business and you are probably going to want a dedicated analyst, but if you fall in to that demographic I would recommend engaging a partner
If you want to pull data directly in to NetSuite from one of your other systems you might look at integrating. Check the out the NetSuite Salesforce Integration here for example.
Are you familiar with the NetSuite Schema Browser. If building your own integrations it is useful to be aware of it. Find out all about it here.