Tulip for Dashboard Builders

Curriculum

• Intro to the Course
• Intro to the Course

  Welcome to the course!

  This video will provide an overview of the course content, and help you get oriented. Below the video, you'll find a few last notes that will help you get the most out of this course.

• Course Content and Important Resources

  To follow along with the exercises in this course, you'll need to download a few pieces of content—a Tulip Library Application and a .CSV data set.

  Here are the links:

  • Events App Suite - we'll use the "Quality Event Form" application to create data for a dashboard.
  • Dashboards Course Data Set - specifically, you'll need to download a CSV of the "Values Only - Use This Tab" sheet.

  If you don't already have it in your instance, it can also be helpful to download the Tulip UI Template to save yourself some time in UI design.

  I recommend downloading all of the content now so you have it, and there will also be links to appropriate resources throughout the course.

• Dashboard Basics
• Data Sources and Visualizations
• In browser dashboards vs. in app dashboards
• Know your metrics, or, designing applications with dashboards in mind
• Build a Simple Quality Dashboard
• Intro to the Analytics Builder
• Download the Event Suite, create the data set
• Count of defects in the last week
• Defects by product
• List of events by date
• Pareto of defects by location
• Dashboards with Dynamic Filters and Expressions
• Dashboards with Dynamic Filters and Expressions
• Exercise setup: Build the table and import the CSV

  In this portion of the course, we'll create a dashboard using Tulip Analytics fed by Tulip Table data.

  At this point, you'll need to download and import our CSV data set into a Tulip Table.

  You can find the data set here. Make sure you download a CSV of the tab labeled "Values Only - Use This Tab" if you'd like your analyses to match mine.

  This exercise assumes some familiarity with Tulip Tables. If Tables are new to you, you may want to take a break here to complete this course.

• Overview of our assembly performance dashboard
• Build the analysis for parts produced
• Build the analysis for counting defects
• Use the expression editor to calculate first pass yield
• Exercise: Build the "Performance Metrics" analyses

  Let's test what we've learned so far.

  For this exercise, build the analytics for the "Production Performance" portion of the dashboard. Specifically, build the analyses for Goal, Gap, and Miss%.

  Here are some things to keep in mind.

  • The analyses for "Goal" and "Gap" can be build using the same procedure we used to build the "Parts Produced" and "Defects" analyses.
  • Miss percentage is a measurement of what percentage of work orders did not meet their assigned target, or the (number of orders that had less than their target divided by the total number of orders). You'll need to use the expression editor to get the correct number.
  • If you get stuck on any of these analyses, there are video answer keys below, but do try to complete them yourself first.

   

• Build table analyses to view planned vs. actual production by station and operator
• Intro to dynamic filters
• Build filters that respond to user input
• Build Filters for a rolling time frame
• Dashboard Tear Downs
• Total Productive Maintenance Dashboard
• Pack and Ship Dashboard
• Takt Time Dashboard
• Take the Survey
• Survey