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...
Our Blogs
WE LOVE TO SHARE
How to export an Excel file to pipe delimited file rather than comma delimited file
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...
Importing CSV file from AWS S3 into Redshift
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...
* Insert Vendor Here * certification – A big deal?
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...
My Take on – Customer Service
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...
AWS Part Two – Seven best practises for building systems with AWS
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...
AWS Part One – 5 Benefits of the 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...
SAS Package batch Export and Import.
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...