Latest Blog Posts for BIDW

• Data Warehousing Concepts
  on Aug 28, 2012 in Tutorials Data Warehousing Concept
  What is data warehouse? Difference between OLTP and Data Warehouse Architecture of Data Warehouse OLAP its Types OLAP MOLAP HOLAP ODS (Operational Data Store) Star Schema Snowflake Schema Fact Table... [[ This is a content summary only. Visit my web...
• Fast changing dimension and how to handle it in data warehouse system
  on Aug 25, 2012 in Concepts Data Warehousing Fast Chaning Dimension Tutorial
  A dimensions is said to fast changing or rapidly changing dimensions if one or more of its attributes changes very fast and in many rows. e.g. Consider a Employee dimensions where there are 1000 rows... [[ This is a content summary only. Visit my we...
• Understanding OLAP and Type of OLAP
  on Aug 25, 2012 in Concepts Data Warehousing Data Warehousing Tutorial OLAP
  Online analytical processing is the capability to store and manage data in such a way the it can be used to generate actionable information which can be useful in decision making. As per BI... [[ This is a content summary only. Visit my website for...
• Understanding Role Playing Dimension in Data Warehouse
  on Aug 25, 2012 in Concepts Data Warehousing Data Warehousing Concepts
  Same dimension which plays different role to the fact is called as role playing dimension. Its generally implemented using views in dimensional modeling. e.g. Suppose there are two date entities in... [[ This is a content summary only. Visit my webs...
• Data Warehousing Architecture & Components
  on Aug 25, 2012 in Concepts Data Warehousing Architecture
  Since we know what is data warehouse and its benefits its time to dig deeper to understand typical architecture of data warehouse and its architecture. Following diagram depicts different components... [[ This is a content summary only. Visit my web...
• Understanding Datamart in Datawarehousing context
  on Aug 24, 2012 in Concepts Data Warehousing Misc
  Data mart can be viewed as subset of Enterprise Data warehouse specially targeted towards Business Process or subject area. The difference in Data Warehouse and Data Marts is like that of planning a... [[ This is a content summary only. Visit my web...
• SQL Tutorial – INSERT INTO
  on Aug 21, 2012 in SQL INSERT
  In create table statement we saw how to create table, create table with constraints etc.In this tutorial we we will see how to insert a data into tale using INSERT INTO statement. Once you have table... [[ This is a content summary only. Visit my we...
• SQL Create Table
  on Aug 21, 2012 in SQL free sql tutorials
  Table are the basic building blocks of RDBMS. Tables in DBMS are two dimensional data structure which holds data in the for of rows and column. Table has columns which holds data of specific data... [[ This is a content summary only. Visit my websit...
• A Beginner’s Guide to BI Software
  on Jul 18, 2012 in Business Intelligence Featured
  Analyst firm Gartner reported last year that the US business intelligence software market grew 9.7 percent to $10.8 billion, and growth is expected to only slow slightly from now until 2014. Needless... [[ This is a content summary only. Visit my we...
• Competitor price monitoring: necessary research or waste of time?
  on Jun 18, 2012 in Featured Misc
  Surely if you price your products and services according to their branding, their worth, then they’ll fly off the shelves…? Obviously, I’m playing devil’s advocate and to be more specific, obviously,... [[ This is a content summary only. Vis...

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment