Refresh Tableau workbook/dashboard using APIs - Share the discussion and solution that led to the use of Tableau APIs from a scheduling tool in the ETL process to refresh the tableau workbook/dashboard automatically. Kranthi Bandaru
Are you sure we'll have enough staff for the surgery? "How do you make sure you have enough staff available when in-housing the responsibilities for specific Surgical case support? You don't want too few but too many and you are wasting money. This dashboard helped inform decision makers on the right number of staff needed to in-house running surgical equipment. Dynamic percentiles allowed them to toggle through the 1, 2, 3 sigma variation in the concurrent cases running." Austin Chrzanowski
Yes, you GANTT in Tableau! - Displaying project data in a GANTT format. Leticia Valdez
Moving from Uninformed Debate to Data-Informed Decision Making- At the Ford School, data analytics are transforming the way that administrators use information to make data-informed decisions. Tableau has made it simple for administrators to ask sophisticated questions and get actionable answers. Recently, we used Tableau data analytics to provide context to a faculty discussion on course grades. Of particular concern, was how underrepresented minorities were performing in courses that are a part of our program. Based on a request from our Associate Dean, our BI Analyst used Tableau to quickly analyze data post-retreat and provide data-informed context to the discussion. The power of Tableau was highlighted by the ability to connect to the data warehouse via an Oracle connection, and quickly expand the analysis as necessary. Users were able to dynamically use dashboards to filter data and dive deeper into the analysis. The careful selection of charts highlighted critical trends in underrepresented minorities. Strategically, this analysis provided data-informed context to a discussion where information was not previously available. During our five-minute session, we would outline our strategic analysis and discuss its impact on curricular decision making at the Ford School. - Marcella Brighton, Chief Administrative Officer, Ford School of Public Policy and Heather Alemu, Business Intelligence Analyst, Ford School of Public Policy"
Who Are You Really? A fun visual created using the 16 Personalities personality test. Updated whenever new individuals join the team. Tyler Hughes
Projecting Surgical Supply Costs - Michigan Medicine has had the focus of reducing costs especially in the operating rooms. Efforts to standardize supplies used will help with those efforts but it was unclear whether progress was being made. Grabbing the attention of surgical leadership is critical in this dashboard while providing detailed inputs to the successes and areas of improvement. Austin Chrzanowski
Bridging the Gap: Connecting the path between Data Warehouse and Analytics - Human Resources Information Services (HRIS) at the University of Michigan faced a challenge as it started adopting Tableau as its primary analytics platform over the last several years. What is an efficient and maintainable way to bring data into Tableau from the existing data warehouse, so the group could spend more time analyzing data and less time bringing data into Tableau? This presentation will focus on how HRIS went about tackling this challenge and explain the benefits/issues that were encountered along the way. Yurong Hu, Jennifer Watson