Playing with Facts & Dimensions in DW

As promised in the previous post.. lets learn some more on the DW Schemas and the Facts and the Dimension Tables. Before jumping directly to Facts and Dimensions lets first understand where and why exactly are these Facts and Dimensions used?? So lets start with the DW Schemas....

DW Schemas

A Schema is a collection of Database objects like tables, views, indexes etc. The DW schema is designed based on the model of the source schema and the requirements from the users. There are number of other things that decide the design of a DW and can be classified in 2 categories:
Physical Design
Logical Design
But we wont go into so much details about the DW and lets focus on the Schema Types.
So as discussed in the previous post there are 3 types of Schemas:

Datawarehousing revealed..

As we have studied in the previous post that Analytics makes use of common indutry techniques like Datawarehousing and Dimension Modelling, so lets have a brief overview of what is Data Warehouse and what are the Data Warehousing concepts....

What is a Data Warehouse???

A Data Warehouse is a Relational DB that is designed for query and analysis rather than using it for Transactional purposes(eg. OLTP DB). It contains historical data derived from the transactional data and can also include data fromn other sources. In addition to relational DB it also includes an Extraction, Transformation & Loading(ETL) solutions, Online Analytical Processing(OLAP) & Data Mining capabilities.

Lets start with the Basics

Hi All

Lets start with some basics for why we use Analytics. I knw this is a very basic thing and everybody must be knowing this but still there are a number of newbies who wana learn BI and search for some matter on the same. So lets start...

WHY ANALYTICS???

First of all Analytics is a Reporting tool which provides users with the data and tool to answer their queries that are important to run their business. Eg. The users like Managers etc. need reports to check how their business is going on  and what are the profits and lossess, and what opportunities are there in what all regions etc. These reports can be made available to the users on just a click using Analytics. The users dont have to write queries or take out xcels and do all such efforts.