MetaOption offers Business Intelligence (BI) and Reporting solutions on various
platforms.
- Any company has large sets of data and would like to analyze it need a OLAP reporting
solution
- Business Intelligence solution stores data in multi-dimensional cubes with dimensions
and fact information. Example, fact could be actual sale and dimensions could be
offices, regions, employee, product etc.
- This can be done with SQL Server Analysis Services, IBM Cognos or other business
intelligence tools
- This also involves migration of data from one source to OLAP cubes and OLAP databases
which can be achieved using SQL Server Integration Services (SSIS) or Cognos Decision
Stream or other data migration tools
- Once data is loaded to de-normalized databases or OLAP cubes reporting can be achieved
using SQL Server Reporting Services (SSRS), which uses SQL Queries and MDX (Multidimensional
Expressions) to get data from OLAP Cubes.
MetaOption is helping customers:
- Developing Reports in SQL Server Reporting Services (SSRS) from their ERP system
like VisualERP, Navision, Great Plains or any legacy system with Oracle, SQL Server
or MySQL databases
- Developing Reporting with Crystal Reports
- Developing Reports with IBM Cognos Platform
- Data Migration using SQL Server Integration Services (SSIS) from legacy systems
like FoxPro or any other sources to Oracle, SQL, MySQL databases
- Development of Datawarehouse and Data Marts
- Development of OLAP Cubes using SQL Server Analysis Services (SSAS) and IBM Cognos
- Developing Reports on OLAP Cubes using SSRS and MDX (MultiDimentional eXpressions)
queries