Frequently Asked Questions
- Why can’t I access a reporting tool (Tableau or Power BI)?
-
Connect to VPN
Paolo Alto GlobalProtect VPN Client is the GW VPN. You must be connected to the GW VPN (Virtual Private Network) to access GW Tableau (VPN is not required for 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.
Tableau is spinning and does not load the page
If you are not connected to VPN - Paolo Alto GlobalProtect VPN Client - you may see a spinning icon and your dashboard will not load. Please check your connection, reconnect if necessary, and refresh the page.
SAML Authentication Errors
If you receive a SAML authentication error when attempting to access GW Insight (Tableau) or GW Power BI, your connection may have timed out.
The error looks like this:
Proceed with the following steps to resolve.
- Go to GW MyApps
- Click on your initials or picture in the top right corner and choose Profile.
- On the profile page, find and click the link to Sign Out Everywhere
- Restart your browser and attempt to access Tableau or ThoughtSpot.
Dashboard & Report Access
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.
Check Status.gwu
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.
- When is the data refreshed?
-
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/2023
When was the Data Warehouse refreshed?
7/1/2023 between 12am and 3am
The data in the Data Warehouse is as of...?
Close of business 6/30/2023
What "Refresh Date" will GW Insight (Tableau) and GW Power BI display?
7/01/2023 between 12am and 3am
*Exceptions may occur, subscribe to GW Status to receive email alerts about data refresh disruptions and scheduled maintenance.
- When do I submit a ticket to Business Intelligence Services?
-
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:
- Inability to access BIS platforms - check status.gwu to see if there's a university wide issue
- Dashboard or report not functioning properly
- To propose an entirely new dashboard, report or project, or when you are requesting additional data elements or features to be added to an existing BI product
- For non-Business Intelligence Services issues, please visit GW IT Support
- What reporting tools does GW offer and how do I find them?
-
GW BI currently maintains two reporting tools.
GW Insight (Tableau):
Referred to as "Dashboards". Note: To access, VPN connection is required .GW Power BI
Referred to as "Reports" - How do I find reports or dashboards?
-
Business Intelligence Services' Content Catalog!
The Content Catalog provides a way to find reports and dashboards 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.
- What is the difference between CSV and Excel when downloading in Tableau?
-
When you plan to download data from any GW Insight/Tableau dashboard, you will need to choose between two formats:
CSV Format
Use CSV (.csv) file format (preferred method) when:
- You need every column and every row of data for your analysis.
- The formatting and layout (e.g., predefine groups) are not important.
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.
Excel Format
Use Excel (.xls or .xlsx) format on all other occasions:
- To keep the GW Dashboard data grouping or predefine layout.
- To present data as is or you plan to add charts and visualizations, or any Excel functions
- How do I know which reporting tool(s) to use?
-
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.
- What trainings are available to me?
-
Our training webpage outlines webinars and training resources for users to become familiar with BI's products and platforms.
- What is Collibra and how do I use it?
-
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.
- How do I navigate a Tableau dashboard?
-
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.
- How do I create a custom view in Tableau?
-
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.
Step 1: Open the dashboard and apply the filters for your view
Step 2: Select "View" in the top menu bar, name your view, select checkbox options and save
Step 3: Your view is now available in the top menu bar
Step 4: Manage your view(s) by selecting the "View" menu option
For more information about custom views, go to https://help.tableau.com/
current/pro/desktop/en-gb/ customview.htm - How do I download data from Tableau or Power BI?
-
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.
Power BI
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 drop down.
The Excel file will automatically download and open.
- What if I don’t see all the data fields I need on a Tableau dashboard?
-
Download the Table
In a Tableau dashboard not all fields are always displayed in the visual of the detail table, but additional columns are available once you download the table. See tutorial above on "how to download".
Submit a Request
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.
- Why am I unable to access Cognos | Data Mart | Gsource?
-
The reporting tool you are trying to access, GW Cognos| DataMart| gsource.gwu.edu has been decommissioned as of July 31, 2023. You are no longer able to log into this reporting tool to run reports.
We have transitioned replacements of reports to either GW Insight | Tableau | insight.it.gwu.edu or Power BI | app.powerbi.com.
If you need assistance finding your replacement reports, please send a Helpdesk ticket through our website
- Why am I unable to access GW Analysis | ThoughtSpot?
-
The reporting tool you are trying to access, GW Analysis | ThoughtSpot | analysis.it.gwu.edu has been decommissioned as of June 30, 2023. You are no longer able to log into this reporting tool to run reports.
We have transitioned replacements of reports to either GW Insight | Tableau | insight.it.gwu.edu or Power BI | app.powerbi.com.
If you need assistance finding your replacement reports, please send a Helpdesk ticket through our website.