Many data scientists have years of higher education invested in becoming one. In their professional work life, they have had to probably go through many rings of fire before elevated to the title of data scientist in their organizations. Based on personal experience, reading through college curriculums, blog posts from data scientists, research companies’ papers […]

Attribute Roles The support of attribute roles is among the most requested features in the schema/modeling area. It is the result of a common modeling practice where two or more attributes are defined using the same lookup table and column. When these attributes are placed on the same report, the result may return no data. […]

A Star Schema is a design that contains only one lookup table for each hierarchy in the data model instead of having separate lookup tables for each attribute. With only a single lookup table for each hierarchy, the IDs and descriptions of all attributes in the hierarchy are stored in the same table. This type […]

Question Which of the following issues can result from many-to-many relationships? A. Exclusion of some attribute elements when drilling B. Multiple join paths to fact tables C. Missing values on reports including all attributes from the hierarchy D. Multiple counting when aggregating data from base fact tables E. Lost analytical capability Answer Both D. Multiple counting […]