Yellowfin launches analytics industry’s first virtualized integrated Data Preparation Module

Yellowfin launches analytics industry’s first virtualized integrated Data Preparation Module

Global Business Intelligence (BI) and analytics software vendor, Yellowfin, has launched the first ever integrated and virtualized Data Preparation Module for analytics. Data preparation describes the process of transforming data into consistent formats suitable for exploration, analysis and report building. Yellowfin’s new Data Preparation Module was launched alongside the latest version of its BI platform, Yellowfin 7.3.

Access the official Yellowfin 7.3 Release Notes HERE >

Fully integrated into the metadata layer of Yellowfin’s BI platform, the new Data Preparation Module offers clients a unique method of integrating, managing and acting on more data in less time.

Yellowfin’s Data Preparation Module will enable organizations to easily model, profile, clean, shape, enrich, secure and publish all data desired for reporting and analytics in a single BI environment. The Data Preparation Module will be included as part of a standard Yellowfin license at no additional cost.

Access and share Yellowfin’s Data Preparation Module brochure HERE >

“With this release, Yellowfin has delivered another first for the BI and analytics software industry,” said Yellowfin Co-founder and CEO, Glen Rabie. “Yellowfin’s virtualized Data Preparation Module uniquely addresses the cost, complexity, security and inefficiency issues encountered by typical approaches to data preparation. No other vendor in the market is solving data preparation challenges in the same way as Yellowfin.

“Yellowfin’s Data Preparation Module truly supports the needs of data analysts, enterprise IT and business users. Data analysts can independently prepare data for analysis in less time, IT can easily govern that data, and business users have fast access to data they can trust in order to make critical business decisions.”

Yellowfin’s Data Preparation Module has been designed to overcome common challenges encountered when preparing data for analytics in three ways, by:

  • Integrating data preparation processes directly into a single analytics environment
  • Offering comprehensive data profiling capabilities
  • Providing automated best practice metadata modeling functionality

According to independent industry analyst Dr Kevin McIsaac, CEO and Founder of the Data Science Institute, the Yellowfin Data Preparation Module is a significant progression for any company’s approach to advanced analytics.

“With 80 percent of data scientists’ time spent on data preparation, Yellowfin’s new module is a valuable addition that data professionals should investigate,” said McIsaac. “The benefit is your data scientist spends less time on data preparation, or can delegate this task to a lesser specialized data analyst or business user. Either way this is a big step forward in advanced analytics methodology.”

A virtualized approach: Govern all data and analytical content in a single environment

Rabie said the problem with traditional data preparation was that it forced organizations to undertake data migration processes, which put data governance and security at risk.

“Moving data from one environment to another increases the risk of unauthorized data access,” said Rabie. “A virtualized approach means data analysts can directly connect to, prepare and analyze data sources in one place.

“Delivering virtualized data preparation will empower Yellowfin’s clients to maintain unparalleled governance, consistency and security across of all data and analytics content. Any data preparation actions performed will be uniformly reflected across all content – from reports and charts, to dashboards and Storyboards.”

Yellowfin Product Marketing Manager, Ivan Seow, said that by conducting data preparation and analytics in a single application, Yellowfin was also enabling organizations to avoid the cost and complexity of a multi-tool approach.

“Typical data preparation and analytics practices, conducted in separate software applications, introduce unnecessary data provisioning bottlenecks,” said Seow. “Then, there’s the expense of learning and maintaining two products – not to mention the propensity for standalone ‘self-service’ data preparation tools to create untrustworthy and unsecure islands of disparate data.

“Yellowfin avoids the chaos of traditional data preparation by delivering a single source of truth for all enterprise data. Go from data source to dashboard in one analytics platform and environment.”

Data profiling: Quickly introduce new analytics-ready data sources

Yellowfin’s data profiling capabilities enable data analysts to quickly assess the shape and quality of their data. The data profiling functionality visually displays the number and distribution of data profiled, providing statistics on the values within each column (such as minimum, maximum, median, average, empty and distinct values or outliers).

“Yellowfin is the only significant BI vendor in the market that offers data profiling capabilities,” said Rabie. “Yellowfin’s data profiling functionality empowers data analysts to efficiently clean, shape, format and enrich new data sets.”

Seow said that Yellowfin’s data profiling features would enable data analysts to quickly confirm whether data being presented to users for analysis was complete, consistent and accurate.

“Yellowfin’s data profiling capabilities reduce the time taken to deliver new data for analysis to the business,” said Seow.

Best practice metadata modeling: Consistently deliver more insightful analysis

A key feature of Yellowfin’s data profiler is that it provides a list of Suggested Actions, which dynamically propose best practice metadata modeling solutions based on the profile results.

