[general process]
Understand...Identify...Build...Present

Understand the business
Understand and gather information that we have to work with, including:
  • business processes in place today
  • system processes and flows
  • data available and data not available
  • data flows and relationships
Understand the business objects

We work together with the client, to identify, prioritize and sort through all the data they have available. We then identify the following key data elements:
  • Data sources (data bases, text files, excel sheets, etc.)
  • Data collection frequency (hourly, daily, weekly, monthly)
  • Data accuracy
  • Missing data (gaps, lag times)

Understand data

We work together with the client, to identify, prioritize and sort through all the data they have available. We then identify the following key data elements:
  • Data sources (data bases, text files, excel sheets, etc.)
  • Data collection frequency (hourly, daily, weekly, monthly)
  • Data accuracy
  • Missing data (gaps, lag times)

Identify key data elements

Once the data elements have been defined, MSi assists the client in identifying key elements and criteria that are required by the business to make informed decisions. This process involves defining:
  • Data elements required
  • Data elements necessary for supporting information
  • Data elements that are not required
  • Relationships between sources and data elements
  • Retention requirements

Identify performance and productivity indicators

Define the mechanisms required to transform the data elements into the required information for business operations.
  • Metrics
  • Measurements
  • Key Performance Indicators (KPIs)
  • Summaries


Build the Models

Setup the data structures and relationships. Build the models to support the required metrics, analytics and dashboards.

Present & Action the information

Presenting the information to users in a clear and concise manner is key to enabling management to be able to make informed decisions. Build mechanisms to easily action and gain results.

MSi has developed an extensive toolset to provide users with a single multi-faceted web based application. The application facilitates reporting and analysis using:

  • Intuitive navigation supporting drill down capabilities
  • Interactive charting
  • Tabular reporting
  • Exporting to common software formats (i.e., excel)
  • Colour coded calendar based reporting
  • Additional information presentation methods

MSi forms partnerships with its clients to find the best way of leveraging these capabilities for an effective and customized solution.