>

Analytical database design services

Key Points

  • Cubes and columnar databases have been designed specifically to support reporting, analytics, and complex modelling
  • There are a range of technology options that share many similar characteristics including SSAS, PowerPivot, TM1, and Qlikview
  • Cubes and columnar databases are increasingly used to support self service BI

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.

About CMBI

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:

PowerPivot model design services

PowerPivot is the choice for Excel gurus who want the full power of self service BI. Engage CMBI for:

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.

See Also