Step by step bi-Data Warehouse Design

This is because the project has not really started, but it has been in contact with Bi for more than half a year. I have prepared for the past few days.

Create a simplified Bi project. On the one hand, I will give a reference to my friends who are just getting started with Bi, and on the other

In this regard, we also prepare for the project we are about to start, so that we can take some projects into account.

. I also hope to provide some suggestions and experience for Bi researchers.

Because our case was developed on the Bi platform of Microsoft sqlserver2005

Here we first paste a screenshot in webcast, which mainly reflects the use

The architecture of the sqlserver2005 Bi project.

Okay. Let's get started. The requirement for this project is very simple, because it is a simplified version.

. This is a sales analysis software for the items used in the game. It includes several concepts,

Game, sales department, item, transaction amount, number of transactions, and publication singular. We want to do

The thing is to achieve data on the transaction amount and number of transactions by game, department, and item.

Cross analysis.

In our system, our data granularity is day. Okay, since it's a simplified version,

We don't need to worry so much about what needs analysis and design are all saved.

Go to the database design page.

Our database consists of four dimension tables (department, game, and item,

Time Dimension), a fact table (game transaction data fact table ).
Department dimension table

Game dimension table

Item dimension table

Time Dimension Table

Transaction data fact table

Because our case is relatively simple, the relationship between dimensions and fact tables is also relatively simple.

Single, is a simple star architecture.

This section is written here first. In the next section, I will write the ETL section of this project in detail.