World Cup Dashboard 2014 – in 15 minutes

July 3, 2014

dashboard fifa

Are you caught in the World Cup craze? Two of my passions are English football and analytics (hence I’m a SE at Pentaho based in London). So when it came time for this years’ World Cup, naturally I combined my passions to analyse who is going to win and what makes a winning team?

It turns out that a Big Data Analytics team in Germany tried to predict the winners based on massive data sets. Thus far three of their top five predicted teams have faltered. So what went wrong? Is Big Data not accurate? Are analytics not the answer?

Fret not. Exploring their methodology, their analysis was based from only one source of data. At Pentaho, we believe that the strongest insights come from blended data. We don’t just connect to large data sets; we make connecting to all data easy, regardless of format or location.

So why is my little World Copa Dashboard different (pictured above)? Its simple, intuitive and quick to create using Pentaho to access and organize the information I wanted — taking only 15 minutes. Yes, raw data to dashboard in 15 minutes! Here is how I did it:

I took 2010 FIFA World Cup data in CSV format and turned it into three panels of information in a format I wanted to see. It was my view into the action. I wanted more information beyond the basic winners and loosers, rather the interest to look behind the scenes (such as how and why) about one of the most spectacular sporting events on the planet. With analytics, I wanted to explore the following questions:

  1. How did strikers compare in the final outcome?
  2. Across a team, how hard did they work?
  3. What was the strategic approach of the winning teams versus the most industrious ones?

Using Pentaho’s built in mapping features I could visualise the countries with the ‘busiest’ forwards. This told me something about the work rate of the formations that country’s manager/coach was using. I could see the efficiency of the forward position players.

leading forward players

With the pivot table I could conditionally format the table to give me an at-a-glance view of the teams with goalkeeping performance, individual defending and attacking maneuvers.

player stats

 

Embedding the Official FIFA website into my dashboard also gave me access to FIFA’s own ‘trending’ players of this tournament. I could see historic performance versus the latest information.

official FIFA

One of the most vital aspects of analytics is offering the information in the right context for the user. With the rich visualisations of Pentaho Analyser it was simple for me to divide up the teams into a scatter plot showing me which ones worked the hardest for the duration they were in the tournament and which balance took the successful teams furthest.

teamstats

In summary, I got a behind the scenes look at my World Cup data in four different visualisations all combined into one dashboard easily, quickly and efficiently using Pentaho User Console and I was able to prepare the data into a format of my choosing rapidly using Pentaho Data Integration.

Turn your data into your own personal viewpoint with the power of Pentaho Business Analytics 5.1.

GO ENGLAND…for the next World Cup, perhaps? ;)

Zaf Khan
Presales Engineer
Pentaho


Award time at Pentaho

June 18, 2014

The past few weeks we’ve been giddy with excitement about several awards we’ve received celebrating our big data technology and how customers are applying it to reap big benefits. The latest awards Pentaho along with our customers have added to our growing trophy case include:

PrintThe CRN Big Data 100 list identifies vendors that have demonstrated an ability to innovate in bringing to market products and services that help businesses work with big data. Pentaho is proud to be named to the Big Data 100 list for the second year in the business analytics category. The award noted Pentaho’s record 83 percent bookings growth in 2013 for big data and embedded analytics products. In addition, the addition of Christopher Dziekan, previously head of analytics product strategy at IBM as Pentaho’s new Chief Product Officer.

 

2014SDT100_logo_120x123Each year the SD Times 100 recognizes companies, non-commercial organizations, open source projects and other initiatives for their innovation and leadership. Judged by the editors of SD Times, the SD Times 100 recognizes the top innovators and leaders in multiple software development industry areas. Pentaho was selected as a top 10 leader for Big Data, alongside Apache Hadoop, Splunk, Cloudera, DataStax, Hortonworks and MongoDB!

 

Computer-Weekly-EuroUserAwards-EnterpriseSoftwarePentaho customer, Bywaters was shortlisted for the ComputerWeekly European User Awards for Enterprise Software in the category of Best Technology Innovation! Bywaters is a waste management and recycling company based in the UK. They aim to make it easy and affordable for customers to improve their environmental performance and meet regulatory compliance through a system they created that embeds Pentaho called BRAD – Bywaters reporting and analytics dashboards. You can read more about their use case on Pentaho.com or feature article on ComputerWeekly.

