TrustRadius
Yellowfin Review 6 of 6
Review: "Yellowfin as easy BI & Analytical tool for all kind of users of an organisation"
https://www.trustradius.com/business-intelligence-biYellowfinUnspecified8.422101
Samir Kumar Sahoo profile photo
Updated March 14, 2016

Review: "Yellowfin as easy BI & Analytical tool for all kind of users of an organisation"

Score 9 out of 101
Vetted Review
Reseller
Review Source

Overall Satisfaction with Yellowfin

We are re-seller, consulting and system integrator of Yellowfin BI application for our esteem customers. We have implemented many customer business use cases and also use in our own organisation across departments :

Here are some business problems we have addressed for our customers:

  • A framework for candidate sourcing, selection, hiring, on-boarding and
    retention for a large blue collar employee hiring company. The outcome of the framework is the availability dashboards and its
    associate reports to improve productivity, reduce risk and lower cost. The
    dashboard covers requisitions status, candidates timelines & hires.
  • Order Forecasting model - To prepare a 15-day rolling forecasting
    mechanism that will forecast the month-on-month and Y-o-Y sales orders
    for TS business in terms of product lines. An accuracy of ~90% is achieved
    using ARIMA modelling. This is achieved using Yellowfin and "R" integration.
  • Evaluating massive amounts of historical and real-time sensor data across
    assets in operations to optimize “my maintenance” (predictive )
    schedules and real-time executive dashboards with accuracy of data for large boiler room solutions.
  • Yellowfin’s Storyboard, Timeline and Collaborative tools make it easy to share data and insights across an organisation.
  • Strong Operational and Executive Dashboards that reflect the business KPIs and can send out prompts to people within the business based on rules.
  • Yellowfin makes it incredibly easy to create dynamic reports and dashboards which incorporate maps through locational intelligence functionality.
  • Yellowfin is a single license and all access is via a web browser making it perfect for both on-premise and cloud deployment. Mobile apps are also available.
  • User roles and source filtering allows Admin/IT to offer different functions/views by user group/role.
  • Mobile BI applications to support any device ..
  • API connectors ( YF 7.2 on the way in Mar16 ) for a range of third-party Web-based applications, data sources, Enterprises CRM/ERP apps & open data platform apps, including Salesforce, Google Analytics, Twitter, Youtube , Zoho CRM, XE.com & more coming to make endusers to integrate their applications for better benefits
  • Yellowfin Integration with Predictive analytical and Big Data processing tools like R, UDF, Spark to build rich applications for end users
  • Predictive analytics features within Yellowfin tool.
My selection of Yellowfin based on following criteria for the Indian market:

  • Availability in Linux platform to process high volume of transaction with CAL (concurrent user access license) model to use multiple server with high concurrent users
  • Dynamic storyboarding, collaborative and timeline approach for senior management
  • Fast development and deployment with web-based centralised architecture
  • Value/$- Yellowfin has been #1 on BARCs value/$ rating for the past 3 years. Plus it has a very simple user-based licensing model
Yellowfin provides almost all data sources to connect including RDBMS, Hadoop, enterprise Apps, CRM, ERP, analytical tools and custom connectors. Also it has the architecture to build views from various sources to integrate data that is used to build reports, dashboards and powerful collaboration and storyboarding for senior management. Yellowfin provides connectors for almost all social media and open source data platforms for easy integration.
  • Yellowfin believes that data is better when shared and the product has been built around that concept.
  • Role based access privileges enables customers to ensure data security and proper access control. Access control is defined for administrators, developers, analysts and end user level to properly access the data.
  • Multicast Server [can be] use to distribute and scheduling of reports with various format like PDF, XLS etc.
Yellowfin is well suited for:

  • All type of organisations from small, medium to large enterprises applications
  • All type of users in an organisations - Business users , Analysts and consumers
  • Large clustering installation with high volume of transaction under Linux platform with high number of concurrent users
  • Low budget customer engagements

Yellowfin Feature Ratings

Pixel Perfect reports
Not Rated
Customizable dashboards
10
Report Formatting Templates
10
Drill-down analysis
10
Formatting capabilities
10
Integration with R or other statistical packages
10
Report sharing and collaboration
10
Publish to Web
10
Publish to PDF
10
Report Versioning
10
Report Delivery Scheduling
10
Pre-built visualization formats (heatmaps, scatter plots etc.)
10
Location Analytics / Geographic Visualization
10
Predictive Analytics
9
Multi-User Support (named login)
10
Role-Based Security Model
10
Multiple Access Permission Levels (Create, Read, Delete)
10
Responsive Design for Web Access
10
Dedicated iOS Application
10
Dedicated Android Application
10
Dashboard / Report / Visualization Interactivity on Mobile
10

