Business Intelligence i3 Launched by IMS
Information Management Solutions Ltd. (IMS), the dynamic IT consultancy for business solutions, announced today the launch of the latest addition to their latest Business Intelligence and data warehousing solution i3.
i3 is the result of a number of collaborations with other software vendors and IMS. These include IntelligentApps and ProClarity Corporation. The latest addition is the result of further collaboration with IMS’ partner Friedman Corporation in the UK to add Business Intelligence (BI) to their LS400 ERP (Enterprise Resource Planning) product.
i3 enables business users to identify business trends, investigate underlying data, and inform for better business management. It will deliver key performance metrics and provide Business Intelligence for different areas of the business:
i3 for LS400 uses Microsoft SQL Server to extract and store transaction data from LS400, creating a number of user-focused data “marts’. Microsoft Analysis Services generates and stores cube data which is then viewed and analysed using IntelligentApps 4Excel. Data will be analysed in the following areas:
· Purchasing and vendor quality – It will look for price and quality trends by product and vendor
· Sales analysis – It can look for sales and margin trends by customer, salesman, country, product
· Financial performance – It will analyse P&L and Balance sheet in various ways
· Inventory analysis – It can look for under and over stocking by product, warehouse or country
The technology uses Microsoft SQL Server to extract, transform and load the data into a data warehouse, it utilises Microsoft Analysis Services to generate analysis cubes, and uses IntelligentApps 4Excel as the software for the end user to explore the data.
Robin Edmonds, managing director of IMS;
“IMS’ i3 Business Intelligence solutions have been deployedby companies world-wide.i3 for LS400 adds a quick turnaround, fixed cost BI solution to our portfolio which will enable companies which use LS400 to take advantage of leading edge Business Intelligence technology. We expect to add support for other ERP systems in the future.
- Ends – 234 words.
Note: There will be a number of case studies available soon involving the use of i3 for Business Intelligence and data warehousing applications. Initial case studies are expected to cover the logistics and manufacturing sectors.
