Posts

Showing posts from April, 2017

[Automation Solution of Excel] i-MATRIX

Image
i-MATRIX of BI MATRIX is an automation solution of Excel. i-MATRIX is easy to use because of user oriented and intuitive integrated BI solution for data analysis. So, the user can be useful in making accurate decisions as it allows the users to directly create the valuable knowledge from the diverse data in the company such as ERP, DW, CRM, and SCM. Through MATRIX, the end-users can directly access the database and make various analyses by extracting and processing the required data easily and efficiently and into desired form. Especially, the user can user all functions of Excel on the uploaded analysis reports of web because i-MATRIX is compatible with Excel.  For instance, the user can change charts and graphs of Excel,     The user directly can input functions and expressions of Excel on the screen of web analysis and perform the quadratic analysis, The user can create the report of most complex analysis by using i-MATRIX unlike other BI solutions. Act

Business Intelligence, BI

<Gartner> Business intelligence (BI) is an umbrella term that includes the applications, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance. (Gartner, http://blogs.gartner.com/it-glossary/business-intelligence-bi/ )​

Types of Reports(Standard)

Image
[Static Reports] - Subject oriented, reported data defined precisely before creation - Reports with fixed layout defined by a report designer when the report is created - Generated either on request by an end user or refreshed periodically from a scheduler - Product of BI MATRIX: i-MATRIX - Products of other companies : Cognos Report Studio / Crystal Reports / BIRST  [Ad-hoc Reports] - Designed from scratch or using a standard report as a template - Products of BI MATRIX: ​i-MATRIX/i-CANVAS - Products of other companies : Cognos Analysis Studio [Multidimensional OLAP Reports] - Usually provide more general information - Using dynamic drill-down, slicing, dicing and filtering users can get the information they    need - Products of BI MATRIX : i-MATRIX/i-CANVAS - Products of other companies : Cognos PowerPlay / Business Objects / Pentaho  [Dashboards] - Contain company strategic data with comparisons and performance indicators - Include both static and interactive rep