Chapter 3: An overview of Plan Analytics
Transcript of the video:
Strumming guitar plays.
Onscreen text: Charles Schwab. Own your tomorrow®. Plan Analytics. Introduction and Overview.
Female voiceover: Plan Analytics gives you useful information about your plan so you can make decisions that help your employees get the most from their retirement plan. This video shows you a quick overview of the Plan Analytics tool.
Starts at Employee Status Overview screen.
VO: Once you launch the tool and it loads, you’ll quickly see a lot of information. To start, in the Report View area you’ll see the Overview, which includes several report views in a dashboard-type layout.
The Employee Status Overview, Allocation by Position, Net Investment vs Market Value, and Plan Assets and Performance by Position sections are highlighted one by one.
There are participant demographics, asset allocation information, a past performance chart, and a past performance table. This is just a quick overview of the plan. Most of the navigation occurs in the left panel.
Cursor moves to left rail.
VO: These three lines in the left panel are your Menu icon.
Cursor hovers over the Menu icon. A column of options appears.
VO: When you hover over the Menu icon, you see report groupings. There are report views within each grouping.
Cursor hovers over Performance and the following options appear: Investment vs Value, Cumulative Returns, Performance Summary Charts, Performance Summary Multigrid, and Performance Summary Table.
VO: The main grouping is by performance, so if you’re interested in doing analysis about rate of return, you would select Performance.
Cursor next hovers over Participation, and the following options appear: Multiview of Participant Data, Ranges of Participant Data, Dispersion of Participant Data, and Employee Status Overview.
VO: You also have Participation, which shows the demographics of the participants.
Cursor next hovers over Balance & Activity, and the following options appear: Position Summary, Allocation Summary, Cash Flow Analysis, Activity Summary, Activity Details, Balance History, Transaction Activity, Activity Trends, and Allocation History.
VO: And then there’s Balance & Activity, which has the most report views, including activity, balance, and transactions.
Zooms back out to Overview screen. In the top left corner, Selected Balance and Selected Participants are highlighted.
VO: The left panel shows you how many participants you are viewing and their cumulative balance. By default, the analysis period is year-to-date, but you can change it.
Cursor hovers over the information icon under Analysis Period.
VO: For additional information, just hover over one of these information icons.
Clicks on Analysis Period dropdown.
VO: If you click this dropdown box, you can see the prefilled analysis periods, as well as a custom filter that allows you to set a date range. In this example, three years of data is selected.
Selects 2015 from Analysis Period dropdown.
VO: If you select 2015 from the dropdown box, you’ll have a full year of information to analyze.
Clicks on Position, Asset Class, and Contribution Type under Asset Filters. Each one expands to reveal a list of checkboxes for further selection.
VO: You can then choose to view the information by position, asset class, or contribution type. You can filter by assets, use computed filters such as balance and plan returns, and filter by participant demographics and activity.
Clicks on Employee Status under Participant Filters. The Active and Eligible boxes are checked.
VO: If you only want to view active and eligible participants, expand the Employee Status Participant Filter and select Active and Eligible. So now you are looking at only 3,364 participants out of the original hypothetical plan of 8,418. Also, the assets have changed.
Clicks on Applied Filters dropdown in top right.
VO: If you want to quickly see which filters you’ve applied, click the Applied Filters arrow. In this example, you’re only looking at active and eligible participants.
Clicks on Plan Population for ABC Company arrow in top left corner and scrolls down and across the table.
VO: If you want more detail on who these 3,364 participants are, you can expand this top area by clicking the arrow in the top left corner. That gives you a participant grid showing all these participants. You can scroll down and scroll across for additional data points. Each column allows you to sort highest to lowest. The grid is searchable. In this example, we’re going to search by participant name.
Types in “Doe, John.” A row is highlighted in the table.
VO: To search for a specific participant, type their last name in the Search field, and a list of participants with the name you typed will populate. For this example, we’ll select one of the participants below, who are numbered in this test environment.
Clicks X on Selected Participant box under Applied Filters.
VO: To go back to an overview of the whole plan, click the X on the Selected Participant label in the Applied Filters area, and it removes that person from your view.
Clicks on Export to CSV button in top right corner.
VO: You can also download this entire set of participants into Excel if you want to further manipulate or explore the data.
Cursor returns to left rail and clicks on Only This Page under Create Report.
VO: To print this page only, go to the left panel. Under Create Report, select Only This Page.
Printer dialog box opens. Cursor hovers over Print and selects the Change button. The printer destination window opens and the cursor hovers over Save as PDF.
VO: When you do that, you can choose to either print the page or click Change and save it as a PDF. The behavior is a little different depending on your web browser. Right now I’m using Google Chrome.
Cursor clicks Cancel to exit printer windows, revealing the popup window showing the report. Scrolls through report, then closes the window.
VO: You can also click Cancel and view the report online. This generates a popup window where you can quickly see the analysis period, any filters you’ve applied, and how many participants you’re viewing. You get the visual and the table all on one page.
Star in top right corner is highlighted and cursor clicks the star.
VO: To mark this report view as a favorite, click the star in the top right of the Multiview of participant data.
Cursor returns to left rail and hovers over Menu icon, then selects Favorites and Overview.
VO: Now go to the Menu icon, and you’ll see a new grouping called Favorites. This allows you to find your favorite report views quickly.
VO: That’s a brief introduction to Plan Analytics, with some of the basic interactivity and navigation to help you get started. We have three additional videos that cover some of the most frequently used functions of the Plan Analytics tool. Contact your Schwab Plan Services representative to learn how you can use Plan Analytics to refine your plan.
Onscreen text: Contact your Schwab Retirement Plan Services, Inc. representative to learn how you can use Plan Analytics to refine your plan. Charles Schwab. Own your tomorrow.®
Schwab Retirement Plan Services, Inc. (Schwab Retirement Plan Services) created this communication for retirement plan sponsors and retirement plan consultants, advisors and other retirement plan service providers and fiduciaries only. Schwab Retirement Plan Services, Inc. is not a fiduciary to retirement plans or participants and only provides recordkeeping and related services.
©2016 Schwab Retirement Plan Services, Inc. All rights reserved. CC00423543 (0416-EMEP) (05/16)
Learn about the metrics available and how to explore and customize your dashboard.