iCharts is a business intelligence solution that is native to NetSuite. It embeds within NetSuite and you can use it as part of your NetSuite dashboard. With this in mind, people often wonder what makes iCharts different from NetSuite’s out-of-the-box reporting.
NetSuite already has a good reporting platform with Saved Searches and Reports but there are limits to how you can access, combine, and present data. Because of this, many NetSuite users have to use alternatives, like pulling data out into Excel to get the reports they need.
iCharts helps you get the most out of your NetSuite ERP without the need to extract your data. Here are a few ways that iCharts is different from standard NetSuite reporting.
With standard NetSuite reporting, you usually can’t add multiple dimensions to a chart or dashboard. In the example below, we’re using iCharts to view a metric that is typical to software companies: total Annual Recurring Revenue (ARR) broken down by order type. By adding order type as another dimension and segmenting the total ARR, we can see how much revenue comes from new sales, downsells, and upsells. Without iCharts, accessing this data and understanding what comprises our ARR would be much more difficult.
Reporting on data from two standard NetSuite record types is technically possible in NetSuite, but it requires a pre-defined join. In many cases, extracting the data and manipulating it in Excel is necessary to achieve the view you want.
With iCharts mashups, you can visualize data from multiple saved searches based on a common field. Use your common dimensions as rows or columns in a pivot table or as bars and lines on a chart, then use your numeric values as measures. A simple example is budget vs. actuals, as seen below.
iCharts mashups can visualize data from up to five saved searches, with support for standard and custom NetSuite records and fields.
With a mashup, or even a single saved search, you can visualize multiple measures. Let’s say I want to visualize P&L: revenues, costs, and profit. I could easily create a formula to give me each of these values and visualize them, all on one chart. You can use up to 20 measures in a single iCharts visualization.
Using formulas, iCharts can calculate custom measures and present them visually. In the example below, we’re using a formula to calculate and visualize the projected cumulative Monthly Recurring Revenue (MRR) by product. We can see how much increasing revenue to expect for each month. Furthermore, because iCharts incorporates multiple dimensions, we can break down the revenue for each month by product or service sold.
Without iCharts, you’d only be able to see the revenue associated with each month, not the accumulating total month over month.
You can filter any chart you make in iCharts using any field you’ve included on your saved search. This allows for very specific segmentation of data, so you can analyze your business down to the smallest detail. For example, consider a chart showing bookings over time. Some questions you might ask include:
- “Which sales reps contributed to these bookings?”
- “Which products or services were sold?”
- “What is the customer’s location?”
- “What is the customer’s name?”
- “When did the sale take place?”
With iCharts, you can apply any or all of these variables to your charts, so you can explore data without having to view it in a spreadsheet.
In addition to NetSuite standards like line, area, bar, and column charts, iCharts offers pie, stacked bar, 100% stacked bar, and bubble charts. The latest version of iCharts also includes Pivot tables.
iCharts makes chart creation easy and intuitive, so even basic charts are better with iCharts.
Standard NetSuite trend graphs allow you to have one chart per portlet. With iCharts, you can group multiple charts into dashboards for quick viewing. When you’re ready to analyze things a bit further, you can click on the top right corner of a chart to expand it to fill the entire portlet.
There are many differences between the standard NetSuite reporting and iCharts. If you want to learn more, contact our sales team to talk about your specific needs and see a live demo. You can also learn more on our NetSuite product page.