Skip to main content
Visit Remote Work Tools & Guidelines and Student Remote IT Support for details on working remotely under the University's Coronavirus (COVID-19) recommendations
Penn Information Systems & Computing Systems Home

Search form

  • Find my LSP
  • Penn
System Status
  • Get Started
    • IT Staff
    • Faculty
    • Staff
    • Students
    • Alumni & Guests
    • ISC Staff
  • Services
    • — Services A to Z —
    • Accounts, Access & Security
      • Access Management Services
      • Active Directory
      • Identity Management Services
      • Information Security Services
    • Applications & Data Analytics
      • Application Development & Delivery
      • Data Analytics
        • Data Analytics at Penn
      • Integration Development & Delivery
    • Backup, Storage & Platforms
      • BackItUp
      • Cloud Solutions
      • Data Center & Colocation Solutions
      • Database & Application Platform Support & Consulting
      • Endpoint Management
      • Recovery Solutions
      • Storage
      • Virtual Desktop
      • Virtual Server Hosting
    • Community, Support & Learning
      • Classroom Technology Services
      • Desktop Engineering
      • IT Community Events
      • Knowledge Link
      • LinkedIn Learning
      • Tech Center
    • Consulting & Professional Services
      • Brokered Products
      • HireIT
      • Systems Support & Consulting
      • Technology Forecasting
    • Email, Calendaring & Collaboration
      • Classlists
      • Penn Email Routing
      • PennBox
      • PennNet Mailing Lists
      • PennO365
      • PennZoom
      • SMTP-Relay
      • Secure Share
    • Networks & Connectivity
      • Firewall Services
      • Network Design & Installation
      • PennNet
        • Network Names & Numbers
        • MAGPI (Penn's Internet2 Regional Optical Network)
      • PennNet Ethernet Ports
      • Wireless at Penn
    • Phone, TV & Video
      • Broadcasting Studio
      • Contact Center
      • Live Video Streaming
      • Penn Video Network
      • PennFlex Phone
      • PennNet Phone
      • Traditional Telephony
      • Video Content Management
      • Video Production
        • Producing Video Content
    • Web Hosting
      • Web Services
    • — Service Rates —
    • — Service Level Agreements —
  • Security
    • Office of Information Security
    • Security Services
    • Special Projects
    • Policies & Procedures
    • Training & Awareness
  • Collaborations
    • Engaging Penn’s IT Community
    • Computing Policies
    • Identity & Access Management
    • Cloud First
    • Next Generation Unified Communications
    • IT Advisory Groups
      • Common Solutions
      • IT Roundtable
      • Network Policy Committee
      • Penn Technology Investment Committee (PTIC)
        • About PTIC
        • The PTIC IT Development Fund
    • Special Interest Groups (SIGs)
      • Audio-Visual (AV-SIG)
      • Cloud Computing (Cloud-SIG)
      • Data Visualization (DataViz-SIG)
      • Developer SIG (Dev-SIG)
      • High-Performance Computing (HPC-SIG)
      • Instructional Technology SIG
      • Linux SIG
      • Macintosh Networking Group (MacNet)
      • Mobile Technologies (Mobile-SIG)
      • O365 Special Interest Group
      • PC Networking Group (PC-Net)
      • Project Partners SIG
      • Security SIG
      • Social Media SIG
      • Splunk Special Interest Group
      • Super User Group (SUG)
      • Web SIG
    • Technology Services Strategy Review Board
  • News
  • Events
  • About
    • Overview
    • Leadership & Groups
    • Purpose & Values
    • Strategic Goals
    • Recognition
    • Staff Profiles
    • Tech Jobs @ Penn
    • Contact Us
  • Hot Topics
  • Get Help
    • Support Center
    • Contact ISC Client Care
    • Rates for All Services

You are here

Home » Query Tools Overview

Query Tools Overview

BusinessObjects and QlikView are complementary tools for administrative data analysis at Penn. In general, BusinessObjects is the preferred tool for creating and editing queries for all authorized users of the Warehouse data collections; QlikView is better for analyses where visualization and drill-down are desired/appropriate.

BusinessObjects
  • BusinessObjects
  • QlikView
  • Other Tools
BusinessObjects Web Intelligence is the primary supported query tool used to provide access to the Data Warehouse, which resides on an Oracle database server.
 
  • BI4 login
  • Tips and FAQs - browse or search for answers to common questions

SAP/BusinessObjects is a strategic web-based tool for ad hoc analysis. It provides extensive query construction and report formatting capabilities, all in a web environment and without the need for desktop client software.

BI launch pad is the portal to all BusinessObjects reports, including:

  • the individual's personal collection of queries and reports, stored in their My Favorites area on the server
  • the Public Folders which contain all reports shared by groups of people

Supported browsers (and java versions):

  • See Desktop Requirements for Administrative System Users

QlikView facilitates the visualization of data analysis. It is user friendly and provides fast in-memory analysis capabilities by dynamically integrating and presenting data from multiple data sources.

  • QlikView AccessPoint login
  • Tips & How To
  • External Resources (Qlik.com website)

The QlikView tool complements BusinessObjects with the following advantages:

  • Guided data analysis with easy interactivity for end users
  • Dashboard capabilities for easy visual understanding of data analysis such as trending
  • Incorporate data sources in addition to the Data Warehouse such as spreadsheets or other databases

For an introduction to QlikView, see the Tips & How To page.

Contact Enterprise Information & Analytics for licensing information and help getting started using Qlik at Penn.

Warehouse users may also employ other tools, such as Oracle's SQL*Plus, TOAD, Microsoft Access or Excel with Microsoft Query, Microsoft Power BI and FileMaker Pro, once they have received access to a data collection. Users of these and other tools are strongly advised to consult Enterprise Information & Analytics before exploring these options for advice on connecting to the Warehouse, joining tables, and efficient querying.

Share:

  • Facebook
  • Twitter
Print
EI&A Home
Query Tools
  • Introduction
  • BusinessObjects BI Launch Pad
  • BusinessObjects Tips & FAQs
  • QlikView Access Point
  • QlikView Tips & FAQs
Resources
  • Access Forms
  • Current Load Status
  • Password Changer
Warehouse Information
  • Guidelines for Writing Queries
  • Security
  • Support Services
  • Training
Other Information
  • Data Analytics at Penn
Contact EI&A
  • Computing Policies
  • Tech Jobs @ Penn
System Status

© 2022 THE UNIVERSITY OF PENNSYLVANIA — 3401 Walnut Street, Philadelphia, PA 19104 — Report accessibility issues and get help — For ISC Staff