Removing the Compliance Risk of Offline Analytics
It is high time that organisations minimise risks associated with offline data-driven processes. Many people still download data onto their PC, laptop, or other offline location in order to analyse it (usually in Excel). Even in enterprise environments where all kinds...
Building Data Rhythm – a blueprint for outcompeting in a complex world
Why do some organisations successfully outcompete, while others struggle? How do some leaders get more out of their people than others? What patterns do successful leaders put in place? In this article, I will use the concepts of beat, rhythm, music and ovation to...
The Decision Factory: Better Decisions Every Day
Our Virtual World We live in an increasingly virtual world. All functions that can be outsourced have been outsourced or are rapidly moving towards being outsourced. The ‘gig economy’ is well and truly here, and it is making an impact. This virtual world affects how...
ANDalytics – How complete is your Analytics Strategy?
When you have worked in the analytics industry for as long as I have (a wonderful, intense, frustrating and ultimately rewarding 25 years) then not only do you begin to see it as a form of vocation, but you also start to see patterns emerging out of the daily dynamics...
Pentaho Enterprise Edition: Extract the BA schedule into a database
Pentaho Enterprise and Community Editions offer the Scheduling tool to enable jobs to be set to run at certain times on a repeatable basis. At the moment, while the schedule is viewable, there is no built-in method for extracting the schedules for reporting or...
HiPPO or Everyone – Who is responsible for decision making in your business?
I have been working in analytics for over 20 years now. One of the most frustrating things I have seen over this period is the relentless pursuit of and excessive focus on executive dashboards. Please don’t get me wrong, they play a role in business. A concise...
Mistakes businesses make when it comes to Analytics Projects
I have had the pleasure (and the ensuing pain) of working in the Analytics field for more than 20 years now. I have worked at both ends of the spectrum. I have been involved in small-scale departmental analytics projects involving a few analysts. I have also been...
Using JNDI Connections in Spoon Data Integration
Spoon needs the JNDI connection defined somewhere it knows about
Expectations v Reality in Enterprise Analytics
Big Data is a big deal in enterprise, and for good reason. If harnessed entirely and leveraged, it has the potential to change the fate of an organisation. Enter the Internet Of Things (IoT) and the data just got bigger, and that too, by a lot. And it is not just the...
Are your Analytics Investments based on ‘Strong’ or ‘Weak’ Links?
With the recent news that LeBron James is going to make $208M (I have converted to AUD) - and the FIFA World Cup just wrapping up (I can finally sleep again), I have been thinking about a podcast by one of my favourite authors, Malcolm Gladwell – “My Little $100M”. ...
Pentaho 8.1 Release – A Quick Summary
The Pentaho 8.1 Enterprise Edition was released a few months ago. It delivers a wide range of features and improvements, including; Improved Streaming Steps in PDI, Increased Spark Capabilities in PDI, Enhancements to Google Cloud Data, Increased AWS Security....
Pentaho 8.1 Release – Doubling Down on its Core
At BizCubed, we are proud to be a Hitachi partner organisation. And a key reason is, Hitachi has remained committed and consistent to interoperability of data processing and analytics across complex data ecosystems; a core cause we are also driving. Through...
Add a read-only user to Amazon Redshift
a simple script to add a read-only user on Redshift
Use cURL to download a report from Pentaho BA server
run and download a Pentaho Report Designer pixel-perfect report from a secured server – from the command-line
The simplest way to replace variables in a string in Pentaho Spoon
Spoon: variable substitution in string A in the Calculator step
Why we keep picking Pentaho as our solution for our Managed Service
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...
What your Data Life Cycle probably looks like
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...
Spoon: What ETLs are using this connection?
The question was: When I’m using a shared database connection, what other ETLs are using it too?
Your competitors are doing this. Why aren’t you?
Unlock your business – your team has the answers We have recently been reviewing the impact that data quality has on workforce productivity. In the analyses that we have seen, there is an impact of 10—32% of workforce time being wasted due to poor data productivity....
Pentaho Debuts on Gartner Magic Quadrant for Data Integration Tools
Pentaho prides itself on being data challenge agnostic when it comes to the technologies and data sources customers can leverage to achieve analytic business outcomes. Doing this means customers are freed from the hindrances of data and continue to increase analytics...