Sunday January 21st 2018




‘Data Mart Schema’ Archives

Case Study of an Auto Insurance Company for the Data warehouse

Case Study of an Auto Insurance Company for the Data warehouse

This case study is an assignment I submitted and hence sharing with readers. ABC Auto Insurance is under immense pressure from competitors due to reduce Auto Insurance prices and high risk underwriting. ABC Company has huge data resources from business operation, however, it is difficult to get required information in timely manner. ABC Company [...]

Master Data management (MDM) – Why it is critical?

Master Data management (MDM) – Why it is critical?

Right Master Data management (MDM) provides single version of the truth, MDM is critical to impact business positively. With proper (MDM), you will know exactly what products your customers have, what items you buy from selected vendors and business relations with your customers. Customer’s can be contacted with confidence. Staff must agree [...]

Data Mart – Top Down and Bottom Up approaches

Data Mart – Top Down and Bottom Up approaches

Top down approach Single, central storage of data with centralized rules and control. Top down approach takes long time to build, high risk of failure. As they are not driven by end-users needs, there may be information needs gap. Bottom Up approach Faster and easier implementation of manageable pieces of information. Inherently incremental [...]

What is Dimension Key

A quick review about Dimension key. Dimension keys uniquely identify each record in a dimension table. The purpose of dimension keys is to relate one dimension table record to a fact table record. Thus, the dimension key must be stored in both the dimension table and the fact table.

What is a Data Mart Structure ?

In Business Intelligence frequently similar topics are represented by different words. Specialy in Job interviews it is important to have a grasp over different terminologies. We tried our best to elaborate some terms used in Business intelligence, Data Warehousing and Data Mart. If readers have some more to add / please feel free to submit [...]

Graduate Admissions Star Schema

This post is about Intro to Admissions Data Marts workshop at George Mason University. The purpose of including that in is to provide another example or general understanding on Data Marts. This workshop in addition to giving a Data Mart Structure also give picture of Graduate admissions Star Schema. We find this a good example of [...]

Dimensional Data Design – Data Mart Life Cycle

A data mart is a persistent physical store of operational and aggregated data statistically processed data that supports businesspeople in making decisions based primarily on analyses of past activities and results. A data mart contains a predefined subset of enterprise data organized for rapid analysis and reporting. Read More

Financial Data mart example

We have found an example related financial data mart please visit on this link to see more

Health Care Claims Data Mart, University of Maryland Baltimore County Stuart B. Levine, SAS Institute Inc is continuously researching and finding on as many example related to data mart, data warehousing and business intelligence topic as possible. Following is another related post, links to main site are also provided at the end; Health Care Claims Data Mart: Construction and Exploitation Marge Scerbo, CHPDM, University of Maryland [...]

 Page 1 of 2  1  2 »