Monday, August 6, 2012

Business Focused Analytics – The Starting Point

Having been a Business Intelligence practitioner for the last 13 years, there has never been a more exciting time to practice this art, as organizations increasingly realize that a well implemented BI & Analytics system can provide great competitive advantage for them. This leads us to the question of – ‘What is a well implemented BI system?’ Let us follow the Q&A below.

Q: What is a well implemented BI system?

A: A well implemented BI system is one that is completely business focused.

Q: Well, that doesn’t make it any easier. How can we have BI that is completely business focused?

A: BI & Analytics becomes completely business focused when they have ‘business decisions’ as the cornerstone of their implementation. The starting point to build / re-engineer a BI system is to identify the business decisions taken by business stakeholders in their sphere of operations. Business decisions can be operational in nature (taken on a daily basis) and/or strategic (taken more infrequently but they tend to have a longer term impact). To reiterate, the starting point for BI is to catalog the business decisions taken by business stakeholders and collect the artifacts that are currently used to take those decisions.

Q: The starting point is fine – What are the other pieces?

A: The next step is to identify the metrics and key performance indicators that support decision making. In other words, any metric identified should be unambiguously correlated to the decision taken with the help of that metric and by whom. Next we need to identify the core datasets in the organization. Please refer to my earlier blog post titled ‘Thinking by Datasets’  on this subject.

Q: What about the operational systems in the landscape? Aren’t they important?

A: Once we have documented the relationship between Business Decisions to Metrics to Datasets, we need to focus on the transactional applications. The key focus items are:

  • Inventory of all Transactional Applications
  • Identify the business process catered by these applications
  • Identify the datasets generated as part of each of business process
  • Next step is to drill-down into individual entities that make up each of the datasets
  • Once the Facts & Dimensions are identified from the entities, sketch out the classic ‘Bus Matrix’ which would form the basis for dimensional data modeling


Q: All this is good if we are building a BI system from scratch – How about existing BI systems?

A: For existing BI applications, the above mentioned process could be carried out as a health-check on the BI landscape. The bottomline is that every single report / dashboard / any other analytical component should have traceability into the metrics shown which should then link to the decisions taken by business users. BI & Analytics exist to help organizations take better business decisions and that defines its purpose & role in an enterprise IT landscape.

The answers mentioned above provide the high-level view of Hexaware’s approach to Business Intelligence projects. We have worked with many organizations across industries and a business focused analytical approach has provided good value for our customers.

Thanks for reading. Please do share your thoughts.


Some of the content wise details are the best and especially middle part is the best for me and my knowledge.

SEO India

My cousin recommended this blog and she was totally right keep up the fantastic work!

Outsource Product Development

Great post. My business could use a little help and some of my employees suggested I look into a few seo firms. I don't really know much about seo so I have been doing some research, that is how I came across your post. Thanks for sharing!

I don't really know much about seo so I have been doing some analysis, that is how I came across your publish.
Internet Marketing in london

http://Paidbounty.Com/?share=30317 plz chk it

SEO emerged a great practice for promoting your business via your online website. There are many companies which are doing this, but some companies like Acceleration are deserves to be known as Best SEO Firm In India.

Thanks for your ideas. You can also find the details on Affity Solutions, at the Internet marketing company Australia. The main object of the Affity Solutions is to provide quality web services and is among the few software development company in Australia.

Thanks for sharing this wonderful post...Pls visit us: ecommerce india

Thanks for sharing this article.Really looking forward to read more. Awesome.
Website Design Training Courses In Coimbatore

A very good blog post! This will really help the business owners.

best seo company in chennai

top seo company in chennai

Assuredly beneficial guidance published by you. I like the way you stick to the point of interest and impart your valuable insights among us. Continue blogging. Professional Web design services are provided by W3BMINDS- Website designer in Lucknow.
Website Design Agency | Website design company in Lucknow