Training & Resources

Workshops

Attend an EDW workshop to learn more about EDW resources and how to use them. Register for a class today! >>

Online Sessions

These online, recorded sessions walk you through step by step examples of how to get connected to and use Enterprise Data Warehouse reports, cubes and data. Learn online at your own pace, when and where it's convenient for you. Take a look at the videos >>

How-To Guides

Step-by-step instructions for accomplishing common tasks for data access or report development. Start now >>

Community

Share and learn what other users do with EDW and other reports and tools. Learn and connect >>

Data Analysis

Reading
  • The Accidental Analyst, by Eileen and Stephen McDaniel
  • Now You See It: Simple Visualization Techniques for Quantitative Analysis, by Stephen Few
Working with Pivot Tables
  • A variety of offerings on YouTube
  • PivotTable I: What's so great about PivotTable reports? offered by Microsoft

Report Development Learning Resources

  • SQL Server Reporting Services
  • Webcasts at Microsoft
  • Microsoft Developer Network Forum
  • SQL Server Reporting Services Developer Center
  • MSDN 2008 Reporting Services Tutorials
  • Microsoft TechNet's Report Design: Best Practices and Guidelines
  • Professional Microsoft SQL Server 2008 Reporting Services - by Paul Turley, Thiago Silva, Bryan C. Smith, and Ken Withee

Cube Learning Resources

  • Introduction to Cubes
  • Excel Pivot Table using Cubes (also known as Online Analytical Processing – OLAP)
  • Analysis Services Webcasts
  • SQL Server 2008 Analysis Services Step by Step - by Scott Cameron

SQL Online Communities

  • SQLServerCentral.com
Contains thousands of articles, scripts, and forum postings. Subscribe to a daily newsletter containing handy tips. Membership is free if you provide your email address. Many suggestions learned from this site have been shared at RS-SIG meetings.

Enterprise Data Warehouse Business Intelligence SIG
The Enterprise Data Warehouse (EDW) Business Intelligence (BI) Special Interest Group (SIG) formed to share information about EDW activity, tools and other resources. The group meets monthly in semi-structured format with both presentations and free-form discussion on issues of the day. If you are involved in reporting or using information to make decisions, you are encourage you to attend.

UW Tableau User Group Canvas site. Subscribe to the mailing list.
Tableau Software users at UW are encourage to join this mailing list to connect with each other. UW Information Technology and the Office of Planning and Budgeting are sponsoring a Tableau Pilot to determine fit and scalability as a data visualization tool for UW. If you are interested in joining the pilot, please contact the Decision Support Services team.

Certificate in Business Intelligence: Techniques for Decision Making
Understand how to translate and manage mass-information for businesses and drive effective strategic decisions. Build mining models, perform what-if analyses and simplify data into practical visual presentations. Learn techniques to consolidate and aggregate data on customers, transactions and demographics.

Certificate in Business Intelligence: Building the Data Warehouse
Learn to transform raw data into business assets by synthesizing massive amounts of information in the forms of databases, spreadsheets, text-based documents and various internal and external communications. Improve organizational use, sharing and storage of information by planning and implementing a data warehouse project. Develop robust data and technical architecture to meet business goals.