Overview

The estimated time to complete this lab is 40 minutes.

In this lab, we will cover what is under the hood then you will connect to your data and transform it into a usable data model.

Creating reports in Power BI is driven by a need to either understand some raw data or to solve a problem or both.  Sometimes it isn’t evident you have a problem until you see the data and sometimes you have a problem and you don’t know how to solve it but the answer lies in the data.

The data that we will be using in this Power BI training is based on the locations of where crocodiles are captured in the Northern Territory as defined by broad geographic areas referred to as Crocodile Capture Zones. The coordinate location of traps is not provided to the public.

The zones may be viewed using NR Maps. See folder: Parks and Culture > Wildlife. https://nrmaps.nt.gov.au/nrmaps.html

Zones were generally developed as follows;
– Borroloola: 100 km buffer from Borroloola township
– Katherine Zone 1: 5 km buffer from the Katherine River
– Litchfield: an extraction from reserves in GEODATA.
– Management Zone: originated in 2009 with minor modifications over the years.
– Nhulunbuy: 50 km buffer from Nhulunbuy township.
– Shoal Bay, Upper Harbour, Lower Harbour: straight line boundaries were hand-drawn

The spatial polygons are provided in an ESRI shapefile format in Geographics with datum GDA94. The capture table is provided in a Microsoft Office Excel format.

For more information about crocodile captures in the Northern Territory, visit nt.gov.au/emergency/community-safety/crocodile-capture-and-management/map-of-crocodile-captures

This data describes the daily captures within the Northern Territory Crocodile Capture Zones.
Custodian:	Parks and Wildlife Commission of the Northern Territory
Agency:	Department of Environment, Parks and Water Security. Northern Territory Government
Metadata:	http://www.ntlis.nt.gov.au/metadata/export_data?type=html&metadata_id=C67DB1A044D43F3BE0532144CD9B0761
View:	https://nrmaps.nt.gov.au/nrmaps.html
The capture zones can be viewed in NR Maps. See folder: Parks and Culture > Wildlife.    This dataset features date, region and other crocodile capture components making perfect real data for training materials.
Data description:
ORDER	FIELD	DATA FORM	DESCRIPTION
1	OBJECTID		Unique identifier for each record
2	DATE_CAPTURED	date	Date of capture
3	SCIENTIFIC_NAME	text x 50	Scientific name
4	COMMON_NAME	text x 50	Common name
5	CAPTURE_METHOD	text x 50	Method of capture
6	TOTAL_LENGTH	float	Length (cm) between the tip of snout and the tip of tail
7	HEAD_LENGTH	float	Length (cm) between the tip of snout and the end of dorsal cranial platform
8	SEX	float	Female or male
9	SNOUT_VENT_LENGTH	text x 1	Length (cm) between the tip of snout and the beginning of vent (cloaca)
10	TAIL_COMPLETE	text x 1	Whether the tail is complete or not
12	REGION	text x 50	The region for management zones are Katherine, Nhulunbuy, Darwin, Borroloola and Other/Unknown
13	ZONE_NAME	text x 50	The capture zones are divided into 9 zones: Upper Harbour, Lower Harbour, Shoal Bay, Management Zone, Katherine, Borroloola, Litchfield, Nhulunbuy and Outside Management Zone.
14	ZONE_CODE	number	The code for capture zones
15	GROUP_NAME	text x 50	The location group of traps inside the capture zones
16	LOCATION	text x 50	The location  area of traps inside the location group