tag:blogger.com,1999:blog-31320438511818773532024-03-12T19:58:10.795-07:00Business Intelligence in the heads of peopleBI is in the heads of people, not the softwareMichael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.comBlogger61125tag:blogger.com,1999:blog-3132043851181877353.post-5084909373542422262013-06-13T08:29:00.001-07:002013-06-14T07:40:47.458-07:00My New Blog at http://michaeltarallo.com/<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzxRE2S5Z1qM0n7jj_oODF6BRI2x1Hs8Orf8sH65eUqyGbsavEoUzYW2NbjUUw2bl6ZC-c1tqK-OeCEHFgzUhzAnE7ROfix57PuXTbz95NlHFE0N71WJldB7-QgPqqrI0v2kJjr2n9MuM/s1600/flat_qlikie.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="149" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzxRE2S5Z1qM0n7jj_oODF6BRI2x1Hs8Orf8sH65eUqyGbsavEoUzYW2NbjUUw2bl6ZC-c1tqK-OeCEHFgzUhzAnE7ROfix57PuXTbz95NlHFE0N71WJldB7-QgPqqrI0v2kJjr2n9MuM/s200/flat_qlikie.png" width="200" /></a></div>
To my followers and those that stumble across this blog,<br />
<br />
I no longer maintain this blog - but will continue to leave it up for Pentaho related content that might still be relevant. I no longer post about Pentaho as I work for QlikTech and support QlikView and QlikView Expressor products - from a Product Marketing perspective.<br />
<br />
I appreciate your questions about Pentaho, but they are best left for the Pentaho Community Forums. There is a great group of individuals, both employees and members that are enthusiastic and happy to help.<br />
<br />
Please visit <a href="http://forums.pentaho.com/forum.php">http://forums.pentaho.com/forum.php</a> to post your question.<br />
<br />
If you would like, please join me at my new blog at <a href="http://michaeltarallo.com/">http://michaeltarallo.com/</a> that covers topics on Data Integration (ETL), Business Discovery, Data Governance, Metadata Management, QlikView and QlikView Expressor.<br />
<br />
Michael Tarallo<br />
Senior Product Marketing Manager<br />
QlikView and QlikView Expressor<br />
QlikTech Inc.<br />
@mtaralloMichael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-38385994616538332562011-11-06T18:27:00.000-08:002011-11-06T18:28:37.089-08:00Last post on this blogHello all - this is my last post on this blog - my new blog can be found at <a href="http://michaeltarallo.com/">http://michaeltarallo.com</a>.<div><br /></div><div>Thanks</div><div><br /></div><div>Mike T</div>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-28436171389990913722011-10-04T05:39:00.001-07:002011-10-05T14:37:18.611-07:00"We haven't really thought about that"<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://bigmikescience.files.wordpress.com/2008/07/bush-scratching-head.jpg"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 285px; height: 227px;" src="http://bigmikescience.files.wordpress.com/2008/07/bush-scratching-head.jpg" alt="" border="0" /></a>If you have been dealing with BI related sales activities or are searching for that "right" BI tool, you will find that most organizations:<div><br /></div><div>* Use manual tasks, including desktop query and reporting tools, to answer their business questions.<br /><br />* Have "something" in place that they are not happy with or is costing them too much money.<br /><br />* Have data in multiple silos that they need to access, consolidate and optimize.</div><div><br /></div><div>Hence, they are usually looking for a low cost BI alternative that can provide them with the answers to their business questions, as well as ease of use and functionality within their budget.</div><div><br /></div><div>Don't believe me? Join the many BI groups available in LinkedIn and other social networking type sites and you will see the barrage of questions from those looking for recommendations on BI tools. </div><div><div><br /></div><div>So...I was on a call yesterday with a well known organization where the "prospect" stated: "We need basic reporting with the ability to access all of our data without moving it or massaging it." </div><div><br /></div><div>"Okay? That is absolutely possible, however do you understand the pros and cons that are associated with that?" I replied.</div><div><br /></div><div>[...] Silence...not only can you hear crickets on their phone, but you could hear them in the next conference room over. I took the proverbial saying "Silence is Golden" to another level. It became so uncomfortable that the Account Rep felt he should interject. I interrupted promptly to allow them to answer the question. After about a minute of what appeared to be hours of silence, they responded, "We haven't really thought about that." - BINGO! Case closed! Next!</div><div><br /></div><div>Hmm... "We haven't really thought about that."</div><div><br /></div><div>That's the problem, no one is taking the time to be proactive and think about what it is they need and are rather just reacting. "Let's see a demo." "I just need Reporting". "We need Dashboards." If that is the case, I would recommend you watch a video demonstration which may intrigue you to start thinking about what you really need. Then come talk to me when you have more criteria that will support your BI initiative. :-)</div><div><br /></div><div>So I digress...in turn, I took this as an opportunity to educate by asking pointed questions that would help them see what it is they actually need vs. what they thought they needed.</div><div><ul><li>Is the data you need to access all in one location? - No<br /><br /></li><li>Does the data you have support a majority of questions that will be asked of it? - Don't know<br /><br /></li><li>Would you like answers to questions that occur on a regular basis? - Yes<br /><br /></li><li>Would you like your users to answer their own questions on a random basis? - Yes<br /><br /></li><li>Would you like your users to explore and discover answers to questions they did not think to ask? - Yes<br /><br /></li><li>Do you have a predefined set of KPIs to manage and track business performance? - Yes<br /><br /></li><li>Would you like your executives to see an at a glance view of those KPIs? - Yes<br /><br /></li><li>Would you like to be aware of "something" when a defined threshold is met? - Yes</li></ul><div>Alright, now we are getting somewhere. Each of those questions and responses clearly identifies that their needs are more than just simple reporting as originally desired. They require a solution that encompasses both Data Integration and Content Delivery. (ETL, Reporting, Analysis and Dashboards)</div></div><div><br /></div><div>I further probed as to why they wanted to access all of the data "without moving it or massaging it". They replied: "Because building a Data Warehouse takes too much time and costs too much money."</div><div><br /></div><div>Wow! Clearly a response most likely seeded by a competitor whom believes they can access all of the data where it sits, without building a DW. Which may be true for some of the competition out there. However they usually leave out the fact that they are still "moving and massaging" the data - they just don't call it ETL or refer to their process as Data Integration or even use the words "Data Warehousing".</div><div><br /></div><div>I further explained that Data Integration (ETL) does not have to be about building an EDW, Enterprise Data Warehouse. It can be about building operational data stores that are refreshed periodically to support questions that the business users want to ask. It can involve federated queries where the data is accessed from the source without having to stage the data. It can also be about normalizing data in to a small data mart that supports speed of thought analytics for the power users. </div><div><br /></div><div>Upon those points I provided a demonstration of Pentaho's "<a href="http://www.pentaho.com/agile_bi/">Agile BI</a>" capabilities which involves a rapid, collaborative and iterative approach to building BI applications. At completion of the presentation, the prospect was amazed and pleased. They stated: "This is exactly what we need." Music to my ears. </div><div><br /></div><div>People, you cannot throw a BI tool in your organization and expect it to stick without asking some important questions. It is those answers that will help guide you to the right solution. And most importantly, you cannot put a BI tool on top of all as-is data without knowing what questions are going to be asked of it. It is impossible to know every question that may be asked, but at least have those that are important to tracking your business performance.</div><div><br /></div><div>On the majority of calls that I participate in, it seems that organizations don't have the time to properly plan and discuss the criteria needed to implement a decision support system. Why? Because everyone is doing more with less these days and researching a BI tool is usually an ancillary responsibility for them. If that is the case, allow us to help you with your research and <b>we</b> will ask those question you haven't really thought about.</div><div><br /></div><div>Regards,</div><div><br /></div><div>Michael Tarallo<br />Director of Enterprise Solutions</div><div>Pentaho</div><div><br /></div></div>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com1tag:blogger.com,1999:blog-3132043851181877353.post-63388718255410808802011-09-25T07:38:00.001-07:002011-09-26T11:39:12.344-07:00Using Pentaho to Be Aware, Analyze, Take Action and Protect<h2><img style="text-align: center;margin-left: 5px; margin-right: 5px; " title="no-spam" src="http://pentahoadmin.files.wordpress.com/2011/09/no-spam.png" alt="" width="250" height="206" align="left" /><span style="text-decoration: underline; color: #808080;"><strong>Be Aware</strong></span></h2><br />Denial of Service attacking (DoS), IP Spoofing, Comment Spamming and Malware programming... are malicious activities designed to disrupt services used by many people and organizations. If you are taking advantage of the internet to run your business, create an awareness of a product or service or simply keep in touch with friends and family, your systems are at risk at becoming a target.<br /><br />Successful internet "intrusions" can cost you money and even steal your identity. DoS attacks can prevent internet sites from running efficiently and in most cases can take them down. IP Spoofing, frequently used in DoS attacks, is a means to "forge" the IP address and make it appear that the internet request or "attack" is coming from some other machine or location. And Comment Spamming, oh brother...where programs or people flood your site with random nonsense comments and links with an attempt to raise their site's search engine ranking or increase internet traffic to their sites:<br /><br /><br /><span style="color: #0000ff;">"Nice informations for me. Your posts is been helpful. I wish to has valuable posts like yours in my blog. How do you find these posts? Check mind out [link here]"</span><br /><br /><span style="color: #000000;">Huh? - LOL</span><br /><br />You may already have defensive measures in place to address some if not all of these things. There are programs, filters and services that you can use to look up, track and prevent this sort of activity. However, with the continuous stream of unique and newly produced malware, those programs and services are only as good as the latest "malicious" activity that is captured. No matter what, it will eventually cause headaches for many people and organizations around the globe. Being able to monitor when something is "just not right" is a great step in the right direction.<br /><br /><h2><span style="text-decoration: underline; color: #808080;"><strong>Analyze</strong></span></h2><br />In September of 2010, I introduced the <a href="http://sandbox.pentaho.com/" target="_blank">Pentaho Evaluation Sandbox</a>. It was designed as a tool to assist with Pentaho evaluations as well as showcase many examples of what Pentaho can do. There have been numerous unique visitors to this site, both legitimate and some as I soon discovered...not. Prior to the site's launch, using Pentaho's Reporting, Dashboard and Analysis capabilities, I created a simplistic Web Analytic Dashboard that would highlight metrics and dimensions of the Sandbox's internet traffic. It was a great example to demonstrate Pentaho Web Analytics embedded in a hosted application. Upon my daily review of the Site Activity dashboard which includes a real-time visit strip chart monitor, I noticed an unusually large spike in page views that occurred within a 1 minute time-frame.<br /><br /><br /><a href="http://pentahoadmin.files.wordpress.com/2011/09/attemp2.jpg"><img class="size-full wp-image-2479 aligncenter" style="margin-top: 5px; margin-bottom: 5px;" title="attemp2" src="http://pentahoadmin.files.wordpress.com/2011/09/attemp2.jpg" alt="" width="450" height="198" /></a><br /><br /><br />Now that spike can be normal, providing a number of different people are surfing the site at the same time. However it caught my attention as "unusual" due to what I knew was normal. The dashboard quickly alerted me of something I should possibly take action on. So I clicked on the point at the peak to drill-down into the page visit detail at that time. The detail report revealed that who or whatever was accessing the Sandbox was rapidly traversing the site's page map and directories looking for holes in the system. I also notice that all the page views were accessed by the same IP address within under 1 minute. Hmmm, I thought. "That could be a shared IP, a person or even a bot ignoring my robots.txt rules." But..as I scrolled down I further discovered there were attempts to access the .htaccess and passwd files that protect the site. I immediately clicked on the IP address data value in the detail report (in my admin version of the report) which linked me to an IP Address <a href="http://www.find-ip-address.org/ip-blacklist-lookup.php" target="_blank">Blacklist look-up service</a>. The Blacklist Look-up program informed me that the IP address has been previously reported and was listed as suspicious for malicious activity. BINGO! Goodbye whoever you are!<br /><br /><h2><span style="text-decoration: underline;"><strong><a href="http://pentahoadmin.files.wordpress.com/2011/09/attemp1.jpg"><img class="alignleft size-full wp-image-2493" style="margin-left: 5px; margin-right: 5px;" title="attemp1" src="http://pentahoadmin.files.wordpress.com/2011/09/attemp1.jpg" alt="" width="450" height="624" /></a></strong></span></h2><div><span class="Apple-style-span" style="font-size: 24px; font-weight: bold; "><span style="text-decoration: underline;"><strong><br />Take</strong></span><span style="text-decoration: underline;"><strong> Action</strong></span></span></div><h2></h2><h2></h2><div>I quickly took action on my findings by banning the IP address from the system to prevent any further attempts to access the site. I then began to think of some random questions I needed to ask of the data. I switched gears and turned to Pentaho Analysis. Upon further analysis of the site's data using <a href="http://sandbox.pentaho.com/analyze-this/" target="_blank">Pentaho Analyzer Report </a>- I was able to see evidence of IP Spoofing and even Comment Spamming coming form certain IP address ranges. The action I took next was to block certain IP address ranges that have been accessing the site in this manner. In addition I created a contact page for those who may be accessing the site legitimately but may have gotten blocked if their IP falls in that range.</div><br />Wow, talk about taking action on your data huh?<br /><br />It is not a question of if, but when an unwarranted attempt will occur on your systems. Make sure you take the appropriate steps to protect them by using the appropriate software and services that will make you aware of problems. My experience may be an oversimplification but it is a great example of how I used Pentaho to make me aware of a problem and take that raw data and turn it into actionable information.<br /><br />Special thanks to Marc Batchelor, Chief Engineer and Co-Founder of Pentaho for helping me explore the corrective actions to take to protect the Pentaho Evaluation Sandbox.<br /><br />Regards,<br /><br />Michael Tarallo<br />Director of Enterprise Solutions<br />PentahoMichael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-10263593870467839722011-09-19T07:29:00.000-07:002011-09-19T07:30:24.935-07:00The right tool for the right job - Part 1<a href="http://blog.pentaho.com/2011/08/23/back-to-school-savings/2245-revision-2/" rel="attachment wp-att-2248"><img class="size-full wp-image-2248 alignleft" style="margin: 5px;" title="itdepend" src="http://sandbox.pentaho.com/wp-content/uploads/2011/08/itdepend1.png" alt="" width="240" height="174" align="left" /></a><span style="text-decoration: underline;"><strong>All too Common</strong></span><br /><br />You have questions. How do you get your answers? The methods and the tools used to help get those answers to business questions will vary per organization. For those <span style="text-decoration: underline;">without</span> established BI solutions; using desktop database query and spreadsheet tools are...all too common. And...If <em>there is</em> a BI tool in place, usage and its longevity are dependent on its capabilities, costs to maintain it and ease of use for both development staff and business users. Decreased BI tool adoption, due to rising <em>costs</em>, lack of functionality and complexity may increase dependencies on technical resources and other home grown solutions to get answers. IT departments have numerous responsibilities. Running queries and creating reports may be ancillary, which can result in information not getting out in a timely manner, questions going unanswered and decisions being delayed. Therefore, the organization may not be leveraging its BI investment for what it was originally designed to do...empower business user to create actionable information.<br /><br />(Read the similar experiences of Pentaho customer Kiva.org here at Marketwire: <a href="http://www.sys-con.com/node/1971384" target="_blank">http://www.sys-con.com/node/1971384</a>)<br /><br /><strong><span style="text-decoration: underline;">Six of One, Half a Dozen of the Other</span></strong><br /><br />The BI market is saturated with BI tools, from the well known proprietary vendors to the established commercial open source leaders and niche players. There are choices that include the "Cloud", on premise, hosted (SaaS) and even embedded. Let's face it and not complicate things...most, if not all, of the BI tools out there can do the same thing in some form or fashion. They are designed to <em>access, optimize and visualize data </em>that will aid in the answering of questions and tracking of business performance. Dashboards, Reporting and Analysis fall under a category I refer as "Content Delivery". These methods of delivering information are the foundation of a typical BI solution. They provide the most common means for tracking performance and identifying problems that need attention. But..did you know, there is usually some sort of prep work to be done, before that chart or traffic light is displayed on your screen or printed in that report. That prep work can range from simple ETL scripting to provisioning more robust Data Warehouse and Metadata Repositories.<br /><br /><span style="text-decoration: underline;"><strong>Data Integration</strong></span><br /><br />Content Delivery should begin first with some sort of Data Integration. In my 15 years in the BI space I have not seen one customer or prospect challenge me on this. They all have "data" in multiple silos. They all have a "need" to access it, consolidate it, extrapolate it and make it available for analysis and reporting applications. Whether they use it already as <em>second-hand data</em>, loaded into an Enterprise Data Warehouse for historical purposes, or produce Operational Data Stores, they are using Data Integration. Whether they are writing code to access and move the data, using a proprietary utility or even some ETL tool, they are using Data Integration. It is important to realize that not <em>all</em> data needs to be "optimized" out of the gate, as it is not only the data that is important. It is how it will be used in the day to day activities supporting the questions that will be asked. This requires careful planning and consideration of the overall objectives that the BI tools will be supporting.<br /><br /><span style="text-decoration: underline;"><strong>Well, How do I know what tools to use? - Stay Tuned<br /></strong></span><br /><br />With so many tools available, how will you know what is right for the organization? Thorough investigation of the tools through RFIs, RFPs, self evaluation and POCs are a good start. However, make sure you are selecting tools based on the ability to solve your specific current AND future needs and not solely because it looks cool and provides only the "sex and sizzle" the executives are after. The typical need is always Reporting, Analysis, Dashboards. Little realize that there is a lot more to it than those three little words. In the next part of this article I will cover a few of the most common "BI Profiles" that are in almost every organization. In each profile I will cover the Pains, Symptoms and Impacts that plague organizations today as well as the solution strategies and limitations you should be aware of when looking at Pentaho.<br /><br />Stay tuned!<br /><br />Regards,<br /><br />Michael Tarallo<br />Director of Enterprise Solutions<br />PentahoMichael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-86613511069437353002011-09-13T07:52:00.000-07:002011-09-13T09:23:32.581-07:00Are you hungry for some Pentaho ETL? Check out the Data Integration Cookbook<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifa4cvMEiGRa5k1joQzRLCl3RNIOFYAlFJtseH9INhVod3Szvl5ym-KccECya48lA7aHTbWDyJjuSAYOf7j0ayTOgcPgF8mT2-89TzdOycoIZTJS9vlPkORLrOwUIrebypU9PZubhJZlI/s1600/5245OS_Pentaho+Data+Integration+4+Cookbook.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 125px; height: 152px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifa4cvMEiGRa5k1joQzRLCl3RNIOFYAlFJtseH9INhVod3Szvl5ym-KccECya48lA7aHTbWDyJjuSAYOf7j0ayTOgcPgF8mT2-89TzdOycoIZTJS9vlPkORLrOwUIrebypU9PZubhJZlI/s400/5245OS_Pentaho+Data+Integration+4+Cookbook.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5651858484946983618" /></a><div>Well? Are you? If so, you will want to pick up the <a href="http://link.packtpub.com/9VeDWl">Pentaho Data Integration 4 Cookbook</a> by Adrian Sergio Pulvirenti and <a href="http://www.packtpub.com/authors/profiles/maria-carina-roldan">Maria Carina Roldan</a> published by PACKT Publishing. You may know Mari from <a href="http://www.webdetails.pt/#">Webdetails</a> as well as from her previous book, <a href="http://www.packtpub.com/pentaho-32-data-integration-beginners-guide/book">Pentaho 3.2 Data Integration: Beginner's Guide</a> published in April 2010.</div><div><div><br /></div><div>In the PDI 4 Cookbook you will find over 70 "recipes" that will not only answer the most common ETL questions, when working with Pentaho Data Integration, but also guide you through each exercise. Whether you are new to ETL or new to Pentaho, you will find that the Pentaho Data Integration 4 Cookbook accommodates many skill sets, from the novice to the expert. It is a great addition to the growing series of Pentaho books published by PACKT and Wiley. </div><div><br /></div><div>Chapter 1 introduces you to working with databases and covers step by step how to connect PDI to your data so you can begin extracting, transforming and loading with ease. The chapter even shows you how to work with parameters...a very powerful feature of PDI. </div><div><br /></div><div>Each section in the book clearly identifies the steps taken to perform the tasks with headers marked "Getting Ready", "How to do it" and then follows up with "How it Works". Very nice for those who need to understand what is happening inside the PDI ETL engine and behind the scenes.</div><div><br /></div><div>The book continues with topics on working with files, XML, using Lookups, Data Flows, Jobs and goes into integrating Pentaho Data Integration transformations and jobs with the rest of the Pentaho BI Suite, leveraging such things as Pentaho Reports, Pentaho Action Sequences and the Community Dashboard Framework. I especially like the topics that are covered in Chapter 8; using Pentaho Data Integration with CDA (Community Data Access) and CDE (Community Dashboard Editor). This topic depicts greater extensibility of the Pentaho software by working with powerful Pentaho plug-ins contributed by Webdetails. </div><div><br /></div><div>The book concludes with Chapter 9, which helps you get the most out of Pentaho Data Integration, by explaining how to work with PDI logging, JSON, custom programs and sample data generators.</div><div><br /></div><div>If you are exploring the world of Pentaho, I would highly suggest picking up this book. It is great for beginners and for those experts (myself included) who thought they knew everything there was to know about Pentaho Data Integration and were pleasantly surprised by the additional knowledge gained. </div><div><br /></div><div>Get started and <a href="http://www.pentaho.com/download/">download</a> Pentaho today.</div><div><br /></div><div>Read more about the authors at <a href="http://blog.pentaho.com/2011/07/19/pentaho-data-integration-4-cookbook-%E2%80%93-win-a-free-copy/">blog.pentaho.com</a></div><div><br /></div><div>Recipe for a lower TCO and Higher ROI:</div><div><br /></div><div><ul><li> Gather needs and requirements</li><li>Take 1 Pentaho Installation </li><li>Add your data</li><li>Add Training</li><li>Can substitute: Pentaho Sales Engineering, Consulting or a Pentaho Certified Network Partner</li><li>Prepare a Scope of Work</li><li>Communicate Effectively</li><li>Execute Accordingly</li><li>Sit back and enjoy your lower TCO</li></ul></div><div>Regards,</div><div><br /></div><div>Michael Tarallo</div><div>Director of Enterprise Solutions </div><div>Pentaho</div></div><div><br /></div><div><br /></div>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-43792786315060004502011-07-07T16:04:00.000-07:002011-07-11T13:17:43.272-07:00Pentaho Data Integration and the Facebook Graph API<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNdf3G71qSgiPbQJIOaW94CfgUyEXpGYeBvmlHNup3HFLXrCHRGvVVJAyiXKkVyPn88UoU083lKM7yBI98tZ9bUd_H14p6v5ePi-nNzUflXvw17ZLDbzajO0PhDe1EL0MezZBFFxMMubE/s1600/facebook_icon.png"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 200px; height: 200px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNdf3G71qSgiPbQJIOaW94CfgUyEXpGYeBvmlHNup3HFLXrCHRGvVVJAyiXKkVyPn88UoU083lKM7yBI98tZ9bUd_H14p6v5ePi-nNzUflXvw17ZLDbzajO0PhDe1EL0MezZBFFxMMubE/s200/facebook_icon.png" alt="" id="BLOGGER_PHOTO_ID_5628191511678736642" border="0" /></a><span style="text-decoration: underline;"><strong>Social Networking Data</strong></span><br /><br /><strong>R</strong>ecently, I have been asked about Pentaho's product <em>interaction</em> with social network providers such as Twitter and Facebook. The <em>data</em> stored deep within these "<a href="http://en.wikipedia.org/wiki/Social_graph">social graphs</a>" can provide its owners with critical metrics around their content. By analyzing trends within user growth and demographics, and consumption and creation of content, owners and developers are better equipped to improve their business with Facebook and Twitter. Social networking data can be viewed and analyzed utilizing existing tools such as FB Insights or even purchasable 3rd party software packages created for this specific purpose. Now...Pentaho Data Integration in its traditional sense is an ETL (<a href="http://en.wikipedia.org/wiki/Extract,_transform,_load">Extract Transform Load</a>) tool. It can be used to extract and extrapolate data from these services and merge or consolidate it with <em>other</em> relative company data. However, it can also be used to <em>automatically push</em> information about a company's product or service to the social network platforms. You see this in action if you have ever used Facebook and "<em><span style="color:#0000ff;">Like</span>d</em>" something. At regular intervals, you will note unsolicited product offers and advertisements posted to your wall or news feed from those companies. A great way to get the word out.<br /><br />Interacting with these systems is possible because they provide an API. (<a href="http://en.wikipedia.org/wiki/API">Application Programming Interface</a>) To keep it simple, a developer can write a program in <em>"some language"</em> to run on one machine which communicates with the <em>social networking system</em> on another machine. The API can leverage a 3GL such as Java or JavaScript or even simpler RESTful services. At times, software developers will write <em>connectors</em> in the native API that can be distributed and used in many software applications. These connectors offer a quicker and easier approach than writing code alone. It may be possible within the next release of Pentaho Data Integration, that a Facebook and/or Twitter transformation step is developed - but until then the RESTful APIs provided work just fine with the HTTP POST step. <a href="http://sandbox.pentaho.com/wp-content/uploads/2011/07/Capture.jpg"></a><br /><br /><a href="http://sandbox.pentaho.com/wp-content/uploads/2011/07/Capture.jpg"><img class="size-full wp-image-1807 aligncenter" title="Capture" src="http://sandbox.pentaho.com/wp-content/uploads/2011/07/Capture.jpg" alt="" height="89" width="287" /></a><br /><br /><span style="text-decoration: underline;"><strong>The Facebook Graph API</strong></span><br /><br />Both Facebook and Twitter provide a number of APIs, one worth mentioning is the Facebook <a href="http://developers.facebook.com/docs/reference/api/">Graph API</a> (don't worry Twitter, I'll get back to you in my next blog entry).<br /><br />The Graph API is a RESTful service that returns a <a href="http://en.wikipedia.org/wiki/JSON">JSON</a> response. Simply stated an HTTP request can initiate a connection with the FB systems and publish / return data that can then be parsed with a programming language or even better yet - without programing using Pentaho Data Integration and its JSON input step.<br /><br /><a href="http://sandbox.pentaho.com/wp-content/uploads/2011/07/Capture3.jpg"><img class="size-full wp-image-1808 aligncenter" title="Capture3" src="http://sandbox.pentaho.com/wp-content/uploads/2011/07/Capture3.jpg" alt="" height="183" width="406" /></a><br /><br />Since the FB Graph API provides both data access and publish capabilities across a number of <a href="http://developers.facebook.com/docs/reference/api/post/">objects (photos, events, statuses, people pages)</a> supported in the FB Social graph, once can leverage both automated push and pull capabilities.<br /><br /><strong><span style="text-decoration: underline;">Tutorial: Publishing content to a Facebook Wall Using Pentaho Data Integration</span><br /></strong><br /><br />The following is an example of a reference implementation to walk you through the steps to be able to have Pentaho Data Integration automatically post content to a FB Wall.<br /><br />It is broken down into the following steps:<br /><ol><br /> <li>Create a new FB Account</li><br /> <li>Create a new unique FB user name</li><br /> <li>Create a new FB application</li><br /> <li>Obtain permanent OAUTH access token</li><br /> <li>Create PDI transformation</li><br /></ol><br /><br /><br /><span style="text-decoration: underline;"><strong>Step 1: Created a new FB account</strong></span><br /><br /><a href="http://www.facebook.com/">http://www.facebook.com</a><br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand110.png" alt="" /><br /><br /><span style="text-decoration: underline;"><strong>Step 2: Follow Instructions to setup your unique username</strong></span><br /><br /><a href="http://www.facebook.com/username/">http://www.facebook.com/username/</a><br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand210.png" alt="" /><br /><br />Add your own - or accept the defaults.<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand33.png" alt="" /><br /><br />Example: facebook.com/mpentaho<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand41.png" alt="" /><br /><br /><span style="text-decoration: underline;"><strong>Step 3: Create a FB Application</strong></span><br /><br /><a href="http://www.facebook.com/developers/createapp.php">http://www.facebook.com/developers/createapp.php</a><br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand51.png" alt="" /><br /><br />Allow "Developer" access to your basic information.<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand61.png" alt="" /><br /><br />After you allow access to the Developer App - go back here: <a href="https://www.facebook.com/developers/createapp.php%20">https://www.facebook.com/developers/createapp.php</a> if it does not redirect you.<br /><br />Create Application<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand71.png" alt="" /><br /><br />Security Check<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand81.png" alt="" /><br /><br />Verify Information<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand91.png" alt="" /><br /><br />Click Web Site<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand101.png" alt="" /><br /><br />Note your application ID and Application Secret<br /><br />Examples:<br /><br />Application ID: xxxxxxxxxxxxxxx<br /><br />Application Secret: yyyyyyyyyyyyyyyyyyyyy<br /><br />Enter your Site URL and Site Domain, this can be pretty much anything, but attempt to use your real information if available.<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand111.png" alt="" /><br /><br />Note Settings, App ID, API Key and App Secret<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand121.png" alt="" /><br /><br />Note: From here you can follow the link below for a detail tutorial on setting up permanent OAUTH access:<br /><br /><a href="http://liquid9.tv/blog/2011/may/12/obtaining-permanent-facebook-oauth-access-token/">http://liquid9.tv/blog/2011/may/12/obtaining-permanent-facebook-oauth-access-token/</a><br /><br />Below summarizes those steps:<br /><br /><strong><span style="text-decoration: underline;">Step 4: Obtain Permanent OAUTH Access Token:</span></strong><br /><br />Create and execute the below URL in your browser: Modify the below URL to use your client_id and redirect_uri - see notes in blog post link above set permission values accordingly. (<a href="http://developers.facebook.com/docs/authentication/permissions/">http://developers.facebook.com/docs/authentication/permissions/</a>)<br /><br />Your client_id is your App ID and the redirect_uri can be anything.<br /><br /><span style="text-decoration: underline;">Sample URL:</span><br /><pre>https://graph.facebook.com/oauth/authorize?client_id=<span style="color:#ff0000;">...&</span>redirect_uri=<span style="color:#ff0000;">http://wordsofthefamily.com/</span>&<span style="color:#ff0000;">scope=read_insights,offline_access,publish_stream,create_event</span></pre><br /><span style="text-decoration: underline;">Constructed URL:</span><br /><pre>https://graph.facebook.com/oauth/authorize?client_id=<span style="color:#ff0000;">xxxxxxxxxxxxxx</span>&redirect_uri=<span style="color:#ff0000;">http://wordsofthefamily.com/&scope=read_insights,offline_access, publish_stream,create_event,rsvp_event,sms,publish_checkins,manage_friendlists,read_stream,read_requests,user_status,user_about_me</span></pre><br />You will get the following screen - yours might be different depending on what permissions you selected - make sure at least that "Post to my Wall" is there.<br />If not verify your permissions based of off the permission link in the blog post.<br /><br />Click Allow<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand131.png" alt="" /><br /><br />Now note the URL that was created in the browser address bar and that you were redirected to your page that you placed in the redirect_url.<br /><br />You need the <span style="color:#ff0000;">code</span> value.<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand141.png" alt="" /><br /><br />The <span style=" ;font-family:Courier New;font-size:10pt;" >code</span> parameter will be a very lengthy string of random characters. Copy this value and hang on to it for the construction of a new URL.<br /><br />This URL will turn the generated code into a valid access token for your application.<br /><br />Sample of what is returned:<br /><pre>http://wordsofthefamily.com/?<span style="color:#ff0000;">code=fdfdfdfdfdfeereghyjj.eyJpdiI6IjczU2YwUVJmaUJocXJjM1plOUdzVVEifQ.psncSCrwu-1659AZCHd7UBpUdBYdKCmvwXSu2-WxLcxfRt6wtwKzcjYkblwshjbnRX0EhcSrbG_U83AOv9pDrfomcLB8SY3gH1VW083oM997NqM28czfeaWpd8uv6sjE</span></pre><br /><span style="color:#ff0000;"><span style="text-decoration: underline;"><strong><code>CODE Example:</code></strong></span> <code>fdfdfdfdfrert-8Qoj7wFkUqoCKWSEk89aCwd2zM.eyJpdiI6IjczU2YwUVJmaUJocXJjM1plOUdzVVEifQ.psncSCrwu-1659AZCHd7UBpUdBYdKCmvwXSu2-WxLcxfRt6wtwKzcjYkblwshjbnRX0EhcSrbG_U83AOv9pDrfomcLB8SY3gH1VW083oM997NqM28czfxxxrrer </code> <code><br /></code></span><br /><br /><code>Now Create the Following:</code><br /><br /><code>https://graph.facebook.com/oauth/access_token?client_id=...&client_secret=...&redirect_uri=http://liquid9.tv/&code=... </code><br /><br />Fill in your application ID, application secret, redirect uri, and the code we just copied. Again, ours looks like this:<br /><br />Constructed:<br /><pre>https://graph.facebook.com/oauth/access_token?client_id=xxxxxxxxx&client_secret=yyyyyyyyyyyyyyy&redirect_uri=http://wordsofthefamily.com/&code=xxxxxxxxxxx9_A-8Qoj7wFkUqoCKWSEk89aCwd2zM.eyJpdiI6IjczU2YwUVJmaUJocXJjM1plOUdzVVEifQ.psncSCrwu-1659AZCHd7UBpUdBYdKCmvwXSu2-WxLcxfRt6wtwKzcjYkblwshjbnRX0EhcSrbG_U83AOv9pDrfomcLB8SY3gH1VW083oM997NqM2xxxxxxxxxx</pre><br />You will get back an access token:<br /><pre><code>access_token=1111111332444877557776746ghhg758d8f970bd1cbc17.1-100002640151006|d9WWkjxODcel0ZVIZfMEv5YKc10 </code></pre><br />Now you should be able to use PDI and the HTTP POST step using the various FB GRAPH APIs to do things: <a href="http://developers.facebook.com/docs/reference/api/%20">http://developers.facebook.com/docs/reference/api/</a> such as posting content to the FB wall / news feed and etc.<br /><br /><span style="text-decoration: underline;"><strong>Step 5: Created a PDI Transformation using the HTTP POST step and the FB Graph API with /PROFILE_ID/feed</strong></span><br /><ol><br /> <li>Create a new Transformation</li><br /> <li>Use a Generate Rows Step (found under Input) to set the various Facebook parameter names that can be found here<br /><a href="http://developers.facebook.com/docs/reference/api/post/">http://developers.facebook.com/docs/reference/api/post/</a></li><br /> <li>Make sure to use the access_token parameter and value you got from the steps above<a href="http://sandbox.pentaho.com/wp-content/uploads/2011/07/Capture22.jpg"><img class="alignnone size-full wp-image-1815" title="Capture2" src="http://sandbox.pentaho.com/wp-content/uploads/2011/07/Capture22.jpg" alt="" height="284" width="682" /></a></li><br /> <li>Add HTTP Post step (found under Lookup) and connect hop from Generate Rows<br /><a href="http://sandbox.pentaho.com/wp-content/uploads/2011/07/Capture.jpg"><img class="alignnone size-full wp-image-1807" title="Capture" src="http://sandbox.pentaho.com/wp-content/uploads/2011/07/Capture.jpg" alt="" height="89" width="287" /></a></li><br /> <li>Configure the HTTP Post step to use the feed RESTful service <a href="https://graph.facebook.com/mpentaho/feed">https://graph.facebook.com/mpentaho/feed</a><br />Refer to http://developers.facebook.com/docs/reference/api/ <strong>Publishing </strong>section for list of methods<br />Replace mpentaho with your unique user name you set up earlier<br /><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand181.png" alt="" /></li><br /> <li>Jump to the Fields tab and click "Get Fields" under the "Query parameter" panel<br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand191.png" alt="" /></li><br /> <li>Click OK, Save and right click on the HTTP Post Step and select Preview, then Quick Launch</li><br /> <li>In a few seconds a panel should come up displaying your data</li><br /> <li>Check the result column (at the end) and look for a return code such as:<br />Example: {"id":"100002640151006_100565053374833"}</li><br /> <li>Check your newly created Facebook account wall and you should see</li><br /> <li>If not check your FB account security and application privacy settings to ensure the application has access.</li><br /></ol><br /><img src="http://michaeltarallo.files.wordpress.com/2011/07/071111_1645_facebookand201.png" alt="" /><br /><br />Regards,<br /><br />Michael Tarallo<br />Director of Enterprise Solutions<br />PentahoMichael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com1tag:blogger.com,1999:blog-3132043851181877353.post-71463384354994750762011-06-27T12:25:00.001-07:002011-07-07T20:31:18.494-07:00Pentaho Report Bursting with Pentaho Data IntegrationOriginally posted on the <a href="http://sandbox.pentaho.com/2011/06/bursting-pentaho-reports-with-pentaho-data-integration-4-2/">Pentaho Evaluation Sandbox</a><br /><br />Report bursting is the process of sending personalized formatted results derived from one or more queries to multiple destinations. Destinations can be file systems, email distribution lists, network printers or even FTP hosts. Allowing a greater method of distribution. Usually, the end result will display information pertinent to the recipient or location; therefore each recipient only sees their own data. Below is a brief example of how Pentaho Report Bursting can be achieved with Pentaho Data Integration 4.2. By leveraging Pentaho Data Integration's new Pentaho Reporting Output step, once can create a simple tasks that executes and renders multiple reports from a single Pentaho Report template. This is a truly powerful example of how Pentaho Data Integration can be used for more than just ETL.<br /><br />Special thanks to Wayne Johnson, Senior Sales Engineer for providing the sample and setup document.<br /><br />How To document and sample <a href="https://www.yousendit.com/download/MFo2QmtjNnkyWGMwTVE9PQ">here</a><br /><br /><iframe src="http://www.youtube.com/embed/0kIHZUQlCXw" allowfullscreen="" frameborder="0" height="549" width="625"></iframe>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com3tag:blogger.com,1999:blog-3132043851181877353.post-60194934921340125992011-05-31T04:29:00.000-07:002011-05-31T04:30:48.219-07:00Configuring Pentaho to use LDAP<p><span style="text-decoration: underline;"><strong>Before you Begin</strong></span></p> <p>The following tutorial should be used to setup a <em>simple reference implementation</em> of the Pentaho BI Server configured with LDAP authentication. The prerequisites needed in order to be successful with this tutorial include an existing installation and usage of the Pentaho BI Server and Enterprise Console, a simple understanding of LDAP and the ability to follow standard installation procedures using install wizards. The tutorial is represented from a Windows operating system perspective, but is applicable across multiple platforms. It is recommended that you get the <em>reference implementation</em> working successfully before configuring your Pentaho BI Server to use your own LDAP configuration.</p>The rest can be found here at the Pentaho Evaluation Sandbox.<br /><br /><a href="http://sandbox.pentaho.com/2011/05/configuring-pentaho-to-use-ldap/">http://sandbox.pentaho.com/2011/05/configuring-pentaho-to-use-ldap/</a>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-49481798564038550392011-05-21T08:48:00.000-07:002011-05-21T08:53:24.101-07:00Spatial Reporting with Pentaho and Google Maps<a href="http://presales.pentahosandbox.com/wp-content/uploads/2010/09/map.jpg"><img class="alignnone size-full wp-image-152" title="map" src="http://presales.pentahosandbox.com/wp-content/uploads/2010/09/map.jpg" alt="" height="513" width="735" /></a><br /><br /><b>Pentaho Experience Level:</b> Medium to Advanced<br /><br />Spatial or also known as Geographical Reporting, is a great way to answer the question: "<i>Where</i> are my....(fill in the blank here)?" It is a great way to visualize the spatial or location component of your data (Latitude, Longitude, Country, County, Region, City, State, Zip Code etc). It can also tell you where the lowest or highest concentration of a desired metric may lie with the use of color gradients or conditionally styled points. The ability to drill in even deeper, allows you to eliminate the surrounding areas and focus your attention on the areas that may need it most. The Pentaho BI Platform can take advantage of 3rd party visualization solutions such as the Google Maps API and integrate it as a component that can be used with the Pentaho User Console.<br /><br />Read more and come see and example in action here: <a href="http://sandbox.pentaho.com/samples-and-examples/samples-and-examples/dynamic-google-maps-widget/">http://sandbox.pentaho.com/samples-and-examples/samples-and-examples/dynamic-google-maps-widget/</a><br /><br />Regards,<br /><br />Michael Tarallo<br />Director of Sales Engineering<br />PentahoMichael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com2tag:blogger.com,1999:blog-3132043851181877353.post-24539271894983754972011-05-09T20:31:00.000-07:002011-05-09T20:33:10.926-07:00Unlocking Non-Relational Data with Ease<a href="http://sandbox.pentaho.com/2011/01/pentaho-reporting-and-pentaho-analysis/" target="_blank">Pentaho Reporting</a> can easily access data from many different sources; sources such as your traditional RDBMS, and even more advanced sources such as Java, XML, OLAP and our own <a href="http://sandbox.pentaho.com/2011/03/high-availability-and-scalability-with-pentaho-data-integration/" target="_blank">Pentaho Data Integration</a> transformations. Download these brief instructions (.doc) or watch the Techcast to learn how easily you can use a Pentaho Data Integration Transformation as a data source within the Pentaho Report Designer to unlock the power of non-relational data.<br /><br />View the <a href="https://pentaho.webex.com/pentaho/lsr.php?AT=pb&SP=EC&rID=34651817&rKey=d8748782d7bcdaa1" target="_blank">Techcast here</a>.<br /><br />Download <a href="https://www.yousendit.com/download/MEtUeEVmcGswVW52Wmc9PQ" target="_blank">document AND sample .ktr and .prpt files here</a>.<br /><br />To use the sample:<br /><ul><br /> <li>Unzip *.zip file</li><br /> <li>Copy Files to temporary folder</li><br /> <li>Use Report Designer and Open the PRPT file (the .ktr is already embedded in it)</li><br /> <li>Preview</li><br /> <li>Publish to Pentaho User Console as you would with any other Pentaho Report</li><br /> <li>Optional: Import .ktr file into PDI to see the simple transformation</li><br /></ul>Contributed by,<br /><br />Wayne Johnson<br />Senior Sales Engineer<br />Pentaho<br /><br />Originally posted on the Pentaho Evaluation Sandbox:<br /><br /><a href="http://sandbox.pentaho.com/2011/05/unlocking-non-relational-data-with-ease/">http://sandbox.pentaho.com/2011/05/unlocking-non-relational-data-with-ease/</a>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-62219713192531309582011-03-29T08:01:00.000-07:002011-03-29T08:03:42.778-07:00High Availability and Scalability with Pentaho Data Integration<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgq2i0UDNHOXoT9HUjGmWH-8zi-kuOzle-deot1s5BRLQPEnLqP3BRr_Pt5QE2tG0-XT19tG0KN7rPMsf1sNRL917Yju5QqYPFBus3mgcJwxxYmVbOWy2jyx04AnGga3mFZk2JYp_A8l2k/s1600/matrix2.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 310px; height: 320px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgq2i0UDNHOXoT9HUjGmWH-8zi-kuOzle-deot1s5BRLQPEnLqP3BRr_Pt5QE2tG0-XT19tG0KN7rPMsf1sNRL917Yju5QqYPFBus3mgcJwxxYmVbOWy2jyx04AnGga3mFZk2JYp_A8l2k/s320/matrix2.jpg" alt="" id="BLOGGER_PHOTO_ID_5589517552692939218" border="0" /></a><span style="text-decoration: underline;"><strong>Data</strong></span><br /><br /><span>“<a href="http://thinkexist.com/quotation/experts_often_possess_more_data_than_judgment/202234.html" target="_blank">Experts often possess more <strong>data</strong> than judgment.</a>”</span> - Colin Powell. Perhaps because they did not have a highly scalable Business Intelligence solution in place to assist them with their judgment. :-)<br /><br />Data is everywhere! The amount of data being collected by organizations today is experiencing explosive growth. In general, ETL (Extract Transform Load) tools have been designed to move, cleanse, integrate, normalize and enrich raw data to make it meaningful and available for potential decision makers. Once data has been "optimized", it can then be turned into "actionable" information using the appropriate business applications or Business Intelligence software. Significant information could then be used to discover how to increase profits, reduce costs or even suggest what your next movie rental on Netflix should be. The ability to <em>pre-process</em> this raw-data before making it available to the masses, becomes increasingly vital to organizations that must collect, merge and create a centralized repository containing "one version of the truth". Having an ETL solution that is always available, extensible, flexible and highly scalable is an integral part of processing this data.<br /><br />Read more here at the Pentaho Evaluation Sandbox:<br /><a href="http://sandbox.pentaho.com/2011/03/high-availability-and-scalability-with-pentaho-data-integration/">http://sandbox.pentaho.com/2011/03/high-availability-and-scalability-with-pentaho-data-integration/<br /></a><br />Regards,<br /><br />Michael Tarallo<br />Senior Director of Sales Engineering<br />PentahoMichael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-8855962038738895142011-01-22T22:58:00.000-08:002011-01-22T23:00:47.123-08:00Guided Ad hoc 2.0 with Pentaho 3.x<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_Ni4P_9G6tlS7WcfiKR_rVevJ9qPUQASwnCQmJGRV6TppuXQ92S_EbzwP_tH-rR14n-WpvYeUueTRmk9quriR6acwLIDhsY2Xfug52JpgETqRuuAHAk-Eine0mPXOYNp-7FYNff_EONQ/s1600/computer-out-window.jpg"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 272px; height: 320px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_Ni4P_9G6tlS7WcfiKR_rVevJ9qPUQASwnCQmJGRV6TppuXQ92S_EbzwP_tH-rR14n-WpvYeUueTRmk9quriR6acwLIDhsY2Xfug52JpgETqRuuAHAk-Eine0mPXOYNp-7FYNff_EONQ/s320/computer-out-window.jpg" alt="" id="BLOGGER_PHOTO_ID_5565272497364342322" border="0" /></a>A barrier that may be encountered when adopting a Business Intelligence tool is...ease of use. If the BI tool is too difficult for business users to use or understand, they may resort back to using antiquated desktop databases and spreadsheets. If the new BI tool is not being used to the best of its abilities, then the organization is not leveraging their BI investment. Therefore its dreams of consolidating information and delivering one version of the truth just went out the window. <em>**CRASH**</em> Sure training, mentorship and education can help with this barrier, however there are many individuals that are simply resistant to change. What if there was another way to provide robust reporting capabilities without a steep learning curve? Possibly with the creation of templates designed for a specific purpose? Let's leave the Dashboards, Ad hoc query and OLAP tools for the experts and provide a simpler way for the<em> technically challenged </em>to run and create reports.<br /><br />Read more about it <a href="http://sandbox.pentaho.com/guided-ad-hoc-with-pentaho-reporting/">here</a> and watch the tutorial and download the sample:<br /><a href="http://sandbox.pentaho.com/guided-ad-hoc-with-pentaho-reporting/">http://sandbox.pentaho.com/guided-ad-hoc-with-pentaho-reporting/</a>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-66632260432289266942011-01-12T07:42:00.000-08:002011-01-13T16:21:55.004-08:00Pentaho Reporting and Pentaho AnalysisThe Pentaho BI Suite consists of the following BI modules: Reporting, Analysis, Data Integration, Dashboards and Data Mining. The modules can be deployed as an entire package or as individual components that can be integrated and embedded. Traditionally, each module is used in conjunction with a specific business need. The focus of this article will be to highlight the differences and similarities between Pentaho Reporting and Pentaho Analysis. Most organizations already have some form of Operational Reporting and Analysis tools. These tools are used for tracking business performance, trends and uncovering potential problems that require action. Business questions usually fall into a few categories. Questions that are asked on a regular basis for certain time periods (years, quarters,months, weeks) and questions that are asked for a purpose - usually random in nature, posed to uncover potential problems or outliers and can be commonly referred to as Ad hoc queries or OLAP Analysis.<br /><br />Read more here: <a href="http://sandbox.pentaho.com/2011/01/pentaho-reporting-and-pentaho-analysis/">http://sandbox.pentaho.com/2011/01/pentaho-reporting-and-pentaho-analysis/</a>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-82788560832205792852011-01-06T10:51:00.000-08:002011-01-06T19:48:24.829-08:00See you in San Francisco at the Pentaho Global Partner Summit<div style="text-align: justify;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiaWIG03XqeHm2SvtQ2JAsRn5McJDM9EFgPflvAlwAm_Khu1ViR6nh-NAVVxWUwbIeQZf-vJOlK6X9eAoTYsFasQJc7PV8bQAF6BOgScvw80ZHzgeJwwwuLR1cPQCPoZKbQ9PMG_h3GZU/s1600/sanfrancisco3.jpg"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 320px; height: 241px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiaWIG03XqeHm2SvtQ2JAsRn5McJDM9EFgPflvAlwAm_Khu1ViR6nh-NAVVxWUwbIeQZf-vJOlK6X9eAoTYsFasQJc7PV8bQAF6BOgScvw80ZHzgeJwwwuLR1cPQCPoZKbQ9PMG_h3GZU/s320/sanfrancisco3.jpg" alt="" id="BLOGGER_PHOTO_ID_5559284695100107714" border="0" /></a>It is only the 6th of January and already this has been a crazy month.<br /><br />"Crazy" as in crazy busy. I'm sure you have heard the phrase before, but then again it depends on what industry you are in. A down economy has certainly not affected the Commercial Open Source space, I can tell you that.<br /><br />To add to all the excitement, on January 19th and 20th is our Global Partner Summit in San Francisco at the Presido Golden Gate Club.<br /><br />CTOs, architects, product managers, business executives and partner-facing staff from System Integrators and Resellers should attend this event. You can register and find out more here: <a href="http://www.pentaho.com/events/20110119_global_partner_summit/">Global Partner Summit</a><br /><br />There will be technology tracks, business tracks, Q&A discussion panels and more for all to take part in. This year I am honored to join the team to present a couple of topics that surely should not be missed.<br /><br />Sales Engineering will be holding sessions that will show you how you can brand and customize the default Pentaho User Console. I will also present how adding "Guided Ad hoc" to your applications can provide business value to those who are not so accepting of the out-of-the-box tools.<br /><br />You can view the full agenda <a href="http://www.pentaho.com/events/20110119_global_partner_summit/agenda.php">here</a><br /><br />I look forward to speaking with many of you as well as, once again ,visiting my home away from home...San Francisco.<br /><br />See you there.<br /><br />Michael Tarallo<br />Director of Sales Engineering<br />Pentaho<br /><br /></div>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-75946041246977419192011-01-05T08:35:00.000-08:002011-01-05T08:48:28.191-08:00Pretty is not a decision maker<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVDlT5xxb3uQJAxI_0M6vxGN1YWIFY1acqcHb-Qeyk1cg3HmlvBJzuXmXqmd3BwOgIQ4VhHYahPd3CBohFJOrGdomTvumsSHOPhGKoYrLShAg5y0-SoPnMdGyunZ5MFBLfzONGOo6Qr-Q/s1600/images.jpg"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 265px; height: 190px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVDlT5xxb3uQJAxI_0M6vxGN1YWIFY1acqcHb-Qeyk1cg3HmlvBJzuXmXqmd3BwOgIQ4VhHYahPd3CBohFJOrGdomTvumsSHOPhGKoYrLShAg5y0-SoPnMdGyunZ5MFBLfzONGOo6Qr-Q/s320/images.jpg" alt="" id="BLOGGER_PHOTO_ID_5558741731923901698" border="0" /></a>"Beauty is only skin deep." "Physical beauty is superficial." Blah, Blah, yeah I know, I am sure you've heard it all before.... and "No" they are not phrases coined by some "ugly duckling" in an attempt to make it feel better about itself. However, physical characteristics will always play a part in how we as humans are initially captivated and intrigued. It's true for how most of us consider our mates... it is even true for how some organizations consider BI software.<br /><br /><br />When I was with a proprietary BI vendor (before the explosive disruptive model of Commercial Open Source BI), I spent 3 weeks on site with a prospect conducting a POC (Proof of Concept). It was well received for both its data integration and information delivery functionality. However, even though we had specific data integration capabilities that surpassed the competition, we still lost because the <em>business users</em> liked the competition's "<em>Prettier Dashboards</em>". The first thing out of the IT Director's mouth was... "Well, we went with <vendor>"Vendor B", their dashboards just looked better." Completely disregarding the specific EDI integration that we brought to the table. Huh..I pondered for a few minutes...scratching my head with a puzzled look. Cocking my head slightly to one side I rebutted, "That's disappointing, since when did 'Pretty' become a decision maker?" The Sales Rep looked over at me and smiled. That was over 5 years ago.<br /><br />More recently, inspired by a colleague of mine, Gabriel Fuchs and his web post <a href="http://www.information-management.com/news/1030748-1.html" target="_self">Data Visualization – Cool is Not a Key Driver</a>! - I am still overwhelmingly surprised how much emphasis organizations put on the importance of "having nice looking dashboards" without really knowing what is involved under the covers. Further more they have a tendency to not know what charts or visualizations should "go" with "what" data. (You'll be surprised at how many simple line charts are used incorrectly or when to use or not use a pie chart) I have heard so many colorful descriptions I had to wonder if they really understood the business value behind a BI solution at all. From dashboards that are "Nice and Friendly" to those that are "Fancy, Sexy, Sizzle and In your face". At times I was wondering if they were describing their ideal mate or the latest and greatest automobile.<br /><br />All too often, IT or the occasional business user will start researching BI solutions and stumble upon a software package that appears to do what they need. Perhaps they were able to get a "Fancy" dashboard up and running quickly. Soon they may find that the proposed solution is either too costly, not scalable, only runs on Windows, cannot access all their data easily or perhaps only provides dashboards and lacks other critical BI functionality. They may have been initially captivated by the Siren's music but soon realize that the "Fancy" dashboard was just skin deep. 1 out of every 10 calls that I am on reveals that the prospects are <strong>only</strong> looking for just dashboards. When further discovery takes place, it is also learned that the "dashboard only" deployment is usually for just a few users and localized departmental data, not exactly an Enterprise wide solution. The rest of the prospective calls are looking for Dashboards as well as Reporting, Analysis and more often than not, Data Integration. I mention Data Integration as well because these organizations have disparate data sources on many different platforms. They are looking to easily access, optimize and visualize this data that will be able to answer today's questions as well as tomorrow's questions, perhaps across the entire data set - not just a small slice.<br /><br />Here are some important facts to remember:<br /><ul><br /><li>Most business users do not understand the value of BI</li><li>It is important to show how BI can help knowledge workers do a better job</li><li>IT cannot just throw a BI application at the wall of business users and hope it sticks</li><li>BI is NOT a technology tool</li><li>BI involves specific business processes</li><li>BI applications can both drive revenue growth and can also reduce costs to optimize profits</li><li>Do NOT assume that Subject Matter experts understand BI and its potential</li></ul>Here are some key questions an organization should ask before they begin the process of finding a BI solution provider:<br /><ul><br /><li>What is your definition of a successful evaluation?</li><li>What data is needed in order to…..?</li><li>Where is the data I need in order to….?</li><li>How easily can I access all that data?</li><li>Do I have the proper skill sets to deploy a BI Application?</li><li>Do I want my business users to ask Ad hoc questions?</li><li>What questions do I or my business users want to ask of the data?</li><li>Do I need Operational reporting including schedule and distribution? </li><li>What have I found from my existing BI application(s)?</li><li>What actions do I want to take from my findings?</li></ul></vendor> I hope you now realize that there is a lot more involved than just that "Pretty Dashboard".Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-91196761108241961212010-12-28T14:07:00.000-08:002010-12-28T14:08:30.622-08:00Dynamic Pentaho User Console LogosThe following topic covers how the Pentaho User Console logo can change based on the user id or role of the user that logs in.<br /><br />This is performed by adding the <a title="UrlRewriteFilter" href="http://www.tuckey.org/urlrewrite/" target="_blank">UrlRewriteFilter</a> Java Web filter to the Pentaho BI Server installation.<br /><div align="center"><br /><object width="680" height="585"><param name="movie" value="http://www.youtube.com/v/zVYcRxqwxdc?fs=1&hl=en_US"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/zVYcRxqwxdc?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="480" height="385"></embed></object><br /></div><br /><br /><br />Learn how here: <a href="http://sandbox.pentaho.com/2010/09/demonstrating-a-user-group-defined-logo/">http://sandbox.pentaho.com/2010/09/demonstrating-a-user-group-defined-logo/</a><br /><br />Regards,<br /><br />Michael Tarallo<br />Sales Engineering Director<br />PentahoMichael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-82529988743826364902010-12-27T11:34:00.000-08:002010-12-27T11:38:41.652-08:00Dynamic Step Metadata with PDI<div style="text-align: left;"><a href="http://sandbox.pentaho.com/wp-content/uploads/2010/12/Capture.jpg"><img class="alignright size-full wp-image-1257" title="Capture" src="http://sandbox.pentaho.com/wp-content/uploads/2010/12/Capture.jpg" alt="" width="387" height="83" /></a> Did you know that Pentaho Data Integration includes <em>Experimental Transformation</em> steps? Experimental steps encourage proactive testing and critical feedback from the user community. The reported results are used to <em>harden</em> the product for the next revision. You can always provide your feedback, suggest new features and report issues <a href="http://jira.pentaho.com/" target="_blank">here on our tracking site</a> for any of Pentaho's product offerings.<br /></div><br /> One of the experimental steps available in PDI version 4.1 is the <strong>ETL Metadata Injection </strong>step. This <em>Transformation </em>step is used to dynamically set another transformation's step metadata, i.e the actual editable properties of a step.<br /><br />Transformation steps already ........ read more of this topic and download a working sample <a href="http://sandbox.pentaho.com/dynamic-step-metadata-with-pdi/">here</a> at the Pentaho Evaluation Sandbox.<br /><p style="text-align: center;"></p>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-40674367484809131992010-12-09T12:54:00.000-08:002010-12-20T11:52:00.456-08:00Pentaho Sales Engineering Live Techcasts<p>Greetings Everyone. Pentaho Sales Engineering is introducing live weekly Techcasts starting this Monday December 13th at 11 AM EST. The weekly Techcasts will cover a variety of topics ranging from installation and configuration of the Pentaho BI Server, to development, best practices and tips and techniques with the desktop and web based design tools. Anyone can join and take advantage of this valuable free education presented directly by the experts. Weekly events and descriptions will be posted in the Upcoming Events section on the homepage of the Pentaho Sandbox on the right-hand side. Click the link to join on the day of the even or download the latest calendar invite from the "Download" link below.</p> <p>I look forward to seeing you there.</p> <p>Michael Tarallo<br />Director of Sales Engineering<br />Pentaho</p><p>Click here for more information: <a href="http://sandbox.pentaho.com/2010/12/sales-engineering-live-techcasts/">http://sandbox.pentaho.com/2010/12/sales-engineering-live-techcasts/</a><br /></p>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-58653385910711910302010-11-30T06:04:00.000-08:002010-11-30T06:08:23.118-08:00"Drilling" in to the detail with Pentaho"Drilling".....(with respect to Business Intelligence applications and Information Technology). Where did that word come from? What does it mean? What can it mean? I am sure you have heard the phrase "Drill down to detail" before, but you may have also heard "Drill Up", "Drill Out", "Drill Across", "Drill In" and "Drill Through" and don't forget "Drill Anywhere". In general, it means to simply move from summary level information to underlying detail data, either within its current data set or even outside to another data set. Its main purpose is to allow one to easily view summarized information in the form of a chart, table or some graphical visualization with the added ability to "click" on a value, series or region and "drill in" to the next level of detail or out to some other dimension. "Drilling" allows business users to make informed decisions quickly without having to page through sheets of raw data. For example, summarized sales revenue for the year 2010 is $200K, but upon drilling down we see that $175K was brought in by 3 out of 4 regions, leaving 1 region with very low numbers. This now exposes a single region as being an outlier or a entity that needs focused attention. The power of Business Intelligence applications at work, turning raw data into actionable information.<br /><br />The Pentaho BI Suite can provide "Drilling" in a number of ways depending on which module you deploy. We will explore each of these in this article..........read more about it <a href="http://sandbox.pentaho.com/2010/11/drilling-in-to-the-details-with-pentaho/">here</a> at the Pentaho Evaluation Sandbox.<br /><a href="http://sandbox.pentaho.com/2010/11/drilling-in-to-the-details-with-pentaho/"><br />http://sandbox.pentaho.com/2010/11/drilling-in-to-the-details-with-pentaho/</a><br /><br />Regards,<br /><br />Michael Tarallo<br />Director of Sales Engineering<br />PentahoMichael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-22683129305107059692010-10-29T10:06:00.000-07:002010-10-29T10:10:08.535-07:00Pentaho Data Integration Reporting Plug-inI was recently invited, by Matt Casters (Pentaho Data Integration’s Chief Architect and founder of the Kettle Project) to test out a new plug-in for Pentaho Data Integration version 4.1 RC1. The Pentaho Reporting Plug-in, is a new transformation step entry that allows the execution of a Pentaho Reporting object (*.PRPT) to be rendered and saved to a desired location on a file system. With the included efforts of Thomas Morgner (Chief Architect and founder of Pentaho Reporting formerly JFree Report), Matt was ale to develop this plug-in in a very short time period due to the tight integration between both of the products; a “couple of evenings” to be exact. This plug-in can serve a number of use cases, from including additional reporting capabilities in to the actual flow of an ETL job to more advanced EII, EAI type work-flow processes. ork-flow. One of the most powerful differentiators of Pentaho Data Integration is that it is not just used for ETL. Along with the Pentaho BI Platform and Pentaho Reporting – real-time data access, data federation and data virtualization can be achieved.<br /><br />Check it out and give it a try here: <a href="http://sandbox.pentaho.com/Pentaho-Data-Integration-Reporting-Plug-in/">http://sandbox.pentaho.com/Pentaho-Data-Integration-Reporting-Plug-in/</a><br /><br /><div style="text-align: center;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.ibridge.be/images/pdi-pentaho-reporting-plugin.png"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 629px; height: 729px;" src="http://www.ibridge.be/images/pdi-pentaho-reporting-plugin.png" alt="" border="0" /></a><br /></div>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-14354154666557694932010-10-21T19:08:00.001-07:002010-10-21T19:09:37.033-07:00Pentaho Data Access and 3.7 New FeaturesCome see a brief tutorial of the new features available in Pentaho 3.7 as well as how easily one can prototype their data with the new Data Access and thin client model editor.<br /><br /><a href="http://sandbox.pentaho.com/tutorial-extra-pentaho-data-access-and-new-features/">http://sandbox.pentaho.com/tutorial-extra-pentaho-data-access-and-new-features/</a>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com1tag:blogger.com,1999:blog-3132043851181877353.post-91672784141339170482010-10-05T18:26:00.000-07:002010-10-05T18:42:02.686-07:00The Pentaho Pre-Sales Sandbox<div style="text-align: justify;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisI12_wn_Ia1kjd8koXXsEYa8wFpLk2uKEvuJKAAqNA5ebRUKEFModsXAVToIP3aA9xDvbxhhPAdgtIsHcJmq9me8pTiP-UNje9ZqfAGd37gE9XzbxcXnwb7WPwsJsD_qnX5Ys3B_dz6M/s1600/sandbox-300x243.jpg"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 204px; height: 165px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisI12_wn_Ia1kjd8koXXsEYa8wFpLk2uKEvuJKAAqNA5ebRUKEFModsXAVToIP3aA9xDvbxhhPAdgtIsHcJmq9me8pTiP-UNje9ZqfAGd37gE9XzbxcXnwb7WPwsJsD_qnX5Ys3B_dz6M/s320/sandbox-300x243.jpg" alt="" id="BLOGGER_PHOTO_ID_5524739150591614322" border="0" /></a><br /><strong><span style="text-decoration: underline;">Quick Bit About Pentaho</span></strong><strong></strong><br /><br />Pentaho has been all about building and delivering a scalable, complete end-to-end BI Suite from day one. From making the software "possible" during those humble beginnings to making it "available" and now "easy". You will find that Pentaho has an extensive offering that is both flexible and intuitive. Pentaho software has been targeted as the Commercial Open Source BI alternative by System Integrators, Consultancies, Enterprises, OEMs and SMBs. It has been deployed worldwide in a variety of industries; supporting mission critical applications which encompass both data integration and information delivery, all provided by "one" vendor, Pentaho.<br /><br /><strong><span style="text-decoration: underline;">The Pentaho Pre-Sales Sandbox</span></strong><strong></strong><br /><br />The Pre-Sales Sandbox is a resource that will streamline the effectiveness of the Evaluation/Selection process. With this resource at hand, you will be able to make an informed decision as quickly and efficiently as possible. Examples, tutorials, consolidated information are staged here to view and download to assist you in your evaluation process. Please be aware that the collateral available on this site can be posted on a moments notice and is intended to serve the masses as quickly as possible. Therefore the content downloaded may be a work in progress, a draft, incomplete, or limited in detail. Please see our website at <a href="http://www.pentaho.com/">www.pentaho.com</a> for more information about our products and value added services.<br /><br /><span style="text-decoration: underline;"><strong>Who should use this resource</strong></span><br /><br />This resource is primarily for those who are actively evaluating the Pentaho BI suite. It is not a replacement for our FREE evaluation support offering or the Pentaho Knowledge Base. It has been designed for those who are intending on exploring the power, flexibility and extensibility of the software. They have a basic understanding of Business Intelligence applications including information delivery and data integration. They are familiar with concepts of accessing data sources, creating and publishing reports as well as understand the fundamentals of ETL (Extract Transfer Load). They understand terminology such as metric, measure, dimension and have a general understanding of data modeling. Professional documentation for the Pentaho BI suite, including Administration and Security guides are located in the Knowledge Base.<br /><br />If you are evaluating Pentaho, or are simply a bit curious come check out the Pentaho Pre-Sales Sandbox here: <a href="http://sandbox.pentaho.com/">http://sandbox.pentaho.com/</a><br /><br />I hope to speak with you in person.<br /><br />Michael Tarallo<br />Pre-Sales Director<br />Pentaho<br /></div>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-81104711376311276302010-08-17T09:34:00.000-07:002010-08-17T09:36:09.564-07:00Top 3 questions asked to Pentaho Pre-Sales<strong></strong><strong>Can you...? How does...? Where do...? What is...? </strong><br /><br /><span style="font-weight: bold;"> Sound familiar?</span><br /><div style="text-align: justify;"><br /><br /><a href="http://pentahoadmin.files.wordpress.com/2010/07/questions.jpg"><img class="size-medium wp-image-635 alignright" style="border: 2px none ; margin: 2px 3px;" title="questions" src="http://pentahoadmin.files.wordpress.com/2010/07/questions.jpg?w=300" alt="" align="right" width="222" height="163" /></a>Pre-Sales Engineers are the stage performers of the IT world; immensely capable, adaptable, confident, excellent communicators who are equally cool in front of large crowds and intimate groups. If you are in a Pre-Sales role, you have the absolute pleasure of showcasing what your product / service / solution can offer to help prospects make an informed decision. Pentaho Pre-Sales Engineers, have numerous discussions everyday with qualified prospects that want to evaluate Pentaho and prove that the software can satisfy their goals. Most prospects are looking for a solution that will help them reduce costs, increase profits and make their businesses function efficiently. Part of my job is to identify a "fit" for these objectives and recommend an approach to take when evaluating. During these discussions I am asked many questions that have definitive answers and some questions that have more than one answer. I thought it would be helpful to share the 3 most common questions asked to my team and I and our responses.<br /><br /><span style="font-weight: bold;">Question 1: What is the most common reason an evaluation or implementation will not be successful?</span><br /><br />That answer is quite simple. So simple in fact I wrote a blog entry about it in March 2009. You can view it <a href="http://michaeltarallo.blogspot.com/2009/03/pentaho-evaluations-and-implementations.html">here</a>. However I will summarize it for you in one word.<br /><br /><span style="font-weight: bold;">Answer:</span> People<br /><br />People involved in the evaluation process of anything, are the lead cause for its success or failure. There are those who are self sufficient, "read" the provided materials, have the knowledge and expertise to get the job done with little assistance....then there are those that expect everything to be done for them. I elaborate more about this in the fore mentioned blog entry. However, for those who need a lot of hand holding, please be prepared to present clearly identified evaluation criteria to those you will be working with.<br /><br /><span style="font-weight: bold;">Question 2: What skill sets are required to use the Pentaho software?</span><br /><br /><span style="font-weight: bold;">Answer:</span> I will first state that having Java Engineering skills are <span style="font-weight: bold;">not</span> necessary. You <span style="font-weight: bold;">do not</span> have to be a Java developer to use Pentaho. This stigma can attach itself to not just Pentaho, but to other "Java" developed platforms. Someone sees the word "Java" somewhere in the Wiki or on the Web and they automatically assume they need to know Java. This is not true. Pentaho is built on modern open standards that are written in Java. All this should mean to you, is that Pentaho provides a cost effective alternative that can run almost anywhere that supports Java.<br /><br />Primarily, <a href="http://www.pentaho.com/services/training/" target="_blank">Pentaho training</a> is the #1 skill set needed to really exploit all of the power that the software provides from the GUI design suite. Just like learning anything new, you should attempt to pick up the manual. I certainly wouldn't start driving a car without learning how to operate it first. Other skills that can help are a general understanding of BI technologies and terminology. Relating to terms such as KPI (Key Performance Indicator), RDBMS (Relational Database Management System) metrics, dimensions, operational reporting, analyitcs, dashboards, and even a little acronym known as ETL (Extract Transform and Load). Furthermore, if you want to dive deeper and start embedding, integrating and enhancing the applications...having a Java background or even a simple web development skill set is always a plus.<br /><br /><span style="font-weight: bold;">Question 3: How scalable / performant is your solution?</span><br /><br /><span style="font-weight: bold;">Answer:</span> I love this one. What answer do you think I am going to give? - Simply stated, your mileage is going to vary and greatly depends on what products you are using. Are you using the software for data integration or content delivery or perhaps both? I don't care if you have the beefiest machine on the block or are paying for the largest cloud, your scalability and performance are going to be dependent on numerous factors. Prospects are usually looking for exact sizing statistics. They want to have some predetermined knowledge of application performance as well as what hardware and software infrastructure they may need to provision. Fortunately, Pentaho has produced the <a href="http://www.pentaho.com/products/demos/showNtell.php?tab=papers&article=pentaho-linear-scalability">Pentaho Linear Scalability White Paper</a> for the BI platform, and an independent consultancy has created the <a href="http://www.bayontechnologies.com/bt/ourwork/pdi_scale_out_whitepaper.php">PDI Scaleout White Paper</a> for Pentaho Data Integration. These documents can give additional insight in setting those expectations. Pentaho Services can also conduct capacity planning sessions with prospects to give an estimate of what can be expected. In addition to the white papers please note that there are a number of real-world scalability <a href="http://www.pentaho.com/about/customers/" target="_blank">customer success stories</a> you can read about on our website.<br /><br />Thanks for your time, I look forward to answering your questions in person.<br /><br />Michael Tarallo<br />Pre-Sales Director<br />Pentaho<br /><br /></div>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0tag:blogger.com,1999:blog-3132043851181877353.post-53628505286336263642010-07-28T08:19:00.000-07:002010-07-28T08:24:32.657-07:00Part 3: Easily prototyping your dataHello everyone. Starting with Part 3 of the Pentaho Video Tutorial series, I will now be using <a href="http://wordpress.com">wordpress.com</a> to exclusively post future video tutorials covering the Pentaho BI Suite. The videos available from Wordpress are of a higher quality and are also shareable and download-able directly from the embedded video viewer.<br /><br />So please navigate here to view Part 3 and Part 4 of this series.<br /><br /><a href="http://michaeltarallo.wordpress.com/">http://michaeltarallo.wordpress.com/</a>Michael Tarallohttp://www.blogger.com/profile/17849332612249485125noreply@blogger.com0