概要
Yellowfinは、ドラッグ＆ドロップインターフェースを備え、コンピュータの知識のないユーザーでも簡単にご利用になれるソフトウェアです。これを使えば、特別なコーディングの知識なしに複数のデータベースの情報にアクセスできます。複雑な技術的知識なしで、ユーザーが慣れ親しんでいるビジネス用語でデータを扱うことが可能です。Where does the data come from?
Yellowfinは、データベースの技術的側面を隠蔽するメタデータレイヤーと呼ばれる技術を利用してレポート作成のためのデータベースアクセスを容易にします。メタデータレイヤーはデータを可視化するためにビューと呼ばれる機構を参照します。通常、ユーザーはメタデータレイヤーについて多くを知る必要はありません。
ビューはYellowfinの管理者によって作成され、日常的なビジネス用語を使用してデータベースにマップされています。使いやすいドラッグ＆ドロップインターフェースにより、レポートに使用するデータは簡単に選択できます。このレポート作成の実際については後の章で詳しく説明します。
Views consist of categories and items. The categories are logical groupings of items. For example in a human resource view the category of PERSONAL DETAILS could consist of items including last name, date of birth and gender.
When you build a report, you select items from a view, and then run a query. Yellowfin connects to the database, and retrieves the data mapped by the items you selected.
What about security?
Yellowfin is very secure. Your administrator has many options for managing security profiles. All of the rights you have as a user are granted by your administrator. The administrator defines:- The parts of the Yellowfin interface you can access. Your administrator can restrict the availability of Yellowfin functionality, such as access to certain menu commands;
- The Categories and Subcategories of reports that you can access;
- The views you can access for creating and editing queries;
- Your ability to publish public reports; and
- The data that you can access
The permissions assigned to each user define the content they can see and the functionality they can access. This profile-based security system allows a single report to be distributed to many users - with end users having access only to the information that they are authorised to see.
What Data Analysis can you do?
Using Yellowfin you can create many types of reports to suit your reporting needs. These can vary from basic tabular reports to far more advanced varieties.- With Yellowfin you may be able to create and distribute reports that are "drillable." This means that other users can simply click on values in the report to see more detail as they feel they need it, without having to run the query all over again.
- You can set up a report to include calculations and Conditional Formats.
- You can include prompts that let you obtain just the information you need, and filter out the rest.
- You can choose from a wide variety of chart formats to represent the data. If you think another graphical format would make the data clearer, you can change the format in a couple of mouse clicks:
