• Why Choose GURUS
    • About Us
    • Clients
    • Events
    • Gurus Partner Program
    • Reference Program
    • GURUS for GOOD
  • Careers
    • Job Openings
    • Working at GURUS
    • GURUS Academy
  • Contact
Free Business Intelligence Demo   1.877.664.1023
  • Solutions
    • NetSuite
      • NetSuite OneWorld
      • NetSuite PSA & SRP
      • NetSuite OpenAir
      • NetSuite Sandbox
    • Data Toolkit
      • GURUS Business Intelligence (BI)
        • BI by Role
        • NetSuite Data Warehousing
        • BI Templates for NetSuite
      • GURUS NetSuite Data Exporter
        • Financial Planning & Analysis Edition
    • Custom Solutions
      • Container Management
      • Engineer-To-Order (ETO)
      • Dynamic Special Order
      • Marketplace Reconciliation
      • Bulk Transaction Emailer
    • NetSuite Modules
      • Financials and Management
        • Dunning Letters
        • Financials
        • Fixed Assets
        • Incentive Compensation
      • Manufacturing
        • WIP & Routing
        • Work Orders & Assemblies
      • Retail and Distribution
        • Demand Planning
        • Grid Order Management
        • Inventory Management
        • Procurement
        • WMS Lite
      • Services
        • Job Costing
        • Project Management
        • Resource Allocation
        • Revenue Management
      • Software
        • Contract Renewals
        • Software Management
    • Boomi
    • NetSuite Add Ons Solutions
    • NetSuite for Private Equity Firms

    FREE BUSINESS INTELLIGENCE DEMO

    Request your Free Business Intelligence Demo & Discovery Call Today. Have our resident BI expert guide you through the solution’s features.

    Learn More

  • Industries
    • Industry Solutions
      • Food and Beverage
        • NetSuite’s Top 5 for Food and Beverage
        • Top Software For Food and Beverage Industry
        • Food and Beverage Industry Trends
      • Life Sciences
        • Biotherapeutics
        • Clinical Trials
        • Genomics
        • Laboratories
        • Medical Devices
        • Medical Distribution & eCommerce
        • Medical Practices
        • Medical Software
      • Professional Services
      • Software & Internet Providers
      • eCommerce
      • Media & Publishing
      • Non-Profits
      • Engineering
      • Construction
      • Manufacturing
        • Cloud-Based ERP for Manufacturing
        • Complete Manufacturing Workflow with NetSuite
        • How to Increase Profits with NetSuite ERP
      • Cannabis & CBD
      • Wholesale Distribution
        • The Benefits of an ERP For Wholesalers
        • Top Wholesale Distribution Software
        • Wholesale Distributors vs. Direct-To-Consumer
      • Healthcare
        • 5 ERP Features For Healthcare Suppliers
        • Healthcare ERP for Clinics
        • NetSuite FAQ for the Healthcare Industry
      • Energy
      • Retail

    FIND THE NETSUITE BUNDLE FOR YOUR INDUSTRY

     

    Our team of specialists can customize your NetSuite with the right features to meet the needs of your business. Find the right solution for your industry.

    Learn More

  • Services
    • NetSuite Services
      • NetSuite Implementation & Configuration
      • NetSuite Project Rescue
      • NetSuite Training
      • NetSuite Data Migration
      • Business Process Review
      • NetSuite Integration
      • NetSuite Upgrade Readiness Review
      • Customization & Development
      • Assessment & Architecture
      • NetSuite Optimization
      • NetSuite Support
      • Staff a Project
      • NetSuite Admin Services
    • Integrations and Connectors
      • NetSuite Integrations
        • NetSuite to Salesforce Integration
        • NetSuite to Shopify Integration
        • NetSuite to HubSpot Integration
        • NetSuite to Procore Integration
        • NetSuite EDI Integration
        • NetSuite eCommerce Integration
      • Salesforce Integrations
        • Salesforce To HubSpot
        • Salesforce To NetSuite
        • Salesforce To Outlook
        • Salesforce To QuickBooks
        • Salesforce To Slack
        • Salesforce To Call Center Software

    FIND THE RIGHT CUSTOM SOLUTION TAILORED TO YOUR INDUSTRY

    Custom ERP solutions to connect your company’s needs with NetSuite functionalities using custom script. Learn more to find a solution that meets your company’s needs.

    Learn More

  • Pricing
  • Resources
    • Browse resources
      • FAQ
        • NetSuite Data Exporter
        • GURUS Business Intelligence
        • NetSuite FAQs
      • Blog
      • Video
      • Press Releases
      • ERP Comparison Hub
    • Filter resources
      • All
      • Demos
      • Podcasts
      • White Papers
      • Data Sheets
      • Webinars
      • Glossary

    GURUS CLOUD CONNECT

    Webinars as short as your coffee break. Register now to hear industry experts answer your tech-questions in snack-sized episodes.

    Learn More

