January 04 newsletter  


 

Welcome to the 5th edition of the monthly Dataworks newsletter
Welcome to the first issue of 2004, the team at Dataworks would like to wish you a Happy & Prosperous New Year to you all. 2004 promises to be every bit as busy as the last six months.

This month we have a selection of current projects on which we are working in our various areas of expertise and the 'The Leading Edge' technology news resumes with an article on Business Intelligence. Should you want to unsubscribe, simply click on the link provided at the end of the page and type "remove" as the subject.

 

Aventis Pharma chooses Dataworks
Aventis Pharma was formed through the merger of Rhône-Poulenc Rorer Limited and Hoechst Marion Roussel Limited in 1999 and employs 71,000 staff worldwide. The company produces prescription drugs, human vaccines and has a 50% equity stake in Merial, an animal health joint venture with Merck & Co. The state of the art Waterford manufacturing plant has chosen Dataworks to develop a made-to-measure system to control and accurately report on inventory in the engineering stores, update SAP with order/ delivery/ invoicing details, track maintenance hours and apportion costs to cost centres and equipment codes. This system will allow Aventis to effectively automate the engineering stores and maintenance functions.

Dataworks redesigns the Castit website
Castit, a Waterford-based manufacturer and distributor of street furniture & exterior lighting was initially setup as a subcontract service until 1994 when it released its own product. Since then Castit Ltd has developed a complete range of street furniture and also designs bespoke products to customer requirements. Castit is now enjoying great success in Ireland and abroad. Originally designed by Dataworks the Castit website is currently being redesigned to reflect the high quality of their products. The new site, due for re-launch in February features a database-driven catalogue searchable in great detail inputing parameters such as material, design style and many more. A made-to-measure content management system allows the staff at Castit to update and add new products very easily and quickly.

Dataworks joins the Microsoft Empower ISV partner programme
The Microsoft Empower ISV (Independent Software Vendor) programme was set up to support ISVs developing commercial software solutions that natively supports Windows XP, 2000, SQL server 2000, Server 2003 or Microsoft Mobility platform in their development and marketing efforts. The software designed by Dataworks under this programme will go through rigorous software testing carried out by Microsoft to receive the much sought after Microsoft Windows Certification. "We are pleased to have been approved by Microsoft to follow this scheme as this shows ultimate recognition for the high quality and robustness of custom solutions and products" says Marc Roosli, Business Development Manager.


 

Business Intelligence - What is it?

A major theme in 2002-2003 was the increasing use of Business Intelligence (BI) for business process management (BPM). BI goes beyond static data snapshots to enable users to identify and analyse ongoing business trends and patterns. We'll now look back and see what BI is all about.

Background
In the 1980's, finance and telecommunication companies pioneered BI to support financial and market analysis of the large volumes of data that they had begun to accumulate electronically. The need for BI capabilities grew in the 80's and 90's in other industries as companies began capturing data electronically across the full range of their business activities. This need was further compounded by the growing interest in real time data access which required effective tools to mine and analyze dramatically increased data volumes. To support this growing need, large software and services providers like IBM and Oracle launched major initiatives to bring data warehousing capabilities to the marketplace. These data warehouses, or data marts, are the most common sources of data for BI applications. ERP systems have also been used to capture data and enforce consistency, but they tend to be too inflexible to support ad hoc exploration of data. Fortunately, better tools for access and analysis have emerged. These tools usually start with flexible query and reporting capabilities that are combined with some mix of online analytical processing (OLAP), statistical analysis, forecasting and data mining techniques.

So What's the difference between DataWarehousing (DW) & Business Intelligence?
DW - is a way of storing data and creating information through leveraging data marts (DM). DM's are segments or categories of information and/or data that are grouped together to provide 'information' into that segment or category. DW does not require BI to work. Reporting tools can generate reports from the DW.

BI - is the leveraging of DataWarehousing to help make business decisions and recommendations. Information and data rules engines are leveraged here to help make these decisions along with statistical analysis tools and data mining tools.

More about Business Intelligence at http://businessintelligence.ittoolbox.com/

 

If you do not wish to hear from Dataworks again, simply click here and type "remove" as the subject