SIG-Awards-headline-sponsor-logo-300x237Pentaho/Ctools pro-bono customer, Leukaemia & Lymphoma Research organization was awarded GOLD for ‘Best Use of Performance Reporting and Data Visualization’ by the Institute of Fundraising Insight Awards. The CTools team and Dan Keeley (@Codek1) worked with the UK Beating Blood Cancer group dedicated to improving the lives of patients with all types of blood cancer, including Leukaemia, Lymphoma and Myeloma. They created an (now) award winning dashboards to track the charity events they organize – check out the sample version here.

If you love awards as much as we do, then, you must check out the Pentaho Excellence Awards. This is our first annual awards program to recognize and honor our customers, partners and users who have deployed Pentaho in interesting and innovative ways.  Nominations are open until July 11th.

Rebecca Shomair
Director of Communications
Pentaho

 


PentahoWorld 2014 – save the date

May 2, 2014

PentahoWorld stacked dateClick here to be the first to hear more details on PentahoWorld 2014. #PWorld2014

 


Pentaho and MongoDB Rendezvous in SF

April 22, 2014

CityClubThe City Club of San Francisco is well known for hosting the swankiest of weddings in San Francisco. However, on May 1st, it will be the location of a union of a different sort – The Pentaho and MongoDB ‘Better Together’ luncheon. Pentaho and MongoDB have emerged as a powerful combination for scalable data storage, processes and analytics. This special event is not to be missed as the four hours is packed with access to industry leaders, peer use cases, and key points you need to know to make a difference in your organization right away – PLUS a free Pentaho Analytics for MongoDB book and 5 star lunch. Here is a glance at the agenda:

Agenda
10:30 a.m. to 11:00 a.m.
Welcome & Introductions: Pentaho & MongoDB Teams

11:00 a.m. to 12:00 p.m.
Pentaho Analytics for MongoDB & Demo – Bo Borland, Pentaho’s VP of Field Technical Sales and author of Pentaho Analytics for MongoDB

12:00 p.m. to 12:30 p.m.
Advantages, Use Cases, and Value of MongoDB

12:30 p.m. to 1:00 p.m.
Customer Use Case

1:00 p.m. to 2:00 p.m.
Optional Breakout Session & Book Signing by Bo Borland author of Pentaho Analytics for MongoDB

We hope you can rendezvous with us on May 1 at the City Club of SF. 

Click here for more details and to register. Don’t delay – space is limited! 

Learn more about why Pentaho and MongoDB are better together

Don’t live in San Francisco? Visit the Pentaho events page to find details about Pentaho and MongoDB luncheons in Atlanta, Minneapolis and Tampa. Stay tuned for more locations and dates.


Cloudera Stamp of Approval

April 3, 2014

logo_cloudera_certifiedYesterday, Cloudera announced the general availability of Cloudera 5 (C5), the latest generation of Cloudera’s unified data platform for the enterprise data hub. Pentaho engineers have been working on certification since the beta was available in early February to make sure we are certified on day one of the GA.

Cloudera and Pentaho  have a long standing strategic relationship with tested joint technologies that have been deployed time and time over again. By using Cloudera Certified products, enterprises significantly reduce risk while taking advantage of the worlds most complete, tested and popular platform powered by Apache Hadoop. This stamp of approval should put customers at ease when deploying C5 knowing that Pentaho and Cloudera have worked together to ensure the highest level of capabilities and compatibility.

Learn more about Pentaho and Cloudera’s joint solution benefits, access the download, resources and recordings.

Paul Vasquez
Senior Product Manager, Technology Partners
Pentaho
@BigDataPaul


International Women’s Day – Software Developer

March 7, 2014

As part of our series highlighting women in tech for International Women’s Day on March 8th we are we are featuring Gretchen Moran, Software Developer at Pentaho. Gretchen’s title may be ‘Software Developer,’ however, over her nine years at Pentaho, she has worn many technical hats to help lead the company to where it is today!

Rosanne, Sarah, Michelle and Gretchen are just a few of the impressive women that work at Pentaho. Our goal with this series is to promote the theme of this year’s International Women’s Day…to inspire change. We encourage you to share their stories with girls and women to encourage them to become more interested in STEM or to hopefully bring more strong and smart women to the tech industry.

OLYMPUS DIGITAL CAMERA

Gretchen Moran, Software Developer at Pentaho

What do you do at Pentaho? How long have you been at Pentaho?
I have been developing software in the warehousing and business analytics space for 15 years, 9 of them with Pentaho.

I have held many different roles through my many years at Pentaho. When I haven’t been coding, I have worked with our talented open source community, managed the technical side of larger Pentaho customer accounts as a Technical Account Manager, and consulted on numerous internal projects.

