Tools for Reporting and Analytics

The right tool for the right type of analysis is key to understanding information. These highly interactive reporting tools designed to make the access to information easier than ever. These tools provide campus the data access it needs.

ODMAS has a KnowledgeBase that includes some helpful resources related to these tools.

Tableau

Tableau is a business intelligence data visualization tool that allows users to interact with data through dynamic and interactive dashboards, maps, and other presentation formats. Find out more about UW–Madison’s Tableau environment.

Learn more about purchasing a Tableau desktop license.

SAS

SAS is a business intelligence tool used for statistical analysis and data visualization. Licenses are available through the campus software library for UW–Madison faculty and staff to install on university-owned devices.

There are two different license types:

Teaching & Research License: As defined by SAS, is software used for purposes of classroom instruction, academic (non-commercial) research, and course work primarily related to the customer’s post-secondary degree requirements, including the formulation of theses and dissertations.

Administrative Purposes License: As defined by SAS, is software used for purposes directly related to customer’s operations as a post-secondary degree granting institution. This includes institutional research and any such use related to reporting about the UW to the UW.

Badger Analytics User Training

The Badger Analytics user training course is currently being developed in Canvas. However, those who are ready to get started may begin by completing the following:

SQL Baseline

Completion of either of these two courses on LinkedIn Learning should be sufficient to demonstrate SQL proficiency. Either a screenshot of the certificate from either course or passing score on the final exam from the first course will serve as satisfactory proof of completion. If you feel that your SQL knowledge is sufficient, you may take the final exam in the first course without reviewing the material; a passing score on that exam is sufficient proof of a baseline understanding of SQL.

  1. Learning SQL Programming
  2. SQL: Data Reporting and Analysis

Introduction to Snowflake

The following courses provided by Snowflake should serve as a good introduction to the Snowflake environment and interface:

  1. LVLUP-101, Level Up: First Concepts
  2. LVLUP-102, Snowflake Key Concepts
  3. LVLUP-103, Level Up: Snowflake Ecosystem
  4. LVLUP-105, Container Hierarchy
  5. LVLUP-201, Query History and Caching
  6. LVLUP-202, Context

Additionally, the following YouTube videos provide additional information about the Snowflake environment:

  1. Getting Started – Introduction to Snowflake
    1. Documentation
  2. Getting Started – Architecture and Key Concepts
  3. Accelerating BI Queries with caching in Snowflake

Case Study

Developers are required to complete a case study on a Badger Analytics/Snowflake data set to demonstrate proficiency in both SQL and the Snowflake environment. If you have completed the above SQL and Snowflake requirements and you are ready to begin the case study, please reach out to us by email to get started.

Skip to content