New/Custom Reports & Exporting Data
Faculty Profile allows you to create three types of custom reports: (1) Blank Document allows you to build a custom report from scratch; (2) Vita allows you to start from a sample vita report and edit as needed; (3) Export Data will extract raw data from Faculty Profile that you can open in Microsoft Excel. For information on the Blank Document and Vita options, see: https://www.digitalmeasures.com/activity-insight/docs/reporting.html. The following instructions for the Export Data option.
To Export Data
- Open Faculty Profile: facultyprofile.byu.edu
- Select Reports from the top menu bar.
- Select Create a New Report in the top right-hand corner of the page.
- Select Export Data.
- Step 1: Date Range. Select the date range for the information you wish to include in your report. If you wish to include all dates for which there is data, select All Dates.
- Step 2: Whom to Include. By default, all enabled users are included in the report. To limit your report to certain users or groups, select Change Selection. You can select to include particular individuals or all individuals in a particular college or department. If colleges, departments, and individual users are selected, these selections function using "and" logic, and the report will include all the selections you have made.
- To decide which accounts are included in the report, look at the options under Include These Accounts. Your options are “Enabled only,” “Disabled Only,” and “Enabled and Disabled.” Disabled accounts are accounts of faculty who have left BYU or who are no longer faculty members. NOTE: Faculty Profile uses the college and department listed in each user’s most recent Yearly BYU Personnel Information to determine who should be included (all previous units are ignored when determining who to include in a report).
- Step 3: Data to Include. You can click on Change Selection to select the fields you want to include in the report. Click on the Include All box to uncheck all options.
- Step 4: Grouping Method. The data in the report can be organized by unit, such as college or department, or by individual. For example, if you select department from the list, the report will be grouped for each department that you have selected. You can go under individual units and select only the items you want to include in your report by checking the box next to your desired unit.
- Step 5: Search Keywords. If there any specific keywords you want to have searched in your report, type those in here.
- Step 6: File Format. Select your desired file format and the files per screen you want to see.
- When you have completed your selections, select Save to save your selection and return to the Run Reports page.
- Review your selections and select Run Report (upper right-hand corner of the screen).
- Your report will appear on the bottom left-hand side of your screen. Click on it to open the report. (If you instead receive a warning message stating that you have exceeded the 20,000 record limit, please revise your report selections to include a narrower range of data.)
Manipulate the Data in the Downloaded CSV file
The raw data is downloaded in comma-delimited [CSV] format. Use Excel (or comparable apps) to open the file and manipulate the data.
Using the Keywords Feature in "Create a new report"
When running "Create a new report," Faculty Profile enables you to search for any specific text stored in faculty records, including the files they have stored to supplement their activity records. This might help in answering questions like
- Who has published recently in a given area?
- Who is best suited to pursue a given grant opportunity or to speak to an industry group or external constituent?
- What types of relationships do our faculty members have with a given organization through their service activities?
The data a user can search for is restricted by the scope and limitations of the security role that gives the user access to Run Reports. If the user only has the ability to run reports for particular users, he or she will only be able to search the information for those same users. (Also: If the user’s Run Reports permission does not include Show Hidden Data, the user will only be able to search fields that are not hidden for his or her scope of users.
- Select Reports in Faculty Profile
- Choose "Create a new report"
- Fill out the report parameters as desired.
- Type in the specific text you want to search for into the search box in Step 6. (Click on the ? help button for more assistance.)
To locate: Publications records between 2006 and 2009 for users in Chemistry that contain the text “amino acids.”
Step 2: Choose the years 2006 and 2009.
Step 3: Select the Chemistry department and whether to include Enabled, Disabled or both
Step 4: Choose data to include
Step 5: Select one report per Individual
Step 6: Type the text: "amino acids"
Step 7: Select the file format
When you search for keywords, all records that contain the words that you specify will be returned. It is important to note that search terms apply at a record-level, not a field-level. This means that if you search for “amino acids,” all records that contain those words will be returned—even if the terms are not found in the specific fields that are included in the output of your report per your selections in Select data to include. For example, if you select to only show publication titles and authors, but the text is found in the field that contains the abstract, the record will still be returned.
For personal assistance running reports, contact the Faculty Profile Helpdesk.