This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We are starting to use Alteryx as a full ETL DW build tool (and blogging about it too..)
Compared to other tools in the market there do not seem to be the usual SCD(slowly changing dimension) and other "standard" tools or templates to start building.
It would be great to have a template/Macros/guide to starting to build a DW solution. It is rather daunting starting with a blank page!
This is an interesting idea and is something that I think we've heard about from others in terms of metadata management. Would be interested to hear if there are others that are looking for similar functionality.
I have only just started this but intend to update every couple of days. Will endeavour to add diagrams and pics to explain thoughts too.
Feel free to share link.
This is something that comes up from time to time with other clients, I have blogged on items such as SCD: http://www.theinformationlab.co.uk/2015/07/03/slowly-changing-dimensions
I'd also like to start putting together a blogging guide to DW via Alteryx, the challenges come from where to start and what level to hit. @neil_randall what would you like to cover? My thoughts:
Primary Key tracking / updates
Full refresh vs Incremental
In terms of macros every requirement is subtely different, I think it's going to be hard to create a set of macros but we can show the underlying principles and how quick it is for you to build out macros to do your specific requirements in Alteryx.
Look forward to hearing thoughts from you and others on this subject.
I‘d love to use Alteryx as ETL tool for any DW projects when we see below features
hope these optiones will help us to start with typical ETL with Alteryx 🙂
We are also looking for better Stored Procedure support (eg accepting parameters) for SQL Server.
We are new to Alteryx but are certainly interested in the possibility of using it for ETL in addition to the usual BI/Analytics applications.
As we're new, I can't do much more than register interest in the idea.
I've come accross change data capture being mentioned in RFPs when we told clients Alteryx does data blending and can be used as an ETL tool...
So I second the idea of developing DWH Macros, even we can have a district for that...
Gartner shared Alteryx position in a recent slide... at the intersection of ETL, BI and Analytics...
I believe recent visualisation and reporting development + predictive district and macros should be balanced with more ETL and data quality related developments to keep Alteryx in the crossection...
Blog seems not up-to-date, http://journeysindata.blogspot.co.uk/, any updates on this anyone?
Fully agree with the need for native support of basic DW needs such as:- Synchronise tables
- Conform to a dimension
Looking at what Tableau just announced this week at TC17, project Maestro then brings in the other piece - making data blending & cleaning visual and simple for users.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.