What are the top five reasons you use EDT?

EDTers, I have to create a demonstration about EDT.
Can you please help me, by listing your top 5 reasons you use EDT? What problem does it solve for you?

Please consider helping me out.

@mklopfer - What about you?

1 Like

EDT is almost a secret weapon. I can consolidate multiple spreadsheets faster than any of my coworkers.

Top five reasons I like EDT?

  1. It’s very quick and easy to use.
  2. It’s quick to debug. If at first a report doesn’t come out as needed, just look at intermediate output from each transformation. Sometimes I have little stubs off the main flow where I filter to watch a single record.
  3. Spreadsheets become databases without the need to know SQL. Even if you are comfortable with SQL (I am), EDT is fast and intuitive
  4. It’s cheap for what it does. I got EDT to browse tax district data. I documented abuses in the system and I think I’ve rooted out some crooks.
  5. Andy Brice. Great customer support and active development.

My first use of EDT more than justified its cost.

3 Likes

EDT is a gem of a tool. In no order

1It has wider applications than one might first think. as an example, I have taken to reading XML files as plain text, and then using the transforms to manipulate data. in this way you can deal with complex structures more easily, IMHO. You will continue to discover applications for it all the time.

2 Javascript inclusion - really simple to use implementation but it expands the capabilities enormously.

3 Very efficient
price  matching
matching 4.4m stock exchange prices to codes - 2 seconds

or
dret02aout

Writing out 8.6m accounting records with 95m dataset values, 1.2Gb in less than 17 seconds.

4 It’s crazy cheap. My lawyer charges me the licence fee every 15 minutes she works.

5 Incredibly user friendly. Minimal manual reading time. You should know what to do just by looking at - the mark of well designed software.

6 Support, and Andy B. Amazingly responsive.

@DanFeliciano , I’ve got some slides which may be of some use. Message me if you are interested.

2 Likes
  1. Automate data entry that requires logic.
  2. To bulk update large spreadsheets, where excel/vba might crash
  3. When power query crashes or takes too long, I pre-format —> PQuery —> Data Model
  • Formatting Vendor spreadsheets from hell
  • Even with a hasty website scrape, I can extract relevant info with a “chunk” of HTML.
  • Then automate to format a a specific format

@DanFeliciano
Who are you presenting this to?

2 Likes

Absolutely confirming and subscribing on all this 5 points. Same here. And I actually have a license for SPSS Modeler and find myself many times using EDT instead because of being so easy and intuitive. The only thing I am missing to put SPSS aside for most things related to data cleaning and wrangling tasks I have to do is for EDT to not forget the column positions every time I have to put a new transformation in the middle or I change slightly the source file column structure. I know @Admin promised he was going to look into this… that would be the key: sometimes is very very annoying to have to fix the entire stream transformations because of little adjustments.

2 Likes

Hi @mk2109, I have a large international consulting firm as a client and they need a tool their consultants can use to aggregate and prepare data in multiple formats for analysis.

1 Like

I also am a huge fan and promoter of EDT.

I primarily have used it so for for new software implementations

  1. Preparing the data from the legacy systems for conversion into the new system.
  2. Validating the conversions - comparing the legacy data to the new system data
  3. Validating Parallel Tests - comparing documents from the legacy systems to the new (for example: comparing all paychecks from a pay period created in the legacy system to what would be the paychecks in the new system.)
  4. EDT has got me out of several jams and it seems like there is not much I can not do with EDT and Excel. It is fun and efficient to use!
    Thanks,
    Dave
2 Likes

My wife is a fractional CFO and does bookkeeping (QuickBooks) and accounting. I use EDT to create an uploadable file to QuickBooks from very crappy downloaded Point of Systems reports.

I understand what you’re saying. I started using EDT I think about a year ago maybe longer and the support team has been very responsive. For example, there are several transforms that I think were based on my suggestions. Or at least I like to think that. ; j

1 Like

I use EDT because I process the same reports daily with only a few changes in the numbers of these reports. Once I have the processes saved in EDT, I can use it over and over again without worry of a Excel marco messing up.

1 Like

Hello sir, the debate is closed since long but the question is still interesting. So here are my tops:

  1. EDT is visual & easy to fix when a step breaks. Moreover you can check data consistency at every step. You can document your flows. You are in control from A to Z.

  2. When you are in Excel’s Powerquery and need some info in another spreadsheet your current view locks everything in Excel. You need first to save & exit, consult then get back. With EDT I am free to open whatever I need, no limitation.

  3. Usually in Excel you have: 1 Powerquery 1 output sheet. In EDT my transformations have many outputs and many joins with outputs of outputs. it is like playing a 2D game versus a 3D game, there is no comparison possible.

  4. Our ICT department automates 80 pc of the flows and leaves the 20 pc left to the users. You know the last 20 pc that are difficult to track, modelize, automate…
    Those 20 pc are in fact millions of rows for me. As you know in Excel, a sheet has a 1 M rows limitation. I know the Data Modeler feature but there you have to play at column level (and I need to stay at cell level). Well, EDT can process millions of rows in an eyeblink. It is like driving a roadster, so agile (today I am close to 1 Billion rows processed and it continues to grow). With EDT millions of rows do not scare me anymore.

  5. You can easily include a transformation in a short script for repetitive tasks. In Excel you can vba your workbook but it is less straightforward (I speak for myself). I would say in a general way, Excel works best with Microsoft galaxy while EDT works with anything (I use it in combo with many non Microsoft tools without any problem).

  6. EDT is so versatile that 2/3 of my transformations are GET (it gets data for me) and 1/3 are DASH (I use it like a figures dashboard in order to control various things).

  7. Before I had few tools to deal with. Today I work with many different intern softwares that have each their own file formats. Hence ETL has become a major preoccupation. Excel can do it but let’s be honest it is best for calculations rather than doing ETL. EDT on the contrary is an ETL Master.

  8. I used Trello but could not attach a spreadsheet with a powerquery to a trello card and trigger it from my webpage. I’ve switched to Hyper Plan which is EDT’s twin (same service provider). Today my cards in Hyper Plan are directed linked to transformations. That is so comfy and so fast (both softwares are portable). I don’t even no more know where the files are located. Everything is linked to everything thanks to HP and EDT. I feel free from our old legacy network. I can breath and focus on data. Priceless.

  9. During many years I used to be a spreadsheet zealot, venerating Excel because spending minimum 50 pc of work hours in it. Since EDT venue, my Excel time has been divided by a factor of minimum two. Some tasks are even EDT only. I still can not believe it.

1 Like

Explain with small example ?

Hello @prashant, for machine-to-machine business we use Electronic Data Interchange (EDI) protocol. I also use EDT to retrieve, count & categorize messages (eg. 500,000 msg for 1 month). And to align months with 30 days with months with 30 days (eg. Sep and Nov) (same with 31 days).

Suppose (thanks to EDT) I see 50,000 APERAK for Sep and 50,000 APERAK for Nov => I know then that inbound messaging is completed (then I can launch EDT to GET data content). If I see instead 50,000 APERAK for Sep and 45,000 APERAK for Nov => apparently 5,000 msg are still pending (no need to run EDT to get data, for the moment).

1 Like