Daikibo Telemetry Analysis - Tableau Task Guide
1. Download and Install Tableau
Visit https://www.tableau.com/products/trial
Download Tableau Desktop by clicking 'Start Free Trial'.
Install and register using the same email you used to download it.
2. Download & Unzip the Telemetry Data
Download 'daikibo-telemetry-data.json.zip' from your resources.
Unzip it to get 'daikibo-telemetry-data.json'.
3. Open Tableau & Import Data
Launch Tableau Desktop.
Click 'Connect to a File' > JSON.
Select 'daikibo-telemetry-data.json'.
4. Create Calculated Field 'Unhealthy'
Go to the Data Pane.
Right-click any field > Create Calculated Field.
Name it: Unhealthy
Use the formula:
 IF [status] = 'unhealthy' THEN 10 ELSE 0 END
5. Create Bar Chart: 'Down Time per Factory'
Open a new worksheet.
Drag 'factory' to Columns.
Drag 'Unhealthy' to Rows and set it to SUM.
Rename the sheet to 'Down Time per Factory'.
6. Create Bar Chart: 'Down Time per Device Type'
                            Daikibo Telemetry Analysis - Tableau Task Guide
Open another new worksheet.
Drag 'device_type' to Columns.
Drag 'Unhealthy' to Rows and set it to SUM.
Rename the sheet to 'Down Time per Device Type'.
7. Create the Dashboard
Click the New Dashboard icon.
Drag both sheets into the dashboard.
Click on 'Down Time per Factory', then click the drop-down arrow > Use as Filter.
8. Screenshot & Submit
Find the factory with the highest down time.
Click its bar to filter the second chart.
Take a screenshot of the full dashboard.
Submit this screenshot.