Using Yellowfin

Users and Roles

15 - Business users
Analysts
End users who view and analyze the data and reports ( Finance, HR, IT, procurement )

Support Headcount Required

3 - Support resources have good knowledge on the following for L1, L2 and L3 support
  • SQL
  • Linux
  • Web Services and Java
  • Business Intelligence Development
  • Communication skill
  • Support procedures & SLA
  • Incident logs - Remedy tools

Future Planned Uses

  • Predictive analysis
  • Large volume of data processing and Report & Data Sharing
  • Self Service BI
  • Mobile BI implementation
  • Management reporting using Storyboards with collaboration & timeline

Business Processes Supported

  • Order Forecasting: To prepare a 15-day rolling forecasting mechanism that will forecast the month-on-month and Y-o-Y sales orders for TS business in terms of product lines. An accuracy of ~90% is achieved using ARIMA, Neural Network, and Time-Series Modeling using Yellowfin as data visualization and R for predictive analysis... Calling R functions within Yellowfin to achieve this.
  • Specialized Workforce Hiring Dashboard and KPI: A framework for candidate sourcing, selection, hiring, on-boarding and retention. The outcome of the framework is the availability dashboard and its associate reports to improve productivity, reduce risk and lower cost. The dashboard covers requisitions status, candidate timelines & hires.
  • Risk Population Analysis: Modeling the risk population, length of stay and predicting the risk of over stay (cost, doctors allocation, optimizing the bed-admission) for specific medical conditions using a decision tree or SVM models using Yellowfin & R integration.

Innovative Uses

  • Integration of Yellowfin with R
  • Integration of Yellowfin with UDF (user defined functions)
  • Unique Chart ; Data Visualization creation using DashXML and Web Services integration
  • API connectors with many CRM, ERP, Open Source platforms, Web-based applications etc.
  • ISV integrations with many pre-build models

Evaluating Yellowfin and Competitors

Products Replaced

Yes - QlikView
The reason of replacement of lack of scalability of QlikView when the massive data to be processed
Cost of infrastructure was high ; Cost of Development is too high ; not able to integrate with R , UDF, Spark and most of the important connectors available in the IT market for the end user applications


Key Differentiators

  • Price
  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
  • Vendor Reputation
  • Existing Relationship with the Vendor
  • Positive Sales Experience with the Vendor
  • Analyst Reports
  • Third-party Reviews
Yellowfin product support Linux based low cost infrastructure that support large of data processing on Hadoop environment. Yellowfin also support clustering environment with massive concurrent users support.

Evaluation Lessons Learned

My evaluation would be on:
  • Large number of concurrent users testing
  • 1000 report distribution per minute using multicast
  • Connecting to Hadoop, Spark, UDF and a large number of connectors to open data platform, CRM, ERP applications

Yellowfin Implementation

Implementation

10
Design the data model and views for each dashboard is very important and it is the success factor
Configuration of cluster for large implementation

Implementation Details / Implementation Partner

  • Implemented in-house

Implementation Phases

Yes - 
  • Assessment and Requirement Gathering
  • Design: Modeling and View Development
  • Development: Report & dashboard development
  • Rollout: easily rolled out using on JAR file migration
  • QA testing and User acceptance testing

Change Management Lessons

Change management was a small part of the implementation and was well-handled - - Change logging system using ZIRA
- Document and code version control implementation
- Rebuild and Report rolled out

Implementation Issues

  • Web Services for custom development

Yellowfin Training

Training Types Used

  • Online training
  • In-person training
  • Self-taught

In-Person Training

10
Yellowfin provides 3 levels of training to support consumers, business analytics, developers and Administrations :
  1. Yellowfin BI Training - Level 1 (Exploration)
  2. Yellowfin BI Training - Level 2 (Advanced)
  3. Yellowfin BI Training - Level 3(Expert)



Online Training

9
Web-based training for large audiences for Level 1 and Level 2 I would suggest

Ease of Yellowfin Training

