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...
The Road to Reliable Predictive Analytics and The Top 10 Requirements That Bridge IT and The Business
In her latest contribution to Computer Business Review, Pentaho CMO Rosanne Saccone reflects on the book, “Do Lunch or Be Lunch,” by Harvard Business School faculty member Howard H. Stevenson. As she points out, while Stevenson’s book itself may be a bit dated, the...
5 Keys to Creating a Killer Data Lake
It’s been several years since the term “Data Lake” was coined by my friend and Pentaho co-founder James Dixon. The idea continues to be a hot topic and a challenge to execute properly. The problem is that too many people think all they need to do is dump data into...
Filling the Data Lake with Hadoop and Pentaho
The blueprint for filling the data lake refers to a modern data onboarding process for ingesting big data into Hadoop data lakes that is flexible, scalable, and repeatable. It streamlines data ingestion from a wide variety of source data and business users, reduces...