Already registered - sign up here for full access your portal.

sign-in

Partner or professional - register here to get access to great people, great projects and a great opportunity.

Register now for all of the latest Cimbax opportunities.

register

BI for Dynamics


At Cimbax we have years of experience of implementing Business Intelligence in some of the largest companies, and we know that it's not just about a nice front end and a few dashboards. A Data Warehouse, the ability to handle change and a durable architecture are vital components of any sucessful Business Intelligence implementation.

These requirements led us to select timeXtender as the basis for all our BI practice and Dynamics BI offerings. timeXtender is an ETL (Extract, Transform & Load) and cube-building toolset, with a drag and drop interface, that generates native SQL code. It dramatically reduces the time and cost required to deploy any SQL data warehouse.

timeXender has a series of pre built cubes called QuickCubes that can be deployed in one day with a SQL Data Warehouse template.

timeXtender has QuickCubes for AX, NAV & MS CRM

 


     

     


     

     


     

    Durable Information Architecture

    The advantage of timeXtender with Dynamics AX, CRM or NAV is that it is possible to build a properly-architected Business Intelligence application, based on SQL Server, very quickly with no programming. The ability to produce a working proof of concept on a client’s own data within a few hours often provides the breakthrough that gets a BI project underway. The code produced is standard SQL – so there are no black boxes here.



    There are a number of ways to get the most from data in Dynamics. Cimbax nearly always recommend a SQL Server-based staging area, data warehouse and OLAP server to do the job.

      

    timeXtender has adaptors for AX NAV & CRM that understand the data structure and content of these applications. QuickCubes provide OLAP 'out of the box' for AX NAV & CRM. Together, these give the ability to get a proof of concept working with your own data within a few hours.


     

     


     

    Front End Flexibilty

    By producing an Information Architecture with a SQL Server Data Warehouse and Analysis Services OLAP cubes, the choice of tools to present the data to users is wide. In a Microsoft environment, SharePoint and Excel provide good functionality for analysis and delivery of information in 2007 - and especially 2010 versions.

    The Analyzer product from Strategy Companion is popular choice, as is the Targit solution.

    Many others exist, and with data being held in the Data Warehouse and OLAP cubes, hybrid solutions with more than one analysis and presentation product are also often used. 

     


     

     Interested?

    To arrange a demo, or for a free one-day Proof of Concept on your on data, please contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it

     


     

    BI for AX

    Dynamics AX (3, 4 or 2009)

    Quickcubes for AX & Analyzer Package (example screenshots)

       

       

       

       

     

     

     

     


    QuickCubes are built for:

    • Finance
    • Debtors
    • Creditors
    • Sales Orders
    • Purchase Orders
    • Inventory
    • Production

     

     

     

    BI for NAV

    Dynamics NAV (4, 5 or 2009)

    It does not matter which version of NAV you are running, connectors and adapters are available for both SQL Server and C-Side NAV implementations. In either case, QuickCubes powered by timeXtender generates a SQL Server 2005 or 2008 Data Warehouse and full Business intelligence solution with the following cubes out of the box:

    • Finance
    • Accounts Payable
    • Accounts Receivable
    • Sales Analytics
    • Vendor Analytics
    • Inventory Analytics

     

    BI for CRM

    Dynamics CRM

    QuickCubes for MSCRM4.0                       Free Dashboards *

    • Activity                                              4 Sales
    • Campaign                                           3 Marketing
    • Case                                                  2 Service
    • Lead
    • Opportunity
    • Opportunity History 

     All this delivered on your own CRM environment in one day at an unbeatable price

    * required purchase of one developer seat of Analyzer from www.strategycompanion.com

     

    UK Office number - +44 20 3189 2090