ProtoMart Efficiently design and construct
Business Intelligence data marts.
  • Home
  • Login
  • Subscribe
  • Contact Us

Validate data mart design before ETL coding

  • Are you frustrated that data marts you build often do not match user requirements?
  • Do you wish there was a quicker approach to delivering prototypes and production marts?
  • Are you tired of tedious re-working of ETL code?
  • Do you wish there was a way to efficiently re-use previous work?

ProtoMart is the answer:

ProtoMart provides the ability to quickly prototype data marts from knowledge of the business along with utilizing existing dimension data from operational systems and/or previously created data marts. ProtoMart also comes with dimension generators and prebuilt models that can effectively quick-start a BI project. With ProtoMart you can quickly deliver prototype data marts complete with realistic, automatically generated fact data.

Design and validate before ETL coding

Invariably, business users need to see a working version of their data mart in order to confirm that what they are asking for meets their needs. Typically, without ProtoMart, users only get to see what they've asked for after the data mart has been built, many days or weeks later. Feedback at this stage, of course, leads to re-work of the data mart or users learn to live with what has been delivered.

With ProtoMart, prototypes can be developed at a fraction of the time and problems in the design can be discovered early in the process. A good design can be achieved before actual BI coding is even started. Instead of building to "requirements", with ProtoMart you can build to a confirmed prototype. With the ability to deliver prototypes in a shorter time frame, you are able to ask better questions which in turn leads to a better solution in the end.

To help you start any given BI project, ProtoMart provides the ability to use common prebuilt ProtoMart models as well as common business dimensions created from ProtoMart's dimension generation wizards. Even though this provides for a quick start, you are not locked-in to a given approach or design style, it is just a starting point.

Boost efficiency and effectiveness

Creating data marts efficiently is only part of the power of the ProtoMart solution. Not only does it automatically generate the required DDL, it also builds/updates the corresponding Star and fills the Fact table(s) with realistic generated data. Stars created with ProtoMart comply with "Kimball" industry standards, and documentation for a ProtoMart model can be generated from which your BI technician can use to configure production ETL transformations.

Full life-cycle support

Use of ProtoMart doesn't stop with creating validated prototypes efficiently. When you move into the construction phase of a data mart, you can iteratively incorporate completed dimensions until a full-functioning production data mart has been built. This will let you blend existing dimensions with new dimensions that are still being designed.

Get started with ProtoMart immediately:

Subscribe today to gain immediate access to all of the contents of the ProtoMart data mart portal and take advantage of the power and time savings that come with the use ProtoMart in your current and future BI projects.

LEARN MORE SUBSCRIBE
  • Home
  • Login
  • Subscribe
  • Contact Us
© 2007 - 2009 Seward Consulting Ltd. All rights reserved.