Consolidating databases excel
Data from different reporting entities may reside in different databases.
Different departments may have specialized data like T&E data or commissions data or purchasing information.
When combined with BIO’s built-in content—such as pre-defined reports, folder structures, naming conventions, calculations, hierarchies, and relationships—BIO users get an extremely valuable view of their consolidated data that would be difficult at best to obtain by other means.
Many companies try to consolidate the data themselves, using Excel, for example.
Here are some of the major items to consider: BIO has facilities built into the software that can assist you in resolving these issues.In no time, even your non-technical folks will be analyzing consolidated data without a thought as to where the source data resides or how to compare the apples in your ERP system to the oranges in your CRM system.I have read a tip on Importing SQL Server Data from Multiple Data Sources into Power Pivot for Excel, which talks about bringing in data from two or more sources into Power Pivot and storing data from each source table/query as a separate Power Pivot table.You may need to combine transactional data with your forecasted data or operational data and R&D estimates.Whatever the source, BIO Business Intelligence for Microsoft Dynamics gives you the tools you need to uncover the knowledge in your consolidated data that you need to make decisions that impact your bottom line.