Breadcrumb

  • Home
  • FAQ
  • GURUS Business Intelligence FAQ

GURUS Business Intelligence (BI) for NetSuite FAQ

Get in Touch With a NetSuite Professional

Table of Contents

  • What is GURUS Business Intelligence (BI) for NetSuite?
  • How do I install GURUS Business Intelligence?
  • How much does GURUS Business Intelligence cost?
  • What is Data Visualization?
  • Create and View Reports
  • Graphs and Visualizations
  • What Data Visualization tool is included with GURUS BI?
  • Why use a Data Warehouse instead of NetSuite’s Database?
  • Which Data Warehouse is supported by GURUS Business Intelligence?
  • Embed reports into a NetSuite dashboard
  • Update Product License
  • Accessing GURUS Business Intelligence
  • Does the solution allow for customizations?
  • Roles and Permissions
  • Troubleshooting
  • Frequently Asked Questions and Errors
  • Acronyms and Glossary

What is GURUS Business Intelligence (BI) for NetSuite?

GURUS Business Intelligence is a powerful turnkey platform built exclusively for NetSuite ERP. Designed to solve common reporting challenges within NetSuite, BI for NetSuite delivers extended enterprise-grade capabilities right inside your NetSuite dashboards. Customers can leverage best in-class visualization and data warehousing features by Google in order to fully take advantage of their historical data as well as improve visibility and strategic reporting that is critical to growing their business.

Top benefits include:
  • Enterprise-grade BI priced for the typical mid-market NetSuite user
  • A powerful turnkey Data Warehouse platform that scales with your business
  • Accessible reports within your NetSuite system already familiar to your Netsuite user base 
  • GURUS Solutions technology and expert ERP consultants who have been dedicated to NetSuite for over 15 years
     

How do I install GURUS Business Intelligence?

GURUS Business Intelligence is installed by the GURUS BI team. When purchasing the solution, there is a session for configuration and training of GURUS Business Intelligence.

For additional information, please reach out to your designated sales representative or click here for a demo and pricing.

How much does GURUS Business Intelligence cost?

As each business is unique, our pricing depends on your reporting requirements.

To learn more about our BI pricing, contact us via our online form.

What is Data Visualization?

Data visualization is a complex way to describe presenting information through visual graphics. It highlights patterns and trends in data and helps the reader to achieve quick insights.

Create and View Reports

The goal of your report is to display crucial data for your audience. Whether your audience is you, your boss, your team, or the wider public, you’ll need to design your report to match their needs. Begin by asking yourself:

  • Who is your audience?
  • Why are they invested in these analytics?
  • What do they already know?  
  • What do they need to know?
  • How is this information intended to drive action?

With these answers, you can provide context and present information measured against the audience’s goals.

GURUS Business Intelligence is delivered with Google Data Studio, which allows you to easily build and view reports from scratch or via provided templates.

NetSuite data is accessible via the included BigQuery Data Warehouse. Reports are then viewed in Data Studio dashboards and/or the GURUS BI embedded NetSuite dashboard for consumption.

