Join David Benaim, our resident tech guru, for a demo heavy workshop showcasing the common pitfalls with external data.
He will show how Excel's Power Query and dynamic arrays can really change the way to think about external data and automate the process so updaing to the latest information can be reduced to a few clicks rather than cumbersome copy & paste with lots of room for error and inconsistent data structures. David will showcase lots of typical external data structures and demonstrate how to create steps to clean them.
