Create a Time Dimension with SSAS (DimTime) - 2 Part

After creating our DimTime table in the 1ages part of this article, we will now make some improvements on our dimension.

From experience, I would recommend using a key PKDate int type in format yyyymmdd.

This type of key will allow you to get better performance.

This coding in the format yyyymmdd should be generalized at all levels of our axis time: year, semester, quarter, month, week ... So I suggest that each level (year, semester, quarter, month, week, day) be composed of three distinct attributes:

  • Code
  • Date
  • Last name

Read More Create a Time Dimension with SSAS (DimTime) - 2 Part

Create a Time Dimension with SSAS (DimTime) - 1 Part

The dimension Time (DimTime) plays a very important role in a decision-making system, its presence is obligatory in the tables of facts which characterizes a decision-making system compared to a transactional system.

In the rest of this article, we will create the table DimTime using an SSAS project wizard.

Read More Create a Time Dimension with SSAS (DimTime) - 1 Part

How to create your own SSRS card?

As part of the BI project I'm currently working on, I needed to render my data on a map of several gold countries on visual studio, we found that the map of the United States, so how to do for other countries?

Here is a solution to create our own personalized map.

Read More How to create your own SSRS card?

Feedback (MCSE BI)

Last week, I passed my final exam to acquire the MCSE BI, I want to share with you this feedback especially on my preparation for all exams, it is not a strict guideline of course, but it just what was best for me.

The MCSE certification consists of passing 5 separate exams: the first 3 give you the MCSA SQL Server certification:

Read More Feedback (MCSE BI)