BIReady Australia
BIReady Pty Ltd
143 Aiken Road,
West Pennant Hills NSW 2125
Australia
Email info@biready.com.au
Telephone +61 (0)2 8880 5111
www.biready.com.au
ABN : 57 167 132 112
Still need to be convinced
about Data Warehouse
Automation?
To hire an ETL developer for three
months at $1500/day
will cost you around $90,000.
BIReady costs a fraction of that,
and delivers in days.
Call us today to find out how you
can get started
using BIReady on a realistic
budget for your business.
Data Warehouse Automation.
How BIReady Adds Value.
Data Warehouse Automation and Why it
is Important for Your BI Project
Data Warehouse
Automation
Technology
Data Warehouse
Automation solves a
great number of the
problems of Data
Warehouses development. Traditional data warehouses are
brittle, hand-coded, complex and expensive. BIReady doesn’t
get rid of the complexity; it automates it, getting rid of the
expensive hand-coded solutions that take too long to
develop.
BIReady’s automated technology is model-driven, which
gives you the power to turn your source data’s meta-data
into the perfect data warehouse design for your business.
This puts your Model-driven Data Warehouse fully under
your control. Changes to the model are implemented
automatically, and you can grow and adapt your Data
Warehouse at the speed of your business. You can design,
generate, adapt - without limits.
Why has Data Warehouse Automation become so
important?
Today’s business cannot afford to wait for vital information.
Dependence on slow, costly, manual data warehouse
development using ETL tools can no longer be tolerated.
Processes that have evolved to become standardised and
repeatable can be made generic and automated. The
frontiers of BI tools were pushed back when reporting tools
became generic – from that moment, you no longer had to
build the equivalent of Cognos, Business Objects or the
Microsoft BI stack by hand.
In the same way, the underlying Data Warehouse and star-
schema Data Marts have followed suit. With BIReady, the
Data Warehouse architecture that feeds your BI tools is now
automated, enforcing best-practices, simplifying the
processes, while driving down cost and development time.
Put simply, BIReady is a smarter, faster, better, cheaper
way to build data warehouses.
Where does Data Warehouse Automation add value
to your organisation?
Automation solves several problems with traditional Data
Warehouse development, both technical and commercial:-
•
Building a new Data Warehouse
Data Warehouses are incredibly expensive to build by
hand. However, BIReady completes the same work
throughout the entire solution straight from your
Business Information Model, and does so with a few
clicks. You can import your data source model from
your favorite CASE/Modelling tool such as ERWin,
reverse-engineer an existing database, or build the
model directly in BIReady. BIReady generates and
executes all the necessary ETL code while giving you
total control over the process – to tweak and adapt the
code for any organisation-specific customisations. Data
Marts can be designed and adapted using BIReady’s
wizard interface. Loading is scheduled and customised
with ease. BIReady works with all major database
platforms including SQL Server, Oracle, DB2, Teradata,
Netezza and even MySQL.
•
Changes to an existing Data Warehouse
As if building a Data Warehouse by hand wasn’t
expensive enough, an even bigger shock to most
organisations is the cost of change. Since current Data
Warehouse technology stacks require tight coupling of
the various dependent components between the
source systems and the final reports, change requests
come with a high price tag. Adapting an existing report
in order to add a new dimension for drill-down has
implications for Data Mart redesign, additional scope
for the normalised Data Warehouse that feeds it, the
ETL back to the source systems, the handling of history
and data warehouse keys and logging. Additional
Change-data Capture code has to be implemented.
Each of these changes must be managed carefully
through analysis, implementation, testing and
transition to the production reporting environment.
Additional complexity is introduced when new
developers make changes to an existing Data
Warehouse - different coding styles, and variations in
adherence to best-practices often create a large impact
on maintainability.
All this is a thing of the past with BIReady. Changes are
quick and easy to manage - even to an already-live data
warehouse environment. Your users experience fast,
dependable updates with no interruptions to their flow
of data.
•
Prototyping
BIReady is extremely powerful for prototyping. With the
Data Shop functionality, BIReady creates Excel Pivot
tables on the fly based on the BIReady Data
Warehouse. This way, data, as a sample report, can be
shown to business users in minutes. Very valuable to
really understand the information requirements
immediately.