Analytical databases overview
Analytical databases encompass technology labels like multidimensional, columnar, in-memory, and OLAP. But whatever the label, they all share three common attributes. Analytical databases are:
- Designed and optimised for efficient querying
- More intuitive for end users
- Powerful expression language for analytical calculations
Analytical databases provide faster and more flexible query analysis than can be achieved through an RDBMS with equivalent hardware. They are able to do this because the data model is not concerned with supporting the ongoing maintenance and integrity of the data. Analytical databases are one of the most exciting areas of BI with the latest products able to consume huge quantities of data whilst maintaining very fast query response times. For this reason, they are well suited for ad hoc query or interactive dashboards and reports.
CMBI analytical database services
CMBI have many years of experience designing reporting and analytics solutions using Analysis Services (SSAS), PowerPivot, Qlikview, and TM1. Each of these technologies has it's strengths and optimal applications. CMBI can help with technology selection, design, and implementation of a new project or maintenance of an existing solution including performance optimisation, mentoring and training.
Analysis Services (SSAS) database design services
Analysis Services is the choice for enterprise scalability and complex modelling scenarios. Engage CMBI for:
- Analysis Services and Power BI
- Tabular and multdimensional modelling
- MDX and DAX scripting and calculations
- SSAS performance tuning, optimisation, and healthcheck
- Microsoft enterprise BI architecture
Power Pivot model design services
Power Pivot is the choice for Excel gurus who want the full power of self service BI. Engage CMBI for:
- Power BI for Excel, Microsoft 365 and Power BI Web
- Power Pivot data modelling
- PowerPivot training and mentoring
- DAX calculation support
- Self-service BI strategy advice
About CMBI
CMBI designs and develops business intelligence and analytics solutions for clients in Sydney and regional NSW. CMBI technology expertise includes Power BI, Power Pivot, Excel, SQL Server, Analysis Services, SharePoint BI, and Tableau.
