Data preparation for Analysis – New Tools and Savings
davekeys2014-04-28T11:47:08+10:00A few weeks ago I went to the Tableau On Tour Conference in Sydney, an excellent event. What really got my interest was subtle changes in complimentary tools for the back end, not Tableau’s back end (tho there are some excellent changes coming in 8.2) but in the data preparation market.
Most people look at Tableau (quite rightly) as the tool of choice for analysis and visualisation of their beautiful datasets to tell the compelling story they know (or assume) is their for the taking.
However most organisational data sources are complex and disparate in nature and rarely comprise a single large table that can be pivoted for that magic business insite!
Preparation of those datasets can be via as many disparate sources, mechanisms & routines as one can imagine, getting control of these dataset’s is the daunting task only surpassed by making these datasets/sources systemic/repeatable, reliable and governable (You want what! A single source of truth!).
To enable and prepare the data for extraction of these business insights some excellent tools have been around for some time like Wherescape Red and BI Ready these make Kimball Schema or star style data warehousing relatively easy but are not cheap.
The new kids on the block however are excellent and nimble as well as much more reasonably priced for mid size (and large) business. The products on show were LavaStorm and Alteryx Software.
Here are some observations and reasons I expect to see a lot more of these guys around the traps:
|
These products offer exceptional data preparation capabilities at a very good price point that will pay for itself easily in effort expended on data preparation.
I am in the process of comparing these products and early impressions are excellent, feel free to get in touch if you wish to find out more.
Stay In Touch