by Andrew Cave | Aug 6, 2018 | Analytics Products, How To, News, Troubleshooting
The Pentaho ETL tools are really powerful, flexible and useful. However, being so complex they are prone to sometimes throwing errors that aren’t that easy to interpret. To assist others with this, I’m posting some of these error strings and how I...
by Andrew Cave | May 14, 2018 | Data Engineer, How To
Creating a read-only user is one of those simple tasks you do once in a blue moon. Normally you can Google it and find somebody else’s script and away you go. Not the case with AWS Redshift! It’s spread all over the place, so I thought I would publish a...
by Andrew Cave | Apr 4, 2018 | Analytics at Operational Scale, Analytics Products, Data Engineer, How To, Main Blog
The Pentaho Business Analytics (BA) server is a production level application for storing, scheduling, creating and running all the Pentaho report types through your web-browser. But sometimes, you need to work on the commandline and put things precisely where you...
by Andrew Cave | Jan 24, 2018 | Analytics Products, How To, Pentaho
Spoon: variable substitution in string A in the Calculator step This post is going to look at using the Calculator step to do variable or parameter interpolation into a string. In other words, we can use the Calculator step to do variable substitution instead of...
by Zachary Zeus | Sep 8, 2017 | BizCubed, Case Studies, How To, Main Blog, Pentaho
We have a firmly held belief that when you increase the number of staff members that participate in analytics – you significantly improve the value of your data assets. When your organisation has high value data assets your business is more efficient, more agile, and...
by Zachary Zeus | Aug 31, 2017 | Data Analyst, Data Engineer, Data Life Cycle, Data Scientist, How To, Main Blog
From Analyst, to Scientist, to Engineer A common problem we see is that different roles are using different methods of preparing and reporting data. What occurs is that there is very little collaboration between key data driven roles within the organisations that we...
