Working in Excel on the Mac and noticed this for the first time, maybe it has always been there or maybe not, in any case it is really nice usability from Microsoft where the tooltip for the sort icon changes based on the data type of the cells that are highlighted.
It is no wonder why Microsoft remains an elite company.
The USD/CAD conversion rate is one of those things that I’ve generally watched since a kid with varying levels of interest and intensity. Getting immersed in the concept of seeing money disappear as we converted cash into travellers cheques to get ready for a summertime journey to ‘the states’.
Over the last couple years (well probably since 2008) it has been much more in the forefront — something that gets an appropriate amount of attention given that we operate in Canada and USA — but the last couple of years have been pretty interesting to read commentary about Canadian currency being sensitive to commodity price.
So this morning I thought it might be a good exercise to test this theory with some data. First step was to open an IDE and start reading about API’s to gain access to exchange data and oil prices. Second step, stop and realize I was trying to solve a problem with my favorite hammer and this was not a nail.
The modern web has most of all data we need and it has already been compiled for us — a couple of searches later, data downloaded in Excel format. This was a great lesson that the entry friction for acting on ideas in today’s content rich web is pretty low, data is readily accessible and readily usable, so low in fact that becoming a data scientist might just become the ‘norm’ the expectation any professional.
So what did the data show us? Without much fuss or manipulation the trend between Oil Price and CAD/USD exchange rate is fascinatingly close, looking generally like a small lag (in weeks) between the two where exchange rate declines soon after decline in commodity.
Getting the most out of your GIS data can sometimes mean getting most of your data out of GIS. Understanding the limits of applications and using the right tools for the job are key to maximizing efficiencies and insights.
We wanted better integration between Tableau and ArcGIS so we did something about it recently by launching Integrated Portage, an application that easily feeds spatial and attribute data into Tableau. Super fast data conversion that allows for all the analytics of Tableau to be applied to proprietary spatial data or custom spatial analysis results output to Tableau.
Pipelines: Colored by location Quality and Sized by Diameter for Lower 48
Soil polygons: Colored by Slope category for East Coast Canada
Gearing up for data analytics and social media scraping and decided to hit our blog to see how things trend and popular articles hits and views etc. Taking a quick read through it was most surprising is that our post from 2011 on our Python-based Alignment Sheet Generator remains the second most popular article (besides the landing page).
We’ve continued to use and hone the product since 2011 onwards in various projects to build nice looking alignment sheets for clients. Ever evolving, continuing to get better, performance improvements, workflow improvements, simplification, and a new name — Integrated Folio.
One notable addition to our Python-based alignment sheet generator is that it is now fully interactive for viewing sheets within ArcMap. Super nice to be able to jump to a page and have it automatically draw all the necessary details.
We are now at the point where the layout and data content of the alignment sheet is defined by a simple spreadsheet! Let’s be clear here, simple does not mean dumbed-down, it just means elegance and simplicity — there is no shortage of awesome automation in the product, supporting advanced symbology and labeling and graphical bands.
PODS? APDM? ISAT? We don’t really care the source, if it can be shown along a route then we can use it — we’ve tried to build out the product as being an “Infographic for your Pipeline”. I mean we aren’t in the era of mylar and tape any longer so why do we keep trying to pave that cow-path?
Brushing dust off of the blog site. A lot can be said in 140 characters but it is not always enough to express your thoughts in rich detail.