Rapid Business Intelligence Tool For SQL Server

Do you find yourself repeating the same tasks over and over; creating staging / warehouse tables, building update procedures, adding measure groups and dimensions to cubes. Its normally the same thing just different data!

 

Our Rapid Business Intelligence Tool enables you to deliver best practice, enterprise grade solutions with ultimate simplicity.

How It Works

The application works by translating a loaded specification file into a complete BI solution. It will connect to the SQL and SSAS instances you select and build the appropriate objects directly in the system. The solution is then ready to use.

 

There are comprehensive options to make sure the resulting solution fits with your naming conventions. 

 

If needed, the application can build date and time dimensions and incorporate them into the solution.

 

You can even reference existing dimensions and add measure groups to extend an existing cubes.

Slash Development Time

Save time and development costs by turning ideas into reality in minutes. Our rapid BI tool does all the grunt work for you. All you need to do is tell it what to build using a simple Excel specification file.

 

Because the solution is built entirely from specification files. These can then be easily stored, shared and deployed across your organisation or clients. 

A Complete BI Solution, Instantly

Our tool allows you to create complete business intelligence solutions at the press of a button. The resulting solution will include:

  • Staging Database
    • All tables required to build your solution
    • Source to Staging ETL procedures
  • Warehouse Database
    • All tables required to build your solution
    • Surrogate Keys for the dimensional model
    • Foreign key relationships ensuring consistency between tables
    • Unknown members in dimension tables
    • Staging to Warehouse ETL procedures
  • OLAP Cube
    • Dimension objects
      • Type 1 & 2 Slowly Changing Dimensions (SCD) supported
    • Measure Groups
    • Dimensional usage configuration
  • SQL Agent Job for executing the ETL and processing the cube

Try it now and see how much time it could save you!

Download the tool now and try it completely free for 10 days.

 

Once you see it in action you'll never look back!

System Requirements

The Rapid Business Intelligence Tool has the following system requirements to run:

  • Windows Vista or later, Windows Server 2008 or later
  • 100MB free hard drive space
  • Access to an instance of Micorosft SQL Server 2008 or later