MDB has experience building full enterprise level business intelligence solutions using Microsoft’s industry leading Business Intelligence technologies.

• Microsoft Certified Technology Specialist’s
• Design your relational and dimensional data warehouse structure
• Fully utilise Microsoft’s enterprise ETL (Extract, Transform, Load) platform, SQL Server Integration Services, to populate your data warehouse - including full audit trails and data lineage tracking
• Design and build your high speed OLAP (On Line Analytical processing) engine using Microsoft SQL Server Analysis Services
• Incorporate complex calculations, key performance indicators and data mining algorithms
• Design and build your reporting system using technologies such as Microsoft Business Scorecard Manager, Microsoft PerformancePoint Server 2007, Microsoft SQL Server Reporting Services and Microsoft SharePoint Server

In addition, MDB has specified knowledge of:

• Structured Query Language (SQL) - query language for relational databases
• Multidimensional Expressions (MDX) - query language for OLAP databases
• Meta data management
• Scorecards – traffic light performance indicators, trend arrows, drill down
• SQL Report Builder – empower end users to create their own reports in a safe way
• SharePoint
• Security – only allow specified users access to view specific data (such as financial data at director level)
• Time calculations – e.g. view current period, previous period and year to date on a single scorecard