functional & technical consultancy

Data Warehouse Design

This is the centralisation of the various information scattered all over the company. It is a collection of “data marts” in which all information is kept in a conformed and standardised way. Moreover, it can keep track of historical situations of the company by archiving the changes of the data.

The data are kept in several star-scheme models, this is called the dimensional star-scheme approach. For each star, there is one (sometimes more) central table with facts (numerical data like sales, inventory and purchase information) that is surrounded by several dimension tables (holding e.g. customer records, employee information, general ledger accounts, etc...).

Extraction, Transformation and Loading

Data is transferred from source (or legacy) systems to the central data warehouse. These source systems can be ERP systems (like SAP and Oracle Applications), CRM applications (like SIEBEL), or any other application that was written for the company and that is held in databases, spreadsheets or other.

The ETL (Extraction, Load and Transformation) process takes out the data from the sources, transforms it into the needed format, removes the dirty data and loads it into the data warehouse. This is done with ETL tools, or by tailored code that is written by ETL experts. These loads happen in batches, overnight. If there's a need for data exchange between databases on the moment data is created, it's called EAI, a messaging service that propagates the data on the moment it appears.

CPM products

BinMotion can build on many experienced developers in a variety of CPM products like Cognos, Business Objects, Microsoft and others. Typically, these are reporting, analysis, dashboard and planning tools.

project management

Because of the particular nature of Corporate Performance Projects, Binmotion provides highly specialised project management roles to guarantee a successful implementation on schedule and well within budget. Because of the excellent track record of our company, our people have a thorough understanding of the expected deliverables and the effort and budget that are needed to make things happen.

strategic consultancy

Many companies use Corporate Performance Management tools as a support for their decision making processes for the long term. But also the CPM proces itself needs a strategic plan to ensure these services keep on supporting the organisation in the coming years without becoming obsolete. Binmotion assists customers in making choices in the CPM world and helps turning these products into supportive tools, helping to achieve the long term mission and vision of the customer.

business consultancy

Prior to the development of a Corporate Performance Management project, some analysis is needed. Starting with a thorough investigation on the processes and needs of the targeted organisation, BinMotion draws a picture of the where-what-when’s and then proceeds with an information analysis to detect the location of the needed data. This is always done in the field of CPM projects, either by the customer itself or BinMotion consultants.

solution architect

This role designs applications required to automate business processes and meet business needs. The resulting design may run on multiple platforms and may be composed of multiple software packages and custom components. This role defines best practices in the critical evaluation and selection and / or development of the software components and hardware requirements of the applications and data, and the development of the application, including evaluation and selection of development methods, development processes, best practices and tools. Applications Architects are responsible for applications-related quality, performance, availability, scalability, and integrity. They are also responsible for the functional interface to applications and for ensuring application usability.