How do organisations consolidate data from your Human Resources and Financial systems, where you have separate systems (like us)?
We use SAP SuccessFactors for HR, and Oracle Fusion for Financials. We need to extract and combine data from both for enterprise reporting purposes - Power BI dashboard.
There are many options to extract the data from these systems, from simple csv file export, to use of Fusion Analytics Warehouse and SAP Analytics Cloud with Power BI connectors and/or putting the data into a Data Warehouse (an option we are considering).
I'm interested in what other organisations are doing as a practical solution.
Dear Rosie, the answer is...it depends ;-) Here some advises and reccomendations I can share from my experience. 1. Power BI itself can merge different data sources by nature. Just check if the connector is available. 2. What kind of refresh frequency are you talking about? 3. If you are thinking of a daily refresh start from import mode, direct mode is more complex and implies native query optimization. 4. which data size are you talking about? Pro license have limited size model (I think 1Gb which for normal cases it's enough) 4.Anyway, direct mode doesn't work with csv, it requires a RDBMS 5. consider the usage of dataflow to pull data from each source and shape them 6. than use them in a Power BI combined semantic model 7. model your data as star schema! That's is definetively a must do! It prevents many performance issues, improves data model usability and clearnees 8. consider also Microsoft Fabric which simplifies data transformation and incremental data loading 9. anyway start first with just Power BI 10. have your own data strategy! Start experimenting but try to envision your landing world ;-)
Dear Rosie,
the answer is...it depends ;-)
Here some advises and reccomendations I can share from my experience.
1. Power BI itself can merge different data sources by nature. Just check if the connector is available.
2. What kind of refresh frequency are you talking about?
3. If you are thinking of a daily refresh start from import mode, direct mode is more complex and implies native query optimization.
4. which data size are you talking about? Pro license have limited size model (I think 1Gb which for normal cases it's enough)
4.Anyway, direct mode doesn't work with csv, it requires a RDBMS
5. consider the usage of dataflow to pull data from each source and shape them
6. than use them in a Power BI combined semantic model
7. model your data as star schema! That's is definetively a must do! It prevents many performance issues, improves data model usability and clearnees
8. consider also Microsoft Fabric which simplifies data transformation and incremental data loading
9. anyway start first with just Power BI
10. have your own data strategy! Start experimenting but try to envision your landing world ;-)
Hope this will help.
Regards,
Antonio