top of page
Writer's pictureMiBiCube

Long Live the Data Warehouse


Data Warehousing as a concept has been around for a long time. It was first developed to get around processing problems in core applications, as well as bringing data together from multiple data sources. The concept works! But it has three fundamental flaws.



  1. It's incredibly expensive. Data Warehouses require consultancy to deliver a model, extract data, Transform it into a single reportable dataset, Schedule the loads and finally to develop Business Intelligence reports. Solutions could take Months of Consultancy and then require the cost to support it in the Organisation. DBA's, BI Architects, BI Developers, Report Writers to name a few. Infrastructure Costs mount up - Databases, More Processors and Memory, Larger Servers, BI Servers, BI software.

  2. It takes a lot of time to deliver: Time for Consultants to review data sets, Model data, Generate extraction code and Transformational code. Typically Data Warehouses take months to deliver phases of the project.

  3. They are not very agile: By the time solutions are delivered changes have happened at the source application level requiring further work to the ETL. Data Warehouses were often seen as a barrier to change as the amount of work needed to generate new ETLs meant corporates would shy away from implementing new technology to their stack.

Solutions were invented to get around this. Reporting directly against Source applications and generating charts side by side became a norm. Products such as Business Objects led the way, directly connecting to databases over ODBC and attempting to tie data sets together via a report. Other BI Companies identified market sectors and developed a Warehouse in a Can solution, with standard insight reports that would run from a special preset cloud Data Warehouse. These all reduced cost but did not eliminate the complexity when Management wanted to query deeper and draw insight from the data.


MiBiCube seeks to address these issues. Our product enables the user to rapidly turn around the Data Warehouse. It generates all the code for you and stores the data in a Cloud Database model of your choice. In this way we can eliminate costly consultancy and bring delivery from months to literally hours and days. On top of this we combine the best aspects of off the shelf software with our Secure Extractor, our Data Loader and our scheduler product replacing costly individual software offerings.


For More information reach out to us on info@mibicube.com

35 views0 comments

Recent Posts

See All

Comments


bottom of page