Knowledge is Power
BI Reporting is permission-based. Contact your FP Administrator if you need access to reporting. |
Introduction:
Understanding your important business data within Function Point is what gives you the power to grow. With BI Reporting, you can analyze data from across your entire FP system in one place. You also have the ability to customize reports, create report templates and choose how you want to visualize your data.
Watch us walk through the report in The New Business Intelligence Reporting Webinar.
Standard Reports:
-
To get you started, there are 26 built-in reports based popular use
- The original Function Point Reports you’re used to using are still available. Hover over the “Reports” drop-down in the main navigation bar and select “Standard Reports”
-
To access BI Reporting, select BI Reports
Generate a Report:
-
Select All in the left margin to view all available pre-defined reports under section “Standard Reports”. Your saved reports can also be found here under Saved Reports dropdown (explained in later section within this article).
- Select a report in the Choose a Report panel
- Select your report parameters in the Define Your Data column
Each dropdown field allows multiple selection. Select one at a time. The list will build up and appears like this:
- To remove your entry, click on x individually within a selection, or remove all on the x next to the dropdown arrow
- Leave all parameters blank to include everything. If you have been on the system for multiple years, this can be a big report, some delays may occur and restrictions may apply
- Select Continue at the bottom of the parameters
- How do you want to see your data? Select from the list in the “Pick a Visualization” column
- Select Table and choose which columns you don’t want to see by unchecking the blue box. Select Pivot Grid Premium to pick and choose to show in column or row
For a graphical report, select:
Bar Chart Premium
Line Chart Premium - Change your mind? You can always switch views and modify the data you have chosen
- Adjust Data dropdown will give the report parameters to modify. Click Apply to change the report setup.
Navigating the Report:
Table View:
This view is ideal for presenting data in a 2-dimensional view in rows and columns.
-
Modify the parameters just like the previous page
-
Drag and drop columns to arrange how you want to view the data by holding down the click and drag to the ideal position
-
Sort by the selected column by clicking on the arrow left of the column or right-click the column header
-
Rename the column
-
To remove a column, use the eye icon on the left margin
- Select the number of rows to view on one page in the number dropdown. Click the arrow beside the dropdown to scroll through the records.
“of 61” is the total number of records in the report. In this example, there are 61 records within the report. Because the view is showing 100 rows, I can see all on one page - Looking for more? For premium users, Add New Columns Premium feature allows you to add any related data field from Function Point into your report
- Add a Calculated Column Premium - create a column with a formula calculating over multiple columns within the report.
- Enter your choice of name for your calculated column and its format from the dropdown.
- Here, you are writing the formula for the calculation.
Select the column to include in the first part of your equation - Type in the Operator. On the right margin shows the available operators. As you create the formula, you will see an error message like this:
The system is constantly performing a validation check. As an operator is added, the system sees it as an incomplete formula, hence giving an error. Just keep going! - Repeat step 8-1 and 8-2 until your equation is complete
- You will see a message in green in your formula is correct
For premium users, don’t worry. Your work in #4 to #8 will not go to waste. There is a Save the report function for future use. Select Menu to Save the report. Make sure to use a unique name. Include your own description. The report is now available under “Saved Reports”
Pivot Grid (Premium)
This view is ideal to group or summarize data. The Pivot Grid provides a way to summarize the data by summing the selected data set and arrange them by choosing the data field to be in rows or columns.
For example,
I want to know a company’s YTD invoiced amounts.
- Select any report listed. For the purpose of the example, select “Invoice Data Report” from Pre-Defined Reports list.
- Filter the data to include on the report. If all data should be included, leave the field blank.
- Select date range
- Click Continue at the bottom of the page
- Select Pivot Grid in the far right column
- Click Build Report
- In the new pop-up window, select the fields to include in the pivot grid report.
- Expand Misc. menu, select Total and Balance and add to data in a similar fashion.
- Click Confirm. The data can be adjusted even after the Grid is created.
- To add more columns or fields, select the setup (first) icon under Options. This will bring up the pop-up window in the previous screen.
- Select Menu at the top right corner, click Export to save this report in Excel.
Note: the export will reflect the current view. If the expectation is to see the grid all expanded, expand before exporting.
Right-click on the dropdown arrow to expand or collapse all. - Click Refresh at the upper right corner to update the report with the most up-to-date data. This is a good idea if the report is generated during office hours while the current date is included in the report.
- Save As Premium to save this view for future uses. This report will be found in BI Report main page, Saved Reports list.
- Hover over Exit to see 3 options.
- Select New Report to bring you back to step 1
- Back to Dashboard to go back to Function Point
- Log out of FP to log out of Function Point completely
Bar Graph (Premium)
This view is best used when for comparisons. Let’s use the example of a report showing Invoiced 2018 Q4 by Client
- Like the Table View, select the most relevant report. For this example, select Estimated vs Invoiced vs Actual
- Select the date range.
Where the date filter is Data date set range, the data will include Jobs that contains activity (invoice, timesheet, etc.) within the range. Note that there is limited space. If the date range is too wide resulting in too much data, the graph may not be as meaningful - Select Bar Graph
- X-axis = only categorical columns like dates or names/status etc. For this example, add Company Name to the x-axis.
- Y-axis = numerical values are preferred but you can also add categorical columns.
For this example, add dollar amounts Invoice - Add the Job Status column to the report and then add it to Color By.
Note: This function only works with one column on the y-axis and only with the date and category data. Hover over the question mark for guidance. - The graph is now colour coded by Job Status. Each colour (Color By) representing a Job Status and the Invoiced amounts (y-axis) within each Company (x-axis).
- Graph customization
- Click this button to see Graph properties
- Input Graph Title. Note that this is independent of the Report name at the header.
- Click on the data colour square to change bar colour
- Click on the 3 dots for each column to rename the column
- You could even choose Stacked Bar view, to see a different representation of the Color By.
- Choose from Display All to show the labels (invoiced amount for each company) or Display None
- Instead of knowing the total invoiced amount, I want to know how many Jobs make up the total invoiced amount
- Click on the 3 dots next to SUM (Invoiced)
- Hover over Aggregate > select COUNT. If I want to know the average invoiced amount, select AVG.
- Try adding another column to the y-axis.
The error message will indicate that the Color By option cannot be used for when there are multiple columns in the y-axis. - Switch to Stacked Bar (like pie chart) from the graph properties.
- Open graph properties
- Select Stacked Bar from the Graph Type dropdown
- Option to turn off the value label for a better view of the stacked bars
- Hover over the category for data
- Remove Color By and proceed to adding Actuals Total to y-axis.
- The graph is now showing two scales for y-axis. Note the label on each side.
- Hover over Menu > Export will export the graph as it appears within BI Report page to PDF, PNG or JPEG.
- Hover over Menu > Export Raw Data will export the data that was used to build the graph to Excel.
Line Graph (Premium)
This view is most effective to analyze trends over time. Let’s use the example of a report showing Job count by month to see which is the busiest months.
- Select the most relevant report. For this example, select Job Data Report
- For line-graph, having more historical data will provide better insight into trends over time. For this view, leave date blank to analyze data across all date.
- Select Line Graph
This graph tells me the busiest month for delivering Jobs is October and November in 2018.
- To dive one level deeper, we can find out whether Job Type has any relation with the time of the year so we can better prepare resources.
Add Job Type to Color By - Each Job Type is a separate line. Tip: Filter to remove any Job Type that seems irrelevant information to the trend analysis
In 2018, October has mostly Website Jobs. In June 2018 and 2019, Event Planning was the most popular. - To have a clearer view of a selected line, simply click on the one of interest. The other lines will fade.
- To add a different dataset (example: SUM Invoiced) to compare to Job Count, remove Color By. The Color By function can only be used with a single y-Axis dataset.
Comments
0 comments
Please sign in to leave a comment.