SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Business Intelligence Prototyping Tool


Business Intelligence Prototyping Tool

Author
Message
Barakuda
Barakuda
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 71
Hi All

I'm developing a utility for rapidly prototyping full BI systems based on specification files. The idea is that an architect can design the system using Excel, run my utility and instantly have a full system (Staging, Warehouse, Cube, ETL procedures & Agent Job).

The utility is ready for beta testing and I'm looking for guinea pigs to put it through its paces.

Let me know if you're interested.

Cheers
Dan
larskandersen
larskandersen
Old Hand
Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)

Group: General Forum Members
Points: 348 Visits: 1032
I am interested in it for spin and let you know my thoughts.

Cheers
Lars
Barakuda
Barakuda
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 71
Hi Lars

I've sent you a PM with details.

Many thanks
Dan
Barakuda
Barakuda
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 71
It's been pointed out that I probably need to give a better explanation of what my tool does and why I think you guys will like it so..

As a freelance BI consultant. I constantly find myself 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 and naming conventions.

My tool, which for now is called RaBIT (Rapid Business Intelligence Tool), aims to alleviate that grunt work by building the whole lot for you. The tool uses a specification file as its input which is not a great deal different than what you would expect from a decent technical spec document so the initial overheads are low. The tool reads the spec file in, determines what objects need to be built, confirms what the solution will look like, then goes away and builds it. You can effectively go from a specification to a full BI solution in seconds.

The resulting solution includes; staging tables, warehouse tables, dimensions, measure groups, a cube and the ETL procedures needed to populate the lot. It supports degenerate and SCD type 1 & 2 dimensions. It can build you basic date and time dimensions. It creates all the appropriate primary keys, surrogate keys and foreign keys. It can even be used to extend existing solutions, tacking on measure groups and dimensions to existing cubes or making use of existing dimensions in new measure groups and cubes. There are comprehensive settings that can be adjusted so the resulting solution fits with whatever whimsical naming conventions are needed.

The bottom line is that it can save you days of that tedious development work we all do on a regular basis.

The tool currently only works with versions of SQL Server 2008 R2 or later but I hope to add support back to 2005 at some point.

Volunteers for the beta test will receive free lifetime licenses to the application and all future updates. All I ask ask in return is feedback.

There is a free trial of the tool available to download from my website www.barakudabi.com/rapid-business-intelligence/

I'm still waiting for my software publisher certificate so you will probably get an install warning, if you aren't comfortable installing without this you could always spin up a VM and try it out on there.
Edit: Certificate is now added so we're official Smile

If anyone is interested in a beta license please send me a PM and I'll arrange an activation code.

Many thanks
Dan
sqlvogel
sqlvogel
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2090 Visits: 3706
Possibly some people will have a problem with the suggestion of prototyping a BI solution. Agile methods are increasingly what's expected of BI projects. Agile emphasises iterative delivery rather than RAD and "prototype" is an offensive word to many agile practitioners ;-) Just a thought, although I haven't tried your tool.

You may be aware that there are other metadata driven BI in-a-box type solutions. Examples:

BIML
Wherescape RED
Kalido

RED and BIML are developer tools whereas Kalido is also a production data integration engine. Personally I prefer the development tool approach.
Barakuda
Barakuda
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 71
Hi David

I appreciate your point about agile development but there are often cases when you need/want to knock something up quickly.

I'm familiar with the tools you mentioned but I think our tool provides something different. It's definitely a developer tool and requires a good grasp of dimensional modelling.

Why don't you give it a try and feedback your thoughts here. I think you'll be pleasantly surprised Wink

You can download a free trial from our website.

Many thanks
Dan
Barakuda
Barakuda
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 71
Thanks to everyone who volunteered for the beta program, the response has been fantastic.

We now have enough people and will not be issuing any more beta licenses.

The application is still available as a 10 day trial from our website if anyone fancies giving it a go.

Many thanks
Dan
xsevensinzx
xsevensinzx
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5087 Visits: 3128
Aww man, I missed the beta. I would have loved to have tried it. Please let me know if there is more. I'm designing a pretty large BI solution and would love to test new and upcoming tools.
naveenka
naveenka
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 46
Thanks Barkuda and Mr. Dan,

I had the opportunity to test out this tool and it is an amazing tool to say the least.

You define all the definitions of the dimension model in a Excel spreadsheet and the application creates a staging database, relational data warehouse and all the stored procedures to extract the data and it also creates the Analysis Services Database, SSAS cube and a SQL Agent job to populate the staging db, relational data warehouse and to process the cube.

The tool definitely helps to get an initial prototype of a BI solution in place in minutes which can be refined further by any experienced BI professional.

Thank you.

Naveen


Naveen Abraham
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search