---
title: "Drill Plods v1.0 PowerBI Dashboard"
canonical: "https://servicedesk.maxgeo.com/space/DS/1422065730/Drill%20Plods%20v1.0%20PowerBI%20Dashboard"
format: markdown
---
> Macro (toc)

# Automated drill plods imports

## Data Handling

The most common types of data supplied on drill plods are supported but the solution can handle most additional types of data.

- Drilled meters
- Time based items
- Consumables
- Staff hours
- Downhole survey

 **Costs **are calculated using the schedule of rates derived from the contract(s) governing the drilling program.

 Associated **library tables **are updated when new options are found.

 Associated **contract items **are added when not originally in the Contract file with a cost of 0.

## Error reporting

The **client and maxgeo hosted DBA **will be notified of the following errors:

- Foreign key conflicts
- Check constraint conflicts
- NULL value inserted into a Not Null column.
- Data type conversion errors
- Data truncation errors
- Any mapping issue (implies the source file or target table structure has been changed) The **maxgeo DBA **will be notified of any other types of errors

The **maxgeo service desk **will be notified of errors caused by causes other than mapping or source data

## Drilling Invoicing Data

Data from drilling invoices can be captured into Excel or CSV files and either imported manually or using the csv import automation process as long as invoice importing templates have been provided and these have been mapped and configured as part of the automation process

 If manually imported, the data needs to be imported from Excel files using DataShed5 import functionality

 The invoice data needs to be broken down by cost code to allow each Contract Item to be comparable with an invoices amount.

## Automated CSV Import workflow

![image-20240930-011046.png](media://a30e050a-056d-49f4-bcf5-4a9cbf7fb36c)

## Automated API Import workflow

![image-20240930-011125.png](media://267feea8-358e-409e-af7b-f1ec8e9f5f5a)

# The Drill Plods Dashboard

## Opening the Report

## Homepage

## Navigating the Report

# Filtering the Report

There are several ways you can adjust what you see on the various report pages.

 Report objects are generally dynamic and via in-built relationships they will filter corresponding data and objects on the report.

 Other options are **Slicers **and **Filters**

***Slicers ****are dropdowns that allow you to quickly filter the report results. Slicers may allow you to pick more than one option. Picking items from a Slicer may impact what options are available in other slicers*

## Charts & Tables

**Hovering the mouse over the graph, you will see an additional menu. Important! **Some of the features may be available depending on the chart.

![image-20240930-011839.png](media://8301d7cb-a818-4c2c-b060-68b632115448)

## Other Report Basics

Power BI uses an alternative data source connection and does not utilise any filters or selected DataSets within DataShed5. Only active Slicers and Filters can be used to filter the Power BI reports.

 Data is automatically refreshed daily.

 Note that the default report has been configured for the standard MDS and some client customisations (including data) are not incorporated or accounted for.

 All feedback is appreciated so please forward all suggestions and any issues noted to maxgeo Service Desk.

There is currently no Export option. Use the options listed on the next section of this slide to output visualisations or reports.

# Report 1: Drilling Summary

# Report 2: Drilling Cost Summary

# Report 3: Consumables

# Report 4: Drill Hole Status

# Report 5: Rig Performance

# Report 6: Location Deviation

# Report 7: Plods Forms (DDR)

# Report 8: Invoice Reconciliation

# MDS Data Tables

Drill plod data and associated contract data reside in the following tables which are used in the dashboard reports

| **Contracts Tables** |  |
| --- | --- |
| tblContractHeader | Basic information related to Drilling Contracts |
| tblContractDetails | Detailed contract items cost breakdowns from the Contract Schedule of Rates |
| tblContractDetailsRate | Optional table for Contracts that span many years and can have different rates at different times |
| tblContractInvoice | Basic information related to Drilling Invoice received |
| tblContractInvoiceCostCode | Detailed contract items cost breakdowns from the invoice received |
|  |  |
| **Drilling Plods Tables** |  |
| tblContractActivityLog | Basic information related to Daily Drilling Reports (DDR/Plods) |
| tblContractActivityLogCrews | Detailed information related to crew complement and hours for each shift |
| tblContractActivityLogDetails | Detailed information related to time based items and consumable items per shift |
| tblContractActivityLogMetres | Detailed information related to amount of meters drilled per shift |