---
title: "Profiles"
slug: "profiles-1"
updated: 2023-11-06T15:33:21Z
published: 2023-11-06T15:33:21Z
canonical: "docs.datajet.app/profiles-1"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Profiles

A key feature of DataJet is the ability to rapidly profile data on very large datasets without needing to create SQL queries. This gives Instant insight into the data without the need for complex engineering.

Profiles are used for:

- summarizing
- visualizing
- counting, frequency, grouping, aggregating, cross-tabulating

All profiles count and summarize individual records in order to understand the distribution of the data:![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697046664915.png)

SQLThe SQL equivalent to DataJet profiles would involve some form of GROUPBY or PIVOT clause.  There is no need to create a SQL query in order to generate profiles in DataJet.   All profile types can be generated by dragging data objects from the Project Explorer and dropping them onto a report or dashboard, or by right-clicking the object in the Database tree and choosing a profile option.

As well as simple instant profiles, sophisticated calculations can be configured to group and display multiple measures. It is also possible to visualize relative [under or over-representation](/v1/docs/index-profile) of unique values in different datasets, and to create [calculated columns](/v1/docs/post-processing-overview) from profile results. Profile result sets can be output to file, saved as new tables, used as input for models and added to [dashboards](/v1/docs/dashboard-overview-introduction) and [standardized reports](/v1/docs/static-standardized-report-quick-reference). Underlying data can be selected from grids and graphs and used to create datasets for further analysis.

Profiles can be rapidly [duplicated](/v1/docs/dashboard-auto-generate) with new dimensions or filters by dropping field templates onto an individual profile report. Variables can be used to [automate](/v1/docs/introduction-to-scripting) the production of all profile types in script, and many different [chart types and layout options](/v1/docs/dashboard-overview-adding-components) are available.

All categorical data is suitable for profiling - continuous data can be engineered so that it is suitable for profiling.

## Types of Profile

The following profile reports are available:

| Profile Type | Example | Used For |
| --- | --- | --- |
| [Profile](/v1/docs/functional-overview) | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697051339299.png) | Use for instant counts and summaries. Accessed by Database Tree right-click or from [Analytics \| Profile](/v1/docs/profile) - Simple Profile - distribution grouped by a single dimension(e.g. count of Gender) - 2-dimensional Profile - distribution grouped by 2 dimensions (e.g., count of Gender by Marital Status) - Function Profile - single with a function applied (eg., sum of income grouped by Gender) - Function Profile - multiple dimension with a function applied (eg., sum of income grouped by Gender and Marital Status) - Crosstab - 2 dimensions, pivoted by one dimension |
| [Index Profile](/v1/docs/index-profile) | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697051127190.png) | Used to determine under and over-representation of values in datasets. Accessed by Database Tree right-click or from Analytics \| Index Profile - 1-Dimension - under or over representation of values from a single dimension - 2-Dimension - under or over representation of values from 2 dimensions |
| [Multi-Function Profile](/v1/docs/mfprofile-introduction) | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697051465884.png) | Used for summaries and visualisations where multiple measures and/or further manipulation of results is required post-processing - Simple Profile - one or more dimensions - Multi-Function Profile - one or more measures - Multi-Segment - one or more segments |
| [Combined Profile](/v1/docs/combined-profile) | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697052125829.png) | Used to join one or more simple profiles sharing common categorical values into a single result set. Allows data from different tables to be seen in the same visualisation - Simple Profile - one or more profiles |
| [Field Profile](/v1/docs/multi-field-profile) | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697827046023.png) | Create individual profiles for one or more fields, showing the count of records for each discrete value in each field. |
| [Query Matrix](/v1/docs/query-matrix) | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1699284593097.png) | Analyze **non-exclusive** or **disconnected segments** in the same report. Used to group segments not directly linked in the Data Model. |

(For details of other report types, see [Introduction to Reporting](/v1/docs/introduction-to-reporting))

For details of how to access profile reports via Project Explorer shortcuts, see [Shortcuts](/v1/docs/database-tree-shortcuts)

## Tips for Working with Profiles

- [Dashboards](/v1/docs/dashboard-overview-introduction)
- [Shortcuts](/v1/docs/getting-started-shortcut-keys)
- Duplicate
- [Mass-Profile](/v1/docs/dashboard-auto-generate)
- Auto-Dashboard

Measures are quantitative measurements, sometimes referred to as metrics. They control what is being counted or summarized, as well as how it is being summarized (e.g., Min, max, avg). A measure is often used as short-hand for a numeric field that is being summarized.

A dimension is a qualitative variable that provides context and meaning to a metric or measure. It is used to group data. Usually a dimension is a discrete field (or column). Dimensions provide row groupings for tabulations and profiles, and are similar to "row fields" in a spreadsheet pivot table.

A collection of table records - may be all records in the table, or a subset of records. A dataset has a corresponding Query Rule, that determines which records from the table are in or out of the dataset (or "selection").