You might also be interested in
Replies (7)
Please login or register to join the discussion.
BI is better than it was presented
I'm a bit surprised by the Microsoft answers. As with all reportng tools you only get out what you put in.
All of the data you wanted to see is available and is easily calculated if it is not. The analysis services and integration services combined can be used to filter out specific data and be made to calculate columns. And you can include as much or as little as you want in your data warehouse.
Gulf between IT and accountants
"IT technologists don’t understand the numbers" is an interesting point. I recently exchanged some comments with Stephane-Robert Langer ( http://blog.srlanger.com/ ) where he observed that IT departments typically manage the storage and connectivity to large volumes of data without being accountable for the values. Conversely, accountants working with the same data are usually less concerned with the database but are accountable for the values and meanings contained.
This seemingly small difference in the perspective of two sets of professionals looking at the same set of data makes a world of difference in practice. I believe too many accountants shy away from technology, because it's the domain of IT, and fail to realise that only they can provide the meaning. The result is IT systems that fail to deliver what is truly required.
Lets not play party politics with BI
As a member of a firm of accountants who successfully use a BI solution I would make the following comments:
OLAP is only one element of a reporting strategy, but a very powerful one. Its strength is in presenting clear management information from a mass of underlying detail. Traditional transaction reporting systems fail to do this in an efficient and flexible way due to the resources required to process high volumes of source transactions. A complete reporting strategy does need to include elements that cater for detailed reporting where appropriate. It may be that David has misunderstood the scope OLAP is currently designed to address. The OLAP solution should not be criticised for what it doesn’t do, but admired for what it can.
David implies that this technology is new. We have been successfully using this technology for over 4 years. Microsoft should be congratulated for making this technology available to medium to small organisations at a price which represents extremely good value for money. However, it should be pointed out that the skill set required to deliver an effective OLAP solution is very different from that associated with a traditional transaction reporting system. This skill set should be identified along with the software product in order to ensure an effective solution. This is no different from looking for the correct skill set to deliver effective tax or accounting advice. We are fortunate to work with APS as our OLAP solution provider. APS have many years experience in both the OLAP and professional services domain and this has been vital to the success of this part of our reporting strategy.
For any successful reporting solution to be delivered (be it OLAP or traditional transactional), teamwork between the users and the developers is essential. It is as easy to deliver a poor transactional system as a poor OLAP one. What is vital is that both disciplines acknowledge each other’s potential contribution. IT developers are clearly not accountants and vice-versa. The best solution will come from the combination of the two skill sets. Our IT department has worked closely both with internal project teams and APS to arrive at a solution which works. It’s not about accountants knowing more than IT developers or the other way round, teamwork brings the best results in today’s business world.
In summary, the tone of David’s article runs the risk of influencing views in a way that may result in firms missing out on the significant benefits of a readily available technology. BI is not solely OLAP, it just tends to be sold that way. BI is about using a set of tools and solutions to satisfy ongoing reporting requirements which will enable a firm to run efficiently and make not only the IT developers and accountants happy, but ultimately better serve the customers. Surely that is in everyone's interest.
Doing things right with the right things
Neil's response is spot on. Its been our experience that Accounting Firms, particularly the Top 100, have been looking towards OLAP to deal with their Business Intelligence / Reporting issues for some time.
Here is an another example of a leading UK practice, like Armstrong Watson, that implemented OLAP over 5 years ago.
http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=52206
Brian Coventry
APS
Doing BI with Excel 2.007 and Pivot Tables
I am consultant for small companies in Spain.
I have read a lot about OLAP, altough I haven´t use it yet. Small companies I work with don´t have SQL Server. They only use Excel, Access and traditional accounting software.
In the case of small company without sql server:
Don´t you think that BI can be easily implemented with Excel 2.007, pivot tables and macros? It sounds to simple, but people love simple solutions.
(it is very easy to import a text file with accounting records and then apply pivot tables).
I would like your point of view !
BI for Excel 2007
Rolo
Happy to discuss how OLAP works with Excel 2007. We have been very impressed with the BI capability that Microsoft has built in to Excel.
+44 (0) 870 351 4878 or [email protected]