Learning SQL Server bi--Data Warehouse design step by step

Since the project has not really started, but has been in contact with BI for more than half a year, preface, these days to get a simplified version of the BI project. On the one hand to the new bi beginners friend a reference, on the other hand also for their upcoming projects to prepare, so that they can take into account the details of some projects. We also want to provide some advice and experience for bi-research friends. Since our case was developed using Microsoft's sqlserver2005 BI platform, here's a screenshot of webcast, which reflects the architecture of the BI project using sqlserver2005.

All right, let's get started. The requirement for this project is simple, because it is a simplified version. This is a sales analysis software for the items used in the game. It includes several concepts, games, sales department, items, transaction amount, number of trades, issuing singular, etc. What we want to do is according to the game, according to the department, according to the goods to achieve the transaction amount, the number of data cross analysis.

In our system, our data granularity is days. Well, since it is a simplified version, we do not need to be so wordy, what needs analysis, analysis and design are saved, the following directly into the database design.

Our database consists of four dimension tables (Department dimension, game dimension, item dimension, Time dimension), a fact table (game Transaction Data Fact sheet).

Departmental dimension table

Game dimension table