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's Colin McGowan has 12 years 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. Colin 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:
- SSAS 2005 - 2012
- Tabular and multdimensional modelling
- MDX scripting
- SSAS performance tuning, optimisation, and healthcheck
- Microsoft enterprise BI architecture
PowerPivot model design services
PowerPivot is the choice for Excel gurus who want the full power of self service BI. Engage CMBI for:
- PowerPivot 2008 R2 and 2012
- PowerPivot data modelling
- PowerPivot training and mentoring
- DAX calculation support
- Self service BI strategy advice
TM1 database design services
TM1 is the choice for budgeting, forecasting, and what-if scenario analysis. Engage CMBI for:
- TM1 cube modelling
- TM1 rules definition and optimisation
- Turbo Integrator scripting
- Advanced MDX
- TM1 solution design
Qlikview database design services
Qlikview is the choice for usability and data exploration. Engage CMBI for:
- Qlikview data modelling
- Qlikview data integration
- Set based calculations
- Dashboard design
- Self service BI strategy
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.