My current role is software developer for Pentaho Data Integration and Pentaho’s Big Data stack of technology.

What inspired you to want you to work in technology?
I have always wanted to push boundaries. In college, I wanted to see how far I could take my interests in math and science. My college career began in the 90’s, and computing and technology provided a great landscape to test my skills.

As I have grown in my career, working in technology has given me the challenges and change I need to stay engaged in my work. It has also allowed the flexibility I desire to be a great mom.

How do you think the industry could inspire more girls and women towards careers in technology? 
I think we need to talk less about inspiring women toward technology, and talk more about how a career in technology can fuel any passion a person might have.  Are you passionate about the medical field? Innovate some tech that will make medical records handling more efficient and private. Are you passionate about drama and acting? Pursue a career in graphics and animation; filmmaking today is as much technology as it is human resources.  In my experience, the passion doesn’t lie in the code; it lies in the industries you are coding for.

What advice do you have for women wanting to become a software developer?

Engage! The mainstreaming of open source makes this easier than ever today. Find a tutorial, get some code under your belt, and then start contributing to a project that means something to you. The best part is that there is a project for everyone. From open source medical records systems that serve third world countries to smart phone apps that help you find great shoes. It’s all out there, anyone can contribute, and there are few barriers to entry.

The formal education for computer science does not need to be intimidating. As with any worthy endeavor, it requires focus and hard work, and is absolutely within reach if you are passionate about the subject. The key to finding passion in technology for me was realizing that no subject is outside the technology realm.

Confession – I am not a code junky. A new API or performance progress does not excite me. I get excited when a customer wins based on Pentaho solutions that revealed a market differentiator for them. I get excited when I see Pentaho Community Edition implementations powering countries and organizations that would otherwise be shut out of the business analytics value proposition.

I’ve had the privilege of giving this advice to many different demographic and age groups. I recently spoke to a computer club at a local middle school, and a week later gave the same talk to a house full of single moms in a transitional program. Technology from an open perspective is a meritocracy upon entry; it’s up to the entrant to determine how far they will take it. That advice applies equally to boys AND girlsJ

What is a favorite memory you have about Pentaho?
My favorite memories will always be the first year(s) of Pentaho. There is a special energy that a company has as a startup. Late nights, bean bags for office chairs, and a few energetic developers working toward a common vision of disrupting the business intelligence industry is a wonderful thing I’ve been privileged to be a part of.  I love that even as we have grown, we have kept this energy and passion for what we do as a company.

Fun Fact about you. 
I love Christian mission work! I have served in New Orleans and Guatemala and have contributed to missions in Central America and Africa for the last five years.

I also have three of the greatest kids EVER… if I do say soJ


International Women’s Day – Product Management

March 6, 2014

As part of our series highlighting women in tech for International Women’s Day we are featuring Michelle Bradbury, Director of Product Management at Pentaho.

Our goal with this series is to promote the theme of this year’s International Women’s Day…to inspire change. We encourage you to share this story and help our effort to bring more women into the field of technology.

Michelle Bradbury, Director of Product Management at Pentaho

Michelle Bradbury, Director of Product Management at Pentaho

What do I do at Pentaho?
I am the Director of Product Management. I work with my team to create and deliver features that will make our product compelling in the market place. I have been at Pentaho for over two years and in the technology industry for over 18 years including companies like CapitalOne, Fujitsu, and Microsoft.

What inspired you to work in technology?
My interest in technology from the beginning was the power of data. Coming from a marketing background, I Initially had interest in utilizing data to try and understand customers motivations and buying behavior. That turned into a long career in data warehousing and business analytics.

How do you think the industry could inspire more girls and women?
There are so few areas in today’s world that aren’t impacted by technology. I think the industry should provide more insight into how technology impacts areas of interest for a large percentage of girls and women. Examples could include electronic planning for better family organization or the tech behind purchasing at online fashion retailers like ideeli and Modcloth (both Pentaho customers). The possibilities are truly endless.

The role of a product manager is really all about breaking boundaries.  It is being able to see what is relevant today and dreaming up what will be relevant tomorrow.  The best advice I have for girls and women seeking a product management role is to stay in the forefront of an industry that interest them. Understand how technology can better that industry, and look for technical opportunities to make that happen.

Favorite memory about Pentaho?
Taking my team to play trampoline dodgeball.  It was a great opportunity to relax while hurling nerf balls at top speed at one another.

Fun fact about me.
I have a credit on IMDB.


Follow

Get every new post delivered to your Inbox.

Join 101 other followers