8.1.1.2 Results Data

DFCS supports result entities’ data visualization based on pre-defined out-of-the-box datasets called subject areas. Each subject area is a pre-configured dataset that brings together all fact entities of similar grain and includes pre-defined relationships with their related dimension entities. Customized results data visualization canvases can be created by user to enable them or other staff to access and analyze results data more as per their specific requirement for a given subject area. The service offering also includes pre-built sample dashboards called Pre-Built reports for user to view results data.

Results Data visualization represents view of results (fact) data either via tables or via various graphics forms such as charts, pie graphs, scatter plots and other such sophisticated forms. Visualization can be for out-of-the box sample dashboards or custom requirements of user. There are many visualizations options that help user display data in the form of tables or various graphs and charts. Visualizations options include but are not limited to tabular data, pivots, bar graphs (Vertical, horizontal, stacked bar, etc.) pie charts, line graphs, scatter graphs, tree map, etc. This makes it easier for user to spot patterns and trends in massive data sets that are hard to identify with the naked eye. These interactive dashboards can be created by a business user to enable self and other staff to access information more easily, as data visualizations created by one user can be shared with other users too. Each graphical element has the potential to provide granular information that updates all visualizations in the dashboard as the user drills down into finer and finer detail even on a single given visualization.

To summarize, the main goal of results data visualization is to:
  • Make results (fact) data available for user for each subject area or granularity.
  • Make results (fact) data available for user for tabular view without the need to write complex SQL queries or without any dependency on any third party application.
  • Make results (fact) data available via graphic visualizations for data analysis and MIS reporting.
  • Access out of the box sample pre-built visualizations and pre-built reports for each subject area.
  • Access granular data via drill through.
  • Share data visualizations custom created by one user with other users within the organization.
  • Access sample Key performance Indicators (KPIs).
  • Options to export reports to multiple formats such as Microsoft Excel, Microsoft PowerPoint, PDF, and so on.
Visualization options can be seen in LHS top under the Visualizations button.

Figure 8-13 Visualization


Visualization

There are two ways to view results data:

1. Custom results data view

2. Pre-configured pre-built reports