by Ahlyzik M
When a business is looking to increase the ROI, new investments are made and new technologies are used. In the case of businesses that are online, data is increasing at an ever expanding rate and the ability to scale with the demand is slowly being met. Data Warehouses and Data Marts are being used to house business intelligence for companies that are seeking to scale with the demand. In his article, Jason Tiret discusses the key factors of leveraging data models for business intelligence and data warehousing. He mentions that a company must know what their customers want and give it to them. This is done so by conducting interviews with the company’s consumer base. Additionally, Jason states that there are four elements to defining a business data model which are as follows:
- Well formed definitions
- Business Names in the Logical Model
- Reference values
- Dominate assigned to each attribute/column
With these standards, the data will have more integrity and consistency among the data warehouses which is essential when the data is being used by multiples departments. When discussing these standards, one must also take into account security and compliance mappings which are essential in a hostile business environment. Ultimately, he states that clients must see the data gathered in a presentable fashion in order to make the proper decisions.
Jason’s analysis of the advantages of the data models is spot on when it comes to gathering the requirements for general model. After reading the article, it has become clear that without this step in the database development process, it will become rather difficult for programmer to implement and create the database. Jason’s approach to explaining documentation is one that makes the specifications easier to understand for people in business development.
With acts such as Sarbanes Oxley, IT compliance and governance is quickly becoming a standard among all industries as the information held by a corporation is meant to be private. Jason’s advice to uphold these standards will help any company keep their data secure. I believe that as technology becomes more ubiquitous in business, the need to properly structure a database is going to be essential as businesses continue to grow and demand for data increases.
Tiret, Jason. (2010, November 9) Leveraging Data Models for Business Intelligence and Data Warehousing Agility. Retrieved October 9th, 2011, from http://www.dbta.com/Articles/Editorial/Trends-and-Applications/Leveraging-Data-Models-for-Business-Intelligence-and-Data-Warehousing-Agility-71242.aspx