Alternatively, reports can be created in other popular Data Visualization tools (e.g. Looker, Power BI, Tableau, etc.) that can link to the solution as well. Click here to learn more about Google Data Studio.

Graphs and Visualizations

Bar charts compare metrics using vertical or horizontal bars, and allow you to compare discrete quantities of different categories.

Line charts can easily help depict the relationship between two or more variables over time. Similarly, an area chart can help you discover correlations within a dimension.

The scorecard shows the total for a single metric. This won’t be grouped with any dimension, but will be impacted by filter controls.

Pie charts compare the parts of a whole, and are most helpful when comparing only two or three values.

The Geo Map provides an easy way to visualize how a measurement varies across a geographic area. To use a geo map, your data set needs to have geo data, such as latitude, longitude, or AdWords criteria IDs.

Scatter and Bubble charts help you identify a correlation or lack thereof between data points. These charts show your data as points or circles on a graph using X (left to right) and Y (top to bottom) axes.

Bullet charts (also known as the: thermometer graph) gives you a way to quickly see how well a given metric is performing against target benchmarks. These only measure horizontally.

What Data Visualization tool is included with GURUS BI?

Although our product supports most data visualization tools in the market, GURUS Business Intelligence is installed with Google Data Studio and a number of foundational report templates. To learn more or receive training on Google Data Studio, click here.

Why use a Data Warehouse instead of NetSuite’s Database?

Both databases and data warehouses are systems that store data, yet, they serve very different purposes. 

A database stores real-time information about one particular part of your business. Its main job is to process the daily transactions that your company makes; e.g., recording which items have sold. Databases handle massive volumes of simple queries very quickly.

A data warehouse, on the other hand,  is a system that pulls together data from many different sources within an organization for reporting and analysis. The reports created from complex queries within a data warehouse are used to make business decisions. A data warehouse stores historical data about your business so that you can analyze and pull insights from it. It does not store current information, nor is it updated in real-time.

The GURUS Business Intelligence system architecture leverages the Google BigQuery Data Warehouse to allow for a more complex reporting that is difficult to achieve directly via the NetSuite database. Its optimized data model allows for better reporting across tables. This quickly accesses higher volumes of data and allows for the consolidation of data within NetSuite and other external data sets (CRM, WMS, POS, etc.).

Which Data Warehouse is supported by GURUS Business Intelligence?

GURUS Business Intelligence is integrated with Google Big Query where an optimized Netsuite Data Model resides. Click here to learn more about Google BigQuery.

Embed reports into a NetSuite dashboard

 

GURUS BI reports are initially created in Google Data Studio (or an alternative data visualization supported tool - Looker, Power BI, Tableau, etc.). Once created, embed URLs and report URLs are inputted into the GURUS BI Report Creation Tab for report display via a custom portlet available in the GURUS BI dashboard.

To embed GURUS Business intelligence reports in NetSuite:

  • In Data Studio Copy the “Embed Report” URL

     

     

  • Within Data Studio, copy the URL page of the Report from the Browser

     

  • In NetSuite Select “New” in GURUS BI Reports and create Name. Paste embed URL link and optional direct link to the Data Studio Report

     

     

  • In NetSuite select “Personalize” and drag and drop “Custom Portal” in the GURUS BI dashboard

     

  • In NetSuite select “GURUS BI Portlet” from Setup and select created report from Edit

     

     

Update Product License

 

To View Licenses go to “License Configuration” under the GURUS BI Menu.

 

To update click “Update License” in “License Configuration” under the GURUS BI Menu.

Accessing GURUS Business Intelligence

 

To purchase or review GURUS Business Intelligence please contact the GURUS sales team sales@gurussolutions.com or request a demo or pricing on our website here.

Does the solution allow for customizations?

 

GURUS Business Intelligence is a highly customizable enterprise-grade BI solution that will address your unique business needs. The GURUS BI team has over 15 years of experience working with NetSuite’s Data Schema with knowledge in scripting and developing custom BI solutions for our customers.

Roles and Permissions

 

GURUS Business Intelligence provides access restrictions at different levels based on your NetSuite instance and the end user of the report.

 

  • Level 1: The NetSuite integration

    The first level of permission is at the NetSuite integration level. We can configure the integrations with NetSuite to only pull and store the data that you choose to make available for GURUS Business Intelligence for NetSuite.

    To do so, we need to adjust the NetSuite role permissions and restrictions that will be used for the Integration portion of GURUS Business Intelligence. Please refer to this SuiteAnswers Article to know more about NetSuite Permissions.

    From here we can decide if we bring the data from all subsidiaries, and which record types to bring. All data excluded from this will NOT be available at all from GURUS Business Intelligence.
  • Level 2: Data Warehouse access

    The second level of permission is at the Data Warehouse level. Here, your company can decide which power users - those responsible for building reports for your organization - will get access to the data warehouse. Please note that at this level, the power users will have access, in read-only, to all the data that is transferred from NetSuite.

    Only the NetSuite Integration and system administrators from GURUS Solutions have write access to the Data Warehouse.
  • Level 3: Data Studio Reports (or other visualization tool)

    The third level of permission is at the visualization tool level. Google Data Studio is provided with the solution, but any other visualization tool like Looker, Power BI or Tableau also work.

    For Google Data Studio, permissions are controlled in a very similar way as with Google Drive.Either directly to each individual user by their email addresses, or through Google Groups, which can contain multiple users. Google Groups can be a very convenient way to add and remove access to groups of reports without having to specify individual emails.

    Permissions can be set at the Report level as well as at the Data Set level. Please refer to the following help article to know more about sharing Data Studio reports.

    For other visualization tools, please refer to their respective documentation to learn about their permission control mechanism.
  • Level 4: GURUS Business Intelligence Reports records and Portlet in NetSuite

    The last level of permission is at the GURUS Business Intelligence Report level. When configuring the embedded reports into NetSuite, you can specify to which NetSuite roles those embedded reports are accessible. You can use the Audience multi-select field to select individual roles or check the All Roles box to give access to all roles. Refer to the section on Configuring Reports to know how.

    Please note that to access the embedded reports, permissions must also be set appropriately on the Visualization tool as in the previous section.

    It is also possible to control who gets access to the Portlet by modifying the Script Deployment Audience. Please contact GURUS Solutions for help with this portion.

Troubleshooting

 

For additional questions and troubleshooting please refer to the GURUS BI User Guide or contact us at: support@gurussolutions.com.

Frequently Asked Questions & Errors

 

Q: A User can’t access a Data Studio report.

A: Here are some things to check if your user cannot access a data studio report:

  1. Is the user logged into their Google Workspace account (or personal Google account your organisation does not use Google Workspace)
  2. Does the user’s Google account have access to the Data Studio report.The report must have the proper permission set in Data Studio.
  3. Does the user's role have access to the embedded report in the GURUS BI Report record.
  4. If none of the above fixes your issue, please contact GURUS Support at support@gurussolutions.com for assistance

Q. I received the message that my license has expired. What should I do?

A: This could mean the following:

  • Your license is indeed expired. Please contact your GURUS Representative to renew it
  • If you have renewed, your license might not have updated properly. Navigate to GURUS BI -> GURUS BI Configuration -> License Configuration and click Update License to refresh the license.

     

     

Q: We went through some company changes, and some of our segments (Class, Location, Department, Subsidiary) have changed, how do I update them?

A: Contact us at support@gurussolutions.com and we will update it for you.

Q: I want to add new fields or new records to my GURUS Business Intelligence setup, how do I add them?

A: Please contact your GURUS Sales representative to discuss the addition of custom components to your setup.

Q: Can I do my financial reporting using GURUS Business Intelligence?

A: The tool technically contains all the data necessary to do the financial reporting, the application does not contain out of the box the mechanism to perform the Elimination and the Consolidation that NetSuite provides. These mechanisms would need to be developed as custom reports.

