As mentioned in Shane Gibson’s blog, Trifacta = I can code! (and free data wrangling on your desktop), some of us at OptimalBI have had the pleasure of using Trifacta’s Desktop Data Wrangling tool. A little something from their website Data Wrangling to Simplify the...
Recently I was tasked to create a pipe delimited file from an Excel Spreadsheet, a simple task you would expect. On first glance it was not as simple I thought. I use Excel 2010 and was expecting to be able to do something like ‘save as’ and select the file type ‘CSV...
I have been researching different ways that we can get data into AWS Redshift and found importing a CSV data into Redshift from AWS S3 is a very simple process. Get the CSV file into S3 -> Define the Target Table -> Import the file Get the CSV file into...
So one of OptimalBI’s SAS administration service selling points is that all of our SAS admin’s are certified, which meant I needed to pull finger and sit the exam (Yay - I am now certified in SAS Platform Administration in SAS 9). This got me thinking, what is the...
To me customer service is key for repeat business and referrals. It is about what you do (and don’t do) for your customers. With our recent move to Auckland and building a house, we have experienced very good and very bad customer service and I thought I would share...
Ok, part two of a series on what I found interesting or thought will be useful from the ‘Architecting with AWS’ training. But first it was pointed out to me not everyone knows what AWS is so to recap AWS or Amazon Web Services offers web services that make up a cloud...
Once again I have been fortunate to attend another course put on by AWS, this time it was the ‘Architecting with AWS’ Partner training which was recently held in Auckland. My next couple of blogs will introduce some parts of the course I found interesting or that I...
In a previous life I was responsible for promoting new and modified SAS DIS jobs from Development through to our production environment. The usual process would consist of manually exporting the appropriate objects, selecting the dependant object option then...