/
Reports (Power BI)

Reports (Power BI)

Owned by Vilhjálmur Hallgrímsson
Last updated: Nov 24, 2023

The objective of this project is to create a Power BI report for The Fisheries Manager cloud service.

 

The Fisheries Manager offers versatile PBI (Power BI) reports that allow customization for individual customers' needs. Administrators can configure and connect to their accounts by providing a unique token to the API connection string.

Look and feel

The general look and feel should be bright, with a white background and a blue-themed color palette for the main components. It is still OK to spice things up with different colors. I leave this to the designer. Please see a few inspirations below. 

Old version 1
Old version 2
New?

Data

All the data is stored in the Oracle DB cloud service. Connecting Power BI to the data through API is straightforward. The data can be accessed through various views, which will be utilized in the report creation process.

Reports

  • Activity Report (MCS)

  • Trips Report

  • Catch Report

  • Sampling Report 

  • Zone Report

  • Vessel Report

  • License Report

  • DIM_CHOICES

  • DIM_COORDINATES

  • DIM_COUNTRIES

  • DIM_DATE

  • DIM_GEAR

  • DIM_LANDING_SITES

  • DIM_PARTIES

  • DIM_SPECIES

  • DIM_TENANTS

  • DIM_VESSELS

  • DIM_VSLCLASS

  • FACT_LANDINGS

  • FACT_LICENSES

  • FACT_LOCATIONS

  • FACT_VESSELS

Filters

In a filter section, the report should display the applied filter configuration. Filters should be user configurable where they can clear, edit and reapply filters.

It would be advantageous if users could save their preconfigured filters for future re-execution. 

Quick filters

Some reports may additionally have Quick filters to refine periods by:

  • today, 

  • the latest x weeks from today, 

  • latest x months from today, 

  • latest x quarters from the current quarter,

  • latest x years from the current year annual.

Layout

Each report should include a:

  • map,

  • a year-over-year comparison, 

  • a table with data drill-down capabilities down to the source (survey)

  • and KPIs.

Map features

Objects that can be displayed on a map are “Landing sites” and “Fishing zones”. Display the location of landing sites as icons on a map. Selecting a landing site will filter/zoom in to that landing site and filter its data. All reports, including maps, should be displayable in full-screen mode. The user should have a convenient way to navigate back to the full size-map (clear the filter).

As we are developing solutions for fisheries, are there any alternative maps/charts better suited for this besides the PBI maps?

Navigation features

When the user has drilled to a level where he can select a single vessel, species, gear, or landing site, he can navigate to the corresponding report and view its details.

Example

The user runs the catch report and drills down to a single specie, “Yellow Fin Tuna“. With the species in focus, the user is able to drill down and view the specie by a landing site or a vessel name. By selecting a vessel, the user will be able to navigate to and view the vessel report with the selected vessel in focus.

The Activity Report (MCS)

The Activity Report is a Monitoring Control and Surveillance (MSC) report that displays fisheries activities

in real-time (or near real-time, let's discuss). The primary report component is a map that can be displayed on full-screen on a wall-hanging monitor.

  • Using custom icons for landing sites (Green, Gray, Orange, Red) and in different sizes (large, medium, small) 

  • Green, large = landing status “In Progress” 

  • Gray, small = landing status other than “In Progress”

Mockup

  • The number of boats out (status = departed)

  • Display the shape of all valid zones 

  • VMS vessel current location and tracks (later)

  • Logbook catch reports as heatmaps (later)

  • KPIs. Show the current value since the beginning of this day and how it compares to the average of the past x days (configurable in a filter). Is the current value above or below the average?  

    • The number of landing sessions completed, in progress, and scheduled

    • The number of vessels out by vessel class

    • The number of samples collected

    • The total number of species landed

    • The total weight of catches

    • The total value of catches

Trips Report

The Trip Report displays fishing trip activities over a period of time. Selecting a sub-report will commence data drill down into the underlying data.

MAP: Selecting a landing site from the full-size map will zoom in to that landing site and filter the data. We need a convenient way to navigate back to the full size-map (clear the filter).

YoY: Compare this year's values to the previous year (years) (By day, week, month, quarter, year?) 

KPI: Selecting a KPI will filter the YoY 

  • The total number of trips by type

  • The total number of landings 

  • The total number of active vessels

  • The number of vessels having status departed

  • The number of vessels having status arrived

  • The number of crew members by role 

  • The number of crew members by gender

  • The number of crew dependents

  • Fuel used

  • Total number of boats operating at the landing site

Catch Report

The Catch Report reports on catches for landing sites.  

We store species images in the database. Can we display images for species?

MAP: Selecting a landing site from the full-size map will zoom in to that landing site and filter the data. We need a convenient way to navigate back to the full size-map (clear the filter).

YoY: Compare this year's values to the previous year (years) (By day, week, month, quarter, year?) 

KPI: Selecting a KPI will filter the YoY

  • Species by weight

  • Species by landing site

  • Species by the gear used 

  • Species by the gear class

  • Species by the vessel name

  • Species by the vessel class

  • Species by total price

  • Species by average price

Sampling Report

The Sampling Report reports on how data collection progresses compared to a sampling plan.  

MAP: Selecting a landing site from the full-size map will zoom in to that landing site and filter the data. We need a convenient way to navigate back to the full size-map (clear the filter).

YoY: Compare this year's values to the previous year (years) (By day, week, month, quarter, year?) 

KPI: Selecting a KPI will filter the YoY

  • Sampling planned dates (targets) vs completed dates (calendar?)

  • Number of samples collected 

  • The number of targets missed, the progress of data collection vs target?

Zone Report

The Zone Report displays the outline of fishing zones and reports on zone types and status.  

MAP: Selecting a landing site from the full-size map will zoom in to that landing site and filter the data. We need a convenient way to navigate back to the full size-map (clear the filter).

  • Draw the outline shapes of zones by type, each type having different line colors,

  • Option to select the shape and configure fill color, transparency, and fill pattern.

YoY: Compare this year's values to the previous year (years) (By day, week, month, quarter, year?) 

KPI: Selecting a KPI will filter the YoY

  • The number of zones by type

Vessel Report

MAP: The vessel report displays the homeport of vessels, their number, vessels by class, propulsion type, and license status, and summary of gross tonnage. 

A list of vessels by name, registration number, and class.

YoY: Compare this year's values to the previous year (years) (By day, week, month, quarter, year?) 

Selecting a single vessel displays its image, registration information, measurements, a list of associated parties and their roles, a list of gear operated, propulsion, a vessel license status, the vessel history, and the vessel license history.

Selecting a single vessel navigates to the vessel catch report prefiltered filtered on the selected vessel.

KPI: Gross tonnage, vessel class, propulsion type, license status

License Report

The License Report displays the number of licenses by type and status. 

MAP: 

YoY: Compare this year's values to the previous year (years) (By day, week, month, quarter, year?) 

KPI: Selecting a KPI will filter the YoY

site,

Inspirations for Look and Feel

New?

 

 

 

 

 

 

 

 

Fisher License

Available Background Colors:

Navy, Orange Green, Light Blue, Red, Teal, Purple.

Icon images can also be provided isolated i.e white with transparent background.

Dasgboard/Command Center
Generic License
Vessel License
Fishing Trips
Vessels
Cach Report
Ports/Landing sites
Species
Fishing Gear
Company Logo

 

 

 

Persons
Reports
Reports

 

Related content