Connecting NetSuite to PowerBI via Neon
Hi, I hope this is the correct place and format to post this, and thank you in advance for taking the time to read.
We use NetSuite as our ERP, and currently report in an incredibly manual way, using Excel. I have been tasked with modernising our reporting to reduce the significant amount of time colleagues spend manually refreshing these workbooks.
My boss is set on using PowerBI for the actual reporting, which I have some familiarity with, but my background is accountancy, not data, and so I have been struggling to get data out of NetSuite and into PowerBI in a complete and 'real-time' way that doesn't struggle with NetSuite's API restrictions.
My research has suggested that utilising a data warehouse to sit in between the two systems is the way to resolve this issue, and my boss has talked to her previous employer, who have spoken highly of Neon in this regard, and is therefore keen for me to use Neon.
My understanding is that I need to feed data from NetSuite to Neon, and then connect PowerBI to Neon. Can anyone point me in the right direction to the correct set up guide for this? I have trawled through various Neon docs nad have so far either failed to find the correct article, or failed to understand that I have actually found the correct article.
Any help anyone can provide will be greatly appreciated. If I have got any assumptions wrong, I am all ears, and if the answer is that I need to bring another party on board to implement this on my behalf then, I understand and would be keen to explore this avenue further too.
Best wishes, Seán
We use NetSuite as our ERP, and currently report in an incredibly manual way, using Excel. I have been tasked with modernising our reporting to reduce the significant amount of time colleagues spend manually refreshing these workbooks.
My boss is set on using PowerBI for the actual reporting, which I have some familiarity with, but my background is accountancy, not data, and so I have been struggling to get data out of NetSuite and into PowerBI in a complete and 'real-time' way that doesn't struggle with NetSuite's API restrictions.
My research has suggested that utilising a data warehouse to sit in between the two systems is the way to resolve this issue, and my boss has talked to her previous employer, who have spoken highly of Neon in this regard, and is therefore keen for me to use Neon.
My understanding is that I need to feed data from NetSuite to Neon, and then connect PowerBI to Neon. Can anyone point me in the right direction to the correct set up guide for this? I have trawled through various Neon docs nad have so far either failed to find the correct article, or failed to understand that I have actually found the correct article.
Any help anyone can provide will be greatly appreciated. If I have got any assumptions wrong, I am all ears, and if the answer is that I need to bring another party on board to implement this on my behalf then, I understand and would be keen to explore this avenue further too.
Best wishes, Seán
