Reviews

in
What Your Peers Are Saying About
Director, Front Office Technology
We are finishing up our migration from our on-prem data center to Azure and at the same time building out our DevOps capabilities (which we are only partly through).   I'm looking to outsource and potentially near shore operations of two areas.  First, our DBA function.  We have an existing organization that worked great to support our DBA operations needs 24x7 however as we've been migrating DBs to Azure SQL they are unable to effectively support us.  So on the DBA side I'm looking for a managed service group that can provide proper Azure SQL dba and instance operation level support.   On the DevOps side, we are not quite a far along our journey, however, we are moving more workloads into platforms like Azure DevOps, CheckMarx, Sonatype, APIM, and I'm sure as we continue to build our capabilities we will be adding more tools into the mix.  Similarly I'd like to outsource operations of the CI/CD platform.  We've had good luck so far with some nearshore development help down in South America, great talent and the timezone difference has been much better than APAC.   Would love any thoughts, general or specific on if people have had success outsourcing these areas, if not why not, and if so any thoughts on direction here?  
Senior Vice President - Advanced Engineering & Data Analytics
Yes,I have and will be able to help. Ping me offline for a discussion session
See Full Discussion
30 Apr 20241.3k Views1 Comment
IT Analyst
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.
IT Manager
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
See Full Discussion
26 Feb 20241.8k Views1 Comment