CODEWITHSUNDEEP
ssisssasdata-warehousedatamartkimball
zara rana
zara rana

Reputation: 59

Can we make data marts at the analysis side in kimball approach?

I followed kimball approach but the problem is I didn't make data marts before star schema. Now my question is can I make data marts in SSAS or is it mandatory to make these marts before schema in kimball approach?

More Information: I am building a warehouse for retail store in my FYP. ![enter image description here

[enter image description here]

Upvotes: 1

Views: 279

Answers (2)

Rich
Rich

Reputation: 2279

Data marts should be at the far right of your diagram: specific databases (or cubes!) aimed at a specific use case or audience.

You absolutely don’t need individual data marts before the main data warehouse and the Kimball approach doesn’t suggest you do.

Both Kimball and Inmon can be used for an all in one data warehouse, and then you have the option of making data marts from them, but it is not mandatory.

Upvotes: 0

Amira Bedhiafi
Amira Bedhiafi

Reputation: 1

The recommended practice for Kimball's approach is to design and create data marts before implementing the star schema in the data warehouse. However, if you have already implemented the star schema in your data warehouse without creating separate data marts, it is still possible to create data marts using SSAS (SQL Server Analysis Services).

Just keep in mind that data marts are subsets of the data warehouse that are focused on specific business areas or subject areas. They typically contain aggregated and pre-calculated data optimized for analysis and reporting purposes. While it is ideal to design data marts upfront in the Kimball approach, you can still create them after implementing the star schema.

In SSAS, I used to define separate cubes or tabular models to represent the data marts. You have the possibility to model the dimensions and measures specific to each data mart and populate them with data from the existing star schema tables in your data warehouse.

In contrast to the Kimball approach, the Inmon approach to data warehousing emphasizes the creation of a centralized enterprise data warehouse (EDW) that serves as a comprehensive and integrated repository of data from various sources. In the Inmon approach, the focus is on building a normalized data model that captures the entire range of business data across the organization.

Upvotes: -1

Related Questions