---
title: "Sample Sleuth v1 PowerBI Dashboard"
canonical: "https://servicedesk.maxgeo.com/space/DS/1812594691/Sample%20Sleuth%20v1%20PowerBI%20Dashboard"
format: markdown
---
The Sample Sleuth guide gives a clear rundown on using the Power BI report to track sample processing at each stage. It walks through setting global filters, viewing data summaries, and checking sample statuses. It’s a handy tool for keeping tabs on data quality and progress. By following the guide, users can better understand their sample workflows and make more informed decisions.


The Sample Sleuth Power BI report can be accessed by click "**Dashboards**" and selecting "**Sample Sleuth**". Sample Sleuth will open at the **Global Filters** page.

![Sample Sleuth - Step 0.png](media://02286c2b-c675-452e-ade0-3d5ccd4677a7)

Sample Sleuth - DQ now has a live connection to the DataShed5 MDS. This is demonstrated on the Help page as shown below.

![Sample Sleuth - Step 1.png](media://a892d8fe-b1a0-483b-a7d1-d8102b9ecffa)

> ⚠️ **Note:** While the Direct Query version of Sample Sleuth provides live access to your data, there may be a performance impact with charts and tables taking longer to load.

# Global Filters

It is important to set a Global Filter in order to view the sample history. Follow the numbered sequence to set the Global Filter.

**Step 1.** Select a **DataSet**.  
**Step 2.** Select a Data **Source Type**.  
**Step 3a.** Select to search by **Batch No** ...  
**Step 3b.** or by **Dispatch ID**.  
**Step 4.** Select a **LabCode**  
Batches from the selected LabCode will display in the Batch Number list.

**Step 5.** Select the **Batch** or **Batches** you wish to review.


![Sample Sleuth - Step 5.webp](media://e99f9e8c-dd8a-4231-a38c-f1f8502eb93e)

# Summary

Click "**Summary**" to display Summary information for the selected Global Filter criteria.

![Sample Sleuth - Step 13.png](media://d1ac0f8a-00c9-4b79-a81e-48618947e158)

This view is a data quality or progress tracking report. It displays the status of sample processing across various stages of a workflow, broken down by **Source**, **DataSet**, and several stages of sample lifecycle such as **Dispatched**, **Consigned**, **Lab Received**, **Prelim Results**, **Final Results**, and **DB Imported**.

Across the top there are three filter options.

![Sample Sleuth - Step 14.png](media://ca5f701b-be1b-4ac7-818e-47cbe17b050a)

Dispatch ID,  
LabCode and  
Batch No.


![Sample Sleuth - Step 15.webp](media://3a21b5dd-a2b5-49ff-ac2e-ac5e974fde76)

Additional filter options are available by clicking the "**EXTRA FILTERS**" button,  
which will display an additional five filter options.  
They are: "**Prospect**", filter by one or more Prospects,  
**Lease ID**,  
**Program Type**,  
**Site Type**,  
and **Sample Type**.  


**17 **The "**Hide Filters**" button will close the Extra Filters.


![Sample Sleuth - Step 19.webp](media://3f285816-9a4c-48b3-9276-f196c649f5d5)

you will be returned to the Summary page.

![Sample Sleuth - Step 28.png](media://b4643583-3b0b-46ba-8135-ca8c1130a67c)

The "**Display**" dropdown allows the selection of status's for each **Step**.

Options are:

- **No**: Number of samples that have **not** progressed to this step.
- **% No**: Percentage of total samples that have not progressed.
- **Yes**: Number of samples that **have** progressed to this step.
- **% Yes**: Percentage of total samples that have progressed.

![Sample Sleuth - Step 29.png](media://5cc3f9b0-141b-4d19-90ac-6d4f4a8df1a9)

It is also possible to "**Drill In**" to have a more granular view of the data.

![Sample Sleuth - Step 30.webp](media://a9179553-c096-4a31-8d10-78ecfade0d84)

**Steps and What They Mean:**

- **Dispatched**: Samples that have been dispatched from the origin.
- **Consigned**: Samples formally consigned (likely to a lab or contractor).
- **Lab Received**: Samples physically received at the laboratory.
- **Prelim Results**: Samples for which preliminary results are available.
- **Final Results**: Samples for which final, validated results have been issued.
- **DB Imported**: Final results that have been successfully imported into the database.
- **Merged**: Samples have been merged in the database.
- **QC Accepted**: Samples have passed QC Rules.
- **Ranked**: Samples have been Ranked in the database.

![Sample Sleuth - Step 34.png](media://c3c777f3-2152-4404-b11c-8a3a5b124abe)

The data can be viewed in several different ways, as outlined.

Make your selection and the view will refresh.

![Sample Sleuth - Step 35.png](media://7e17456f-9417-4d87-86b9-fbf580726173)

# Summary by Date

Click the "**Summary by Date**" tab.

The "**Summary by Date**" view presents data on the number of samples processed through various stages over time.

![Sample Sleuth - Step 37.png](media://426888ee-a26c-4677-afc8-2e6c579bb187)

Select how to group data in the Summary table below this list.  
Summary table grouped by "**Program Type**".  
Select the Steps to display in the chart.  
Hover over a column stack section to display the identity and either Drill Up or Drill Down.  
The chart will Drill into the column stack section, providing a more granular view of the data.


![Sample Sleuth - Step 38.webp](media://ff8ecef0-783f-4042-b0a5-ae5ce0bcfa2a)

The "**Table**" tab displays the same data in a table format.  
The table has drill down functionality. Clicking the + will expand the data row.

![Sample Sleuth - Step 44.webp](media://0be00630-03fd-41fe-8073-a01e5856f462)

# Find Sample

Select "**Find Sample**" to open the "**Find Sample**" view, which displays the status of each stage for every sample.

![Sample Sleuth - Step 48.png](media://a5f4d0ce-c25e-4d52-96cf-2a8a696f3015)

Click the "**Focus Mode**" button to display the view in full screen.  
The Focus Mode full screen view.  
Right click on a Sample and select "Drill Through". There are two options, Sample Details or Batch Details.  
Here a Sample has been selected. The sample status shows dates and time at each stage.

Below, icons show the status of each stage.  
This can be switched to Dates if preferred.


![Sample Sleuth - Step 49.webp](media://b82ee45c-a2a6-401d-bbdb-49e2ef1d44d6)