Explore Yellowfin now with our sample datasetGet Started
A dashboard is a Business Intelligence tool used by business users to communicate and track Key Performance Indicators within particular subject areas or end user roles – such as finance, sales, marketing etc. Similar to a dashboard on a car it organizes multiple visualizations and tables from various data sources into a well organised format to provide the user with an at a glance view of business performance.
Using a variety of data visualizations across a range of metrics, dashboards help users to understand complex relationships in their data. A dashboard enables users to identify trends, discover their causes and act on the opportunities or challenges they imply.
A dashboard is a combination of one or more charts and or tables on a page (tab). The purpose is to aggregate various reports (metrics and dimensional view of your data) in different combinations so that end users get a full understanding of their key metrics and drivers. Typically to do this, you will need multiple unique reports which results in multiple database queries being generated.
The data returned from a report can be displayed in as a tabular or cross-tabular report or as one or more visualizations (charts, maps etc).
Dashboards may also include filters as well as images and text. It can also be made up of multiple tabs.
Businesses typically require a range of dashboards to support their needs. These include strategic, analytical, and operational use cases.
Strategic dashboards, often called executive dashboards, provide the at-a-glance overview that decision makers at all levels of the organisation need to monitor the performance of their business. These dashboards support users by providing them insight into the opportunities or challenges that their business may be facing by focusing on high level measures of performance and forecasting changes in those measures. Typically strategic dashboards are built from aggregated data – especially time aggregations such as weekly, monthly or quarterly views so as to highlight longer term trends and patterns.
Analytical dashboards are designed to enable end users to drill into the detail of their data and support root cause analysis. These are typically used by line management and business analysts. They include more contextual data, comparative analysis along with historical trends. These types of dashboards should enable the user to manually discover the reasons why changes occur by enabling drill down or drill through or automatically with augmented discovery capability. The data in analytical dashboards can be
Operational dashboards support the monitoring of specific business processes, activities or events where the data is constantly changing. These dashboards assist end users to act on changes immediately and as such the data is much more real time and reflective of what is occuring at the moment.
Dashboards can be used to track all corporate functions and across industries. Functions such as finance, sales, customer success, human resources, operations, IT, project management, and many more departments can benefit from dashboard either strategic, analytical or operational.
Reports can be wired together into a single set of common filters – so for example a single data filter, can filter every visualization on the dashboard regardless of the source of that visualization. Likewise, actions in a given visualization such as brushing and drill, can trigger corresponding actions in other visualizations.
Dashboards can consist of a single page, or multiple pages arranged as sub-tabs. Filters can be passed between sub tabs so that if you user filters data in one tab, those filter values will be applied to reports in subsequents tabs.
Dashboard layouts can be pre-defined or canvas style.
Predefined layouts are used when you want to quickly create a dashboard and ensure all report objects are aligned relative to one another. There is a large variety of predefined layouts available.
Canvas style layouts are highly flexible allowing multiple object types (report visualizations, text, images, buttons, filters and custom objects) to be arranged freely together, including in overlapping fashion to achieve complex designs. The canvas gives you the greatest amount of design flexibility.
Yes. Any report or visualization from any defined data source can be combined together on a Dashboard. Further, reports and visualizations from different sources can be linked to a common set of filters.
Yellowfin provides all the tools necessary to create stunning Dashboards. Using Dashboard Canvas, complex designs can be achieved with the ability to freely place a variety of rich content items in any position, and to fine-tune the look and feel of those objects.
Good design principles should be followed at all times to ensure that your Dashboard is not only aesthetically pleasing, but also conveys the necessary information in the most effective and efficient way for users at all skill levels.
Canvas style dashboards have unlimited flexibility. The Dashboard Canvas provides a WYSIWYG editor so you can quickly see your designs come to life – and a preview mode so you can interact with the draft Dashboard before publishing.
Multiple object types can be included on a Canvas:
Content can be freely manoeuvred – using drag and drop or via the properties editor. Control down to the pixel level (x and y coordinate).
Content can be overlapping and it’s z coordinate position can be manipulated – by sending the object backwards and forwards).
Fine grained control of appearance is possible, including defining colors from a preset palette, or even using the hexadecimal color code. Borders, edges, shadows and many other aspects of appearance are configurable.
Objects can be grouped together for easier manipulation.
Code mode allows for direct editing of certain html properties that define appearance – as an alternative to using the properties editor or drag and drop.
Further, code mode can be used to create custom objects and UX experiences.
There are a number of ways to achieve this in Yellowfin.
Action buttons can be added to a Yellowfin tabular report. These buttons can be configured to launch a url when clicked – data from the report can be inserted as variables into the url prior to it being called. Logic can be added to disable to the button based on data appearing in the report.
Logic can be added directly to a dashboard using Code Mode. Code Mode provides access to some of the underlying code of Yellowfin objects – allowing the behaviour to be modified, or for custom UI objects to be created. This allows for example, a custom button to be added that executes custom code.
Code widgets can also be created – these allow for server side execution of code and for reuse across the Yellowfin application.
Developers have complete control of this code, this includes the ability to connect to third-party APIs.
Using these capabilities, Developers can build Dashboard experiences that connect workflows across applications. For example, a developer could code a custom button that updates a third party application using the context of data selected from a chart or a report table. This could create a new lead record for a prospect in a CRM database for example. Alternatively, Code Mode can be used to create custom navigation experiences, such as buttons to toggle between different reports or custom filter logic.
In Yellowfin, charts are created on top of the result set returned from a report. Each Yellowfin report can contain multiple charts. This becomes highly advantageous on the dashboard, as the number of times the underlying dataset needs to be queried and processed can be highly optimized.
Yellowfin provides over 40 different visualization types out of the box ranging from standard line and bar charts, to more use-case specific charts like waterfall and funnel charts.
|Scatter||A scatter plot (points not joined) chart that allows the charting of 2 related attribute series. Can only be used if the data series are related. Useful for seeing trends in data that is not linear.|
|Treemap||Compares metric values via a size relationship. Can also be used to show hierarchical relationships.|
|Histogram||Shows the number of times a given value occurs in the dataset.|
|Box & Whisker||A chart which gives a quick overview of a series of values and their statistical properties.|
|Trellis||A segmented chart for which the behaviour is determined by the data selected.|
|Heat Grid||Plots the intensity of a metric across multiple categories.|
|Area Charts||You want to emphasize the magnitude of change over time. Use an area chart to show how much the value of a measure changes over time.|
|Bar Charts||You want to highlight values for easy comparison and plot your numbers horizontally. Use a bar chart to place less emphasis on time and focus on comparing values.|
|Column Charts||You want to highlight values for easy comparison and plot your numbers vertically. Use a column chart to place less emphasis on time and focus on comparing values.|
|Combination Charts||Combination charts, in effect, superimpose one chart type above or below another. Use to improve clarity and highlight relationships between data sets.|
|Financial Line||Use this chart to display a trading value with a subchart displaying volume.|
|Line Charts||You want to view trends over time by plotting data at points connected by lines. Use a line chart to plot many metrics.|
|Image Maps||If you do not have GIS defined columns you can use the Image Maps to create heat maps – these are a good way to display metrics with a spatial element such as Revenue by State or Country
You will only be able to render maps for which an image map has been defined.
|Google Maps||Google Maps allow you to render location data points onto a Google map which will be displayed as a Yellowfin Chart – along with associated Google map widgets.|
|Meter Charts||You want to measure the rate of change of a measure against pre-defined targets. Useful for dashboard reporting.|
|Numeric Display||Shows the value of a metric on a digital display.|
|Pie Charts||You want to show the relationship of parts to the whole. Use a pie chart to highlight proportions rather than actual values. If it is important to show actual values in the chart, avoid using the pie chart type.|
Choosing the right chart that best communicates the intent of your data is critical if you want your end users to be able to digest and act on them. To assist this process Yellowfin has an Autochart builder that automatically selects the best chart for your data selections or you can manually select the chart you want to use that best suits your data and communication intent.
Basically all charts fall into one of 6 categories:
In addition there are general principles that you should adhere to when designing your charts.
Choose the correct chart: Select a chart that suits the type of analysis that you’re trying to convey.
Charts are created within Yellowfin’s simple drag and drop chart builder, and offer a wide range of customization features including ability to change colors, fonts, axis formatting, labels and much more.
If you need to create truly custom charts that are not in the Yellowfin list or apply formatting that Yellowfin does not natively support you can use the JavaScrip Chart option in Yellowfin.
For location data Yellowfin provides multiple options to show this in maps or visualizations.
You can show points when you want to highlight a specific location, polygons when you want to show areas on a map or metrics on a rasta map image – like an SVG.
Your location data can be mapped in a variety of ways:
Yellowfin charts are capable of doing advanced calculations on top of the primary report resultset, expanding the possibilities for what can be done in a single report, and facilitating advanced dashboard performance optimization <see branching>:
It is worth noting that many of the functions above can easily be done in the report builder using calculated fields or advanced functions as well. What approach you use will depend largely on how your data is stored.
Using chart functions such as set analysis and variance functions you can quickly perform variance and comparative analysis such as year on year comparison without the need to modify your data through complex queries.
You can also use the Yellowfin Assisted Discovery function to automatically create comparative analysis for your. You simply select your data set, choose the dimension or time periods you want to compare and Yellowfin will automatically build the visualizations for you.
Yellowfin charts are able to offer a wide range of interactivity, facilitating deeper analysis, both within the chart and in the context of a broader dashboard, driving action on related reports simply by clicking a chart.<see dashboard interaction linking>
Yellowfin supports the ability to create multiple charts off a single report data set. The benefit of this is that unlike most other reporting tools only one query is generated for all charts and the data is re-aggregated in-memory. This helps to improve performance.
Some good use case for this are:
Yes chart series colour can be inherited from conditional formats applied to the report data table.
However, you do need to be aware that because charts have the capability to re-aggregate data you need to ensure your chart is at the same level of aggregation as your report data table.
Assisted discovery is a process whereby Yellowfin automatically performs analysis on a data set based on a user’s requirements. It then creates a set of visualizations combined with natural language narrative that a user can use to create visualizations and combine into a report.
It is ideally suited for exploring new data sets and for quickly doing detailed analysis of a known change in your data to look for root cause analysis and correlations.
Users have a variety of options to understand why trends in their data have changed. Apart from pre-defined analytic paths like drill through or drill down they can use assisted discovery to understand what changed and why. This type of root cause analysis helps them to quickly analyse their.
Assisted Discovery differs from drill down or drill through in two fundamental ways:
Yellowfin has a capability called Assisted Discovery built into its report builder. Assisted Discovery can automatically analyze data to assist with comparative and explanatory analysis by identifying important and relevant correlations. This can rapidly accelerate the work of a data analyst for example, who may be analyzing a set of data for the first time.
A series of algorithms are run over selected data, and insights are generated and displayed as a series of automatically generated visualizations and natural language narratives. The analyst can select the insights that they are most interested in, and instantly add those to the chart builder. These charts can then be shared, scheduled or combined into a dashboard.
Yes, users can initiate Automated analysis on a dashboard by simply initiating an ‘explain’ process from their charts or tables. The results of the analysis can be shared with all users.
In addition, if the user chooses they can use the results to create a new report and continue their analysis in a manual fashion or build new reports that they can share with others.
Yellowfin supports traditional operational and management reporting with rich tabular report functionality and pixel-perfect reporting. Reports can be exported into a variety of common formats and reports can be distributed via email or delivered to an FTP server for mass consumption.
Yellowfin supports the building of tabular and cross-tabular reports with standard reporting capability such as dynamically sectioning reports, creating totals and subtotals, and a variety of formatting and conditional options.
Reports are fully interactive and support drill-down (pre-defined hierarchy), drill-anywhere (drill to any field) and drill-through (drill to another report eg. more detailed report) and can even contain rich content such as url links, images, action buttons and even sparkline charts within a table column.
With Yellowfin, you can use a Jasper XML report editor such as iReports, or a BIRT XML report editor such as eclipse, to create pixel perfect “Crystal” style reports. This definition can be loaded into Yellowfin and leverage our existing functionality such as security and broadcast functionality for managing the report.
You would use these methods if you want to:
Yes, Yellowfin allows you to break up large complex tables into grouped sections according to selected dimensional values. Sections can be single or multiple section breaks. Any charts created will automatically be run and associated with each section.
Sections can also be formatted differently to show all sections on a single page, across multiple pages, and in tabbed display form.
Yes, Yellowfin automatically applies pagination to long tabular reports according to a pre-configured row count which can be customized.
You can query and blend data from multiple data sources into a single ad hoc analysis / report using Advanced SubQueries.
Yellowfin supports multiple options for period on period comparisons. For tabular reports, if you want to include periods and their values as new columns or rows, you can either append or union data from the same data source using SubQueries. Performing this across multiple data sources into a report is done using Advanced SubQueries.
For visualizations, Set and Variance Analysis can be used to perform period on period comparisons and calculations quickly.
For your reports, you can apply different kinds of formatting:
Yes, you can create rules to highlight or change the appearance of your column values, such as adding conditional icons, that will apply for both reports and charts.
Yes, you can use the calculated field builder in Yellowfin reports to perform simple and advanced calculations. You can also use our predefined formulas for popular calculations, insert your own formulas, and even perform calculations using Freehand SQL if necessary.
There are two ways in which you can create and share commonly used calculations:
The meta-data layer. This is the most flexible area to create new calculations. These calculations are made dynamically at query run time.
Create calculated fields stored in your database. This can be done via a Yellowfin data transformation process or done external to Yellowfin and Yellowfin just queries the results.
Both these methods allow governed formulas and calculations to be used by other report authors in the platform.
Yes, you can switch on column and row totals including subtotals according to selected dimensional values and report grand totals. These can be the result of simple aggregations or you can use calculated totals for fields such as averages or ratios.
Yellowfin supports both data level calculations and chart level calculations.
For data level calculations Yellowfin supports simple to advanced calculations, including complex CASE statements with the Calculated Field Builder in reports. If necessary, calculations can be performed using Freehand SQL to access native database functions as well.
For chart calculations Yellowfin ships with predefined functions that allow for set and variance analysis. The user configures these at the chart level and the calculations run against the report data set.
Yes, sparkline charts can be added into your tabular reports using our Sparkline Advanced Functions and Formatter to show sparklines as either line or column mini column charts.
Yes, report action buttons can be added into your tabular reports using our Action Button Formatter to trigger an action that is local or remote to the Yellowfin platform.
Yes you can add images into a report table. This is supported in multiple ways:
All reports in Yellowfin can be distributed to users, or groups of users, via email or FTP using Yellowfin’s “Broadcast” functionality – either as a link (which opens Yellowfin for full interactive viewing), or as a file attachment (Spreadsheet, html, word document, pdf).
Report broadcasting can be made contingent on meeting a predefined rule. For example, alert style reports can be triggered to only be sent when a key metric or the report meets a predefined threshold.
To configure standard email broadcasts you will first need to set up an SMTP server for Yellowfin to use.
Yes, when setting up a broadcast schedule this can be done in two ways:
The first, reports can be broadcast with different filter values set, and can be set up centrally by an administrator, or by individual users (personal broadcasts).
The second, reports can be broadcast where the list of recipients and filters for each of those recipients, is sourced from another report. This allows broadcasts to deliver individual report results for each recipient.
Yes, each user has the ability to create their own “Personal Broadcasts” that distribute the report to their email on a consistent or alert-based schedule. Any user with the appropriate permissions is also able to create and edit standard broadcasts.
Each broadcast can be configured to deliver only when a specific business rule is met. Consider a report that tracks user activity within an application. If there has been no activity, it wouldn’t make sense to send the report detailing that. By configuring an “Alert” based broadcast, we are able to define a delivery condition. Each time the report is scheduled to run, Yellowfin will compare the intended recipients’ resulting report against those rules, so only the users whose data met or cross the required threshold will receive the report.
Every component of a Yellowfin broadcast can be customized – for multi-tenant clients – this can also be done on a tenant by tenant basis <screenshot of good looking email report, branded>:
Email template formatting – what does the body look like visually, fonts, colors, images, etc? <email template of admin>
Custom body – created on a broadcast by broadcast basis
Report context – title, description, filter breadcrumbs can all be toggled for display
Report headers/footers – common branding that can be applied to every report
Excel is one of our supported formats, others include PDF, CSV, TXT, HTML, DOCX.