Category: 

What is a Data Mart?

Article Details
  • Written By: Katriena Knights
  • Edited By: A. Joseph
  • Last Modified Date: 09 November 2016
  • Copyright Protected:
    2003-2016
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
Helium is the only element that was discovered in space before it was found on Earth.  more...

December 10 ,  1948 :  The UN adopted the Universal Declaration on Human Rights.  more...

Data warehousing has become increasingly important to modern companies as the amount of data necessary to remain competitive and make informed decisions about the future of a company has become greater and greater. A company's entire data warehouse often consists of a collection of data marts, sets of data that typically are focused on a particular department or area of the company. Combined into a data mart warehouse, these data marts help support the information system of the entire company.

A data mart might be dedicated to customer data or sales information, or it could be constructed specifically to support a company's human resources department. In some cases, data marts are compiled from data from the main data warehouse. Many companies, though, take a bottom-up approach to data warehousing and instead build the overall data warehouse by compiling data mart data into smaller systems, then combining them into a company-wide data warehouse.

One important factor in building a data mart is usability. Because the data mart usually is aimed at supplying information to a specific department for a specific purpose, the data must be easily accessed and processed. A company's Information Technology department or Management Information Systems specialists often focus on this area, ensuring that an easy-to-use interface exists so that employees, including managers and other high-level personnel, can access the data mart data and use it within the course of their jobs.

Ad

Individual data mart design depends on the specific needs of the company or the individual department. Most data is organized into relational databases, with a database management system implemented company-wide in order to let individual employees easily access data, generate reports or perform other necessary day-to-day functions. Some companies require more complex data processing that makes use of multidimensional databases. Still others use database functionality that allows multidimensional data analysis while still using the simpler and less costly relational database management system.

For the most part, data warehouses are built by adding data as it comes into the company's systems. Updates to data are not as important to an overall view of company performance as data that has been added to and compiled over a longer period of time. Managers can use data from the data mart to view company trends, sales patterns and efficiency of individual departments and to make forecasts about future performance. At this strategic planning level, the data mart and data warehouse are invaluable to those planning the future of the company.

Ad

You might also Like

Recommended

Discuss this Article

omgnotagain
Post 3

@kangaBurg – I agree with smartypantz that a data warehouse is the way to go. I’m in information management too, and planning a data warehouse can seem really intimidating, but just break it into small pieces and you’ll do fine. During the planning phases, don’t forget to figure out the scope and cost of the project, as well as how long you think it will take to complete.

Things always seem to come up, so I always add an extra month or two to my initial time estimate. It leaves me some breathing room and makes it easier to finish the project on time.

I recommend that because nobody likes it when a project lasts longer than it’s supposed to.

smartypantz
Post 2

@kangaBurg – I’m sorry, but your boss is right. I used to work in data warehousing, and from my experience, when it comes to a data warehouse VS a data mart, the data warehouse wins.

When I first started in information management, I ignored data warehouses. Like you, I thought that working with only data marts would save me some time. After a few months, however, I realized I was wrong. Many of our data marts had the same data in them, and that messed up our analyses. Also, it was hard to compare information from different data marts because we didn’t have an efficient way to move the information.

If I had planned the data marts with a

warehouse structure in mind, it would have saved me a lot of trouble. I nearly got fired because of my oversight. I had to restructure our entire data management system.

Afterward, it was much easier to analyze our customers’ data. My boss was able to find places where we needed improvement, like customer service and so on. We made those changes and our sales improved significantly.

I strongly suggest that you start off with a data warehouse and don’t cut corners.

kangaBurg
Post 1

I’m in charge of planning a sales data mart for my employer. My boss wants me to plan and develop an entire data warehouse. He thinks that will allow us to analyze the sales data better, but it just sounds like extra work to me. How can I convince my boss that it’s better to only develop a data mart?

Post your comments

Post Anonymously

Login

username
password
forgot password?

Register

username
password
confirm
email