Sample data warehouse for dot net nuke users

Discussion in 'Databases' started by peternolan, Sep 27, 2013.

  1. Hi All,
    for those of you using DNN. I have created a sample data warehouse as part of our product offerings.

    What we do is download our DNN databases and run them in to small data warehouses so that we can keep track of users, downloads, page hits and those sorts of things. I am one of the top BI people in the world and we are using this sample as a sales tool to show people how our ETL software works.

    If you are a DNN user? You are in luck because this is pretty much a "community edition" data warehouse with all the sql you need to run a small data warehouse off your DNN implementation if you want it. Yes..it is free. That seems to be what everyone wants now.

    You can maintain the sql by hand or by anything you want. Our maintenance tool (SeETL) has a modest annual license fee that you only pay if you want to maintain our "source code" in excel workbooks rather than the generated code from SeETL.

    You can get the GA package with manuals, white papers, software and the full sample database from here.

    http://www.instantbi.com/LinkClick.aspx?fileticket=cPsrkXN-POs=&tabid=59&mid=443

    One more thing?

    If you think BI off DNN is a good idea and want DASP to host such? Please let DASP know you would like them to offer that service. Suggest how much it is worth to you to DASP.

    We have been with DASP for 7 years and we like them. We would love DASP to offer hosted BI off DNN or anything else using our software/tools/data models. But the demand has to be there from DASP customers first. No demand? Then no point me suggesting the same to DASP. The first thing they will ask me "how many of our customers do you think would want this". So let us answer that question first.

    I would like to see lots of people have successful BI projects. I have seen too many failures over the years.

    Those of you who want to find out about us? This is our web site. Our claim to fame is that we build ETL/Data Models for data warehouses in about 50% of the people time of anyone else...even if they use SSIS or similar tools.

    http://www.instantbi.com/

    Best Regards

    Peter
     
    FrankC likes this.
  2. FrankC

    FrankC DiscountASP.NET Staff

    Very interesting..
     
  3. Hi Frank,
    I hope so. I would like to see more people have successful BI projects. I have been in BI 22+ years and we see too many failures giving us all a bad name.

    One of the main points of failure is how the ETL subsystem is designed and written. I have been writing tools to address that area since 95. We can build the ETL for a data warehouse in about 50% of the time of the next best and generate the ETL as SQL...so there is no runtime tool. This is how we win our consulting deals.....we have a large cost advantage.

    For the last 12 years I have been implementing packaged data models mostly. We now have a package of models with 847+ tables and 28,000 fields in them. For telco, retail, web and media. There is an obvious overlap with DASPs clients in the retail/web space. So we are giving away the "community edition" (like everyone does nowadays). But our tool to maintain documentation or ETL starts at EUR29.99 pa up to EUR799pa per user so it is not like it is expensive. We just introduced license keys and turned it in to a commodity product. It used to be sold as "all you can eat" so it was more expensive.

    We have a hosting partner in germany www.key-work.de but they only host sizeable accounts. They are not set up to host hundreds or thousands of accounts. So I would like to see DASP do that....but it is your clients who need to see the value....not DASP. If your clients see the value and DASP wants to offer that service? I would love it to be using our stuff. I dropped Dmitri a note since I have talked to him in support so often.

    I have also let DNN Corp know that we have done this....maybe they will like what they see and adopt what we have done. Our web data models are not linked to any specific CMS...it is application neutral....in our clients web is usually just one small portion of data flowing into the data warehouse.
     

Share This Page