Common Questions about Cognos, Tableau, and the Data Warehouse

Overview

See below for frequently asked questions about business intelligence (BI) and analytics.

 

Detail

Frequently Asked Questions for Business Intelligence

Do I have to use Cognos or Tableau to get data?

Pitt IT Analytics provides Cognos, Tableau and Alteryx software to the University. The combination of these tools covers most use cases for institutional data. Advanced users with specialized needs can use other SQL-based tools that can be configured to connect to an Oracle database.

Can I automate data extraction from the University Data Warehouse?

Cognos and Alteryx provides jobs that can be configured to run reports or queries and email the results to a user. Tableau extracts can be scheduled to run to update underlying dashboards. Automated data feeds to school, department, or business unit systems may be possible, subject to security, volume, and use considerations. Contact the Technology Help Desk for more information.

 

Request Help Print Article

Related Articles (1)

List of enterprise dashboards available to authorized users

Related Services / Offerings (3)

DATA Alteryx has tools for data extraction, transformation, geospatial mapping, and predictive analytics.
REPORTING Pitt IT Analytics can work with you to develop a report, dashboard and data sets using university data warehouse or unit specific data, including extracting data from a third party system.
ANALYTICS Tableau is easy-to-use analytics software for exploring and visualizing data.