“Yellowfin dynamically suggests ways to clean, shape, format and enrich your data based on the contents of each column profiled,” said Seow. “Be empowered to deliver more trustworthy and insightful reports throughout the business in less time with Yellowfin’s best practice metadata modeling.”

Types of transformations available via Yellowfin’s data profiling functionality include the ability to perform numeric and date grouping; apply filters, formatting, case statements and calculated fields; append, standardize or remove incomplete or inaccurate values; translate values held in the data source into business-friendly terminology (Reference Codes); and assess a data set for attributes (such as zip or post code data) that would enable users to enrich data by adding a Yellowfin GeoPack. Yellowfin GeoPacks are pre-packed geospatial and demographic data points for specific countries or regions. GeoPacks can be downloaded from the Yellowfin Marketplace.

Yellowfin partner network buoyed by industry first

Yellowfin’s channel partners said that Yellowfin’s new virtualized Data Preparation Module would boost their businesses by providing clients with a powerful solution that addressed their data preparation needs.

Principal Consultant at Minerra, Steve Remington: “Despite me knowing that it’s really important for data to be prepared well in order to facilitate user acceptance and visibility, there’s also that trade-off of time. To literally be able to do my data profiling in one click with Yellowfin, that’s incredibly powerful.”

Principal at CBIG Consulting, Henry Lindsay Smith: “I am convinced Yellowfin and CBIG Consulting share some important thinking around virtualized data preparation and the usage of cheap compute power, rather than traditional staging of data, to deliver business users what they want.”

Partner and Senior Consultant at Viteco ApS, Peter Michael Sorensen: “I think Yellowfin’s Data Preparation Module is very useful functionality to have integrated in a BI tool. It gives you the opportunity to learn and explore your data in the preparation phase of your BI project.”

Yellowfin 7.3 launched

The latest version of Yellowfin’s BI platform, Yellowfin 7.3, is now available.

Yellowfin 7.3 contained significant enhancements to Yellowfin’s advanced data visualization capabilities, including the introduction of Set Analysis, and a new Content Creation Canvas. Yellowfin 7.3 also included a new range of API connectors with pre-built dashboards for third-party Web applications.

Watch: Yellowfin 7.3 launch Webinar

View: Yellowfin 7.3 launch Webinar presentation slides

Download the presentation slides HERE >

For an overview of the enhancements and improvements contained in Yellowfin 7.3:

  • Download the Yellowfin 7.3 overview brochure HERE >
  • Visit the Yellowfin 7.3 showcase page HERE >
  • Download the official Yellowfin 7.3 Release Notes HERE >
  • Explore Yellowfin’s new range of API connectors on the Yellowfin Marketplace HERE >

“Comparative business questions are some of the most common and critical types of queries organizations ask of their data,” said Rabie. “The new Set Analysis function in Yellowfin 7.3 makes it quick and easy to create comparative visualizations, without the need for deep technical skills or Sub Queries.”

Access and share Yellowfin’s advanced data visualization brochure HERE >

“The overhauled Content Creation Canvas provides the power and freedom to quickly create beautiful, purpose-built visualizations and analytical infographics via an intuitive drag-and-drop interface,” said Seow. “Meet your organization’s customized content needs, exceed expectations and drive user adoption – all without writing one line of code.”

Access and share Yellowfin’s Content Creation Canvas brochure HERE >

New API connectors delivered as part of Yellowfin 7.3 included Salesforce, Zendesk, Xero, Facebook, Expensify, MailChimp, XE (Standard & Medium Edition), Ring Central, SurveyMonkey and World Weather Online. New and improved versions of Yellowfin’s Twitter and Google Analytics connectors were also launched. Details regarding each connector can be found on the Yellowfin Marketplace.

“Connecting to your favorite Web applications is now even easier, with a new range of API connectors and pre-built dashboards delivered as part of Yellowfin 7.3,” said Rabie. “Be empowered to create, share and act on analytical insights from your most important third-party Web applications.”


– END –

About Yellowfin

Yellowfin is a global Business Intelligence (BI) and analytics software vendor passionate about making BI easy. Founded in 2003 in response to the complexity and costs associated with implementing and using traditional BI tools, Yellowfin is a highly intuitive 100 percent Web-based reporting and analytics solution. Yellowfin is a leader in Mobile BI, Collaborative BI and Embedded BI, as well as Location Intelligence and data visualization.

Over 10,000 organizations, and more than 2 million end-users across 70 different countries, use Yellowfin every day. For more information, visit

For regular news and updates, follow Yellowfin on Twitter (@YellowfinBI), LinkedIn (Yellowfin Business Intelligence), YouTube (Yellowfin Team) or email to subscribe to Yellowfin’s free e-newsletter.

For further media information, interviews, images or product demonstration, please contact:

Lachlan James, Yellowfin Global Communications Manager on +61 (0)3 8617 4954, +61 (0)431 835 658 or