It has been 26 months since I have started working on ETL and have been part of MDM projects and data warehousing project and also have good experience on developing dashboards using semantic layer endpoints and DAX development. I am also a TX-200 certified. I could achieve all this because of my organization and Timextender. Tx has played a great role in shaping up my career as a developer.

Role level security, Custom filters in DSA(data staging area), multiple types of data connectors, supernatural key using hash key algorithm for data warehousing, drag and drop option to the execution queue.

Won't say any feature is least to use as I have explored the tool in and out for 2 years. Every feature is unique in its own way.But there are areas to improve which is:-external executables feature is not very reliable sometimes.-Multiple environment transfer feature can be improved. when a user has it open then the person trying to promote the project is unable to get the transfer window option unless the active user is logged out.

Creating a data warehouce used for reporting and input for critical bussiness application

Most can be done in the UI without coding. The rest can be added where you want with TSQLDeployment is easyHow easy it is to make a new execution package for a specific purpose

When equivalent TSQL function or reserved word cannot be searched in TimeXtender UI / TimeXtender documentation

Generally positive, it is far easier to develop a model, it does mean sometimes you do things without fully thinking about the bigger picture and have to backtrack later. But even that isn't painful.

It allows the creation of a functional data warehouse very quickly.

When you start to push the tool it would be nice to have intellisense or similar.

my 2 years of using this software have been amazing. Great data warehouse.

The software offers out of the box documentation which makes it easy for first timers to understand.

Collaboration is difficult especially when we want to share data with the rest of the team.

It's solves most kind of business requirements and very easy to use

Data transformations, Relationships ,Customer columns and measures, Execution packages

Some times its not behave properly and Code promotion

time saving and taking away the repetitive work from me

some minor problems with high resolution displays

Data warehous

Easy to implement and change things when changing or adding new data from the source

Some things are little obscure and sometimes difficult to find solutions by googling

I like most getting data from different sources and support.

Transformations using SQL queries. Sometimes I need to use SQL queries because I could not find documentation for transformations.

For the most part, the experience was good. We had TX pro come out and train us and answer our questions about advance features and scenarios.

TimeExtender is a fast and flexible way to build a data warehouse. It can import from multiple file formats. And the interface layout makes sense.

Column deletion -- if you change the file layout, it will automatically delete columns that no longer appear in the layout. We needed the columns to remain as the data is still relevant. The workaround is to keep the column even though you are not using it but we learned that the hard way. Stored Proc calling -- it was not clear how to call a stored procedure and use the results if any.

Ease of use for any user with even a little technical know-how.The visualization of what happens with data is much easier to asses compared to reading raw SQL and keeping track of what is happening (and why)

The pace of development of new features can feel a bit slow..Roadmap for the future would also be lovely as a user