Data Warehousing is currently one of the biggest growth areas to originate from the database arena. Most companies currently use a database server just to store online transactional data but, imagine being able to answer all those nagging questions easily from the data you already have..... This is Data Warehousing! |
|||
Key Benefits
|
|
||
Data warehousing is the new enhancement to the world of databasing. The procedure involves extracting data from a OLTP (Online Transaction Processing System) or production database into another structure purely for the purpose of analysis. This area of work is commonly known as Business Intelligence or Executive Information Systems. Traditionally companies who wanted to analyse their productivity normally required a programmer to run off a specialised report against the OLTP Database which took a considerable amount of time and effort and then maybe didn't give the results the executives wished. OLAP (Online Analytical Processing) or Data Warehousing allows these executives to create their own queries (questions) against the system using a simple graphical front end tool until the results answer all the questions they require. | |||
Do you
have questions that you wished could be answered simply ? Ever wanted to know how many products were sold per month ? Want to know who sold them ? How much physical space do we have left in the warehouse ? Does our company productivity depend upon square area our business occupies ? Do you have questions on your company performance ? Do you wish that your corporate Database system could provide you with all these answers ? |
If this sounds like something you can make use of then give us a call. DataTech IT Consultancy services can help you make the most from your existing IT solutions. 0844 567 0412 |
||
© Copyright |