Interviews and Events
- March 12, 2013 TDWI Minneapolis Chapter: Open Source BI Considerations and Implications – Checklist and Guide
- February 12, 2013: Using Open Source Software for Data Management, Julie Hunt, Hub Designs Magazine
- February 8, 2013: Article/excerpt links on TechTarget/SearchBusinessAnalytics:
- February 8, 2013: Interview with Melanie Luna, TechTarget
- January 10, 2013: Podcast with Jim Harris, OCDQ Blog
- December 13, 2012: Interview on Information Management
- November 8, 2012: Editor’s Pick, Radiant Advisors
About the Author
Lyndsay Wise is the President and Founder of WiseAnalytics, an independent analyst firm and consultancy specializing in business intelligence for small and mid-sized organizations. For more than ten years, she has assisted clients in business systems analysis, software selection, and implementation of enterprise applications. Lyndsay conducts regular research studies, consults, writes articles and speaks about how to implement a successful BI approach and improving the value of business intelligence within organizations.
Using Open Source Platforms for Business Intelligence
Avoid Pitfalls and Maximize ROI
Business intelligence is becoming a priority for many organizations. Open source has enabled businesses to develop tailor made solutions without the software costs and limits of proprietary offerings. Tying these together means adding the benefits of both and limiting the stumbling blocks associated with many commercial software offerings. A lot of the benefits surrounding open source BI are fairly obvious, such as community support and IT developer flexibility. Other benefits include collaboration, the focus on continuous improvement, non-proprietary software adoption, and the ability to customize solutions to target business use.
Looking at open source BI skill sets
Do skill sets differ for open source BI projects? Or can the same resources used for traditional BI projects and other IT initiatives be used within OS projects? When looking at IT development efforts, Java programming skills are essential, but what other skill sets should IT development teams have and which internal resources should be brought in to collaborate on design and development efforts?
A mixture of business and IT are required to get a broader picture of business and technical requirements, with more BI projects originating from business units. With this being the case, who should drive the efforts? These questions, and more are required when looking at how to get the most out of OS BI (and BI in general).
So far, some of the skills I have come up with are as follows:
1) IT project management
2) Java developer
3) ETL/data integration
4) Data modeler (depending on the solution)
5) Database optimization
6) Project sponsor
1) Project sponsor
2) Business rules expert
3) Line of business manager
4) Upper management support
What Readers are Saying…
|“Finally, a book focused entirely on Open Source BI (OSBI). Lyndsay has done a great job tackling this complex subject and making it digestible by both business and IT. She discusses the benefits and challenges to choosing OSBI compared to traditional enterprise BI software, in a fair and unbiased approach. It’s worth reading for all those considering OSBI for all, or part of their BI architecture.”
- Steve Dine – Managing Partner, Datasource Consulting
“It is an imperative that enterprises of all sizes develop their ability to procure and assimilate open source software. Open source is an increasingly important way that cost-effective enterprise software is being deployed and business intelligence is a leading industry for utilizing this approach. Full frameworks are now available for complete business intelligence delivery. “Using Open Source Platforms for Business Intelligence” is the handbook for understanding open source business intelligence and how it fits in an organization. Business intelligence has been changing to be more real-time, more analytical and more effective. Open Source Business Intelligence is not just about a new software deployment model, but it’s about being effective with BI as you utilize open source. No matter what business you’re in, you’re in the business of information and business intelligence is essential in harnessing the information asset. The understanding of open source business intelligence that Wise shares in this book is the essential background for keeping costs down and value up in your business intelligence program.”
- William McKnight – President, McKnight Consulting Group