Data warehouse and reporting in ICT Services
As Combell has been growing very intens and did many acquisitions and mergers they were in a high need for consolidated reporting. A data warehouse was developed to do customer (churn) and contract (retention and cohort) analysis on top of approximately 20 sources (Dynamics NAV, in house developed ERP system, webservices, legacy databases). Also a master data management system was developed to create a unified product hierarchy and customer mappings between all sources. It's a fullstack Microsoft implementation using SSIS, SQL server and the data is being visualized in powerBI dashboards on a tabular model.
Customer
Related Topics
Related Technologies
Related Competences
- BI on Databricks
- Business Analytics Training
- Course: Microsoft Power BI coaching workshop
- Course: Microsoft Power BI update sessions
- Microsoft BI & SQL Consulting
- Microsoft BI & SQL Server
- Microsoft Business Intelligence & Analytics
- Microsoft Business Intelligence Front-end
- Microsoft Mixed Technology Implementations
- Microsoft Power BI
- Microsoft Power BI on SAP Data Sources
- Microsoft Power View
- Microsoft PowerPivot
- Microsoft SQL Azure Database
- Microsoft SQL Server 2017
- Power BI "Out-of-the-Box" BI for Microsoft Dynamics Business Central / Navision
- Power BI Embedded & on mobile
- Power BI Governance
- Power BI Pro & Premium
- Power BI Reports Server
- Power BI desktop
- SQL Server 2016 Integration Services
- SQL Server Analysis Services
- SQL Server Reporting Services
- TimeXtender DiscoveryHub