BRIAN CIAMPA
Enabling excellent decision making through data warehousing and business intelligence

About

I believe that data tells the objective story of where a person or an organization has been over a span of time. It can also be a predictor of what lies ahead. As a result, when organizations leverage that data, they start to see it as being a truly valuable resource.

Helping decision makers to see the true value of their data is a passion of mine. A pile of data sitting in a system is just that...a pile of data. However, if that data is warehoused it has the potential to give the leaders of an organization insight into things like...

  1. For a given time period, what is the cost vs. productivity of each individual, department, and/or line of business?
  2. In a given year, during which time periods does revenue peak or decline?
  3. Over a five year period, how has this individual, department, and/or line of business performed? Drilling into the data, which details have contributed to that performance?

Whether it involves dimensional modeling, writing ETL, or creating reports, I love to help others tap into the true value of their data, thus enabling them to make great decisions. Business Intelligence is a great career path for those who love to work with data. If this describes you, consider these resources to help you as you show others how to turn their data into something that is truly valuable...

  1. The Books area of the site (available on the navigation bar above) is intended to help you grow in this area.
  2. Terms - This page explains some general terms that are often used in the world of data warehousing.
  3. Basic Concepts - This page contains an ERD which depicts a very basic star schema. Click on a table to understand the role of that table in the design.
  4. Advanced Concepts - This page contains an ERD which depicts a more advanced schema, called a snowflake schema. Click on a table to understand the role of that table in the design.
  5. Valuable Data Blog - For hands on practice and other thoughts about the data warehousing and business intelligence arenas, view my blog.
  6. Feel free to contact me. I would love to hear from you.