Base concepts
Attributes are describing indicators, usually in a form of general terms such as "country", "department", "product", "employee", etc. Attributes consist of members (instances) eg. "Czech Republic", "Sales Department", "Product XY", "John Smith". |
|
Dashboard typically consists of the most important tables or charts from reports and is primarily determined for managers who need quick overview of actual company situation. Special custom content can be added to every dashboard as a customization. Dashboards can also be shared for public via web. |
|
A virtual database of BellaDati's integrated data warehouse. Each data set usually represents data with similar characteristics (e.g. invoices, wages, costs) from one data source. Data set consists of data set indicators and attributes. Each report is build on single data set. More data sets can also be joined together. |
|
Data set indicators are defined within the data set and are available as musters for report indicators. Another settings (like aggregations, appearance, etc.) are not supported. Simply said, the data set indicators represents a raw numerical value (in the OLAP language it is a fact) with basic attributes - name, unit and rounding mode. Values of these indicators are straightforwardly stored in BellaDati's data warehouse directly from imported data. |
|
Member |
"Instance" of one attribute. For example, members of the "employee" attribute may be "Jan Novak", "John Smith" etc. |
Record |
Particular data row stored in the data set. Each record consists of indicator's value, members and date/time information and has the same structure within single data set |
An analytical output, providing answers to user's research according to the gathered data. Each report can contain description, tags and consists of one or more views (charts and pivot tables), comments and possibly attachments. |
|
Report indicator |
Report indicators are created in the report from the data set indicators or ad hoc. Unlike the data set indicators, report indicators are supporting wide range of various settings - member aggregation, time aggregation, apprearance, conditional formating, extended formula support with report variables etc. |
Detailed glossary
Term |
Meaning |
---|---|
Notifies data manager about changes in value of indicators in a particular data set according fulfillment one or more predefined conditions. |
|
Chart |
Graphic representation of analytical data view. There are a lot of chart types in BellaDati - eg. line chart, pie chart, bar chart, stack bar chart, horizontal bar chart, radar chart, horizontal heat map. Each of them offers a different way how to explore particular dimensions (time, indicators and attributes). |
Comments |
A short message or explaining information attached to report or table cells. |
Conditional formatting |
Conditional formatting allows user to adjust appearance of the particular indicators in table according to currently displayed values or their changes. |
A clone of the existing report, table or chart. Any future change of the copy does not affect the original report. |
Dashlet |
A basic item of the dashboard. Dashlets usually represent your existing views (tables, charts) from reports. Another types of dashlets have informational, supplemental or customizing function. |
Data source is typically a database, Microsoft Excel spreadsheet, text file or another services eg. Google Doc spreadsheet, FaceBook or enterprise services like CRMs (SalesForce, Amiando etc.). |
|
Domain |
Whole virtual space of the one registrated organization. Users of one domain can't access data in another domains. Domains are completely independent. Separate domains can also be suitable for individual divisions or SBUs of large international companies. |
Drill-down |
An operation which results in displaying more detailed data with higher granularity according to the chosen drill-down path. If you drill-down a member, you will see its child members. Eg. drill-down of particular affiliate can display its employees. |
Drill-down path |
A sequence of attributes which influences the results of the drill-down operation. It can be defined in the data set or chosen ad-hoc in the report. |
Fact |
Facts are equal to the data set indicators |
Filters |
Filters restricts data displayed in views according to selected members only or general member match pattern. Eg. you can set filter to show only the largest cities in a table or chart. General filter settings are also available when sharing data sets. |
Formula |
Formula is a tool allowing user to define its own new indicators. Despite using common mathematical functions, advanced functions such as regressions or getting different values of existing indicators in time or depending on their aggregation is possible. |
Geo data |
Geo data are pairs of location identification and its coordinates. In BellaDati, location can be represented as point or region. While point is identified by single pair of longiture and latitude coordinates, region comprises of multiple points creating the polygonal area. |
Group of indicators |
Group of indicator consists of one or more included indicators which have the same context (eg. wage components). Users can effectively work with the whole group like with a single indicator. |
iFrame |
iFrame is a feature, which allows users to embed their analytical views into the external website using HTML code. |
iGoogle |
iGoogle is a feature, which allows users to embed their analytical views into their personal iGoogle dashboard. |
An abstract data set, which represents data from two or more source data sets. This allows user to analyze mutual depencies of data from different data sources or can easily assign member IDs to their names (codebook). Data sets can be connected together according specified condition - inner, outer or cross join. Joined data set reflects all the changes in the source data sets. |
|
Member aggregation |
Specifies the way, how are the repeating data records of one member aggregated (in one time unit). The aggregation possibilities are: sum, average, minimum, maximum and count (of different members). |
Metric |
Metrics are equal to the report indicators |
News |
Dashlet, which shows actual and former changes mainly in reports and data sets within the domain. This dahlet also displays information about the author of those changes. |
Pivot table |
An analytical view in a form of flexible rows and columns. Users can adjust, what should be displayed on each axis (various attributes, indicators or time units) and choose the structure of the drill-down path for the current table. It is also possible to analyze indicators in pivot table through the conditional formatting. |
Predefined import |
Predefined import is a tool, which allows users to easily load columns settings from the first import during repeated imports. |
Query Scheduler |
A tool, which allows to schedule and control regular data synchronization. It's main purpose is to update data warehouse with actual data from data sources. |
Roll-up |
An operation, which displays less detailed data with lower granularity according to the chosen drill-down path. It's an inverse operation to drill-down. |
Sample data |
A set of predefined content, consisting of reports, dashboards, data sets and predefined imports. |
Sharing |
Sharing is a feature, which allows collaboration and cooperation among users. It's possible to share your data sets, reports or dashboards with other users in the same domain. You can also choose to delegate permission to edit your data sets and reports. Besides iFrame and iGoogle are another sharing tools, which allows you to share your views on corporate intranet or publicily via Internet. |
Time aggregation |
Specifies the way, how are the time units with higher granularity aggregated in the units with lower granularity. If you (for example) gather data in days but display them in months, the time aggregation determines if the "month" units show sum, average, maximum, minimum or count of the included day records. |
A set of individual users. The Domain administrator has a right to create, delete or edit these groups. He also adds new users to groups, remove users from groups and assign user roles to the groups. User group is a very useful tool, because users can share their reports or data sets with the whole group instead of choosing of all its individual members. |
|
User roles are designed to separate access to different functions for different types of users. Available user roles are "Domain administrator", "Report editor" and "Data manager". These roles can be combined without any restrictions. Only the Domain administrator has a right to delegate those roles to other users. |
|
View |
Basic element of the report - displays values of the indicators depending on user's criteria. Views represent flexible points of view to the user's data in a form of pivot table, chart or possibly custom content. Views allow you to use the "slice and dice" feature. |