Solution
Existing data warehouses were on Oracle and did not cover all lines of business.
Moreover, dimensions were not conformed.
BI Demantra created an enterprise data warehouse with the focus on various subject areas.
BI Demantra’s consultants also implemented master data services and data quality services using SSIS to bring consistency and data integrity.
Finally SSRS , PPS and Power BI, using SSAS cubes as data source, were used as reporting tools to provide a single version of truth with faster, interactive reporting.