As we slowly move towards a more data focused society as well as with companies well entrenched in the usage of data, analytics, and business intelligence we see that analysts that are hyper-focused in their area of expertise and job function are increasingly more capable with the nitty-gritty details. However, you’ll see that the […]
A Data warehouse is a repository of an organization’s electronically stored data. Data warehouses are designed to manage and store the data whereas the Business Intelligence (BI) focuses on the usage of data to facilitate reporting and analysis. The purpose of a data warehouse is to house standardized, structured,
If you are looking to get deeper knowledge with Cognos or even to begin understanding the Cognos Software, the best two resources for learning Cognos is the “IBM Cognos 8 Business Intelligence: Official Guide” and the “IBM Cognos Business Intelligence V10.1 Handbook” Here we are going to highlight a part of […]
Ralph Kimball is an author on the subject of data warehousing and business intelligence. He is widely regarded as one of the original architects of data warehousing and is known for long-term convictions that data warehouses must be designed to be understandable and fast. His methodology, also known as dimensional modeling or the Kimball […]
The Data Warehouse Lifecycle Toolkit
The Kimball Lifecycle provides the overall framework that ties together the various activities of a Data Warehouse/Business Intelligence implementation. The Kimball Lifecycle is thoroughly documented and explained in the book “The Data Warehouse Lifecycle Toolkit” by Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, and Bob Becker.
In Ralph Kimball’s book “The Data Warehouse Toolkit” he describes the basic elements of a data warehouse. There are essentially four main components: Operational Source Systems, Data Staging Area, Data Presentation Area, and Data Access Tools. Although Operational Source Systems is part of the model, Kimball states “The source systems should really be […]
It is important to learn about not only those who came before us but especially those who either set the standard or are the best at what they do. Bill Inmon falls into both of these categories.
Best known as the “Father of Data Warehousing”, Bill Inmon has become the most prolific and […]
What is OLTP?
OLTP is characterized by a large number of short on-line transactions (INSERT, UPDATE, […]
What is OLAP?
OLAP is an acronym for On Line Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling. It is quickly becoming the fundamental foundation for Intelligent Solutions including Continue Reading →
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.
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