Glossary, which contains a wide variety of definitions for commonly used terms and concepts.
Ski Team Tutorial Data
The tutorials and examples will make use of the tutorial content database (Ski Team), which can be included as part of the installation process. The data has been structured to provide a similar experience to that you may have had when reporting from many operational databases.
Ski Team is a ski tourism business that organises ski trips in various locations around the world and markets these to its existing clients. The Ski Team database contains information relating to the core tourism business. It contains details of the camps run, the athletes who attended those camps, and campaigns associated with sourcing athletes. In addition it does contain financial information related to the amount invoiced and received for each client taking part in ski trips.
The data in this database will assist managers of Ski Team to understand the profitability of each of their programs, identify who their most profitable clients are and better manage their best performing camps.
The main tables used in Ski Team examples are:
This contains information about each athlete and their participation on a camp. In this database the person fact will generally have one record for each camp and each person for every year. The fact record is concerned about the individual trips for each program.
This is a dimensional table which contains information about each camp. For example the name and location of the camp. Camp ID is the Key to this table.
The person table contains information about the athlete such as name and address details. Person ID is the Key to this table.
Yellowfin is designed to reuse components, such as Source Connections and Views, as much as possible. This model creates a hierarchy of objects within Yellowfin and understanding this hierarchy will assist you with this tutorial.
A source connection stores details of how Yellowfin will connect to an external database that you wish to report from. For every database that you wish to write reports for, you will have to create a single source connection record within Yellowfin.
Once you have defined a source connection you must create one or more view records that your users can report off.
Once a view is defined you can write a report against it. A report record is a report definition which defines which columns in your database you want to display and how you want to display them.
Once you have written reports, you can begin to construct your dashboard. You can place as many reports onto a tab as you wish. You can also create as many tabs as you wish on your own personal dashboard.
Storyboard is a presentation layer in Yellowfin that allows users to create slide shows with fully functional reports as well as text, images, and videos.
Content Creation Basics Tutorials
Report Basics Material
- Area Charts
- Bar Charts
- Column Charts
- Combination Charts
- Financial Charts
- Line Charts
- Meter Charts
- Pie Charts
Special Purpose Charts
- Basic Standard Tab
- Pre-Built Tab
- Standard Tab with Analytic Links
- Standard Tab with Series Selection
- KPI Tab
Advanced Report Concepts
Related Reports Material
KPI Reports Tutorials
Sub Queries Tutorials