loader image

Share:

Share on facebook
Share on twitter
Share on linkedin

How to integrate Oracle Netsuite with Power BI and add planning

How to connect Oracle Netsuite To Microsoft Power BI Desktop with Planning & Write-back

Power BI offers unparalleled features for analysis and visualization: in this post we explain the quickest way to connect Oracle Netsuite in Power BI Deskop and how you can add comprehensive planning and budgeting.

How to:

  1. Create a free trial account at: Acterys Trial | Power BI | Business Intelligence | Microsoft BI
  2. After your account has been setup, click on the “Integration” menu and go to the “Oracle Netsuite” section:
Connect to Oracle Netsuite

3. Click on “Add” and enter your authentication details:

4. Following that Acterys will create a data warehouse tables with all Netsuite data selected in an optimal format for analysis that is also write enabled. Users can for example edit dimensions and map accounts or create planning and simulation models as required in either the Acterys Modeller in the browser or using the 8 Acterys Power BI visuals

5. With Power BI you can now use one of the templates that Acterys provides or just connect with a normal Azure/SQL Server connection, add the tables and immediately start analysis with an optimal data warehouse format.

Connect to Netsuite from Power BI

6. Now you can use all planning and collaboration features available in the Acterys Power BI visuals: Business Apps – Microsoft AppSource

Data entry on any level, relative/absolute, comments, conditional formatting
Data entry on any level, relative/absolute, comments, conditional formatting
Acterys Table Edit visual new features
Acterys Table Edit
Acterys Gantt Power BI Visual
Acterys Gantt Power BI Visual

Recent Posts

I can’t help smiling when I see legacy BI/Planning application vendors -that were not so long ago laughing away Power BI- coming out with their own “Power BI Integration” after Microsoft has turned around the industry. These are more often than not nothing but “a marketing spiel” to build on Power BI’s awareness and of very limited use in real life application scenarios.

Across many mid-sized and large companies, finance and operations teams are at crossroads. This was one of the findings from the recent BPM Pulse 2021 survey which revealed that only a third of companies had truly harmonized strategic, financial, and operational plans.

Power BI offers unparalleled features for analysis and visualization: in this post we explain the quickest way to connect Oracle Netsuite in Power BI Deskop and how you can add comprehensive planning and budgeting.After your account has been setup, click on the “Integration” menu and go to the “Oracle Netsuite” section:

The default visuals in Power BI are not perfectly suited for financial reporting. There are ways to realize more advanced financial reporting requirements using DAX as Managility describes in Income Statement using DAX These, though typically require intermediate knowledge of DAX that many financial professional don’t necessarily have.

The Acterys Modeller is cloud based service (with on-premise installation option) that allows enables business users to automatically create optimal analysis models (star schema data warehouse) from a variety to ERP. accounting and SaaS systems. The created models are write and planning enabled and can be edited and extended as needed by business users e.g. for adding new products/attributes, account mappings, new scenarios etc.

Tags