The course begins with a comparison of relational and dimensional data organization and provides an example of business questions not readily answered using more traditional data structures of relational modeling. It then illustrates the steps to design analytic solutions, starting from business questions and concluding by demonstrating an OLAP solution. These steps encompass techniques to capture business questions, represent them as a business solution, translate them into a technology solution, and deliver them to those who need information.
You Will Learn
- Concepts of dimensional data modeling
- The relationship between business metrics and dimensional data
- Similarities and differences between relational and dimensional data models
- Requirements-gathering techniques for business metrics and dimensional data
- How to build a logical dimensional model
- How to translate a logical dimensional model to a star schema design
- How dimensional data is used to deliver business analytics and OLAP capabilities
Geared To
- Data architects
- Data mart developers
- Business analysts
- Business intelligence and data warehouse program and project managers