Category Archives: Open Source Business Intelligence Services

13 Oct

BI Software Selection

you-decide-on-open-source

Variety is the spice of life and a key characteristic of Open Source software, which makes choosing the most appropriate package far from obvious. Deciding which licence, vendor, version to pick can take longer than the problem you are trying to solve.

Thankfully, help is at hand as Millersoft Ltd can take your requirements and use our broad Business Intelligence experience to narrow down the options.

Millersoft Ltd can prepare working prototypes with your own data, demonstrating which open source choices work best for your business. For example, we could configure both JasperSoft and Pentaho to work against your company data held in Infobright or MySql. We can even compare the compare commercial and open source variants of those products and package everything up in a VMWare instance for ease of installation.

13 Oct

BI Software Integration

BI Software Integration

If your Extract Transform Load (ETL) diagram resembles an elevation of the Pompidou Centre then time to review your architecture. The more complex the ETL, the harder reconciliation becomes and the greater the risk that managers are basing decisions on duff data.

Creating reporting data marts from operational systems is seldom simple, especially with all those slowly changing dimensions to consider. This complexity can be reduced through judicious database selection, tool choice and a clear understanding of end-user requirements.

Millersoft Ltd can help streamline your integration strategy; loading data faster, making queries respond and reducing ongoing maintenance.

13 Oct

BI Software Design and Optimisation

BI Software Optimisation

Millersoft Ltd likes to get involved with companies early in the project life cycle to ensure developers avoid some of the common BI pitfalls, however, we can also help with mature projects.

If your Pentaho or Jaspersoft Analysis Views are responding slowly or killing your database/server then Millersoft Ltd can tune your OLAP engine, with:

  • Database architecture choice
  • Database index selection
  • Aggregate table definition
  • OLAP schema design
  • MDX query design
  • Mondrian configuration
  • Java performance tuning

In extreme circumstances we can even build custom versions of Pentaho/Jaspersoft, fine tuned to your data processing requirements.

13 Oct

BI Software Training and Mentoring

BI Software Mentoring and TrainingMillersoft Ltd can bring our expertise to your company and tailor a training programme around your Business Intelligence requirements. If you would like to use open source tools like Jaspersoft, Pentaho, Talend or Kettle but can’t find anyone with experience to train your staff then give us a call.

We also provide support services to staff who are confident with the tools but need help with detailed technical questions from people with hands-on experience.