Most businesses need insight into how their IT offerings are being used to make informed decisions about where to place future investment. Tools that generate reports are often used to provide decision makers with the data they need. As a business understands more about their customers, the types of reports needed and costs associated with creating new ones quickly become a barrier to success.
Additionally, when you operate and deliver IT products and services, data is generated about transactions as your customers use them. When these systems are designed for data entry though applications, changes to the data are overwritten and history is often lost. This makes having an audit trail of changes made to data challenging.
I help teams to plan for and implement data architectures that are designed for answering business questions. This design is known as a dimensional model, and became commonplace in the early 1990s when Ralph Kimball created a group for furthering education in this field. Dimensional models can be created using a simple relational database like Microsoft SQL Server, MySQL, or Oracle as well as “big data” technologies like MongoDB and Hadoop. Depending on what information your business needs to analyze and the volume of information, I can help you select an appropriate architecture that will scale with the needs of your business and become a well of information from which the entire organization can benefit.