Acronyms and Glossary

 

 

 

GCP Google Cloud Platform
BI Business Intelligence
BQ Google BigQuery
AI Artificial Intelligence
DW Data Warehouse

 

Terms Definition
Data Studio Google Data visualization tool
BigQuery Google Data Warehouse tool
View A view can be thought of as a table in a database. The only difference is that a view doesn’t store data, it instead will get it’s data from one or more other tables. Using a view, one can effectively create custom tables without needing more storage.
Data Model

Collection of BigQuery tables, views, with a specific set of fields, created to represent your NetSuite Data within BigQuery.

The GURUS BI Data model is only a subset of the NetSuite data model.

Portlet

A Portlet is a section of a NetSuite Dashboard that serves a specific purpose. A Dashboard consists of multiple portlets.

The GURUS BI Portlets are used to embed your GURUS BI reports directly into a dashboard.

Dashboard A NetSuite Dashboard is the page attached to a NetSuite center tab. (ex: the Home or the GURUS BI tab). It contains one or multiple portlets that each have their own functions.
Report Template Template of a Google Data Studio Report, created based on the Generic Data Model, that can be used as an example to create your own reports.
End-to-End Testing End-to-end testing is a methodology used to test whether the flow of an application is performing as designed from start to finish. The purpose of carrying out end-to-end tests is to identify system dependencies and to ensure that the right information is passed between various system components and systems.

 

Get in Touch With a NetSuite Professional

Profile picture for user GURUS Solutions
Related tags
  • ERP Consultant
  • ERP Implementation
  • NetSuite Buyer Guide

News & Events

  • Press releases

    GURUS Solutions named to the Bob Scott Top 100 VARS for 2023

    Montreal, Quebec - June 28th 2022 On June 9th, 2022, GURUS Solutions was named to The Bob Scott Top 100 VARS for 2022. The
    Read more
    Published 30 January 2023
  • Press releases

    GURUS Solutions Unveils Partnership with Mavenlink

    GURUS Solutions is proud to announce its latest partnership with Mavenlink, the industry cloud for professional services
    Read more
    Published 10 March 2022
  • Press releases

    Dell sells Boomi to Francisco Partners and TPG Capital

    [Chesterbrook, PA, Round Rock, Texas, San Francisco - May 2, 2021] As of May 2nd, 2021, Dell Technologies has officially reached
    Read more
    Published 20 May 2021

Blog

  • Third-Party Logistics (3PL) with NetSuite
    Victoria Sapsford, 23.01.2023
     As more and more companies find themselves growing at an unprecedented rate, certain business
  • Cloudli and GURUS BI for NetSuite
    GURUS Solutions, 15.12.2022
     From startups and small businesses, to large companies or residences, Cloudli offers Cloud-based
  • 7 Reasons Your Business Needs a Cloud CRM
    GURUS Solutions, 12.12.2022
     Start by asking yourself what customer relationship management (CRM) means for your company. Basically
All posts

Contact

TOLL-FREE: 1.877.664.1023
info@gurussolutions.com

Head Office

9880 Clark Street, Suite 101
Montreal, QC
H3L 2R3 Canada

Tel: 514.664.1023

Join the Team

We are always on the 'lookout' for new talent. Are you The One we are looking for?

Careers

 

Regional offices

Boston, MA: 617.807.0903
Chicago, IL: 312.588.7295
Cleveland, OH: 216.202.0264
Dallas, TX: 214.377.1221
Manchester, NH: 603.657.9458
Miami, FL:786.453.9063
Oklahoma City, OK: 405.896.8422
Ottawa, ON: 613.454.6013
Rochester, NY: 585.666.0574
San Francisco, CA: 415.449.8611

 

SEE ALL LOCATIONS

100% MONEY BACK GUARANTEE

Follow us in social media

Copyright © 2023 Gurus Solutions

All rights reserved

  • Privacy policy