This is a continuation from Build a model with IBM Cognos Framework Manager (Part 1). As stated in Part 1, two resources for learning Cognos are the “IBM Cognos 8 Business Intelligence: Official Guide” and the “IBM Cognos Business Intelligence V10.1 Handbook“
What is a conceptual data model?
A conceptual schema or conceptual data model is a map of concepts and their relationships. This describes the semantics of an organization and represents a series of assertions about its nature. Specifically, it describes the things of significance to an organization (entity classes), about which it […]
Building off Dimensional Modeling 101 here are some examples and more detail around specific dimensional models
Three basic types of dimensional models
Star model Snowflake model Multi-star model
Star schemas have one fact table and several dimension tables. The dimension tables are not denormalized.
DM is a logical design technique that seeks to present the data in a standard, intuitive framework that allows for high-performance access. It is inherently dimensional, and it adheres to a discipline that uses the relational model with some important restrictions. Every dimensional model is composed of one table with a multipart key, […]
Please follow us :)5k
- Analytics (21)
- Big Data (9)
- Business Intelligence (59)
- Data Science (70)
- Miscellaneous (17)
Tags2008 Analysis Analytics Article Big Data Book Business Intelligence Charts Cognos Dashboards Data Data Visualization Data Warehouse Design Dimensional Fusion Tables Google Hadoop Humor IBM Logical Market Microsoft Model Modeling Operational Predictive Programming Python R Ralph Kimball Reporting Science Server SQL SQL Server SSIS Statistics TED Tools Tutorial Unstructured Video Visualization Warehousing