Power Query: How to iterate over a list
If you’ve been using Power BI or you’ve seen the demos, then like me, you’re probably excited about Power Query. As a data nerd, I’ve been having a lot of fun pulling data sets off the web and mashing them up. Getting web data used to be quite a manual task for me, since I wasn’t about to write a custom screen-scraper. I really love the “From Web” functionality that mines web pages for HTML tables. But I’m a developer, so of course, I wanted to load a list of files, or a list of websites, and I had some trouble figuring out how to do it. Hopefully, my experiences will help someone else. One of the tricks that I found was that the list that you want to iterate over has to be pulled into Power Query designer. So let’s start with looping over a list of files – this is something that EVERYONE will want to do at some point. So first, launch the Power Query designer from the Power Query ribbon, and use the folder that you want as your data source: As you can see, you get a lot of meta data about your folder contents. The most important…
Read More
Navitas Satalyst Racing Team Corporate Mentoring Program Launched
The Navitas Satalyst mentoring program was launched earlier this month. The aim of the program is to build one-on-one relationships between riders and members from the sponsor/Tifosi group. Some of the mentors include Todd Elliott (Managing Director, Satalyst), Bryce Houghton (CFO, Navitas), John Stringer (CEO, RAC Insurance), Stephen Gobby (CEO, GMA Garnet Group) and Lawrie Tremaine (CFO, Woodside). By sharing their broader experience, knowledge and perspective with individual team members will assist in developing the rider’s full potential in both their cycling and importantly their personal/professional development.
Read More
Satalyst Innovation – FedEx Day
Satalyst is holding its inaugural FedEx day in March! All Satalyst staff will be working on their own pet projects, with the aim of delivering something by the end of the day. This initiative was first brought to Satalyst’s attention via the Australian software company Atlassian, makers of some of our favourite software productivity tools and highlighted in Dan Pink’s New York Times bestselling book Drive and mentioned in his well-known TED talk on motivation. Why is it called a FedEx day? Because like the logistics company, participants have to deliver something overnight. Other than this, there are no rules around what people can work on. Satalyst believes strongly in fostering innovation and see its quarterly FedEx days as a way of allowing Satalyst staff to play with ideas and work together to create something extraordinary.
Read More