Yes - easy to learn with help of Wiki , Training Website and Sufficient documents and online company sponsored training available for users..
Very user flexible and online help .

Configuring Yellowfin

Product Configurability

9
Yellowfin product configuration is very much minimal and just right and few minutes of efforts... the configuration is fully depends on the platform, application server, database , web server and web services. The configuration is based on :









  1. Single Server Installation




  2. Separated Application and Database Server




  3. Multi Server Installation






Configuration Lessons

UI Customization

No - we have not done any customization to the interface

Extensibility and Customization

Yes - we have added extensive custom code - Java , UDF functions

Additional Customization Considerations

NA

Yellowfin Support

Support

9
  • Availability of 24x7x365 support team to cover all regions
  • Technical team well trained
  • Knowledge of product
  • Proper product documentation and support guidelines
  • Defined SLA

Yellowfin Customer Support Pros and Cons

ProsCons
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
No escalation required
Immediate help available
Support understands my problem
Support cares about my success
Quick Initial Response
None

Premium Support

No - Annual Subscription cost includes the support of product. Annual Subscription fee includes: Activation Fee, Support and Maintenance Fee, Upgrades, Patch fixes, and Software license Fee only.

Exceptional Examples of Yellowfin Support

To support a specific client request for a large E-commerce company in India. The client requirement was to support 500 concurrent users in clustering mode with unlimited named users to access the reports. Starting from setup/configuration to testing, the concurrent users were supported by the support team.

Using Yellowfin

Usability

9
Web-based centralised architecture with best user interfaces.

Usability Pros and Cons

ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
None

Easy Tasks

  • Installation, configuration and IT administration
  • Developing dashboards, reports and views
  • Report distribution, broadcasting and sharing
  • Mobile BI development

Difficult Tasks

  • Integration with open source platforms - but these are on the way on 7.2 release on March 2016

Mobile Interface Availability and Impressions

Yes - The Yellowfin mobile application for the iOS / Android platform is a native application that is created to suit the mobile experience in terms of layout, display, and interaction. The usual taps, pinches to zoom, and touch experience is supported in the mobile application to ensure a great mobile discovery experience.

Yellowfin Reliability

Scalability

9
- Tested 500 con-current users in Linux platform with 4 cores systems
- Tested with cloud based VM
- Tested with 1000 reads per minutes

Reliability and Availability

10
99.9% availability

Performance

9

Integrating Yellowfin

Ease of Integration

10
A framework based with dataset results

Systems Integrated With

  • Integration with R for predictive analytics
  • Integration with UDF ( User defined functions)
  • Integration with Spark processing for large data volume processing
  • Integration with any social media
  • Integration with many other connectors like SRC, ERP, HR , Marketing type of applications
It was on predictive modelling and returning result sets to the Yellowfin applications ... Not that difficult ; just to follow certain steps to achieve..

Future Integration Plans

  • Zoho CRM
  • Sugar CRM
  • Salesforce
  • XE
  • Workday
  • SAP
Yes it is planned for 7.2 version

Types of Integration

  • File import/export
  • Single Signon
  • API (e.g. SOAP or REST)
  • Javascript widgets
  • ETL tools
  • AppExchange or similar marketplace
ERP, CRM, HR

Integration Lessons Learned

Extend a minimum of 10 open data platforms and free softwares

Relationship with Yellowfin

Pre-Sale Experience

10
- vendor support trial licenses for 2-3 months
- Supports for a POC development
- Flexible in custom pricing based on Named user , Server licenses and Con-current Access Licenses
- Support within SLA
- Proper and sufficient documentation
- Knowledge base

Post-Sale Experience

10
- Support is SLA based and timely
- Support on professional services , training and documentation
- Volume education

Key Negotiation Points

- POC development
- Con-current user connection license model
- Trial period

Dealing with Yellowfin

- Choose the con-current user testing during POC period
- Process large volume of datasets

Upgrading Yellowfin

Upgrade Process

Yes - No impact on upgradation

Upgrade Benefits

  • Large number of connectors
  • Design and Architecture of Reporting env
  • Analytical functions additions
  • More organised dashboards
  • Improvement of server performance

Anticipated Benefits from Future Upgrades

  • Predictive analytics features within Yellowfin
  • NLP & Mining functionality
  • Integration with SAS, rapidminer, R within yellowfin

Migrating Between Editions

Future Edition Upgrade Plans