I am currently researching BI tools.
I'm looking for a comparison between Sigma and Power BI in terms of costs, performance, and ease of use. Which of these solutions do you prefer and why?
Thank you for your help.
The two are similar, it is cars but of different brands; I ask 1-) the users use Windows 2-) you have Office 365 3-) They will use Excel for the data. If you answer yes to the 3, better BI due to integration, and learning is easier for the user. If they are non-Microsoft databases, investigate on the provider's side, for example, SAP, IBM, etc. I have trained end users in Power BI. I know that Power BI has the majority of connectors. I hope my comment is helpful. Regards
Financial Systems Advisor - US Controller Group at McDonald's
Apr 19, 2023
Easy is a tricky description...We are going through this effort too. We are 'grappling' with the governance of this type of access as well as the technical journey. So you are not alone.
Fusion Middleware applications include a number of connectivity options including native client or Oracle Data Access Components (ODAC), with OLEDB, JDBC, etc., on top. Each has its own quirks. This is the 'plumbing' between the analytic tool and source.
Adding to that is the cloud and database level security of the data source.
A good way to start is to use Oracle's SQL Developer to connect to your data source. It gives developers a great query tool for Oracle and other databases. (https://www.oracle.com/databas...)
Once you understand what you can access, you can easily migrate that connectivity to Power BI.
Moreover, you will have validated queries that you can test directly or simply bring in the tables using the PBI Navigator.
Hi Ross,Good news! The BI Connector, a Power BI-certified connector is created exactly for this purpose!With BI Connector, it's possible to extract your Oracle Fusion data directly to Power BI. Please check it out below:https://www.biconnector.com/po...The connector works seamlessly with both Power BI Desktop and Service (or Report Server) and supports Import and Direct Query modes. It also retains the underlying table joins in the Oracle Fusion Cloud, so you don't have to recreate them from scratch in Power BI.Thanks,Dinesh
Business owners cannot rely on their own market assessments and strategic assumptions to make informed tactical decisions. Rapid technology development and tough competition mean that thorough data analysis is vital for success. In this article, we explain how business analysts, IT teams, and company managers can benefit from Microsoft Power BI integration with the help of BI connectors.
We're happy to share our new bi-weekly Community Spotlight with you. Here you'll find recent contributions by PeerSpot community members: questions, articles and trending discussions.
See what your peers are discussing at the moment!
What to choose: an endpoint antivirus, an EDR solution, or both?
What is your recommended IT Service Management (ITSM) tool in 2022?
This is our new Community Spotlight that includes recent contributions (questions, articles and discussions) by the PeerSpot community members.
Is RPA beneficial for a healthcare organization?
With the increasing risk of cyber attacks in the west, due to the war in Ukraine, how safe is your data in the cloud?
8 Business Automation Ideas to Save Time and...
Hi community members,
Here we go with a new Community Spotlight. We publish it to help YOU catch up on recent contributions by community members.
What open-source HCI solution do you recommend?
How much time does SSO save?
What are the main technical differences between Microsoft Power Automate and Blue Prism?
Top HCI in 2022
What is Web Design? The Ultima...
Hi community members,
Here is our new Community Spotlight for YOU. We publish it to help you catch up on recent contributions by community members.
Do you find it useful? Please comment below!
Top HCI in 2022
What are the main differences between XDR and SIEM?
Top 5 Ethernet Switches in 2022
SASE: what is it and what are the main benefits?