Referred to as "Dashboards"
Referred to as "Reports"
You must be connected to the GW VPN (Virtual Private Network) to access all data reporting systems (except GW Power BI). If you are not familiar with using VPN at GW, please refer to the download and setup instructions provided by GW IT.
If you receive a SAML authentication error when attempting to access Tableau or ThoughtSpot, your connection may have timed out.
The error looks like this:
Proceed with the following steps to resolve.
Access to specific dashboards and reports is granted based on a user's role at the University. If you are unable to access a specific dashboard or report intended for your role, access may not yet have been granted. In this case, please get in touch to request access.
Status.gwu.edu provides an easy-to-read overview of the current availability of GW IT services and any scheduled maintenance events. You will find "Business Intelligence Services" under Administration and Services. Check here to see if there is an issue with any of our reporting tools. Members of GW Community have the option to subscribe and receive service status notifications via email, text or MS Teams.
The Data Warehouse is refreshed nightly and all of our reporting tools reflect data as of the close of business for the previous day. Here's an example of the data refresh process:
Question |
Answer |
What is today's date (example)? |
7/1/2021 |
When was the Data Warehouse refreshed? |
7/1/2021 between 12am and 3am |
The data in the Data Warehouse is as of...? |
Close of business 6/30/2021 |
What "Refresh Date" will GW Insight (Tableau), GW Power BI, GW Analysis (ThoughtSpot) and Data Marts display? |
7/01/2021 between 12am and 3am |
*Exceptions may occur, subscribe to GW Status to receive email alerts about data refresh disruptions and scheduled maintenance.
Submit a ticket to Business Intelligence Services when you are experiencing an issue or need assistance or answers about how to access or use existing BI products, such as:
Typically, we have found the following to be the recommended browsers for each reporting tool. However, you may need to experiment with what works best for your system.
|
|
|
Microsoft Edge Data Mart / Cognos |
Chrome GW Insight / Tableau |
Firefox GW Insight / Tableau |
Steps to enable Internet Explorer (IE) Mode in Microsoft Edge. |
GW Analysis / ThoughtSpot |
GW Analysis / ThoughtSpot |
GW Power BI |
GW Power BI |
GW Power BI |
When you plan to download data from any GW Insight/Tableau dashboard, you will need to choose between two formats:
Use CSV (.csv) file format (preferred method) when:
Note: CSV files can be opened and saved in Excel. Since merged cells are eliminated by the CSV format, you can easily filter and manipulate the data columns. Read more about CSV format.
Use Excel (.xls or .xlsx) format on all other occasions:
GW BI currently maintains four reporting tools. All three can be accessed online (VPN connection required ).
GW Insight (Tableau)
Referred to as "Dashboards"
GW Power BI
Referred to as "Reports"
GW Analysis (ThoughtSpot)
Referred to as "Pinboards"
Data Marts (Cognos)
Referred to as "Reports"
Migration Notes
(1) ThoughtSpot is currently available but will be decommissioned in 2023. GW BI is in the process of migrating all ThoughtSpot reporting functions to either Tableau or Power BI. Reports that have not yet been migrated remain available in ThoughtSpot.
(2) While Cognos is currently still available, GW BI is in the process of migrating all Cognos reporting functions to either Tableau or Power BI. Reports that have not yet been migrated remain available in Cognos. If a report you used in Cognos has been decommissioned you will see a message directing you to the replacement in either Tableau or Power BI.
Microsoft Edge is now the recommended browser for Data Mart / Cognos (gsource.gwu.edu).
On June 15, 2022, Internet Explorer is no longer available. It is necessary to download Microsoft Edge to access Data Mart / Cognos after this date.
Please follow these steps to enable Internet Explorer (IE) Mode in Microsoft Edge.
If you continue to have issues, please submit a ticket to Business Intelligence Services.
The Content Catalog provides a way to find reports, dashboards, and worksheets across the university's data domains. You will also find the link to our Data Governance Center for the associated business terms. This catalog is refreshed daily as updates and additions are put into Collibra.
See the catalog's glossary of terms.
The BI product strategy seeks to serve the majority of user data needs through professionally designed, certified dashboards delivered with Tableau, and the remaining needs with the detailed and build-your-own capabilities of Power BI. Keep this "80/20" guideline in mind when seeking resources for your work, and generally start by seeking to identify the appropriate Tableau dashboard for your use.
You can refer also to the Content Catalog for information such as description, location and business glossary for available reports and dashboards.
Our training webpage outlines webinars and training resources for users to become familiar with BI's products and platforms.
The GW Data Governance Center (DGC), often dubbed Collibra in reference to the underlying software platform, serves as the single source of truth for all GW data governance and stewardship activities, and is where business definitions and data assets are catalogued, defined, and governed.
Dashboards and reports created by the BI team are certified in collaboration with the Data Governance team and relevant Data Stewards, and documented within the DGC to ensure all reports and dashboards are consistent, trusted, and high-quality.
We have synced the Content Catalog with the DGC entry for a report, dashboard,and worksheet. You will find a description, glossary of the business terms included along with their definitions, and a link to the asset itself. On certified assets in Tableau and Power BI, you will find a link to the relevant DGC entry.
Use the filters at the top of the dashboard to generate or update the summary table.
Click on any column, row, or cell in the summary table to generate secondary filters and the detail table (e.g., student level information).
Secondary filters display additional aggregate information. Click on one or more cells to further filter the detail table. Use CTRL + click to select more than one cell from a single filter.
After making all of your selections you can save your view, so it will be available upon next login without having to reapply all filters and selections.
You can subscribe to your view to receive email updates at a regular interval. The email will include an image with a link back to the dashboard. NOTE: Only use schedules labeled *SITE USERS*.
Use the Share option to make your saved view available to others.
A custom view is a saved version of a Tableau dashboard with your selections and filters applied. You can create several views of one dashboard. You can also set one of the views as a default for each time you open the dashboard and make your view visible to others.
For more information about custom views, go to https://help.tableau.com/
Click on Pinboards in the top menu, then choose "Certified" from the sticker dropdown to find pinboards that have been published by BI and certified by DGC.
Use the filters at the top of the pinboard to narrow the displayed data.
Save a copy of the pinboard for future use to retain your filter selections.
Once saved, you can find your copy of the pinboard from the "Yours" option in the pinboard menu. NOTE: Be sure you've removed the "Certified" sticker if it is still selected. Click the star icon next to the pinboard name to mark it as a favorite; favorites will display on your home screen at login for quicker access.
Use the share option to make your copy of a pinboard viewable to others.
Use the Manage Schedules option to receive emails of either a PDF of the pinboard or a CSV of data in the pinboard. NOTE: If you want to include others on the schedule you must first share the pinboard with them.
You can also make copies of individual answers on a pinboard, such as the data detail table.
After copying the answer you can edit the table by adding or removing fields.
After making changes, save your answer. It will now appear under "Yours" in the Answer menu.
Data from any table in the dashboard can be downloaded. To ensure you download the desired table (usually the detail table at the bottom of the dashboard), click on a column or cell in the table before clicking the Download button from the menu at the top. This will ensure the selected table is the default in the download menu. NOTE: Data can be downloaded as XLSX or CSV; they have different formatting in the output so you may wish to download both and see which meets your needs. See answer above, "What's the difference between Excel and CSV" for specific details.
To download data as an XLSX, on the "Detail" page, click on the ellipsis (three dots) on the top right corner of the table you wish to download.
Select 'export data' from the dropdown.
The Excel file will automatically download and open.
To download data as an XLSX or CSV, click on the ellipsis (three dots) on the table you wish to download (not the ellipsis for an entire pinboard). If you do not see XLSX or CSV options you are probably in the pinboard menu.
In a Tableau dashboard not all fields are displayed in the detail table, but additional columns are available once you download the table. See tutorial above on "how to download".
If after downloading there are still columns not present that would be helpful in answering your questions you can submit a ticket. There is no guarantee that the columns will be added.
44983 Knoll Square
Ashburn, VA 20147